reactivate database in standby mode
Funny what is happening to me ...
I have replicated everything you need to reactivate the database in standby mode.
But when running: "RECOVER STANDBY DATABASE;" asks for a archiver with much older than that date should be ....
SQL> RECOVER STANDBY DATABASE;
ORA-00279: change generated at 01/18/2013 11:46:35 1025647219 needed for thread
one
ORA-00289: suggestion: X: \ ORACLE \ ARCHIVER \ ARC12142.001
ORA-00280: change 1025647219 for thread 1 is in sequence # 12142
Specify log: {<RET> = Suggested | filename | AUTO | CANCEL}
And it has nothing to do with the archiver that in theory you should play apply:
"select max (sequence #) from v $ log_history;"
This query tells me that the archiver last applied is:
0