RMAN> alter database open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 09/16/2014 17:06:10
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/u01/app/oracle/oradata/orcl/system01.dbf'
RMAN> restore datafile 1;
Starting restore at 16-SEP-14
using channel ORA_DISK_1
skipping datafile 1; already restored to file /u01/app/oracle/oradata/orcl/system01.dbf
restore not done; all files read only, offline, or already restored
Finished restore at 16-SEP-14
RMAN> alter database open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 09/16/2014 17:06:16
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/u01/app/oracle/oradata/orcl/system01.dbf'复制代码恢复用的是
第一步,根据备份的spfile建立相应的目录,adump,bdump,cdump,udump.
第二步,恢复spfile,restore spfile from '/u01/app/rman_backup/controlfileback/cntrl_%s_%p_%s'; 更改$OARCLE_SID目的数据库的sid,然后用恢复的spfile启动数据库到mount状态。
第三步,恢复controlfile, restore controlfile from '/u01/app/rman_backup/controlfileback/cntrl_%s_%p_%s'; 然后建立controfile中对应的数据文件,联机日志文件所对应的目录。
第四步,像controlfile中注册rman信息。catalog start with '/u01/app/‘;
第五步,取回备份数据。 restore database;
第六步,开始恢复 recover database;
第七步,alter database open resetlogs;