Name

ALTER DATABASE OPEN

Synopsis

ALTER DATABASE [dbname] OPEN [RESETLOGS |
NORESETLOGS]

Opens the database dbname for normal use. The database must first be mounted.

Keywords

RESETLOGS

Resets the log sequence number to 1 and invalidates all redo entries in the existing online and archived log files.

NORESETLOGS

Makes no change to the status of the current log sequence number and redo log entries.

Notes

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.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset