| 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!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
