Re: Max # of datafiles??

From: Departament de Sistemes <jmsam_at_dracnet.es>
Date: 1997/11/15
Message-ID: <01bcf1ba$09f20bc0$2102000a@px287>#1/1

Hi !

I had the same problem and my solution was:

1- sqldba> alter database DB_NAME backup controlfile to trace;
2- full backup offline 
3- sqldba> startup nomount
4- edit the result of step 1 and modify the line MAXDATAFILES
5- sqldba> execute the result of step 4
                (It's possible to get error ORA-213, then delete the old

control files and retry)
6- sqldba> shutdown normal
7- sqldba> startup open ... (a normal startup)

There is a issue:

    With the CREATE CONTROLFILE statement, you lose the log history.     Suppose that you have a DB in archivelog mode. You apply this solution today and

    two days later you need to recover a ts from the backup issued in step 2.

    It's possible that recovery ? I don't know.  

    Anybody can has some idea ?

Thanks a lot,

Juan Carlos Rodriguez
D.B. Administrator

MC12250 <mc12250_at_aol.com> escribió en artículo <19971112222700.RAA21721_at_ladder02.news.aol.com>...
> I have a production DB that was created with a max of 30 datafiles in
 the
> "CREATE DATABASE" statement. I know the parameter in the init.ora file
> can't override this. Is there an easy way to change this without
 re-creating
> the
> DB?
>
> Thanks,
> andy
> andy_at_mcdirect.com
>
>
>
Received on Sat Nov 15 1997 - 00:00:00 CST