Recovering mirrlogA and B

[Former Member]

Hello Friends,

Is there anyway to rebuild the mirrlogA and B? If yes plz tell me the complete procedure to do this. We have lost this folder due to some serious problem in our SAP Server. We are using ECC 6.0/Oracle 10G/Win2003 platform. Plz help me...

thanks & regards,

Vikram

[Former Member · Accepted solution]

Option 1:

Copy the OriglogA & OrigLogB to MirrlogA & MirrlogB

Option 2:

Incase you can create new log files by entering the following command:

alter database add logfile group 11

('/oracle/<SID>/origlogA/log_g11_m1.dbf',

'/oracle/<SID>/mirrlogA/log_g11_m2.dbf') size 50M;

Incase you can delete old redo log files by entering the following command:

alter database drop logfile group 11;

Option 3:

backup the confrolfile to trace. And create a new control file from trace file.

[Former Member]

Hi Vikram

As you say that u have lose the folder then follow the following steps

1.Bring the database in mount position

and execute first this cmd

2.alter database drop logfile group(Number);

3.alter database add logfile group 11

('/oracle/<SID>/origlogA/log_g11_m1.dbf',

'/oracle/<SID>/mirrlogA/log_g11_m2.dbf') size 50M;

4. open database with resetlogs

please let me know regarding any quary

cheer

Paresh

[Former Member]

Vikram

1 Query v$logfile view and review alertlogfile.

2.switch logfile and query v$logfile

3.is this is success.

4.correct the problem by adding new logfile.

Regards

Vinod

[Former Member]

Vikram,

MirrlogA & MirrlogB are basically copies of OriglogA & OrigLogB,

execute select * from v$logfile and see what you are getting

Shutdown DB and copy origlog to mirrorlog and rename the mirrlog files.

it should work.

Regards,

Cherry