Thursday 18 February 2016

Recovery scenario during Loss of system datafile.

LOSS OF SYSTEM DATAFILE (Complete recovery because we have online redo logs and current controlfile)

Assumption:
- All the archive logs are found in local file system for recovery.
- If there are multiple datafiles under system tablespace,try restoring all the system tablespace datafiles and do the recover.

1. I have corrupted the system.dbf by redirecting the contents of one text file. Below are the details.



cat abcd > SID_system01.dbf
ls -ltr
total 2885816
-rw-r-----   1 oracle   dba        10486272 Oct 26 09:00 SID_redo01b.log
-rw-r-----   1 oracle   dba        10486272 Oct 26 09:00 SID_redo01a.log
-rw-r-----   1 oracle   dba        52436992 Oct 26 09:05 SID_users01.dbf
-rw-r-----   1 oracle   dba       104865792 Oct 26 09:05 SID_autoindexes01.dbf
-rw-r-----   1 oracle   dba       524296192 Oct 26 09:05 SID_autodata01.dbf
-rw-r-----   1 oracle   dba       524296192 Oct 26 13:17 SID_sysaux01.dbf
-rw-r-----   1 oracle   dba       209723392 Oct 26 13:22 SID_undotbs01.dbf
-rw-r--r--   1 oracle   dba            5017 Oct 26 13:25 abcd
-rw-r-----   1 oracle   dba        10486272 Oct 26 13:26 SID_redo02b.log
-rw-r-----   1 oracle   dba        10486272 Oct 26 13:26 SID_redo02a.log
-rw-r-----   1 oracle   dba            5017 Oct 26 13:27 SID_system01.dbf
-rw-r-----   1 oracle   dba         6602752 Oct 26 13:27 SID_control03.ctl
-rw-r-----   1 oracle   dba         6602752 Oct 26 13:27 SID_control02.ctl
-rw-r-----   1 oracle   dba         6602752 Oct 26 13:27 SID_control01.ctl

2. Connected to the database try to get the database information from any view (DBA_*, v$ or gv$ views) and got the below error while trying to get the info from dba_data_files;

sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Oct 26 13:27:59 2009
Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning and Data Mining options

