Re: Trouble REUSEing database

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 Sun Feb 20 2000 - 14:57:43 CST