Hi,

We can't use RMAN (it's a SAP database backuped with SAP tools). We have to do it the "old" way.

Question was if this should work: shutdown - copy files - recreate controlfile - startup open resetlogs on different patchset levels

Cheers,
Markus

This is one of the most dangerous things to do.

I would restore the controlfile, rename the log/data/temp-files (alter database rename file1,file2 to newfile1,newfile2) drop the tempfiles, use NID to change the database.

you mount the 11.2.0.2 controfile with 11.2.0.2 binary, the rename, then startup migrate with 11.2.0.3 and run catupgrd

Hi Laurant,

Wie did the restore to a new host. We don't have the 11.2.0.2 binaries there. We also have another file path.

That's why we can't use the current controlfile. Any other idea?

Cheers, Markus

maybe you don't need them.

If you clone from P01 to Q01 you could do

1) restore with sap tool
2) set db_name=P01 , db_unique_name=Q01 in initQ01.ora
3) startup migrate with the 11.2.0.3 binaries

startup migrate

ignore ORA-01157
4) rename file
either

alter database rename file '/oracle/P01/sapdata1/system_1/system.data1' to '/oracle/Q01/sapdata1/system_1/system.data1'

or dynamically with

select 'alter database rename file '''||name||''' to '''||replace(name,'P01','Q01')||''';' from v$datafile

select 'alter database rename file '''||name||''' to '''||replace(name,'P01','Q01')||''';' from v$tempfile

select 'alter database rename file '''||member||''' to '''||replace(member,'P01','Q01')||''';' from v$logfile

5) do this until no more error ORA-1157 (you may need to check the location...)
shutdown immediate
startup migrate

6) run catupgrd

@?/rdbms/admin/catupgr

7) run NID to change the database name back to Q01
nid dbname=Q01 target=sys/manager

8) change the database to Q01 in pfile

This is a bit of a prototype, I hope it works