# Set #1. NORESETLOGS case
#
# The following commands will create a new control file and use it
# to open the database.
# Data used by the recovery manager will be lost. Additional logs may
# be required for media recovery of offline data files. Use this
# only if the current version of all online logs are available.
# Set #2. RESETLOGS case
#
# The following commands will create a new control file and use it
# to open the database.
# The contents of online logs will be lost and all backups will
# be invalidated. Use this only if online logs are damaged.
# or if the last shutdown was not normal or immediate.
RECOVER DATABASE USING BACKUP CONTROLFILE
# Database can now be opened zeroing the online logs.
Set #1. NORESETLOGS case
-- The first set opens the database with the NORESETLOGS option and should be used only if the current versions of all online logs are available.
Set #2. RESETLOGS case
-- The second set opens the database with the RESETLOGS option and should be used if online logs are unavailable.