SQL> select * from dba_data_files;
select * from dba_data_files
              *
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01115: IO error reading block from file 1 (block # 6880)
ORA-01110: data file 1: '/restore1/oracle/SID/data/SID_system01.dbf'
ORA-27091: unable to queue I/O
ORA-27072: File I/O error
IBM AIX RISC System/6000 Error: 25: Not a typewriter
Additional information: 7
Additional information: 6879
3. Shutdown the database using shut abort.
SQL> shut abort
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning and Data Mining options
oracle@tb152:/restore1/oracle/SID/data>

4. Here we have the rman backup and I have restored the system.dbf (If we have multiple rman backups restore the dataifile from latest backup using tag).

RMAN> restore datafile 1;

Starting restore at 26-OCT-09
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/26/2009 13:29:53
RMAN-12010: automatic channel allocation initialization failed
RMAN-06403: could not obtain a fully authorized session
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
IBM AIX RISC System/6000 Error: 2: No such file or directory

Note:
Got the above error when I try to restore the datafiles without mounting database.

5. started the database in mount status and restored the system.dbf datafile;

RMAN>startup mount;

Oracle instance started
database mounted

Total System Global Area     838860800 bytes

Fixed Size                     2074928 bytes
Variable Size                503318224 bytes
Database Buffers             327155712 bytes
Redo Buffers                   6311936 bytes

RMAN> restore datafile 1;

Starting restore at 26-OCT-09
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=211 devtype=DISK
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: sid=209 devtype=SBT_TAPE
channel ORA_SBT_TAPE_1: NMO v4.5.0.0

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /restore1/oracle/SID/data/SID_system01.dbf
channel ORA_DISK_1: reading from backup piece /restore1/oracle/SID/backup/SID_20091013_700141178_4889_1_L0.dbf
channel ORA_DISK_1: restored backup piece 1
piece handle=/restore1/oracle/SID/backup/SID_20091013_700141178_4889_1_L0.dbf tag=TAG20091013T113938
channel ORA_DISK_1: restore complete, elapsed time: 00:00:36
Finished restore at 26-OCT-09

6. Start recoving the datafile Once datafile is restored successfully.(Make sure and available all the required archive logs in archive log destination).

RMAN> recover database;

Starting recover at 26-OCT-09
using channel ORA_DISK_1
using channel ORA_SBT_TAPE_1

starting media recovery

archive log thread 1 sequence 23 is already on disk as file /restore1/oracle/SID/admin/a01/1_23_700066042.dbf
archive log thread 1 sequence 24 is already on disk as file /restore1/oracle/SID/admin/a01/1_24_700066042.dbf
archive log thread 1 sequence 25 is already on disk as file /restore1/oracle/SID/admin/a01/1_25_700066042.dbf
archive log thread 1 sequence 26 is already on disk as file /restore1/oracle/SID/admin/a01/1_26_700066042.dbf
archive log thread 1 sequence 27 is already on disk as file /restore1/oracle/SID/admin/a01/1_27_700066042.dbf
archive log thread 1 sequence 28 is already on disk as file /restore1/oracle/SID/admin/a01/1_28_700066042.dbf
archive log thread 1 sequence 29 is already on disk as file /restore1/oracle/SID/admin/a01/1_29_700066042.dbf
archive log thread 1 sequence 30 is already on disk as file /restore1/oracle/SID/admin/a01/1_30_700066042.dbf
archive log thread 1 sequence 31 is already on disk as file /restore1/oracle/SID/admin/a01/1_31_700066042.dbf
archive log thread 1 sequence 32 is already on disk as file /restore1/oracle/SID/admin/a01/1_32_700066042.dbf
archive log thread 1 sequence 33 is already on disk as file /restore1/oracle/SID/admin/a01/1_33_700066042.dbf
archive log thread 1 sequence 34 is already on disk as file /restore1/oracle/SID/admin/a01/1_34_700066042.dbf
archive log thread 1 sequence 35 is already on disk as file /restore1/oracle/SID/admin/a01/1_35_700066042.dbf
archive log thread 1 sequence 36 is already on disk as file /restore1/oracle/SID/admin/a01/1_36_700066042.dbf
archive log thread 1 sequence 37 is already on disk as file /restore1/oracle/SID/admin/a01/1_37_700066042.dbf
archive log thread 1 sequence 38 is already on disk as file /restore1/oracle/SID/admin/a01/1_38_700066042.dbf
archive log thread 1 sequence 39 is already on disk as file /restore1/oracle/SID/admin/a01/1_39_700066042.dbf
archive log thread 1 sequence 40 is already on disk as file /restore1/oracle/SID/admin/a01/1_40_700066042.dbf
archive log thread 1 sequence 41 is already on disk as file /restore1/oracle/SID/admin/a01/1_41_700066042.dbf
archive log thread 1 sequence 42 is already on disk as file /restore1/oracle/SID/admin/a01/1_42_700066042.dbf
archive log thread 1 sequence 43 is already on disk as file /restore1/oracle/SID/admin/a01/1_43_700066042.dbf
archive log thread 1 sequence 44 is already on disk as file /restore1/oracle/SID/admin/a01/1_44_700066042.dbf
archive log thread 1 sequence 45 is already on disk as file /restore1/oracle/SID/admin/a01/1_45_700066042.dbf
archive log thread 1 sequence 46 is already on disk as file /restore1/oracle/SID/admin/a01/1_46_700066042.dbf
archive log thread 1 sequence 47 is already on disk as file /restore1/oracle/SID/admin/a01/1_47_700066042.dbf
archive log thread 1 sequence 48 is already on disk as file /restore1/oracle/SID/admin/a01/1_48_700066042.dbf
archive log thread 1 sequence 49 is already on disk as file /restore1/oracle/SID/admin/a01/1_49_700066042.dbf
archive log thread 1 sequence 50 is already on disk as file /restore1/oracle/SID/admin/a01/1_50_700066042.dbf
archive log thread 1 sequence 51 is already on disk as file /restore1/oracle/SID/admin/a01/1_51_700066042.dbf
archive log thread 1 sequence 52 is already on disk as file /restore1/oracle/SID/admin/a01/1_52_700066042.dbf
archive log thread 1 sequence 53 is already on disk as file /restore1/oracle/SID/admin/a01/1_53_700066042.dbf
archive log thread 1 sequence 54 is already on disk as file /restore1/oracle/SID/admin/a01/1_54_700066042.dbf
archive log thread 1 sequence 55 is already on disk as file /restore1/oracle/SID/admin/a01/1_55_700066042.dbf
archive log thread 1 sequence 56 is already on disk as file /restore1/oracle/SID/admin/a01/1_56_700066042.dbf
archive log thread 1 sequence 57 is already on disk as file /restore1/oracle/SID/admin/a01/1_57_700066042.dbf
archive log thread 1 sequence 58 is already on disk as file /restore1/oracle/SID/admin/a01/1_58_700066042.dbf
archive log thread 1 sequence 59 is already on disk as file /restore1/oracle/SID/admin/a01/1_59_700066042.dbf
archive log thread 1 sequence 60 is already on disk as file /restore1/oracle/SID/admin/a01/1_60_700066042.dbf
archive log thread 1 sequence 61 is already on disk as file /restore1/oracle/SID/admin/a01/1_61_700066042.dbf
archive log thread 1 sequence 62 is already on disk as file /restore1/oracle/SID/admin/a01/1_62_700066042.dbf
archive log thread 1 sequence 63 is already on disk as file /restore1/oracle/SID/admin/a01/1_63_700066042.dbf
archive log thread 1 sequence 64 is already on disk as file /restore1/oracle/SID/admin/a01/1_64_700066042.dbf
archive log thread 1 sequence 65 is already on disk as file /restore1/oracle/SID/admin/a01/1_65_700066042.dbf
archive log thread 1 sequence 66 is already on disk as file /restore1/oracle/SID/admin/a01/1_66_700066042.dbf
archive log thread 1 sequence 67 is already on disk as file /restore1/oracle/SID/admin/a01/1_67_700066042.dbf
archive log thread 1 sequence 68 is already on disk as file /restore1/oracle/SID/admin/a01/1_68_700066042.dbf
archive log thread 1 sequence 69 is already on disk as file /restore1/oracle/SID/admin/a01/1_69_700066042.dbf
archive log thread 1 sequence 70 is already on disk as file /restore1/oracle/SID/admin/a01/1_70_700066042.dbf
archive log thread 1 sequence 71 is already on disk as file /restore1/oracle/SID/admin/a01/1_71_700066042.dbf
archive log thread 1 sequence 72 is already on disk as file /restore1/oracle/SID/admin/a01/1_72_700066042.dbf
archive log thread 1 sequence 73 is already on disk as file /restore1/oracle/SID/admin/a01/1_73_700066042.dbf
archive log thread 1 sequence 74 is already on disk as file /restore1/oracle/SID/admin/a01/1_74_700066042.dbf
archive log thread 1 sequence 75 is already on disk as file /restore1/oracle/SID/admin/a01/1_75_700066042.dbf
archive log thread 1 sequence 76 is already on disk as file /restore1/oracle/SID/admin/a01/1_76_700066042.dbf
archive log thread 1 sequence 77 is already on disk as file /restore1/oracle/SID/admin/a01/1_77_700066042.dbf
archive log thread 1 sequence 78 is already on disk as file /restore1/oracle/SID/admin/a01/1_78_700066042.dbf
archive log thread 1 sequence 79 is already on disk as file /restore1/oracle/SID/admin/a01/1_79_700066042.dbf
archive log thread 1 sequence 80 is already on disk as file /restore1/oracle/SID/admin/a01/1_80_700066042.dbf
archive log thread 1 sequence 81 is already on disk as file /restore1/oracle/SID/admin/a01/1_81_700066042.dbf
archive log thread 1 sequence 82 is already on disk as file /restore1/oracle/SID/admin/a01/1_82_700066042.dbf
archive log thread 1 sequence 83 is already on disk as file /restore1/oracle/SID/admin/a01/1_83_700066042.dbf
archive log thread 1 sequence 84 is already on disk as file /restore1/oracle/SID/admin/a01/1_84_700066042.dbf
archive log thread 1 sequence 85 is already on disk as file /restore1/oracle/SID/admin/a01/1_85_700066042.dbf
archive log thread 1 sequence 86 is already on disk as file /restore1/oracle/SID/admin/a01/1_86_700066042.dbf
archive log thread 1 sequence 87 is already on disk as file /restore1/oracle/SID/admin/a01/1_87_700066042.dbf
archive log thread 1 sequence 88 is already on disk as file /restore1/oracle/SID/admin/a01/1_88_700066042.dbf
archive log thread 1 sequence 89 is already on disk as file /restore1/oracle/SID/admin/a01/1_89_700066042.dbf
archive log thread 1 sequence 90 is already on disk as file /restore1/oracle/SID/admin/a01/1_90_700066042.dbf
archive log thread 1 sequence 91 is already on disk as file /restore1/oracle/SID/admin/a01/1_91_700066042.dbf
archive log thread 1 sequence 92 is already on disk as file /restore1/oracle/SID/admin/a01/1_92_700066042.dbf
archive log thread 1 sequence 93 is already on disk as file /restore1/oracle/SID/admin/a01/1_93_700066042.dbf
archive log thread 1 sequence 94 is already on disk as file /restore1/oracle/SID/admin/a01/1_94_700066042.dbf
archive log thread 1 sequence 95 is already on disk as file /restore1/oracle/SID/admin/a01/1_95_700066042.dbf
archive log thread 1 sequence 96 is already on disk as file /restore1/oracle/SID/admin/a01/1_96_700066042.dbf
archive log thread 1 sequence 97 is already on disk as file /restore1/oracle/SID/admin/a01/1_97_700066042.dbf
archive log thread 1 sequence 98 is already on disk as file /restore1/oracle/SID/admin/a01/1_98_700066042.dbf
archive log thread 1 sequence 99 is already on disk as file /restore1/oracle/SID/admin/a01/1_99_700066042.dbf
archive log thread 1 sequence 100 is already on disk as file /restore1/oracle/SID/admin/a01/1_100_700066042.dbf
archive log thread 1 sequence 101 is already on disk as file /restore1/oracle/SID/admin/a01/1_101_700066042.dbf
archive log thread 1 sequence 102 is already on disk as file /restore1/oracle/SID/admin/a01/1_102_700066042.dbf
archive log thread 1 sequence 103 is already on disk as file /restore1/oracle/SID/admin/a01/1_103_700066042.dbf
archive log thread 1 sequence 104 is already on disk as file /restore1/oracle/SID/admin/a01/1_104_700066042.dbf
archive log thread 1 sequence 105 is already on disk as file /restore1/oracle/SID/admin/a01/1_105_700066042.dbf
archive log thread 1 sequence 106 is already on disk as file /restore1/oracle/SID/admin/a01/1_106_700066042.dbf
archive log thread 1 sequence 107 is already on disk as file /restore1/oracle/SID/admin/a01/1_107_700066042.dbf
archive log thread 1 sequence 108 is already on disk as file /restore1/oracle/SID/admin/a01/1_108_700066042.dbf
archive log thread 1 sequence 109 is already on disk as file /restore1/oracle/SID/admin/a01/1_109_700066042.dbf
archive log thread 1 sequence 110 is already on disk as file /restore1/oracle/AT
archive log thread 1 sequence 111 is already on disk as file /restore1/oracle/AT
archive log thread 1 sequence 112 is already on disk as file /restore1/oracle/AT
archive log thread 1 sequence 113 is already on disk as file /restore1/oracle/AT
archive log thread 1 sequence 114 is already on disk as file /restore1/oracle/AT
archive log thread 1 sequence 115 is already on disk as file /restore1/oracle/AT
archive log thread 1 sequence 116 is already on disk as file /restore1/oracle/AT
archive log thread 1 sequence 117 is already on disk as file /restore1/oracle/AT
archive log thread 1 sequence 118 is already on disk as file /restore1/oracle/AT
archive log thread 1 sequence 119 is already on disk as file /restore1/oracle/AT
archive log filename=/restore1/oracle/SID/admin/a01/1_23_700066042.dbf thre
archive log filename=/restore1/oracle/SID/admin/a01/1_24_700066042.dbf thre
archive log filename=/restore1/oracle/SID/admin/a01/1_25_700066042.dbf thre
archive log filename=/restore1/oracle/SID/admin/a01/1_26_700066042.dbf thre
archive log filename=/restore1/oracle/SID/admin/a01/1_27_700066042.dbf thre
archive log filename=/restore1/oracle/SID/admin/a01/1_28_700066042.dbf thre
archive log filename=/restore1/oracle/SID/admin/a01/1_29_700066042.dbf thre
archive log filename=/restore1/oracle/SID/admin/a01/1_30_700066042.dbf thre
archive log filename=/restore1/oracle/SID/admin/a01/1_31_700066042.dbf thre
archive log filename=/restore1/oracle/SID/admin/a01/1_32_700066042.dbf thre
archive log filename=/restore1/oracle/SID/admin/a01/1_33_700066042.dbf thre
archive log filename=/restore1/oracle/SID/admin/a01/1_34_700066042.dbf thre
archive log filename=/restore1/oracle/SID/admin/a01/1_35_700066042.dbf thre
archive log filename=/restore1/oracle/SID/admin/a01/1_36_700066042.dbf thread=1 sequence=36
archive log filename=/restore1/oracle/SID/admin/a01/1_37_700066042.dbf thread=1 sequence=37
archive log filename=/restore1/oracle/SID/admin/a01/1_38_700066042.dbf thread=1 sequence=38
archive log filename=/restore1/oracle/SID/admin/a01/1_39_700066042.dbf thread=1 sequence=39
archive log filename=/restore1/oracle/SID/admin/a01/1_40_700066042.dbf thread=1 sequence=40
archive log filename=/restore1/oracle/SID/admin/a01/1_41_700066042.dbf thread=1 sequence=41
archive log filename=/restore1/oracle/SID/admin/a01/1_42_700066042.dbf thread=1 sequence=42
archive log filename=/restore1/oracle/SID/admin/a01/1_43_700066042.dbf thread=1 sequence=43
archive log filename=/restore1/oracle/SID/admin/a01/1_44_700066042.dbf thread=1 sequence=44
archive log filename=/restore1/oracle/SID/admin/a01/1_45_700066042.dbf thread=1 sequence=45
archive log filename=/restore1/oracle/SID/admin/a01/1_46_700066042.dbf thread=1 sequence=46
archive log filename=/restore1/oracle/SID/admin/a01/1_47_700066042.dbf thread=1 sequence=47
archive log filename=/restore1/oracle/SID/admin/a01/1_48_700066042.dbf thread=1 sequence=48
archive log filename=/restore1/oracle/SID/admin/a01/1_49_700066042.dbf thread=1 sequence=49
archive log filename=/restore1/oracle/SID/admin/a01/1_50_700066042.dbf thread=1 sequence=50
archive log filename=/restore1/oracle/SID/admin/a01/1_51_700066042.dbf thread=1 sequence=51
archive log filename=/restore1/oracle/SID/admin/a01/1_52_700066042.dbf thread=1 sequence=52
archive log filename=/restore1/oracle/SID/admin/a01/1_53_700066042.dbf thread=1 sequence=53
archive log filename=/restore1/oracle/SID/admin/a01/1_54_700066042.dbf thread=1 sequence=54
archive log filename=/restore1/oracle/SID/admin/a01/1_55_700066042.dbf thread=1 sequence=55
archive log filename=/restore1/oracle/SID/admin/a01/1_56_700066042.dbf thread=1 sequence=56
archive log filename=/restore1/oracle/SID/admin/a01/1_57_700066042.dbf thread=1 sequence=57
archive log filename=/restore1/oracle/SID/admin/a01/1_58_700066042.dbf thread=1 sequence=58
archive log filename=/restore1/oracle/SID/admin/a01/1_59_700066042.dbf thread=1 sequence=59
archive log filename=/restore1/oracle/SID/admin/a01/1_60_700066042.dbf thread=1 sequence=60
archive log filename=/restore1/oracle/SID/admin/a01/1_61_700066042.dbf thread=1 sequence=61
archive log filename=/restore1/oracle/SID/admin/a01/1_62_700066042.dbf thread=1 sequence=62
archive log filename=/restore1/oracle/SID/admin/a01/1_63_700066042.dbf thread=1 sequence=63
archive log filename=/restore1/oracle/SID/admin/a01/1_64_700066042.dbf thread=1 sequence=64
archive log filename=/restore1/oracle/SID/admin/a01/1_65_700066042.dbf thread=1 sequence=65
archive log filename=/restore1/oracle/SID/admin/a01/1_66_700066042.dbf thread=1 sequence=66
archive log filename=/restore1/oracle/SID/admin/a01/1_67_700066042.dbf thread=1 sequence=67
archive log filename=/restore1/oracle/SID/admin/a01/1_68_700066042.dbf thread=1 sequence=68
archive log filename=/restore1/oracle/SID/admin/a01/1_69_700066042.dbf thread=1 sequence=69
archive log filename=/restore1/oracle/SID/admin/a01/1_70_700066042.dbf thread=1 sequence=70
archive log filename=/restore1/oracle/SID/admin/a01/1_71_700066042.dbf thread=1 sequence=71
archive log filename=/restore1/oracle/SID/admin/a01/1_72_700066042.dbf thread=1 sequence=72
archive log filename=/restore1/oracle/SID/admin/a01/1_73_700066042.dbf thread=1 sequence=73
archive log filename=/restore1/oracle/SID/admin/a01/1_74_700066042.dbf thread=1 sequence=74
archive log filename=/restore1/oracle/SID/admin/a01/1_75_700066042.dbf thread=1 sequence=75
archive log filename=/restore1/oracle/SID/admin/a01/1_76_700066042.dbf thread=1 sequence=76
archive log filename=/restore1/oracle/SID/admin/a01/1_77_700066042.dbf thread=1 sequence=77
archive log filename=/restore1/oracle/SID/admin/a01/1_78_700066042.dbf thread=1 sequence=78
archive log filename=/restore1/oracle/SID/admin/a01/1_79_700066042.dbf thread=1 sequence=79
archive log filename=/restore1/oracle/SID/admin/a01/1_80_700066042.dbf thread=1 sequence=80
archive log filename=/restore1/oracle/SID/admin/a01/1_81_700066042.dbf thread=1 sequence=81
archive log filename=/restore1/oracle/SID/admin/a01/1_82_700066042.dbf thread=1 sequence=82
archive log filename=/restore1/oracle/SID/admin/a01/1_83_700066042.dbf thread=1 sequence=83
archive log filename=/restore1/oracle/SID/admin/a01/1_84_700066042.dbf thread=1 sequence=84
archive log filename=/restore1/oracle/SID/admin/a01/1_85_700066042.dbf thread=1 sequence=85
archive log filename=/restore1/oracle/SID/admin/a01/1_86_700066042.dbf thread=1 sequence=86
archive log filename=/restore1/oracle/SID/admin/a01/1_87_700066042.dbf thread=1 sequence=87
archive log filename=/restore1/oracle/SID/admin/a01/1_88_700066042.dbf thread=1 sequence=88
archive log filename=/restore1/oracle/SID/admin/a01/1_89_700066042.dbf thread=1 sequence=89
archive log filename=/restore1/oracle/SID/admin/a01/1_90_700066042.dbf thread=1 sequence=90
archive log filename=/restore1/oracle/SID/admin/a01/1_91_700066042.dbf thread=1 sequence=91
archive log filename=/restore1/oracle/SID/admin/a01/1_92_700066042.dbf thread=1 sequence=92
archive log filename=/restore1/oracle/SID/admin/a01/1_93_700066042.dbf thread=1 sequence=93
archive log filename=/restore1/oracle/SID/admin/a01/1_94_700066042.dbf thread=1 sequence=94
archive log filename=/restore1/oracle/SID/admin/a01/1_95_700066042.dbf thread=1 sequence=95
archive log filename=/restore1/oracle/SID/admin/a01/1_96_700066042.dbf thread=1 sequence=96
archive log filename=/restore1/oracle/SID/admin/a01/1_97_700066042.dbf thread=1 sequence=97
archive log filename=/restore1/oracle/SID/admin/a01/1_98_700066042.dbf thread=1 sequence=98
archive log filename=/restore1/oracle/SID/admin/a01/1_99_700066042.dbf thread=1 sequence=99
archive log filename=/restore1/oracle/SID/admin/a01/1_100_700066042.dbf thread=1 sequence=100
archive log filename=/restore1/oracle/SID/admin/a01/1_101_700066042.dbf thread=1 sequence=101
archive log filename=/restore1/oracle/SID/admin/a01/1_102_700066042.dbf thread=1 sequence=102
archive log filename=/restore1/oracle/SID/admin/a01/1_103_700066042.dbf thread=1 sequence=103
archive log filename=/restore1/oracle/SID/admin/a01/1_104_700066042.dbf thread=1 sequence=104
archive log filename=/restore1/oracle/SID/admin/a01/1_105_700066042.dbf thread=1 sequence=105
archive log filename=/restore1/oracle/SID/admin/a01/1_106_700066042.dbf thread=1 sequence=106
archive log filename=/restore1/oracle/SID/admin/a01/1_107_700066042.dbf thread=1 sequence=107
archive log filename=/restore1/oracle/SID/admin/a01/1_108_700066042.dbf thread=1 sequence=108
archive log filename=/restore1/oracle/SID/admin/a01/1_109_700066042.dbf thread=1 sequence=109
archive log filename=/restore1/oracle/SID/admin/a01/1_110_700066042.dbf thread=1 sequence=110
archive log filename=/restore1/oracle/SID/admin/a01/1_111_700066042.dbf thread=1 sequence=111
archive log filename=/restore1/oracle/SID/admin/a01/1_112_700066042.dbf thread=1 sequence=112
archive log filename=/restore1/oracle/SID/admin/a01/1_113_700066042.dbf thread=1 sequence=113
archive log filename=/restore1/oracle/SID/admin/a01/1_114_700066042.dbf thread=1 sequence=114
archive log filename=/restore1/oracle/SID/admin/a01/1_115_700066042.dbf thread=1 sequence=115
archive log filename=/restore1/oracle/SID/admin/a01/1_116_700066042.dbf thread=1 sequence=116
archive log filename=/restore1/oracle/SID/admin/a01/1_117_700066042.dbf thread=1 sequence=117
archive log filename=/restore1/oracle/SID/admin/a01/1_118_700066042.dbf thread=1 sequence=118
media recovery complete, elapsed time: 00:01:09
Finished recover at 26-OCT-09

7. Once recovery is completed open the database normally.

RMAN> alter database open;

database opened

No comments:

Post a Comment