Origlog B and Mirror Logs are lost , needs recovery

[former_member196171]

Hi Experts ,

I have Oracle 11G database  restored from filesystems , unfortunately I lost origlogB (log_g12m1.dbf  log_g14m1.dbf), mirrlogA (log_g11m2.dbf  log_g13m2.dbf) and mirrlogB (log_g12m2.dbf  log_g14m2.dbf), only I have origlogA ( log_g11m1.dbf  log_g13m1.dbf) , Control  files and all other datafiles are good ,  How do I recover  the database ?

Any help will be appreciated !

Thanks ,

Al Mamun

[former_member188883 · Accepted solution]

Hi,

Refer oracle docs on the process of recovery when online redo logs are missing.

http://docs.oracle.com/cd/B10501_01/server.920/a96572/recoscenarios.htm#11724

Refer section Recovering After the Loss of Online Redo Log Files: Scenarios

As I understand you have taken an file system backup which shall be offline (correct me if I am wrong). In such a case you may simply try to mount the database and open it with reset log option.

Hope this helps.

Regards,

Deepak Kori

[stefan_koehler]

Hi Al Mamun,

was your database shutdown while you have done the file system backup? What's the status of the online redo log groups?

Please post the output of the following queries (in MOUNT state)

SQL> select GROUP#, SEQUENCE#, ARCHIVED, STATUS from V$LOG;
SQL> select GROUP#, STATUS, MEMBER from V$LOGFILE;
SQL> select FILE#, STATUS, CHECKPOINT_CHANGE# from V$DATAFILE;

Too many unknown stuff - to make an useful suggestion.

Regards

Stefan