In this blog, We are going to learn about recovering online redo log files without any backup
Step 1:
Starting Up the database,
SQL> startup
ORACLE instance started.
Total System Global Area 1862270976 bytes
Fixed Size 8621952 bytes
Variable Size 553648256 bytes
Database Buffers 1291845632 bytes
Redo Buffers 8155136 bytes
Database mounted.
Database opened.
Step 2:
Verifying archive log list is enable or not,
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
——— ——————–
DEMO READ WRITE
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 1
Next log sequence to archive 2
Current log sequence 2
Step 3:
Removing Online Redo log files physically
Step 4:
starting up the database after removing the log files physically,
SQL> startup
ORACLE instance started.
Total System Global Area 2483027968 bytes
Fixed Size 8623736 bytes
Variable Size 671091080 bytes
Database Buffers 1795162112 bytes
Redo Buffers 8151040 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 21012
Session ID: 1 Serial number: 48108
Step 5:
shutting down the database and bring mount stage:
After bringing the mount stage, We can issue the recover command
SQL> recover database until cancel;
Media recovery complete.
Step 6:
We can bring our database open with fresh log files using the reset logs command
SQL> alter database open resetlogs;
Database altered.
Step 7:
SQL> select *from v$logfile;
GROUP# STATUS TYPE
———- ——- ——-
MEMBER
——————————————————————————–
IS_ CON_ID
— ———-
3 ONLINE
/u01/app/oracle/oradata/DEMO/onlinelog/o1_mf_3_hz698rct_.log
NO 0
3 ONLINE
/u01/app/oracle/fast_recovery_area/demo/DEMO/onlinelog/o1_mf_3_hz698v7n_.log
YES 0
GROUP# STATUS TYPE
———- ——- ——-
MEMBER
——————————————————————————–
IS_ CON_ID
— ———-
2 ONLINE
/u01/app/oracle/oradata/DEMO/onlinelog/o1_mf_2_hz698l81_.log
NO 0
2 ONLINE
/u01/app/oracle/fast_recovery_area/demo/DEMO/onlinelog/o1_mf_2_hz698om7_.log
GROUP# STATUS TYPE
———- ——- ——-
MEMBER
——————————————————————————–
IS_ CON_ID
— ———-
YES 0
1 ONLINE
/u01/app/oracle/oradata/DEMO/onlinelog/o1_mf_1_hz698cwy_.log
NO 0
1 ONLINE
GROUP# STATUS TYPE
———- ——- ——-
MEMBER
——————————————————————————–
IS_ CON_ID
— ———-
/u01/app/oracle/fast_recovery_area/demo/DEMO/onlinelog/o1_mf_1_hz698hfm_.log
YES 0
6 rows selected.
