Database Backup and Recovery (MOSC)

MOSC Banner

restore my database without my redolog file. in version 10.2.0.1

edited Dec 7, 2015 4:27AM in Database Backup and Recovery (MOSC) 4 commentsAnswered ✓

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;

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center