Dump file dmp_27578.trc
Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.4.0 - 64bit Production
ORACLE_HOME = ora_8.1.7
System name: SunOS
Node name: dev
Release: 5.8
Version: Generic_11773509-25
Machine: sun4u
Instance name: BDD
Redo thread mounted by this instance: 1
Oracle process number: 8
Unix process pid: 27578, image: oracle@dev
*** SESSION ID
9.15) 2006-01-02 04:00:13.606
*** 2006-01-02 04:00:13.606
# 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 "BDD" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 12
MAXLOGMEMBERS 3
MAXDATAFILES 24
MAXINSTANCES 3
MAXLOGHISTORY 181
LOGFILE
GROUP 1 (
'oraredolog01/BDD_redo1_1.rdo',
'oraredolog02/BDD_redo1_2.rdo'
) SIZE 2M,
GROUP 2 (
'oraredolog01/BDD_redo2_1.rdo',
'oraredolog02/BDD_redo2_2.rdo'
) SIZE 2M,
GROUP 3 (
'oraredolog01/BDD_redo3_1.rdo',
'oraredolog02/BDD_redo3_2.rdo'
) SIZE 2M
DATAFILE
'oradata05/BDD_sys.dbf',
'oradata05/BDD_temp01.dbf',
'oradata05/BDD_rbs01.dbf',
'oradata05/BDD_tab_data01.dbf',
'oradata05/BDD_tab_infrep_01.dbf'
CHARACTER SET WE8MSWIN1252
;
# 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;
# No tempfile entries found to add.
#
Partager