Additional steps required after an Oracle snapshot restore
The following steps are required after you restore an Oracle snapshot. Even though the restore operation itself is successful, these steps are required for the application database to be available for normal use again.
These manual steps are not required in case of a disk-level restore in the following scenario:
You are performing a disk-level restore to the original location or an alternate location
The target host is connected to the NetBackup Snapshot Manager host
The NetBackup Snapshot Manager Oracle plug-in is configured on the target host
Perform the following steps:
- Ensure that the snapshot restore operation has completed successfully and a new disk is created and mounted on the application host (in case of a disk-level restore) or the application host is up and running (in case of a host-level restore).
- Connect to the virtual machine and then log on to the Oracle database as a database administrator (sysdba).
- Start the Oracle database in mount mode using the following command:
# STARTUP MOUNT
Verify that the database is mounted successfully.
- Remove the Oracle database from the backup mode using the following command:
# ALTER DATABASE END BACKUP
- Open the Oracle database for normal usage using the following command:
# ALTER DATABASE OPEN
- Add an entry of the newly created database in the Oracle
listerner.oraandtnsnames.orafiles. - Restart the Oracle listener using the following command:
# lsnrctl start