Home » RDBMS Server » Backup & Recovery » Cannot recover CURRENT redo log
Cannot recover CURRENT redo log [message #199695] Wed, 25 October 2006 21:16 Go to next message
acw1668
Messages: 2
Registered: October 2006
Junior Member
Hi all,

I'm a novice to Oracle. I encounter problem when trying to recover corrupted redo logfile:

RMAN> recover database;

Starting recover at 26-OCT-06
using channel ORA_DISK_1



starting media recovery
media recovery failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00579: the following error occurred at 10/26/2006 10:12:25
RMAN-03002: failure during compilation of command
RMAN-03013: command type: recover
RMAN-03006: non-retryable error occurred during execution of command: recover(3)
RMAN-12004: unhandled exception during command execution on channel default
RMAN-10032: unhandled exception during execution of job step 1: ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
start
RMAN-11001: Oracle Error: ORA-00283: recovery session canceled due to errors
ORA-00314: log 2 of thread 1, expected sequence# 90 doesn't match 100
ORA-00312: online log 2 thread 1: '/u02/oracle/db/ERG/rdo/ERGRP_log2B.rdo'
ORA-00314: log 2 of thread 1, expected sequence# 90 doesn't match 100
ORA-00312: online log 2 thread 1: '/u01/oracle/db/ERG/rdo/ERGRP_log2A.rdo'

--- END ---

The database cannot be open due to the above errors. Any suggestions?

Thanks.
Re: Cannot recover CURRENT redo log [message #200228 is a reply to message #199695] Sun, 29 October 2006 14:40 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Do point in time recovery or follow this procedure.
Re: Cannot recover CURRENT redo log [message #200456 is a reply to message #199695] Tue, 31 October 2006 00:21 Go to previous message
acw1668
Messages: 2
Registered: October 2006
Junior Member
It works. Thanks!
Previous Topic: use scn number
Next Topic: How to restore a specific table using imp command
Goto Forum:
  


Current Time: Thu Dec 08 00:09:30 CST 2016

Total time taken to generate the page: 0.16728 seconds