Re: do disaster recovery without pfile

Ana C. Dent wrote:
> "peter" <hhh.database_at_gmail.com> wrote in news:1155212820.460142.90710
> @p79g2000cwp.googlegroups.com:
>
> > Hello DBAs,
> >
> > I took backup last night of a production database which included all
> > datafile with user managed backup and controlfile to trace. I didn't
> > take any pfile backup. Now I have to do disaster recovery because all
> > datafiles,controlfiles,redo log files,pfile and spfile are lost. I just
> > have backup and archive log files. Please help to recover database when
> > I don't have pfile backup because I can't assume everything of pfile
> > again.
> >
> >
>
> The non-default initSID.ora parameter names & values can be found in the
> alertSID.log file from the last time the DB was succcessfully started.

Yes as ANA has identified a potential source for manually recreating an init.ora for the database. With this you can then recreate the spfile using the crete spfile command. That or just create an init.ora containing only those parameters that you really need to specify like db_name, sessions or processes, db_cache_size, etc ....

HTH -- Mark D Powell -- Received on Thu Aug 10 2006 - 11:15:39 CDT