Re: Q) Changing Max # of Datafiles... (But it does not work...)

ksjune_at_sys.gsnu.ac.kr wrote:
>
> Hi !!! Everyone....
> I'd like to change the number of maxdatafiles. so I run below
> statement and the it does work well....
> note : Oracle 7.3.2 on Windows NT 4.0
>
> svrmgrl> startup
> svrmgrl> alter database backup controfile to trace;
>
> This statement create the trace_file in '%RDBMS73%\trace' directory
> like this. ( I've deleted the comment line)
> If you use the UNIX System, this file will be created in 'udump'
> directory
> =========================================================================
> STARTUP NOMOUNT
> CREATE CONTROLFILE REUSE DATABASE "ORACLE" NORESETLOGS ARCHIVELOG
> MAXLOGFILES 32
> MAXLOGMEMBERS 2
> MAXDATAFILES 32
> MAXINSTANCES 16
> MAXLOGHISTORY 1600
> LOGFILE
> GROUP 1 'D:\ORANT\DATABASE\REDO\GRP1ORCL.LOG' SIZE 2M,
> GROUP 2 'D:\ORANT\DATABASE\REDO\GRP2ORCL.LOG' SIZE 2M,
> GROUP 3 'D:\ORANT\DATABASE\REDO\GRP3ORCL.LOG' SIZE 2M
> DATAFILE
> 'D:\ORANT\DATABASE\SYS_ORCL.DBF',
> 'D:\ORANT\DATABASE\USR_ORCL.DBF',
> 'D:\ORANT\DATABASE\RBS_ORCL.DBF',
> 'D:\ORANT\DATABASE\TMP_ORCL.DBF'
> ;
>
> RECOVER DATABASE
>
> ALTER SYSTEM ARCHIVE LOG ALL;
>
> ALTER DATABASE OPEN;
> ===========================================================================
> you will find the number 32 at line5, MAXDATAFILES section.
> So I've changed this number to 62, and changed the number to 50 at
> db_files section in initSID.ora
> Next, I've shutdown Oracle system, and restart above scripts in
> SVRMGRL.
> But it does not work. Error Message like this
>
> ORA-01503: CREATE CONTROLFILE failed
> ORA-00213: cannot reuse control file 'D:\ORANT\DATABASE\ctl1orcl.ora';
> old file size 310, 358 required
>
> Please Help....
> Thanks in Advance....
>
> ksjune_at_sys.gsnu.ac.kr

Hi,

move your old comtrolfiles to a backup destination and run your script without the REUSE-option.

-- 
Regards

Matthias Gresz    :-)