HP OpenView Storage B6960-96008 manual Changing The Database State

Integrating Oracle and Data Protector

Restoring an Oracle Database

	• Oracle 9i/10g:
	1. Restore the control file from automatic backup.
	If no automatic backup of the control file is available, see problem
	“The Recovery Catalog was lost and the control file cannot be
	restored from Data Protector managed backup” on page 139.
	2. Restore the database or data items.
	Changing The Database State
	Before you restore any database item or you perform a duplication of a
	database, ensure that the database is in the correct state:
Table 1-3	Required Database States
	Item to restore	Database state
	Control file, duplicating a	NoMount (started)
	database
	All other itemsa	Mount

a.When restoring only a few tablespaces or datafiles, then the database can be open with the tablespaces or datafiles to be restored offline.

To put the database into the correct state, run:

sqlplus /nolog

SQL>connect <user>/<password>@<service> as sysdba;

SQL>shutdown immediate;

To put the database into NoMount state, run:

SQL>startup nomount;

To put the database into Mount state, run:

SQL>startup mount;

Chapter 1 73