| Database Recovery [message #60856] |
Wed, 10 March 2004 08:54  |
saj
Messages: 8
Registered: January 1999
|
Junior Member |
|
|
Hi
I've a test database. I issued a shutdown abort command to shutdown the database.
When i try to startup the database again it hangs up.
Then i tried to recover database and it returns Media recovery completed and
again i tried to open the DB its again hangs.
Next after mounting the data base i issued a recover until cancel. Since i don't have the
ARC00126.001 , I cancelled it there itself.How can I recover and open the database?
i've all the data files.
The message it gives is
SQL> recover database until cancel
ORA-00279: change 1467944 generated at 03/10/2004 13:47:37 needed for thread 1
ORA-00289: suggestion : C:ORACLERDBMSARC00126.001
ORA-00280: change 1467944 for thread 1 is in sequence #126
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'C:ORACLEORADATAORCLSYSTEM01.DBF'
ORA-01112: media recovery not started
Thanks
Saj
|
|
|
|
| Re: Database Recovery [message #60858 is a reply to message #60856] |
Wed, 10 March 2004 10:28  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Why are you recovering the database,just becos it hangs on startup ?
Instance recovery is automatic. Media recovery is not required for abnormal shutdowns.
Maybe it just takes a while to complete the rollforward phase of the instance recovery. Are there any errors in alert.log or smon trace file ?
-Thiru
|
|
|
|
| Re: Database Recovery [message #60859 is a reply to message #60858] |
Wed, 10 March 2004 11:21 |
saj
Messages: 8
Registered: January 1999
|
Junior Member |
|
|
This is the last pageof alert file
Wed Mar 10 16:21:51 2004
Thread 1 advanced to log sequence 170
Current log# 3 seq# 170 mem# 0: C:ORACLEORADATAORCLREDO04.LOG
Wed Mar 10 16:21:51 2004
ARC0: Completed archiving log 1 thread 1 sequence 168
Wed Mar 10 16:21:52 2004
ARC1: Evaluating archive log 6 thread 1 sequence 169
ARC1: Beginning to archive log 6 thread 1 sequence 169
Creating archive destination LOG_ARCHIVE_DEST_1: 'C:ORACLERDBMSARC00169.001'
Wed Mar 10 16:21:52 2004
Thread 1 cannot allocate new log, sequence 171
Checkpoint not complete
Current log# 3 seq# 170 mem# 0: C:ORACLEORADATAORCLREDO04.LOG
Wed Mar 10 16:21:52 2004
ARC0: Evaluating archive log 6 thread 1 sequence 169
ARC0: Unable to archive log 6 thread 1 sequence 169
Log actively being archived by another process
Wed Mar 10 16:21:52 2004
ARC1: Completed archiving log 6 thread 1 sequence 169
Wed Mar 10 16:21:53 2004
alter database open
Wed Mar 10 16:21:54 2004
Beginning crash recovery of 1 threads
Wed Mar 10 16:21:55 2004
Started first pass scan
Wed Mar 10 16:21:55 2004
Completed first pass scan
0 redo blocks read, 0 data blocks need recovery
Wed Mar 10 16:21:55 2004
Started recovery at
Thread 1: logseq 170, block 2, scn 0.1548359
Recovery of Online Redo Log: Thread 1 Group 3 Seq 170 Reading mem 0
Mem# 0 errs 0: C:ORACLEORADATAORCLREDO04.LOG
Wed Mar 10 16:21:56 2004
Ended recovery at
Thread 1: logseq 170, block 2, scn 0.1568360
0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Wed Mar 10 16:21:56 2004
Errors in file c:oracleadminorclbdumptest_lgwr_268.trc:
ORA-00600: internal error code, arguments: [[kcrfnl_2]], [[19]], [[14]], [[1]], [[]], [[]], [[]], [[]]
Wed Mar 10 16:24:38 2004
Errors in file c:oracleadminorclbdumptest_lgwr_268.trc:
ORA-00600: internal error code, arguments: [[kcrfnl_2]], [[19]], [[14]], [[1]], [[]], [[]], [[]], [[]]
Wed Mar 10 16:24:38 2004
LGWR: terminating instance due to error 600
Wed Mar 10 16:24:43 2004
Errors in file c:oracleadminorclbdumptest_pmon_2032.trc:
ORA-00600: internal error code, arguments: [[]], [[]], [[]], [[]], [[]], [[]], [[]], [[]]
Instance terminated by LGWR, pid = 268
|
|
|
|
| Re: Database Recovery [message #60860 is a reply to message #60859] |
Wed, 10 March 2004 11:55 |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
The instance is getting terminated by LGWR process,after the crash recovery is complete, due to Ora-600.
You will need to contact Oracle support with the alert.log,lgwr and pmon trace files as shown above.
-Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
