背景:这里提到的常规恢复指的是数据库有完备可用的RMAN物理备份。实验环境:RHEL6.4 + Oracle 11.2.0.4 DG primary.
一、常规恢复之完全恢复:不丢失数据
Oracle 数据库常规恢复的几个概念:
常规恢复之完全恢复:不丢失数据。
比如数据文件丢失,临时文件丢失,参数文件丢失。可以通过RMAN备份完全恢复数据库。
示例: Oracle Recovery 01 - 常规恢复之完全恢复
常规恢复之不完全恢复:部分数据丢失。
一般是有控制文件或是在线重做日志文件丢失。通过RMAN备份恢复,resetlogs会导致丢失数据。
示例: Oracle Recovery 02 - 常规恢复之不完全恢复
SQL> startup ORACLE instance started. Total System Global Area 1620115456 bytes Fixed Size 2253704 bytes Variable Size 905972856 bytes Database Buffers 704643072 bytes Redo Buffers 7245824 bytes Database mounted. ORA-01157: cannot identify/lock data file 15 - see DBWR trace file ORA-01110: data file 15: '+DATA1/jyzhao/datafile/dbs_d_jingyu.259.886871319'
RMAN> restore datafile 15; recover datafile 15; sql 'alter database datafile 15 online'; sql 'alter database open';
SQL> startup ORACLE instance started. Total System Global Area 1620115456 bytes Fixed Size 2253704 bytes Variable Size 905972856 bytes Database Buffers 704643072 bytes Redo Buffers 7245824 bytes Database mounted. ORA-01157: cannot identify/lock data file 1 - see DBWR trace file ORA-01110: data file 1: '+DATA1/jyzhao/datafile/system.278.886441901'
RMAN> restore database; recover database; sql 'alter database open';
SQL> startup ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+DATA1/jyzhao/spfilejyzhao.ora' ORA-17503: ksfdopn:2 Failed to open file +DATA1/jyzhao/spfilejyzhao.ora ORA-15056: additional error message ORA-17503: ksfdopn:2 Failed to open file +DATA1/jyzhao/spfilejyzhao.ora ORA-15173: entry 'spfilejyzhao.ora' does not exist in directory 'jyzhao' ORA-06512: at line 4
1)vi编辑初始化参数文件,指定db_name, control_files,compatible
vi /u01/app/oracle/product/11.2.0/db_1/dbs/init86.ora
db_name='jyzhao' control_files = '+DATA1/JYZHAO/CONTROLFILE/Current.260.874084673' compatible ='11.2.0.4'
SQL> startup mount pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/init86.ora'
RMAN> restore spfile from autobackup;
SQL> shutdown abort SQL> startup
综合考虑1.3,1.2,1.1的内容。
先按照1.3恢复参数文件,再根据实际情况选择1.1或1.2。
重启库之后自动修复临时文件并成功open数据库。可以在alert.log看到如下一段日志:
[8440] Successfully onlined Undo Tablespace 2. Undo initialization finished serial:0 start:348324004 end:348324254 diff:250 (2 seconds) Verifying file header compatibility for 11g tablespace encryption.. Verifying 11g file header compatibility for tablespace encryption completed SMON: enabling tx recovery Re-creating tempfile +DATA1/jyzhao/tempfile/temp.264.874084679 as +DATA1/jyzhao/tempfile/temp.264.887107953 Database Characterset is ZHS16GBK No Resource Manager plan active Archived Log entry 1162 added for thread 1 sequence 883 ID 0x93779c13 dest 1: ARC1: Standby redo logfile selected for thread 1 sequence 883 for destination LOG_ARCHIVE_DEST_2 replication_dependency_tracking turned off (no async multimaster replication found) Starting background process QMNC Fri Aug 07 10:52:33 2015 QMNC started with pid=38, OS id=8605 ARC3: Archival started ARC0: STARTING ARCH PROCESSES COMPLETE Completed: ALTER DATABASE OPEN