current online redo logfile 丢失的处理方法(2)

由于rman并不备份在线日志文件,刚才的rman只是做了个全库备份和控制文件的备份,可以看到redo01.log,redo02.log,redo03.log这3个文件并不存在
 

[oracle@ora10g ~]$ sqlplus / as sysdba
 

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Aug 26 14:52:35 2014
 

Copyright (c) 1982, 2005, Oracle.  All rights reserved.
 

Connected to:
 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
 With the Partitioning, OLAP and Data Mining options
 

SQL> select open_mode from v$database;
 

OPEN_MODE
 ----------
 MOUNTED
 

SQL> col member for a60
 SQL> select group#,member from v$logfile;
 

GROUP# MEMBER
 ---------- ------------------------------------------------------------
          3 /u01/app/oracle/oradata/ora10g/redo03.log
          2 /u01/app/oracle/oradata/ora10g/redo02.log
          1 /u01/app/oracle/oradata/ora10g/redo01.log
 
 SQL> alter database open resetlogs;
 alter database open resetlogs
 *
 ERROR at line 1:
 ORA-01152: file 1 was not restored from a sufficiently old backup
 ORA-01110: data file 1: '/u01/app/oracle/oradata/ora10g/system01.dbf'
 

由于只是restore了数据库,还未recover,数据库是无法打开的
 

SQL> recover database
 ORA-00283: recovery session canceled due to errors
 ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
 

SQL> recover database until cancel;
 ORA-00283: recovery session canceled due to errors
 ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
 

SQL> recover database using backup controlfile;
 ORA-00279: change 502729 generated at 08/26/2014 15:36:54 needed for thread 1
 ORA-00289: suggestion :
 /u01/app/oracle/flash_recovery_area/ORA10G/archivelog/2014_08_26/o1_mf_1_3_%u_.arc
 ORA-00280: change 502729 for thread 1 is in sequence #3
 

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
 auto
 ORA-00308: cannot open archived log
 '/u01/app/oracle/flash_recovery_area/ORA10G/archivelog/2014_08_26/o1_mf_1_3_%u_.arc'
 ORA-27037: unable to obtain file status
 Linux Error: 2: No such file or directory
 Additional information: 3
 

ORA-00308: cannot open archived log
 '/u01/app/oracle/flash_recovery_area/ORA10G/archivelog/2014_08_26/o1_mf_1_3_%u_.arc'
 ORA-27037: unable to obtain file status
 Linux Error: 2: No such file or directory
 Additional information: 3
 

SQL> recover database using backup controlfile until cancel;
 ORA-00279: change 502729 generated at 08/26/2014 15:36:54 needed for thread 1
 ORA-00289: suggestion :
 /u01/app/oracle/flash_recovery_area/ORA10G/archivelog/2014_08_26/o1_mf_1_3_%u_.arc
 ORA-00280: change 502729 for thread 1 is in sequence #3
 

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
 cancel
 Media recovery cancelled.
 SQL>
 


由于之前的归档没有用rman备份,而现在也不存在了,无法recover数据库,就算用resetlogs也无法open数据库。此时,只有通过隐含参数_allow_resetlogs_corruption来open数据库了
 


SQL> show parameter spfile
 

NAME                                TYPE        VALUE
 ------------------------------------ ----------- ------------------------------
 spfile                              string      /u01/app/oracle/product/10.2.0
                                                  /db_1/dbs/spfileora10g.ora
 

--创建pfile 
 SQL> create pfile from spfile;
 

File created.
 

--编辑$ORACLE_HOME/dbs/initora10g.ora初始化参数文件,在文件末尾添加*._allow_resetlogs_corruption = true
 [oracle@ora10g ora10g]$ vi $ORACLE_HOME/dbs/initora10g.ora
 

ora10g.__db_cache_size=180355072
 ora10g.__java_pool_size=4194304
 ora10g.__large_pool_size=4194304
 ora10g.__shared_pool_size=92274688
 ora10g.__streams_pool_size=0
 *.audit_file_dest='/u01/app/oracle/admin/ora10g/adump'
 *.background_dump_dest='/u01/app/oracle/admin/ora10g/bdump'
 *.compatible='10.2.0.1.0'
 *.control_files='/u01/app/oracle/oradata/ora10g/control01.ctl','/u01/app/oracle/oradata/ora10g/control02.ctl','/u01/app/oracle/oradata/ora10g/control03.ctl'#Restore Controlfile
 *.core_dump_dest='/u01/app/oracle/admin/ora10g/cdump'
 *.db_block_size=8192
 *.db_domain=''
 *.db_file_multiblock_read_count=16
 *.db_name='ora10g'
 *.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
 *.db_recovery_file_dest_size=2147483648
 *.dispatchers='(PROTOCOL=TCP) (SERVICE=ora10gXDB)'
 *.job_queue_processes=10
 *.log_archive_format='%t_%s_%r.dbf'
 *.nls_language='SIMPLIFIED CHINESE'
 *.nls_territory='CHINA'
 *.open_cursors=300
 *.pga_aggregate_target=94371840
 *.processes=150
 *.remote_login_passwordfile='EXCLUSIVE'
 *.sga_target=285212672
 *.undo_management='AUTO'
 *.undo_tablespace='UNDOTBS1'
 *.user_dump_dest='/u01/app/oracle/admin/ora10g/udump'
 *._allow_resetlogs_corruption=TRUE
 

--关闭数据库实例,用pfile启动
 SQL> shutdown immediate
 ORA-01109: database not open
 


Database dismounted.
 ORACLE instance shut down.
 SQL> startup pfile=$ORACLE_HOME/dbs/initora10g.ora
 ORACLE instance started.
 

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/5a4e08cb5aeb0a5a7748b38c837e0b25.html