oracle+restore+pfile,RMAN Restore and Recover （文档 ID 2115022.1）

In this Document

APPLIES TO: Oracle Database - Enterprise Edition - Version 11.2.0.4 and later

Information in this document applies to any platform.

GOAL

ASM diskgroup upgrade successful to 12.1.0.2 but DB upgrade from 11.2.0.4 to 12.1.0.2 failed. ASM diskgroups (DATA and FRA) compatible.asm and compatible.rdbms were set to 12.1.0.2.

Need support on how to return database back to 11.2.0.4 because backups are on the FRA which are at the 12.1.0.2 settings.

SOLUTION

Action Plan

After recreating the 11.2 ASM diskgroups to restore to continue the action plan.

From the old server we have image copies of the database files to copy to the new server to recover with.  There are incremental level 1 backupsets and archivelog backupsets.  The database had been opened resetlogs under 12c so we don't want the archivelogs on disk to revert back to 11g.  We will use only the archivelogs in backupsets since we know they are from 11g.  We've identified which autobackup controlfile can be used to restore from and then catalog the datafile copies and backupsets into the controlfile in the new 11g +DG locations.

1. RMAN> RESTORE CONTROLFILE to '+prod1_02/testdb/control01a.ctl' ' FROM '+DG/c-xxxxx-iiiii-yy';

2. RMAN target/

rman> set dbid=12359294

> startup mount pfile = '';

> configure device type disk parallelism 200 backup type to copy;

> backup copy of database format '+prod1_02';

3. >backup force backupset all format '+prod1_fra';

-----------------------------------------

-- 11g

-----------------------------------------

4. Edit pfile

log_archive_dest = 'LOCATION=use_db_recovery_file_dest';

db_recovery_file_dest = '+prod_fra'

db_create_online_log_dest = '+prod1_02'

db_create_file_dest = '+prod1_02'

control_file='+prod1_02/testdb/control01a.ctl'

5. . >startup nomount

6. rman target /

> set dbid = 12359294

>startup nomount pfile = ;

>restore control file from '';

>shutdown

7. edit pfile for control file location when restored

>startup mount pfile = '';

8. >catalog start with '+prod1_02';

>catalog start with '+prod1_fra';

9. >switch database to copy;

10. > SQL "alter database rename redofile locations";

11. SQL> select max(sequence#) from v$backup_redolog;

12. > run {

set until sequence xxxx+1 thread 1;

restore database preview;

}

13. > recover database until seq# (select max(seq_no) + 1 from V$redobackuplog;)

-- You will see media recovery complete and the alert.log shows no errors.

14. > alter database open resetlogs;