Oracle

[Former Member]

Hi Friends,

We are doing a restore of our system , system platform is windows and Oracle.

Before starting the restore , i have stopped sap and oracle.

Do i need to stop database using the below command

sqplus u2018/ as sysdbau2019

shutdown immediate

or just stopping the MMC is enough.

After the restore apart from the below commands , do i need to run any other commands

SQL>startup mount

SQL>recover database

SQL>alter database open;

Please correct me if thing is to be added.

Thanks

anurop

[Former Member · Accepted solution]

follow Note 605062 - FAQ: Restore and recovery and

you can get a restore guide

Note 602497 - BRRECOVER - New tool for Oracle Restore and Recovery

(

-> Backup and Recovery

-> Restore and Recovery

cheers,

-Sunil

[Former Member · Accepted solution]

Thanks for the reply. I have seen the document, but little confusing. The databse is restored. Can you please confirm from the below commands do i need to run anything addtional

SQL>startup mount

SQL>recover database

SQL>alter database open;

After this i can start SAP.

thanks

anu

[former_member204746 · Accepted solution]

it depends on the type of backup you made and if you want to apply offline redologs or not.

[Former Member · Accepted solution]

Hallo,

Do the bellow,

SQL> startup mount;

SQL>alterdatabse open;

sql> alter system switch log file;

Thanks

[Former Member]

you must stop the database using sqlplus commands,

sqplus u2018/ as sysdbau2019

shutdown immediate

Regarding the post restore process, please follow database specific restore procedure.

cheers,

-Sunil