Re: Trouble REUSEing database

I'm actually not trying to rebuild the control file.. I'm trying to NUKE everything in the old database and build a new one on top of it without removing the files... Isn't that possible?

• Dc.

On Sun, 20 Feb 2000 21:57:43 +0100, "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:

>This usually is done by issuing alter database backup controlfile to trace.
>This file will contain a create controlfile statement, which you can use
>for the rebuild.
>When any file (including the controlfile) is not EXACTLY the same size as it
>is on disk, the operation will fail.
>
>Hth,
>
>Sybrand Bakker, Oracle DBA
>
>Doug Cowles <dcowles_at_i84.net> wrote in message
>news:38af49c3.1896513_at_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...
>>
>> - Dc.
>>
>> /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 Tue Feb 22 2000 - 20:27:31 CST