Switchover of databse

Tasks

Take an archive log backup

Verify succesful completion of RMAN Backup of  database on server

Make sure standby DB is in synch with the primary and there is no error on DGMGRL "show configuration" output

Take count of Total number of object and invalid objects in the Database order by owner (paste the output in the sheets: Invalid-Object)

Comment out any cron entries to make sure no jobs run that may impact the export activity

inform to application  team to bring down application related to db

perform couple of log switches

Switch over the prirmary database using dgmglr

Check if the db service is up and registered with the listener on  server

Using DGMGRL verify the DG setup db and there should not be any error

Validate the alert logs .

inform to application team to start the application  and wait for confirmation and sign-off.

Take count of Total number of object and invalid objects in the Database order by owner. The numbers should not be different than what was taken before.

Uncomment/comment relevant cron entries.

Make sure there is no issue for app users to connect using TNS and  any testing and sign-off.

Validate the database Status from OEM

Configure the full backup on  server for db database

switch back to source database