restore my database without my redolog file. in version 10.2.0.1
hello gurus,
1 - I did a save cold datafile.
2 - i restored my datafiles but i losed the redo file.
3 - First question : is it possible to start my database without the redolog.
then :
3-1 - > startup mount
3-2 - > alter database open: then normal because i losed my redolog
3-3 - > alter database open
ERREUR Ó la ligne 1 :
ORA-00314: journal 1, thread 1, numÚro de sÚq. attendu ne correspond pas Ó
ORA-00312: journal en ligne 1 thread 1 :
'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_9NZSWZQK_.LOG'
4 - i executed SQL> ALTER DATABASE RECOVER database using backup controlfile until cancel;