If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

*** SESSION ID:(9.3) 2004-10-13 08:47:17.000
*** 2004-10-13 08:47:17.000
# The following are current System-scope REDO Log Archival related
# parameters and can be included in the database initialization file.
#
# LOG_ARCHIVE_DEST=''
# LOG_ARCHIVE_DUPLEX_DEST=''
#
# LOG_ARCHIVE_FORMAT=ARC%S.%T
# REMOTE_ARCHIVE_ENABLE=TRUE
# LOG_ARCHIVE_MAX_PROCESSES=2
# STANDBY_FILE_MANAGEMENT=MANUAL
# STANDBY_ARCHIVE_DEST=%ORACLE_HOME%\RDBMS
# FAL_CLIENT=''
# FAL_SERVER=''
#
# LOG_ARCHIVE_DEST_1='LOCATION=C:\oracle\ora92\RDBMS'
# LOG_ARCHIVE_DEST_1='MANDATORY NOREOPEN NODELAY'
# LOG_ARCHIVE_DEST_1='ARCH NOAFFIRM SYNC'
# LOG_ARCHIVE_DEST_1='NOREGISTER NOALTERNATE NODEPENDENCY'
# LOG_ARCHIVE_DEST_1='NOMAX_FAILURE NOQUOTA_SIZE NOQUOTA_USED'
# LOG_ARCHIVE_DEST_STATE_1=ENABLE
#
# Below are two sets of SQL statements, each of which creates a new
# control file and uses it to open the database. 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. The second
# set opens the database with the RESETLOGS option and should be used
# if online logs are unavailable.
# The appropriate set of statements can be copied from the trace into
# a script file, edited as necessary, and executed when there is a
# need to re-create the control file.
#
# 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.
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "TRAIN1" NORESETLOGS NOARCHIVELOG
-- SET STANDBY TO MAXIMIZE PERFORMANCE
MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 226
LOGFILE
GROUP 1 'E:\ORACLE\ORADATA\TRAIN1\REDO01.LOG' SIZE 100M,
GROUP 2 'E:\ORACLE\ORADATA\TRAIN1\REDO02.LOG' SIZE 100M,
GROUP 3 'E:\ORACLE\ORADATA\TRAIN1\REDO03.LOG' SIZE 100M
-- STANDBY LOGFILE
DATAFILE
'E:\ORACLE\ORADATA\TRAIN1\SYSTEM01.DBF',
'E:\ORACLE\ORADATA\TRAIN1\UNDOTBS011.DBF',
'E:\ORACLE\ORADATA\TRAIN1\CWMLITE01.DBF',
'E:\ORACLE\ORADATA\TRAIN1\DRSYS01.DBF',
'E:\ORACLE\ORADATA\TRAIN1\EXAMPLE01.DBF',
'E:\ORACLE\ORADATA\TRAIN1\INDX01.DBF',
'E:\ORACLE\ORADATA\TRAIN1\ODM01.DBF',
'E:\ORACLE\ORADATA\TRAIN1\TOOLS01.DBF',
'E:\ORACLE\ORADATA\TRAIN1\USERS01.DBF',
'E:\ORACLE\ORADATA\TRAIN1\XDB01.DBF',
'E:\ORACLE\ORADATA\TRAIN1\DM_W2KVM120040519091720_DB.DBF',
'E:\ORACLE\ORADATA\TRAIN1\DM_NTDISTRIB20040514033149_DB.DBF',
'E:\ORACLE\ORADATA\TRAIN1\DM_W2KVM1_INDX1.ORA'
CHARACTER SET AL32UTF8
;
# Take files offline to match current control file.
ALTER DATABASE DATAFILE 'E:\ORACLE\ORADATA\TRAIN1\UNDOTBS011.DBF' OFFLINE DROP;
# Recovery is required if any of the datafiles are restored backups,
# or if the last shutdown was not normal or immediate.
RECOVER DATABASE
# Database can now be opened normally.
ALTER DATABASE OPEN;
# Commands to add tempfiles to temporary tablespaces.
# Online tempfiles have complete space information.
# Other tempfiles may require adjustment.
ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLE\ORADATA\TRAIN1\TEMP01.DBF' REUSE;
# End of tempfile additions.
#
# 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.
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "TRAIN1" RESETLOGS NOARCHIVELOG
-- SET STANDBY TO MAXIMIZE PERFORMANCE
MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 226
LOGFILE
GROUP 1 'E:\ORACLE\ORADATA\TRAIN1\REDO01.LOG' SIZE 100M,
GROUP 2 'E:\ORACLE\ORADATA\TRAIN1\REDO02.LOG' SIZE 100M,
GROUP 3 'E:\ORACLE\ORADATA\TRAIN1\REDO03.LOG' SIZE 100M
-- STANDBY LOGFILE
DATAFILE
'E:\ORACLE\ORADATA\TRAIN1\SYSTEM01.DBF',
'E:\ORACLE\ORADATA\TRAIN1\UNDOTBS011.DBF',
'E:\ORACLE\ORADATA\TRAIN1\CWMLITE01.DBF',
'E:\ORACLE\ORADATA\TRAIN1\DRSYS01.DBF',
'E:\ORACLE\ORADATA\TRAIN1\EXAMPLE01.DBF',
'E:\ORACLE\ORADATA\TRAIN1\INDX01.DBF',
'E:\ORACLE\ORADATA\TRAIN1\ODM01.DBF',
'E:\ORACLE\ORADATA\TRAIN1\TOOLS01.DBF',
'E:\ORACLE\ORADATA\TRAIN1\USERS01.DBF',
'E:\ORACLE\ORADATA\TRAIN1\XDB01.DBF',
'E:\ORACLE\ORADATA\TRAIN1\DM_W2KVM120040519091720_DB.DBF',
'E:\ORACLE\ORADATA\TRAIN1\DM_NTDISTRIB20040514033149_DB.DBF',
'E:\ORACLE\ORADATA\TRAIN1\DM_W2KVM1_INDX1.ORA'
CHARACTER SET AL32UTF8
;
# Recovery is required if any of the datafiles are restored backups,
# or if the last shutdown was not normal or immediate.
RECOVER DATABASE USING BACKUP CONTROLFILE
# Database can now be opened zeroing the online logs.
ALTER DATABASE OPEN RESETLOGS;
# Commands to add tempfiles to temporary tablespaces.
# Online tempfiles have complete space information.
# Other tempfiles may require adjustment.
ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLE\ORADATA\TRAIN1\TEMP01.DBF' REUSE;
# End of tempfile additions.
#