This content has been marked as final. Show 4 replies
The doubt:You are taking cold backup, So the mentioned procedure you can follow. But ensure all the services/background processes related to database are not running.
1. is this plan ok for refresh of the test databases?
2. with the backup taken at step1 and standby ctl file created at step 5 can i create a physical standby database of the testing db?
Please note, the production database is only in picture while taking backup.
Once you prepare Primary database, even from that database you can create standby control file, so that it will be used for standby database.
But i'm not aware of how fail safe it works, As per the core database part whatever the steps you mentioned, it looks fine.
you procedure is ok only in step 3 you need to do is startup nomount for the standby database. As you want to restore a standby controlfile created on production.
1. this plan is ok to refresh your test database.
2. Yes you can use the coldbackup in step 1 for creating a standby database.
6.open the database.Once you open the backup, it diverges from the primary. You can't use this opened database to build a standby for the primary.
Why do you think you need to open the database ?
What are the failsafe steps ? How does it work ?
Hemant K Chitale
Actually my goal is to create a standby database for the newly restored database. So opening is ok.
The database that i am going refresh with cold backup is configured in active/passive mode with oracle fail safe. So that i took offline it with fail safe and then started normally; like starting the service and then start and shutdown with sqlplus.