Looking for help on below mentioned process:
We are planning to move the standby database from Location A to Location B. I need your help to move this database using lift and drop method, by shutting down the database moving from one location to another and after movement bring up the server and sync with the primary database.
Need your help to identify the steps required / or to be followed for performing this activity. Mainly I am looking for details on backup and archive.
We are planning to shut down the Location "A" office and to want to reuse the existing server by physically moving the server to location "B". We have time and resource constraints for having a second standby.
More information on the primary and standby structure:
- Currently the Primary is located in location "C" and DBA taking only archive logs in the server path. No backups are taken from the primary database.
2.The standby which we are planning to move to Location "B" in this server we are taking the latest
FULL(netbackup) and placing in the same server.
In this current scenario primary is always relying on the standby for backup files.