how recover the database

[Former Member]

dear all

we are using a oracle 9.2.07 i havetaken a backup offline sunday , our database runnig a archive mode , tuseday we have crash the datafile, how we can recove the all data . we we have all archive log

please guide how we can recover the database , please expalin with the with sql commands

thanks

with best regards

venkat

[Former Member]

Hello Venkat,

Follow the basisc steps for recover database.

1. su - <ORASID>

2. sqlplus "/ as sysdba"

3. sql> recover database until cancel;

(> give required archive logs)

and check link for further details -

---

[http://www.filibeto.org/sun/lib/nonsun/oracle/10.2.0.1.0/B19306_01/server.102/b14220/backrec.htm#i1007108]

--- Regards,

Nagendra Pratap Singh

[Former Member]

Hi,

If you are using an offline backup then restoration is enough. no need to recover.

Make sure you are having the backup log file in the /oracle/SID/sapbackup dir. Take a backup of control file.

then restore with the below command with user sidadm

brrestore -m full -b <backup_log_file> -p <profile file: initsid.sap>

Reward points if useful.

Thanks and Regards,

Amit.

[andreas_herzog]

have a thorough look inside sapnotes 4161 & 4164

GreetZ, AH

[markus_doehr2]

Check - bottom section of the page for "Backup and Restore).

I think you should open an OSS call if you´ve never done a restore of a database and if you´re unsure about what you need to do.

Markus