Startup the dummydb instance in nomount mode. Paste the following into this file: db_name='dummydb'ĭispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)' This makes sure the environment is set correctly.Ĭreate a dummy pfile in the location $ORACLE_HOME/dbs: $ vi initdummydb.ora The restore will be done on the machine where the database was located (we simulated a complete loss by dropping the database) and the user ORACLE will do this restore. The DBID is known (see other post to find the DBID from the backup).There is enough space to hold the restored database.The control-file is also backed up and available in the backup-list.So in order to fill in this “gap” in the documentation, this post will document the steps needed to restore a full database from a Netbackup.īefore attempting to restore the database make sure: The good news is, although the backup and scheduling is not the task of the DBA anymore, but of the storage/backup manager, the DBA still maintains control of the restore procedure.Īlthough it is kind of sad to read in the manual of Netbackup under the restore procedure: “Contact your DBA.” When switching over from regular FRA backups to Netbackup, things changed a bit in the way restores are done.
0 Comments
Leave a Reply. |