This content has been marked as final. Show 5 replies
The short answer is no.
The RMAN executable will not match for one. If you need a MOS document I can supply one.
Frequently Asked Questions about Restoring Or Duplicating Between Different Versions And Platforms [ID 369644.1]
Edited by: mseberg on Feb 6, 2013 5:55 PM
Hi, don't is possible. You can do a duplicate of the database and after that, to do a his upgrade.
yes, you can upgrade database using backup,1 person found this helpful
1.backup database plus archivelog
2.backup current controlfile
edit controlfile location in pfile
1.using pfile statup nomount
RMAN>restore controlfile from '<backup_controlfile_location>'
4. regiter backup to rman
set newname for datafile 1 to '<new location>';
set newname for datafile 2 to '<new location>';
set newname for datafile 8 to '<new location>';
switch datafile all;
login to sql
sql>alter database open resetlogs upgrade;
We are wanting to do a rename of the DB as well as the restore/recovery. If I do this, the DB would be restored as PRD vs. DEV so I would need to do a rename after the fact. Then within the DATA diskgroup, I would have a PRD directory as well as a DEV directory for any new datafiles. For example, DATA/PRD/datafile/application_data.123.4567890 for existing files (part of the restore) & then DATA/DEV/datafile/application_data.456.7890123 for newly created files (after the restore is done). We typically have more than 1 database on a server so then there would be multiple directories inside of the ASM disk group for each database. We are hoping to be able to avoid this. If there was any way to get around this, that work for us. Not sure if pre-creating aliases within ASM so that PRD went to DEV would be possible or not for something like this.
I have an example ( not ASM ) where you can do this :
If you shutdown the remote database you can refresh using the same INIT's and scripts.