Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Trouble REUSEing database
It came time to rebuild a database in exactly the same form it was
before. I have create scripts that I used to create the database in
the first place. Usually, what I do is spool v$logfile,v$controlfile
and filename from dba_Data_files, shutdown the instance and remove all
the spooled files.. then rebuild... but I thought.. what the hay -
I'll reuse all the files that are already there.. This is possible
isn't it? So I altered the syntax of my original create database file
(originally generated from dbassist ), I noticed I had to take out
the national character set for some reason, and went ahead and ran it.
But.. the database wasn't open when I was finished.. When I did an alter database open, it said it needed recovery.. so I recovered it.. then I tried to alter it open, and got a nasty 600 error with a pile of internal arguments.. I went back to my original strategy of blowing away all the files first. This is Oracle 8.1.5 on AIX 4.3.2. This was the syntax I used to create the database by trying to reuse everything in sight - what's wrong with it? Keep in mind I did not remove ANY files.. I might have re-created the password file but I wouldn't swear to it...
Any help appreciated...
/u01/app/oracle/product/8.1.5EE/bin/svrmgrl << EOF
spool /u01/app/oracle/product/8.1.5EE/install/crdb1.log
connect internal
startup nomount pfile =
/u01/app/oracle/admin/OFDVP/pfile/initOFDVP.ora
CREATE CONTROLFILE REUSE DATABASE "OFDVP" NORESETLOGS NOARCHIVELOG
maxdatafiles 254
maxinstances 8
maxlogfiles 32
character set WE8ISO8859P1
DATAFILE '/db01/oradata/OFDVP/system01.dbf' SIZE 300M REUSE
logfile
group 1
('/db03/oradata/OFDVP/redo01a.log',
'/db16/oradata/OFDVP/redo01b.log') SIZE 12M REUSE,
group 2
('/db04/oradata/OFDVP/redo02a.log',
'/db17/oradata/OFDVP/redo02b.log') SIZE 12M REUSE,
group 3
('/db03/oradata/OFDVP/redo03a.log',
'/db16/oradata/OFDVP/redo03b.log') SIZE 12M REUSE, group 4
'/db17/oradata/OFDVP/redo04b.log') SIZE 12M REUSE;
disconnect
spool off
exit Received on Sat Feb 19 2000 - 20:02:48 CST