Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Trouble REUSEing database

Trouble REUSEing database

From: Doug Cowles <dcowles_at_i84.net>
Date: Sun, 20 Feb 2000 02:02:48 GMT
Message-ID: <38af49c3.1896513@news.remarq.com>


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                    

('/db04/oradata/OFDVP/redo04a.log',

     '/db17/oradata/OFDVP/redo04b.log') SIZE 12M REUSE;

disconnect

spool off

exit    Received on Sat Feb 19 2000 - 20:02:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US