This content has been marked as final. Show 5 replies
yes, you can upgrade database using backup,
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.