Skip to Content
author's profile photo Former Member
Former Member

Recovering mirrlogA and B

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 08:35 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 06:41 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 07:57 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 09:11 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.