ALTER DATABASE OPEN
ALTER DATABASE [dbname
] OPEN [RESETLOGS |
NORESETLOGS]
Opens the database dbname for normal use. The database must first be mounted.
You must have the OSDBA role to issue this command. The RESETLOGS option can only be specified after performing incomplete media recovery; at all other times, NORESETLOGS should be used. The RESETLOGS option must be specified when opening the database after performing media recovery with a backup control file. If the database is opened with the RESETLOGS keyword, a complete backup of the database should be performed immediately.