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.
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.