rman整库备份还原.docxVIP

整库丢失 1登录rman rman target / 2 备份数据库和归档文件 backup database plus archivelog all; 3 产看备份情况 list backup; 4模拟数据变化 create table test31 as select * from dba_users; alter system switch logfile; create table test32 as select * from dba_users; alter system switch logfile; create table test33 as select * from dba_users; 5删除整个数据库 cd /home/app/oracle/oradata rm –rf ora 数据库已经损坏 6根据数据库启动流程，首先恢复spfile vi initora.ora i db_name=ora :wq -bash-4.2$ sqlplus / as sysdba shut immediate force; 还原数据库 找到备份文件 rman target / 进入rman设置dbid为备份片的id set dbid=1589493431 还原数据库 恢复控制文件 restore controlfile from autobackup; 设置数据库为mount状态 alter database mount; 恢复数据库 restore database; recover database; Starting recover at 22-MAR-18 using channel ORA_DISK_1 starting media recovery archived log for thread 1 with sequence 10 is already on disk as file /home/archivelog/1_10_971265017.dbf archived log for thread 1 with sequence 11 is already on disk as file /home/archivelog/1_11_971265017.dbf archived log file name=/home/archivelog/1_10_971265017.dbf thread=1 sequence=10 archived log file name=/home/archivelog/1_11_971265017.dbf thread=1 sequence=11 unable to find archived log archived log thread=1 sequence=12 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 03/22/2018 13:57:25 RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 12 and starting SCN of 1879455 开始恢复在22-MAR-18 使用通道ORA_DISK_1 媒体开始复苏 以序列10为线程1的归档日志已经在磁盘上作为文件/home/archivelog/1 _10_ 971265017.dbf。 以序列11为线程1的归档日志已经在磁盘上作为文件/home/archivelog/1 _11_ 971265017.dbf。 归档日志文件名称= / home / archivelog _10_971265017 / 1。dbf线程= 1序列= 10 归档日志文件名称= / home / archivelog _11_971265017 / 1。dbf线程= 1 = 11序列 无法找到归档日志。 归档日志线程= 1序列= 12 rman - 00571:= = = = = = = = = = = = = = = = = = = = = = = =