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

Oracle commands to Restore Redulogs and its Database File

Hi Everyone! Pls help...What's the command use in restoration of Redulog files / Database file of Oracle?

Any preferred site for Oracle documentation for Oracle 9.2 as well Oracle Basic Commands?

By the way, we are using SAP R/3 46C, Oracle 9.2 version and AIX5L 5.2.

Need your help!

Thanks,

Armin

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

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

    Hi Armin,

    you can use SAPDBA or Brtools which will help you to resstore the datafile and redofile for recover

    Cheers

    Paresh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 12, 2007 at 03:04 PM

    Hello,

    For Oracle documentation on 9.2 go to http://www.oracle.com/technology/index.html

    then select downloads > database then scroll to the bottom and you'll find a link to the 9i documentation.

    There aren't really any specific Oracle commands to restore your datafiles or redologs. You just get them back from whatever backup solution you use and then run the RECOVER DATABASE command to apply the redologs.

    As Paresh says SAPDBA is very useful for recovering the datafiles/redologs, or you can use brrestore manually to do it. SAPDBA does a lot of checking for you to make sure all your datafiles/controlfiles are in the correct state so it is worth using if you're not confident with Oracle commands.

    Hope this helps

    Regards

    Garry Bayford

    This is a personal post and does not mean that the company Diagonal-Consulting is responsible for the views expressed.

    Message was edited by:

    Basis Team at Diagonal

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 12, 2007 at 04:18 PM

    Hi,

    Its actually very easy using brrestore.

    brrestore -b last -m all

    Restore all tablespaces without the control file and online redo log files, starting from the last successful backup.

    brrestore -b bcnmhluz.aft -m full

    Restore all the files from backup bcnmhluz.aft , including the control file and the online redo log files. Restore the mirror copies of the control file and the online redo log files.

    brrestore -m /usr/sap/C11/SYS/profile

    Restore the SAP profiles.

    brrestore -m /usr/sap/C11/SYS/exe/run:sapdba

    Restore the SAPDBA executable.

    brrestore -m /oracle/C11/sapdata1=/oracle/C11/sapdata5

    Restore all the database data files that were originally stored in the subdirectories of /oracle/C11/sapdata1 in directory /oracle/C11/sapdata5 .

    brrestore -b last -m 1-10,01-04,0

    Restore all the database data files with ORACLE file IDs from 1 through 10, the four online redo log files, and the control file starting from the last successful backup. Restore the mirror copies of the control file and the online redo log files.

    brrestore -m 0

    Restore the control file. Restore the mirror copies of the control file.

    brrestore -b last -m /oracle/C11/sapdata2/ddicd_5/ddicd.data5

    Restore a database data file starting from the last successful backup.

    brrestore -a 200-220

    Restore the archived redo log files with the log sequence numbers from 200 through 220 into the archiving directory.

    brrestore -a 40-70=/oracle/C11/sapbackup, 71-90=/oracle/C11/sapreorg

    Restore the archived redo log files with the log sequence numbers from 40 through 70 in directory sapbackup and those with the log sequence numbers from 71 through 90 in directory /oracle/C11/sapreorg .

    brrestore -a 40-69,70-100=/oracle/C11/sapbackup

    Restore the archived redo log files with the log sequence numbers from 40 through 69 in the archiving directory, and those with the log sequence numbers from 70 through 100 in directory sapbackup .

    brrestore -n det_log

    Restore a detail log to the local working directory.

    I found this from sap documentation, i keep it handy with me , here is the official link:

    http://help.sap.com/saphelp_47x200/helpdata/en/0d/d3077b4a0c11d182b80000e829fbfe/frameset.htm

    Regards,

    Siddhesh

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 12, 2007 at 04:20 PM

    Hi,

    Here is the complete documentation about BRRESTORE:

    http://help.sap.com/saphelp_47x200/helpdata/en/0d/d307614a0c11d182b80000e829fbfe/frameset.htm

    Regards,

    Siddhesh

    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.