Re: Create new DB errors (ORA-01610, ORA-01194, ORA-01110)

On 8 Aug 2001, jkyf0131_at_hotmail.com wrote:

> 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

--
Galen Boyer
It seems to me, I remember every single thing I know.