on 11-11-2008 10:15 AM
Dears,
We are using ECC6 on HP-Unix with Oracle 9i database.For backup we use varitas netbackup utility.
Now to confirm that backup is running fine we want to install a demo server and resotore our PRD backup on this server.
Please suggest what will be the prequisties in this restoration process and how can i restore the database.
Please suggest.
Shivam
Hi Shivam,
Well, not sure if you haev got the soultions yet or not. howevr, here is the list of activities which you mnay have to perform for any DR/Backup test.
1. Make sure that the target server is build with same specs as of the target server. I mean the OS patch level etc.
2. Install backup agent - in your case its Veritas.
3. Create FS in target server - again it depends, as you may like to restore the db with new SID
4. Start the restore from Veritas agent
5. Start the DB as ora<sid> user
If its starts fine, that means your backup is good enough.
Regards,
Rajeev
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
copy these files from source server:
/oracle/<Source SID>/<OraVers>/dbs/init<Source SID>.ora (755)
/oracle/<Source SID>/<OraVers>/dbs/init<Source SID>.sap (755)
/oracle/<Source SID>/<OraVers>/dbs/init<Source SID>.dba (755)
/oracle/<Source SID>/<OraVers>/dbs/init<Source SID>.offline.sap (755)
/oracle/<Source SID>/<OraVers>/dbs/init<Source SID>.offline.utl (666)
/oracle/<Source SID>/sapbackup/back<source SID>.log
/oracle/<Source SID>/sapbackup/?????????.aff
On Target System;
edit file /usr/openv/netbackup/bp.conf and change the ""client name"" for <Source Host Name>
brrestore -b XXXXXXXX.aff -r /oracle/<Source SID>/<OraVers>_64/dbs/init<Source SID>.online.utl -d util_file -m 0,00,all -p init<Source SID>.sap
I am trying to restore from one server, PSS, to another, SND. Both are HP-UX and use SAP on Oracle. I tried to follow your commands but these files do not exist:
/oracle/<Source SID>/<OraVers>/dbs/init<Source SID>.offline.sap (755)
/oracle/<Source SID>/<OraVers>/dbs/init<Source SID>.offline.utl (666)
We use HP Data Protector to do the backup which uses the SAP brstuff ... I see hints when I hunt The Google that a recovery can be done using the brtools menu but am not sure of the files I would need nor the environment setup to make it work.
Can you offer help?
Thanks!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.