On this scenario, we’ve been very bad guys and have no good controlfile backup from a recent archive backup, and also had lost some archivelog (let’s guess that the archivelogs lived on the FRA and all the diskgroups where corrupted). That means we have lost some data in time, but on some recovery scenarios, that means better than having nothing, for instance, on non production environments.<\/p>\n
This database doesn’t fit on a tipical development environment, though, as it’s on archivelog mode. Anyway, it’s a perfectly valid example as the only valid database backup is an old full backup, and that’s definitely a damn development scenario. The SAN storage is quite old, did something weird and completely corrupted all development data, and all we have is an old last week’s full backup…WTH…<\/p>\n
How we get to know this? After recovering the hardware outage, the database starts, but the rman validate command finds data corruption:<\/p>\n
[oracle@rac2 ~]$ rman target \/\r\n\r\nRecovery Manager: Release 11.2.0.1.0 - Production on Wed Dec 14 21:36:47 2011\r\n\r\nCopyright (c) 1982, 2009, Oracle and\/or its affiliates. All rights reserved.\r\n\r\nconnected to target database: RACORA (DBID=4104435745)\r\n\r\nRMAN> validate database;\r\n\r\nStarting validate at 14-DEC-11\r\nusing target database control file instead of recovery catalog\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: SID=53 instance=RACORA2 device type=DISK\r\nRMAN-00571: ===========================================================\r\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\r\nRMAN-00571: ===========================================================\r\nRMAN-03002: failure of validate command at 12\/14\/2011 21:37:21\r\nORA-01135: file 3 accessed for DML\/query is offline\r\nORA-01110: data file 3: '+DATA\/racora\/datafile\/undotbs1.269.729858657'\r\nRMAN-06031: could not translate database keyword\r\n\r\nRMAN> \r\n\r\nRecovery Manager complete.<\/pre>\nGood! Then, we’ll see what excatly means, as the database started and open with no erros…<\/p>\n
[oracle@rac2 ~]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 11.2.0.1.0 Production on Wed Dec 14 21:37:44 2011\r\n\r\nCopyright (c) 1982, 2009, Oracle. All rights reserved.\r\n\r\n\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production\r\nWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,\r\nData Mining and Real Application Testing options\r\n\r\nSQL> select FILE_NAME,STATUS from DBA_DATA_FILES;\r\n\r\nFILE_NAME\r\n--------------------------------------------------------------------------------\r\nSTATUS\r\n---------\r\n+DATA\/racora\/datafile\/users.268.729858659\r\nAVAILABLE\r\n\r\n+DATA\/racora\/datafile\/undotbs1.269.729858657\r\nAVAILABLE\r\n\r\n+DATA\/racora\/datafile\/sysaux.261.729858653\r\nAVAILABLE\r\n\r\n\r\nFILE_NAME\r\n--------------------------------------------------------------------------------\r\nSTATUS\r\n---------\r\n+DATA\/racora\/datafile\/system.260.729858643\r\nAVAILABLE\r\n\r\n+DATA\/racora\/datafile\/example.263.729858985\r\nAVAILABLE\r\n\r\n+DATA\/racora\/datafile\/undotbs2.262.729859525\r\nAVAILABLE\r\n\r\n\r\n6 rows selected.<\/pre>\nThe DBA_DATAF_FILES table reports that all datafiles are online and available… what’s going on here?<\/p>\n
SQL> select * from V$DATAFILE;\r\nselect * from V$DATAFILE\r\n *\r\nERROR at line 1:\r\nORA-01135: file 3 accessed for DML\/query is offline\r\nORA-01110: data file 3: '+DATA\/racora\/datafile\/undotbs1.269.729858657'<\/pre>\nNow we see some light (or to day better, darkness). We had some data corruption on the SAN storage outage…<\/p>\n
We try to restore only that datafile with RMAN:<\/p>\n
SQL> alter database datafile 3 OFFLINE;\r\n\r\nDatabase altered.\r\n\r\nSQL> recover datafile 3;\r\nORA-00283: recovery session canceled due to errors\r\nORA-01110: data file 3: '+DATA\/racora\/datafile\/undotbs1.269.729858657'\r\nORA-01122: database file 3 failed verification check\r\nORA-01110: data file 3: '+DATA\/racora\/datafile\/undotbs1.269.729858657'\r\nORA-01210: data file header is media corrupt<\/pre>\nOuch! OK, this is a controlled error, we can bypass it by removing the datafile manually and then performing the restore:<\/p>\n
\r\n[oracle@rac2 ~]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 11.2.0.1.0 Production on Wed Dec 14 21:42:01 2011\r\n\r\nCopyright (c) 1982, 2009, Oracle. All rights reserved.\r\n\r\n\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production\r\nWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,\r\nData Mining and Real Application Testing options\r\n\r\nSQL> shutdown immediatE;\r\nDatabase closed.\r\nDatabase dismounted.\r\nORACLE instance shut down.\r\nSQL> startup mount; \r\nORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance\r\nORACLE instance started.\r\n\r\nTotal System Global Area 521936896 bytes\r\nFixed Size\t\t 2214936 bytes\r\nVariable Size\t\t 289407976 bytes\r\nDatabase Buffers\t 226492416 bytes\r\nRedo Buffers\t\t 3821568 bytes\r\nDatabase mounted.\r\n\r\n[oracle@rac2 ~]$ export ORACLE_SID=+ASM2\r\n[oracle@rac2 ~]$ export ORACLE_HOME=\"\/u01\/app\/11.2.0\/grid\"\r\n[oracle@rac2 ~]$ asmcmd rm '+DATA\/racora\/datafile\/undotbs1.269.729858657'<\/pre>\nAnd we’re ready to keep on the restore and recovery procedure:<\/p>\n
[oracle@rac2 ~]$ rman target \/\r\n\r\nRecovery Manager: Release 11.2.0.1.0 - Production on Wed Dec 14 22:15:55 2011\r\n\r\nCopyright (c) 1982, 2009, Oracle and\/or its affiliates. All rights reserved.\r\n\r\nconnected to target database: RACORA (DBID=4104435745, not open)\r\n\r\nRMAN> restore database;\r\n\r\nStarting restore at 14-DEC-11\r\nusing target database control file instead of recovery catalog\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: SID=35 instance=RACORA2 device type=DISK\r\n\r\nchannel ORA_DISK_1: starting datafile backup set restore\r\nchannel ORA_DISK_1: specifying datafile(s) to restore from backup set\r\nchannel ORA_DISK_1: restoring datafile 00001 to +DATA\/racora\/datafile\/system.260.729858643\r\nchannel ORA_DISK_1: restoring datafile 00002 to +DATA\/racora\/datafile\/sysaux.261.729858653\r\nchannel ORA_DISK_1: restoring datafile 00003 to +DATA\/racora\/datafile\/undotbs1.269.729858657\r\nchannel ORA_DISK_1: restoring datafile 00004 to +DATA\/racora\/datafile\/users.268.729858659\r\nchannel ORA_DISK_1: restoring datafile 00005 to +DATA\/racora\/datafile\/example.263.729858985\r\nchannel ORA_DISK_1: restoring datafile 00006 to +DATA\/racora\/datafile\/undotbs2.262.729859525\r\nchannel ORA_DISK_1: reading from backup piece \/u01\/app\/oracle\/backups\/datafiles\/RACORA_20110708_s4_s1\r\nchannel ORA_DISK_1: piece handle=\/u01\/app\/oracle\/backups\/datafiles\/RACORA_20110708_s4_s1 tag=TAG20110708T164017\r\nchannel ORA_DISK_1: restored backup piece 1\r\nchannel ORA_DISK_1: restore complete, elapsed time: 00:57:31\r\nFinished restore at 14-DEC-11\r\n\r\nRMAN> recover database;\r\n\r\nStarting recover at 15-DEC-11\r\nusing channel ORA_DISK_1\r\n\r\nstarting media recovery\r\n\r\narchived log for thread 1 with sequence 45 is already on disk as file +DATA\/racora\/archivelog\/1_45_729858920.dbf\r\narchived log for thread 1 with sequence 46 is already on disk as file +DATA\/racora\/archivelog\/1_46_729858920.dbf\r\narchived log for thread 1 with sequence 47 is already on disk as file +DATA\/racora\/archivelog\/1_47_729858920.dbf\r\narchived log for thread 1 with sequence 48 is already on disk as file +DATA\/racora\/archivelog\/1_48_729858920.dbf\r\narchived log for thread 1 with sequence 49 is already on disk as file +DATA\/racora\/archivelog\/1_49_729858920.dbf\r\narchived log for thread 1 with sequence 50 is already on disk as file +DATA\/racora\/archivelog\/1_50_729858920.dbf\r\narchived log for thread 1 with sequence 51 is already on disk as file +DATA\/racora\/archivelog\/1_51_729858920.dbf\r\narchived log for thread 1 with sequence 52 is already on disk as file +DATA\/racora\/archivelog\/1_52_729858920.dbf\r\narchived log for thread 1 with sequence 53 is already on disk as file +DATA\/racora\/archivelog\/1_53_729858920.dbf\r\narchived log for thread 1 with sequence 54 is already on disk as file +DATA\/racora\/archivelog\/1_54_729858920.dbf\r\narchived log for thread 1 with sequence 55 is already on disk as file +DATA\/racora\/archivelog\/1_55_729858920.dbf\r\narchived log for thread 1 with sequence 56 is already on disk as file +DATA\/racora\/archivelog\/1_56_729858920.dbf\r\narchived log for thread 1 with sequence 57 is already on disk as file +DATA\/racora\/archivelog\/1_57_729858920.dbf\r\narchived log for thread 1 with sequence 58 is already on disk as file +DATA\/racora\/archivelog\/1_58_729858920.dbf\r\narchived log for thread 1 with sequence 59 is already on disk as file +DATA\/racora\/archivelog\/1_59_729858920.dbf\r\narchived log for thread 1 with sequence 60 is already on disk as file +DATA\/racora\/archivelog\/1_60_729858920.dbf\r\narchived log for thread 1 with sequence 61 is already on disk as file +DATA\/racora\/archivelog\/1_61_729858920.dbf\r\narchived log for thread 1 with sequence 62 is already on disk as file +DATA\/racora\/archivelog\/1_62_729858920.dbf\r\narchived log for thread 1 with sequence 63 is already on disk as file +DATA\/racora\/archivelog\/1_63_729858920.dbf\r\narchived log for thread 1 with sequence 64 is already on disk as file +DATA\/racora\/archivelog\/1_64_729858920.dbf\r\narchived log for thread 1 with sequence 65 is already on disk as file +DATA\/racora\/archivelog\/1_65_729858920.dbf\r\narchived log for thread 1 with sequence 66 is already on disk as file +DATA\/racora\/archivelog\/1_66_729858920.dbf\r\narchived log for thread 1 with sequence 67 is already on disk as file +DATA\/racora\/archivelog\/1_67_729858920.dbf\r\narchived log for thread 1 with sequence 68 is already on disk as file +DATA\/racora\/archivelog\/1_68_729858920.dbf\r\narchived log for thread 1 with sequence 69 is already on disk as file +DATA\/racora\/archivelog\/1_69_729858920.dbf\r\narchived log for thread 2 with sequence 24 is already on disk as file +DATA\/racora\/archivelog\/2_24_729858920.dbf\r\narchived log for thread 2 with sequence 25 is already on disk as file +DATA\/racora\/archivelog\/2_25_729858920.dbf\r\narchived log for thread 2 with sequence 26 is already on disk as file +DATA\/racora\/archivelog\/2_26_729858920.dbf\r\narchived log for thread 2 with sequence 27 is already on disk as file +DATA\/racora\/archivelog\/2_27_729858920.dbf\r\narchived log for thread 2 with sequence 28 is already on disk as file +DATA\/racora\/archivelog\/2_28_729858920.dbf\r\narchived log for thread 2 with sequence 29 is already on disk as file +DATA\/racora\/archivelog\/2_29_729858920.dbf\r\narchived log for thread 2 with sequence 30 is already on disk as file +DATA\/racora\/archivelog\/2_30_729858920.dbf\r\narchived log for thread 2 with sequence 31 is already on disk as file +DATA\/racora\/archivelog\/2_31_729858920.dbf\r\narchived log for thread 2 with sequence 32 is already on disk as file +DATA\/racora\/archivelog\/2_32_729858920.dbf\r\narchived log for thread 2 with sequence 33 is already on disk as file +DATA\/racora\/archivelog\/2_33_729858920.dbf\r\narchived log for thread 2 with sequence 34 is already on disk as file +DATA\/racora\/archivelog\/2_34_729858920.dbf\r\narchived log for thread 2 with sequence 35 is already on disk as file +DATA\/racora\/archivelog\/2_35_729858920.dbf\r\narchived log for thread 2 with sequence 36 is already on disk as file +DATA\/racora\/archivelog\/2_36_729858920.dbf\r\narchived log for thread 2 with sequence 37 is already on disk as file +DATA\/racora\/archivelog\/2_37_729858920.dbf\r\narchived log for thread 2 with sequence 38 is already on disk as file +DATA\/racora\/archivelog\/2_38_729858920.dbf\r\narchived log for thread 2 with sequence 39 is already on disk as file +DATA\/racora\/archivelog\/2_39_729858920.dbf\r\narchived log for thread 2 with sequence 40 is already on disk as file +DATA\/racora\/archivelog\/2_40_729858920.dbf\r\narchived log for thread 2 with sequence 41 is already on disk as file +DATA\/racora\/archivelog\/2_41_729858920.dbf\r\narchived log for thread 2 with sequence 42 is already on disk as file +DATA\/racora\/archivelog\/2_42_729858920.dbf\r\narchived log for thread 2 with sequence 43 is already on disk as file +DATA\/racora\/archivelog\/2_43_729858920.dbf\r\narchived log for thread 2 with sequence 44 is already on disk as file +DATA\/racora\/archivelog\/2_44_729858920.dbf\r\narchived log for thread 2 with sequence 45 is already on disk as file \/u02\/oradata\/ORASTB\/archivelogs\/2_45_729858920.dbf\r\narchived log for thread 2 with sequence 46 is already on disk as file +DATA\/racora\/archivelog\/2_46_729858920.dbf\r\nchannel ORA_DISK_1: starting archived log restore to default destination\r\nchannel ORA_DISK_1: restoring archived log\r\narchived log thread=1 sequence=32\r\nchannel ORA_DISK_1: reading from backup piece \/u01\/app\/oracle\/backups\/datafiles\/RACORA_20110708_s5_s1\r\nchannel ORA_DISK_1: piece handle=\/u01\/app\/oracle\/backups\/datafiles\/RACORA_20110708_s5_s1 tag=TAG20110708T164226\r\nchannel ORA_DISK_1: restored backup piece 1\r\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:03\r\narchived log file name=\/u02\/oradata\/ORASTB\/archivelogs\/1_32_729858920.dbf thread=1 sequence=32<\/pre>\nIf after all of this, your database still doesn’t opens, saying that datafile 1 (System tablespace datafile) needs recovery, then we’ll have to dismiss all data from last controlfile backup.<\/p>\n
As we said, all we have is a full backup including controlfile. We’ll restore the controlfile from that backup and recover the database to that controlfile’s SCN.<\/p>\n
First of all, we recover the controlfile with the database started in “nomount” mode:<\/p>\n
[oracle@rac1 ~]$ ls -l \/u01\/app\/oracle\/backups\/controlspfile\/\r\ntotal 54424\r\n-rw-r----- 1 oracle oinstall 18579456 jul 8 16:37 c-4104435745-20110708-00\r\n-rw-r----- 1 oracle oinstall 18579456 jul 8 16:42 c-4104435745-20110708-01\r\n-rw-r----- 1 oracle oinstall 18497536 jul 8 16:42 snapcf_RACORA1.f\r\n[oracle@rac1 ~]$ rman target \/\r\n\r\nRecovery Manager: Release 11.2.0.1.0 - Production on Sun Dec 18 13:26:05 2011\r\n\r\nCopyright (c) 1982, 2009, Oracle and\/or its affiliates. All rights reserved.\r\n\r\nconnected to target database: RACORA (not mounted)\r\n\r\nRMAN> restore controlfile from '\/u01\/app\/oracle\/backups\/controlspfile\/c-4104435745-20110708-01';\r\n\r\nStarting restore at 18-DEC-11\r\nusing target database control file instead of recovery catalog\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: SID=1 instance=RACORA1 device type=DISK\r\n\r\nchannel ORA_DISK_1: restoring control file\r\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:07\r\noutput file name=+DATA\/racora\/controlfile\/current.267.729858913\r\nFinished restore at 18-DEC-11<\/pre>\nThen, we restore and recover the database:<\/p>\n
RMAN> mount database;\r\n\r\ndatabase mounted\r\nreleased channel: ORA_DISK_1\r\n\r\nRMAN> restore database;\r\n\r\nStarting restore at 18-DEC-11\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: SID=1 instance=RACORA1 device type=DISK\r\n\r\nchannel ORA_DISK_1: starting datafile backup set restore\r\nchannel ORA_DISK_1: specifying datafile(s) to restore from backup set\r\nchannel ORA_DISK_1: restoring datafile 00001 to +DATA\/racora\/datafile\/system.260.729858643\r\nchannel ORA_DISK_1: restoring datafile 00002 to +DATA\/racora\/datafile\/sysaux.261.729858653\r\nchannel ORA_DISK_1: restoring datafile 00003 to +DATA\/racora\/datafile\/undotbs1.269.729858657\r\nchannel ORA_DISK_1: restoring datafile 00004 to +DATA\/racora\/datafile\/users.268.729858659\r\nchannel ORA_DISK_1: restoring datafile 00005 to +DATA\/racora\/datafile\/example.263.729858985\r\nchannel ORA_DISK_1: restoring datafile 00006 to +DATA\/racora\/datafile\/undotbs2.262.729859525\r\nchannel ORA_DISK_1: reading from backup piece \/u01\/app\/oracle\/backups\/datafiles\/RACORA_20110708_s4_s1\r\nchannel ORA_DISK_1: piece handle=\/u01\/app\/oracle\/backups\/datafiles\/RACORA_20110708_s4_s1 tag=TAG20110708T164017\r\nchannel ORA_DISK_1: restored backup piece 1\r\nchannel ORA_DISK_1: restore complete, elapsed time: 00:04:46\r\nFinished restore at 18-DEC-11\r\n\r\nRMAN> \r\n\r\nRecovery Manager complete.\r\n[oracle@rac1 ~]$ rman target \/\r\n\r\nRecovery Manager: Release 11.2.0.1.0 - Production on Sun Dec 18 13:39:26 2011\r\n\r\nCopyright (c) 1982, 2009, Oracle and\/or its affiliates. All rights reserved.\r\n\r\nconnected to target database: RACORA (DBID=4104435745, not open)\r\n\r\nRMAN> recover database;\r\n\r\nStarting recover at 18-DEC-11\r\nusing target database control file instead of recovery catalog\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: SID=32 instance=RACORA1 device type=DISK\r\n\r\nstarting media recovery\r\n\r\narchived log for thread 1 with sequence 32 is already on disk as file +DATA\/racora\/archivelog\/1_32_729858920.dbf\r\narchived log for thread 1 with sequence 68 is already on disk as file +DATA\/racora\/onlinelog\/group_2.265.729858931\r\narchived log for thread 1 with sequence 69 is already on disk as file +DATA\/racora\/onlinelog\/group_1.266.729858921\r\narchived log for thread 2 with sequence 46 is already on disk as file +DATA\/racora\/onlinelog\/group_4.258.729859647\r\narchived log for thread 2 with sequence 47 is already on disk as file +DATA\/racora\/onlinelog\/group_3.259.729859639\r\narchived log file name=+DATA\/racora\/archivelog\/1_32_729858920.dbf thread=1 sequence=32\r\narchived log file name=+DATA\/racora\/archivelog\/1_33_729858920.dbf thread=1 sequence=33\r\narchived log file name=+DATA\/racora\/archivelog\/1_34_729858920.dbf thread=1 sequence=34\r\narchived log file name=+DATA\/racora\/archivelog\/2_14_729858920.dbf thread=2 sequence=14\r\narchived log file name=+DATA\/racora\/archivelog\/2_15_729858920.dbf thread=2 sequence=15\r\narchived log file name=+DATA\/racora\/archivelog\/1_35_729858920.dbf thread=1 sequence=35\r\narchived log file name=+DATA\/racora\/archivelog\/2_16_729858920.dbf thread=2 sequence=16\r\narchived log file name=+DATA\/racora\/archivelog\/2_17_729858920.dbf thread=2 sequence=17\r\narchived log file name=+DATA\/racora\/archivelog\/1_36_729858920.dbf thread=1 sequence=36\r\narchived log file name=+DATA\/racora\/archivelog\/2_18_729858920.dbf thread=2 sequence=18\r\narchived log file name=+DATA\/racora\/archivelog\/1_37_729858920.dbf thread=1 sequence=37\r\narchived log file name=+DATA\/racora\/archivelog\/2_19_729858920.dbf thread=2 sequence=19\r\narchived log file name=+DATA\/racora\/archivelog\/2_20_729858920.dbf thread=2 sequence=20\r\narchived log file name=+DATA\/racora\/archivelog\/1_38_729858920.dbf thread=1 sequence=38\r\narchived log file name=+DATA\/racora\/archivelog\/2_21_729858920.dbf thread=2 sequence=21\r\narchived log file name=+DATA\/racora\/archivelog\/1_39_729858920.dbf thread=1 sequence=39\r\narchived log file name=+DATA\/racora\/archivelog\/1_40_729858920.dbf thread=1 sequence=40\r\narchived log file name=+DATA\/racora\/archivelog\/2_22_729858920.dbf thread=2 sequence=22\r\narchived log file name=+DATA\/racora\/archivelog\/2_23_729858920.dbf thread=2 sequence=23\r\narchived log file name=+DATA\/racora\/archivelog\/1_41_729858920.dbf thread=1 sequence=41\r\narchived log file name=+DATA\/racora\/archivelog\/1_42_729858920.dbf thread=1 sequence=42\r\narchived log file name=+DATA\/racora\/archivelog\/1_43_729858920.dbf thread=1 sequence=43\r\narchived log file name=+DATA\/racora\/archivelog\/1_44_729858920.dbf thread=1 sequence=44\r\narchived log file name=+DATA\/racora\/archivelog\/2_24_729858920.dbf thread=2 sequence=24\r\narchived log file name=+DATA\/racora\/archivelog\/1_45_729858920.dbf thread=1 sequence=45\r\narchived log file name=+DATA\/racora\/archivelog\/2_25_729858920.dbf thread=2 sequence=25\r\narchived log file name=+DATA\/racora\/archivelog\/1_46_729858920.dbf thread=1 sequence=46\r\narchived log file name=+DATA\/racora\/archivelog\/2_26_729858920.dbf thread=2 sequence=26\r\narchived log file name=+DATA\/racora\/archivelog\/1_47_729858920.dbf thread=1 sequence=47\r\narchived log file name=+DATA\/racora\/archivelog\/2_27_729858920.dbf thread=2 sequence=27\r\narchived log file name=+DATA\/racora\/archivelog\/1_48_729858920.dbf thread=1 sequence=48\r\narchived log file name=+DATA\/racora\/archivelog\/1_49_729858920.dbf thread=1 sequence=49\r\narchived log file name=+DATA\/racora\/archivelog\/2_28_729858920.dbf thread=2 sequence=28\r\narchived log file name=+DATA\/racora\/archivelog\/1_50_729858920.dbf thread=1 sequence=50\r\narchived log file name=+DATA\/racora\/archivelog\/2_29_729858920.dbf thread=2 sequence=29\r\narchived log file name=+DATA\/racora\/archivelog\/1_51_729858920.dbf thread=1 sequence=51\r\narchived log file name=+DATA\/racora\/archivelog\/2_30_729858920.dbf thread=2 sequence=30\r\narchived log file name=+DATA\/racora\/archivelog\/1_52_729858920.dbf thread=1 sequence=52\r\narchived log file name=+DATA\/racora\/archivelog\/2_31_729858920.dbf thread=2 sequence=31\r\narchived log file name=+DATA\/racora\/archivelog\/2_32_729858920.dbf thread=2 sequence=32\r\narchived log file name=+DATA\/racora\/archivelog\/1_53_729858920.dbf thread=1 sequence=53\r\narchived log file name=+DATA\/racora\/archivelog\/2_33_729858920.dbf thread=2 sequence=33\r\narchived log file name=+DATA\/racora\/archivelog\/1_54_729858920.dbf thread=1 sequence=54\r\narchived log file name=+DATA\/racora\/archivelog\/2_34_729858920.dbf thread=2 sequence=34\r\narchived log file name=+DATA\/racora\/archivelog\/1_55_729858920.dbf thread=1 sequence=55\r\narchived log file name=+DATA\/racora\/archivelog\/2_35_729858920.dbf thread=2 sequence=35\r\narchived log file name=+DATA\/racora\/archivelog\/1_56_729858920.dbf thread=1 sequence=56\r\narchived log file name=+DATA\/racora\/archivelog\/1_57_729858920.dbf thread=1 sequence=57\r\narchived log file name=+DATA\/racora\/archivelog\/2_36_729858920.dbf thread=2 sequence=36\r\narchived log file name=+DATA\/racora\/archivelog\/2_37_729858920.dbf thread=2 sequence=37\r\narchived log file name=+DATA\/racora\/archivelog\/1_58_729858920.dbf thread=1 sequence=58\r\narchived log file name=+DATA\/racora\/archivelog\/2_38_729858920.dbf thread=2 sequence=38\r\narchived log file name=+DATA\/racora\/archivelog\/2_39_729858920.dbf thread=2 sequence=39\r\narchived log file name=+DATA\/racora\/archivelog\/1_59_729858920.dbf thread=1 sequence=59\r\narchived log file name=+DATA\/racora\/archivelog\/1_60_729858920.dbf thread=1 sequence=60\r\narchived log file name=+DATA\/racora\/archivelog\/2_40_729858920.dbf thread=2 sequence=40\r\narchived log file name=+DATA\/racora\/archivelog\/1_61_729858920.dbf thread=1 sequence=61\r\narchived log file name=+DATA\/racora\/archivelog\/1_62_729858920.dbf thread=1 sequence=62\r\narchived log file name=+DATA\/racora\/archivelog\/2_41_729858920.dbf thread=2 sequence=41\r\narchived log file name=+DATA\/racora\/archivelog\/1_63_729858920.dbf thread=1 sequence=63\r\narchived log file name=+DATA\/racora\/archivelog\/2_42_729858920.dbf thread=2 sequence=42\r\narchived log file name=+DATA\/racora\/archivelog\/2_43_729858920.dbf thread=2 sequence=43\r\narchived log file name=+DATA\/racora\/archivelog\/1_64_729858920.dbf thread=1 sequence=64\r\narchived log file name=+DATA\/racora\/archivelog\/1_65_729858920.dbf thread=1 sequence=65\r\narchived log file name=+DATA\/racora\/archivelog\/1_66_729858920.dbf thread=1 sequence=66\r\narchived log file name=+DATA\/racora\/archivelog\/2_44_729858920.dbf thread=2 sequence=44\r\narchived log file name=+DATA\/racora\/archivelog\/2_45_729858920.dbf thread=2 sequence=45\r\narchived log file name=+DATA\/racora\/archivelog\/1_67_729858920.dbf thread=1 sequence=67\r\narchived log file name=+DATA\/racora\/onlinelog\/group_2.265.729858931 thread=1 sequence=68\r\narchived log file name=+DATA\/racora\/onlinelog\/group_4.258.729859647 thread=2 sequence=46\r\narchived log file name=+DATA\/racora\/onlinelog\/group_1.266.729858921 thread=1 sequence=69\r\narchived log file name=+DATA\/racora\/onlinelog\/group_3.259.729859639 thread=2 sequence=47\r\nmedia recovery complete, elapsed time: 00:07:31\r\nFinished recover at 18-DEC-11\r\n\r\nRMAN> \r\n<\/pre>\nAnd now we open the database with the resetlogs option:<\/p>\n
[oracle@rac1 ~]$ sqlplus '\/as sysdba'\r\n\r\nSQL*Plus: Release 11.2.0.1.0 Production on Sun Dec 18 13:48:17 2011\r\n\r\nCopyright (c) 1982, 2009, Oracle. All rights reserved.\r\n\r\n\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production\r\nWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,\r\nData Mining and Real Application Testing options\r\n\r\nSQL> alter database open resetlogs;\r\n\r\nDatabase altered.\r\n\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"On this scenario, we’ve been very bad guys and have no good controlfile backup from a recent archive backup, and also had lost some archivelog (let’s guess that the archivelogs lived on the FRA and all the diskgroups where corrupted). That means we have lost some data in time, but on some recovery scenarios, that […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/selectsysdatefromdual.gnusystems.net\/index.php?rest_route=\/wp\/v2\/posts\/102"}],"collection":[{"href":"https:\/\/selectsysdatefromdual.gnusystems.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/selectsysdatefromdual.gnusystems.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/selectsysdatefromdual.gnusystems.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/selectsysdatefromdual.gnusystems.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=102"}],"version-history":[{"count":6,"href":"https:\/\/selectsysdatefromdual.gnusystems.net\/index.php?rest_route=\/wp\/v2\/posts\/102\/revisions"}],"predecessor-version":[{"id":108,"href":"https:\/\/selectsysdatefromdual.gnusystems.net\/index.php?rest_route=\/wp\/v2\/posts\/102\/revisions\/108"}],"wp:attachment":[{"href":"https:\/\/selectsysdatefromdual.gnusystems.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=102"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/selectsysdatefromdual.gnusystems.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=102"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/selectsysdatefromdual.gnusystems.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=102"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}