rman备份恢复日记.doc

恢复密码文件 orapwd file=orapwdz password=sys entries=5 恢复控制文件 数据库启动到NOMOUNT状态 登陆RMAN 用RESTORE CONTROLFILE FROM AUTOBACKUP；进行恢复 错误处理： RMAN-06495: must explicitly specify DBID with SET DBID command 设置下DBID即可，SETDBID=； RMAN-06172: no autobackup found or specified handle is not a valid copy or piece 没发现可以供恢复的备份文件，一、可能是自动备份未成功，此原因无法恢复；二、RMAN自动寻找7天之内的备份文件没有找到，解决方法有两种，一种是RESTORE SPFILE FROM AUTOBACKUP UNTIL TIME ‘SYSDATE – N’的方法。另一种是RESTORE SPFILE FROM AUTOBACKUP MAXDAYS Nrestore controlfile from /data1/backup/testdata/c-227076259301 数据库启动到MOUNT状态； alter database open resetlogs; RMAN-03002: failure of alter db command at 01/09/2011 03:10:20 ORA-01153: an incompatible media recovery is active 需要我们RECOVER DATABASE RECOVER DATABASE； 恢复REDOLOG 在SQLPLUS下运行以下语句 1、启动数据库到MOUNT状态 2、recover database until cancel; 3、Alter database open resetlogs; 提示ORA-01139: RESETLOGS option only valid after an incomplete database recovery 解决办法：切换到SQLPLUS下运行 在mount过后运行‘recover database until cancel; ‘ 恢复datafile 先将DATAFILE置于OFFLINE状态下 alter database datafile 5 offline RESTORE DATAFILE 5; RMAN-06026: some targets not found - aborting restore RMAN-06023: no backup or copy of datafile 10 found to restore 解决办法： [oracle@localhost ~]$ sqlplus /nolog SQL*Plus: Release 9.2.0.4.0 - Production on Wed Jan 12 05:22:44 2011 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL conn /as sysdba Connected. SQL shutdown immediate; ORA-01507: database not mounted ORACLE instance shut down. SQL startup nomount; ORACLE instance started. Total System Global Area 236000356 bytes Fixed Size 451684 bytes Variable Size 201326592 bytes Database Buffers bytes Redo Buffers 667648 bytes SQL DECLARE devtype varchar2(256); done boolean; BEGIN devtype:=sys.dbms_backup_restore.deviceAllocate(type=,ident=t1); sys.dbms_backup_restore.restoreSetDatafile; sys.dbms_backup_restore.restoreDatafileTo(dfnumber=10,toname=/u01/oracle/oradata/rmanda