RMAN Restore and Recover （文档 ID 2115022.1）

最新推荐文章于 2025-08-15 10:38:51 发布

weixin_33805557

最新推荐文章于 2025-08-15 10:38:51 发布

阅读量92

点赞数

CC 4.0 BY-SA版权

文章标签：数据库 python

原文链接：https://my.oschina.net/1272149624/blog/690843

本文提供了从Oracle 12.1.0.2版本回退到11.2.0.4版本的具体步骤，适用于使用ASM磁盘组的场景。通过RMAN工具，指导如何从备份集恢复并重新配置数据库。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

2019独角兽企业重金招聘Python工程师标准>>>

RMAN Restore and Recover from backupsets to New ASM DG (文档 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 '<filename_location of snapshot controlfile>';
  >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;