Dear all,
We just reinstall the OS in test server box and finished install
Oracle7.3.4.  then created a empty database with the same
datafiles as the production database.  plan to import the dmp
file which I exported from test database before. fter I create
the database use following script:
CREATE DATABASE P2000
?OARCHIVELOG
?AXLOGFILES 32
?AXLOGMEMBERS 2
?AXDATAFILES 60
?AXINSTANCES 8
?AXLOGHISTORY 800
LOGFILE
ROUP 1 (
??/data1/P2000/redoPOWER601.log',
??/data1/P2000/redoPOWER604.log'
? SIZE 20M,
ROUP 2 (
??/data1/P2000/redoPOWER602.log',
??/data1/P2000/redoPOWER605.log'
? SIZE 20M,
ROUP 3 (
??/data1/P2000/redoPOWER603.log',
??/data1/P2000/redoPOWER606.log'
? SIZE 20M,
ROUP 4 (
??/data1/P2000/logPOWER607.ora',
??/data1/P2000/logPOWER608.ora'
? SIZE 20M
DATAFILE
?/data1/P2000/ac_data.dbf' size 800M,
?/data1/P2000/ac_data1.dbf' size 840M,
?/data1/P2000/ac_index.dbf' size 500M,
?/data1/P2000/ac_index1.dbf' size 500M,
?/data1/P2000/ac_index2.dbf' size 940M,
?/data1/P2000/ac_report.dbf' size 550M,
?/data1/P2000/dm_data.dbf' size 800M,
?/data1/P2000/dm_data1.dbf' size 1000M,
?/data1/P2000/dm_index.dbf' size 600M,
?/data1/P2000/dm_index1.dbf' size 200M,
?/data1/P2000/dm_report.dbf' size 100M,
?/data1/P2000/dm_report1.dbf' size 110M,
?/data1/P2000/fnd_data.dbf' size 700,
?/data1/P2000/fnd_data1.dbf' size 700M,
?/data1/P2000/fnd_data2.dbf' size 700M,
?/data1/P2000/fnd_index.dbf' size 1000M,
?/data1/P2000/fnd_report.dbf' size 300M,
?/data1/P2000/mmi_data.dbf' size 20M,
?/data1/P2000/mpc_data.dbf' size 1500M,
?/data1/P2000/mpc_data1.dbf' size 1450M,
?/data1/P2000/mpc_data2.dbf' size 500M,
?/data1/P2000/mpc_index.dbf' size 1500M,
?/data1/P2000/mpc_index1.dbf' size 1500M,
?/data1/P2000/mpc_report.dbf' size 100M,
?/data1/P2000/rbs.dbf' size 1200M,
?/data1/P2000/rollback1.dbf' size 550M,
?/data1/P2000/rollback2.dbf' size 550M,
?/data1/P2000/system01.dbf' size 600M,
?/data1/P2000/temp01.dbf' size 750M,
?/data1/P2000/tools01.dbf' size 20M,
?/data1/P2000/users01.dbf' size 30M
;
However, later when I startup the database there are some errors.
fter I recreate controlfiles, there are other errors.
he error mesg showing below:
SVRMGR> alter database open resetlogs
??2> ;
alter database open resetlogs
*
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/data1/P2000/ac_data.dbf'
SVRMGR> recover database
ORA-00283: Recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
SVRMGR> recover database BACKUP CONTROLFILE;
ORA-00274: Illegal recovery option BACKUP
SVRMGR> recover tablespace ac_data;
ORA-01109: database not open
SVRMGR> startup nomount
ORA-01081: cannot start already-running ORACLE - shut it down first
our OS: Solaris5.7
Oracle: 7.3.4
NOARCHIVELOGS
Any idea? lease help.
Thanks in advance.
regards,
JK
Received on Wed Aug 08 2001 - 20:41:20 CDT