RMAN从备份到已机恢复

朱雀 2022-03-12 08:14 286阅读 0赞

这是原机和目标机的ORACLE安装版本一样，安装路径一样，实例名都是ORACL。下次尝试不同版本的恢复

1.备份

全库备份命令：

run {
        CONFIGURE RETENTION POLICY TO REDUNDANCY = 2;
    	CONFIGURE DEVICE TYPE DISK PARALLELISM 2;
    	CONFIGURE DEFAULT DEVICE TYPE TO DISK;
    	backup as compressed backupset database format 'F:\rman_backup\FULLBAK_%d_%T_%s_%p.DBFILE'; 
    	backup current controlfile format 'F:\rman_backup\%d.%s.%p.%T.CTL';
    	backup spfile format 'F:\rman_backup\%d.%s.%p.%T.SPFILE';
    	crosscheck backup;
    	crosscheck copy;
    	sql "alter system archive log current";
    	backup as COMPRESSED backupset archivelog all not backed up format 'F:\rman_backup\%d.%s.%p.%T.ARC';
    	crosscheck archivelog all;
    	delete noprompt archivelog all completed before 'sysdate-60';
    	delete noprompt expired backup;
    	delete noprompt obsolete;
    }

2.恢复

shutdown immediate
    startup nomount pfile="F:\app\Administrator\admin\orcl\pfile\init.ora.252019115455"
    restore controlfile from "E:\oracle_install\rman_bk\ORCL.132.1.20190305.CTL";
    alter database mount;
    catalog start with "E:\oracle_install\rman_bk";
    crosscheck backup;
    restore database;
    sql "alter session set nls_date_format=''yyyy-mm-dd hh24:mi:ss''";
    recover database until time '2019-03-05 15:00:00';

RMAN-00571: ===========================================================  
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============  
RMAN-00571: ===========================================================  
RMAN-03002: recover 命令 (在 03/05/2019 15:16:18 上) 失败  
RMAN-06054: 介质恢复正在请求未知的线程 1 序列 186 的归档日志以及起始 SCN 14623085

执行这里执行报错了，解决方法如下：

run {
    set until sequence 186;
    recover database;
    }
    
    --执行成功，退出rman，启动数据库
    exit
    sqlplus / as sysdba
    alter database open resetlogs;
    exit

RMAN> run \{  
2> set until sequence 186;  
3> recover database;  
4> \}

正在执行命令: SET until clause

启动 recover 于 05-3月 -19  
使用通道 ORA\_DISK\_1  
使用通道 ORA\_DISK\_2  
使用通道 ORA\_DISK\_3  
使用通道 ORA\_DISK\_4  
使用通道 ORA\_DISK\_5  
使用通道 ORA\_DISK\_6

正在开始介质的恢复  
介质恢复完成, 用时: 00:00:01

完成 recover 于 05-3月 -19

RMAN> exit

SQL> alter database open resetlogs;

数据库已更改。