Home » RDBMS Server » Backup & Recovery » Corrupted redo log (Oracle 10.2.0.1.0 - Linux)
Corrupted redo log [message #351424] Tue, 30 September 2008 14:59
danyromimd
Messages: 73
Registered: August 2008
Member
Hi!
I guess I have a corrupted redo log... though when I try to make a recover it says...

SQL> recover standby database;
ORA-00279: change 228321345 generated at 09/26/2008 17:20:22 needed for thread
1
ORA-00289: suggestion :
/u01/app/oracle/oradata/com/log1_74683_535370301.arc
ORA-00280: change 228321345 for thread 1 is in sequence #74683


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/u01/app/oracle/oradata/com/log1_74683_535370301.arc
ORA-00283: recovery session canceled due to errors
ORA-16067: activation identifier mismatch in archive log
/u01/app/oracle/oradata/com/log1_74683_535370301.arc


ORA-01112: media recovery not started

This is a standby database and the log never came from the primary db, so I copied it by hand.
What can I do? Either to make recovery not to ask for this sequence#, or to "invent" it ...
It's got a suspicious size:
-rw-r----- 1 oracle oinstall 1024 Sep 29 17:04 1_74683_535370301.arc


Thanks in advance!
Previous Topic: RMAN: ORA-01587: error during control file backup file copy.
Next Topic: alert.log > Bad header found during deleting archived log
Goto Forum:
  


Current Time: Fri Dec 09 04:04:26 CST 2016

Total time taken to generate the page: 0.14060 seconds