By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,322 Members | 1,182 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,322 IT Pros & Developers. It's quick & easy.

Standby Database Issues

P: n/a
Hi ,

Oracle 8.1.7.0.0 on HP-UX 11.0
EMC2 Disk Array

We are in a process of implementing DR Site using Standby Database
feature of Oracle. We have tested it on 2 NT machines here & things
are going fine.
I have few questions about Standby Database which I could not find
answer in Backup Recovery Guide.

1. What is the sequence of Startup & Shutdown ? Which shd be started
/stopped first ? Primary or Standby ?

2. If I want to take cold backup of Primary Database , can I do that ?
Do I need to anything else for ReSyncing Standby ? I am quite curious
abt this as Cold Backup on every week is a practice here .
e.g. I have copied cold backup from tape to standby & all archive logs
from that backup to standby site. Now everything is gong fine. But if
I shutdown promary for backup , what shd be the procedure ? Do I need
to copy cold backup again ?

Regards,
Mahesh Hardikar
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
ha*******@yahoo.com (Mahesh Hardikar) wrote in message news:<4a**************************@posting.google. com>...
Hi ,

Oracle 8.1.7.0.0 on HP-UX 11.0
EMC2 Disk Array

We are in a process of implementing DR Site using Standby Database
feature of Oracle. We have tested it on 2 NT machines here & things
are going fine.
I have few questions about Standby Database which I could not find
answer in Backup Recovery Guide.

1. What is the sequence of Startup & Shutdown ? Which shd be started
/stopped first ? Primary or Standby ?

2. If I want to take cold backup of Primary Database , can I do that ?
Do I need to anything else for ReSyncing Standby ? I am quite curious
abt this as Cold Backup on every week is a practice here .
e.g. I have copied cold backup from tape to standby & all archive logs
from that backup to standby site. Now everything is gong fine. But if
I shutdown promary for backup , what shd be the procedure ? Do I need
to copy cold backup again ?

Regards,
Mahesh Hardikar

There is a separate standby manual.

2 Making cold backups of a primary database with a standby database is
just what it is: silly. If you make a cold backup you should
definitely NOT!!!!!
copy the archivelogs to the standby site.

Sybrand Bakker
Senior Oracle DBA
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.