| 144 redo blocks read, 36 data blocks need recovery [message #126872] |
Thu, 07 July 2005 01:35  |
confident
Messages: 28
Registered: March 2005
|
Junior Member |
|
|
Today morning, i saw one of database is not working, i check the alert.log, the database is open.. and smon is not running, i even given shut immedaite, but given a error and then i given startup command, after a while the database is up.... i check the alert.log again
ALTER DATABASE OPEN
Thu Jul 7 09:12:59 2005
Beginning crash recovery of 1 threads
Thu Jul 7 09:12:59 2005
Started redo scan
Thu Jul 7 09:12:59 2005
Completed redo scan
144 redo blocks read, 36 data blocks need recovery
Thu Jul 7 09:13:00 2005
Started recovery at
Thread 1: logseq 28, block 88935, scn 0.0
Thu Jul 7 09:13:00 2005
Recovery of Online Redo Log: Thread 1 Group 1 Seq 28 Reading mem 0
Mem# 0 errs 0: /koala_u01/oradata/VTST31/redo01aVTST31.log
Mem# 1 errs 0: /koala_u06/oradata/VTST31/redo01bVTST31.log
Thu Jul 7 09:13:01 2005
Completed redo application
Thu Jul 7 09:13:01 2005
Ended recovery at
Thread 1: logseq 28, block 89079, scn 1801.2597341987
36 data blocks read, 36 data blocks written, 144 redo blocks read
Crash recovery completed successfully
..
why it happen, let say it happen again, and how to recover the database. and my database is not archive log mode..
recovery Steps please
|
|
|
|
|
|
| Re: 144 redo blocks read, 36 data blocks need recovery [message #126961 is a reply to message #126955] |
Thu, 07 July 2005 09:38  |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
Hi
You might have faced an instance crash. At the time of this problem did you checked the following:
1. Any accidental reboot of server.
2. The status of other oracle processes. Were they running?
Also, what was the message you got when you issued shutdown immediate command.
Regds
Girish
|
|
|
|
| Re: 144 redo blocks read, 36 data blocks need recovery [message #127293 is a reply to message #126961] |
Mon, 11 July 2005 02:04 |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
Hi
below are steps to recover redologfile if database is crah coz of it. In this u can see the crash that i generate and then how i recovered database
*************************
RECOVERY OF REDO LOG FILE
*************************
Case 1 – When Only One Member Available In Group
(INCOMPLETE RECOVERY)
-----------------------------------------------
How To Simulate Crash :
-----------------------------------------------
Shutdown database.
Delete all Redo Log Files of a specific group.
SQL>Startup
We get an error related to redo log file. Here redo log file is corrupted not your data file i.e. there is corruption in mechanism of DB recovery
Solution:
SQL>RECOVER DATABASE UNTIL CANCEL;
SQL>ALTER DATABASE OPEN;
This will also shows you error : must use resetlog or noresetlog option for DB
SQL>ALTER DATABASE OPEN RESETLOG;
After such kind of recovery take the cold backup of your DB
RESETLOGS
when we do reset log , oracle recreates
all redo log files (all groups)
sequence no is initialized
now it will not access any old archive or data file for DB recovery
-------------------------------------------------------------------
***************************
RECOVERY OF REDO LOG FILE
***************************
Case 2 – When There Are Multiple Members Available In Group
-----------------------------------------------------------
How To Simulate Crash:
-----------------------------------------------------------
Shutdown database.
Delete any one Redo Log File of a specific group.
SQL>Startup
Its not going to show an error related to redo log file. Even one of the redo log file is corrupted it will startup your DB
But to see an error
Errors in ‘ORAALERT’ file
Errors in file D:\oracle\admin\oracle\bdump\oracleLGWR.TRC:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'F:\REDOLOG01A.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
Wed Jan 28 11:33:33 2004
Errors in file D:\oracle\admin\oracle\bdump\oracleLGWR.TRC:
ORA-00321: log 1 of thread 1, cannot update log file header
ORA-00312: online log 1 thread 1: 'F:\REDOLOG01A.LOG'
Wed Jan 28 11:33:34 2004
Errors in file D:\oracle\admin\oracle\bdump\oracleLGWR.TRC:
ORA-00313: open failed for members of log group 1 of thread 1
Note : for whichever background process has some problem oracle creates a file in bdump directory
In ‘ORALCELGWR’ File
*** SESSION ID:(3.1) 2004-01-28 11:33:33.000
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'F:\REDOLOG01A.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-00321: log 1 of thread 1, cannot update log file header
ORA-00312: online log 1 thread 1: 'F:\REDOLOG01A.LOG'
ORA-00313: open failed for members of log group 1 of thread 1
Solution:
You create the new group with suitable members
Its better to have members of the new group has the same size as of the old group members
SQL>ALTER DATABASE ADD LOGFILE GROUP 4
(‘D:\ORACLE\ORADATA\ORACLE\REDO04a.LOG’,
‘D:\ORACLE\ORADATA\ORACLE\REDO04b.LOG’) SIZE 1M;
After creation of the new group drop the corrupted group with all members
SQL> ALTER DATABASE DROP LOGFILE GROUP 1;
-----------------------------------------------------------------
From :- Sunil
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
