December 2002
Intermediate to advanced
928 pages
85h 29m
English
ALTER DATABASE OPEN
ALTER DATABASE OPEN dbname [NORESETLOGS | RESETLOGS]SQL*Plus command. Opens the database after performing user-managed recovery.
Specifies the name of the database to be opened.
Continues numbering the archive logs from the last set. This is the default value and is used after a complete recovery of the database.
Needed after incomplete recovery or use of a backup control file to ensure that old archived logs are not used to recover the new incarnation of the database.