---

alterDatabase

Syntax

Purpose

To mount or open a database.

Requirements

• Execute this command either within the braces of a run command or at the RMAN prompt.

• Execute the command only if an Oracle instance is already started.

Keywords and Parameters

alter database	allows you to either mount or open the database.
	mount	mounts the database without opening it.
	open	opens the database.
mount database	mounts the database without opening it. This option is equivalent to the SQL statement ALTER DATABASE MOUNT. See Also: For ALTER DATABASE syntax, see the Oracle8i SQL Reference.
open database	mounts and opens database. This option is equivalent to the SQL statement ALTER DATABASE OPEN. See Also: For ALTER DATABASE syntax, see the Oracle8i SQL Reference.

Examples

Opening the Database after a Backup

This example mounts the database, takes a whole database backup, then opens the database. At the RMAN prompt enter:

startup mount; 
run { 
     allocate channel ch1 type disk; 
     backup database;  
     # now that the backup is complete, open the database. 
     alter database open; 
} 

Mounting the Database after Restoring the Control File

To restore the control file to its default location enter the following:

startup nomount;
run { 
     allocate channel ch1 type 'sbt_tape'; 
     restore controlfile; 
} 
# mount the database with the restored control file.
alter database mount;

Related Topics

"sql"

"startup"

"shutdown"

---