Re: do disaster recovery without pfile

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Thu, 10 Aug 2006 13:23:14 GMT
Message-ID: <Xns981B40F97AD8anacedenthotmailcom@70.169.32.36>

"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. Received on Thu Aug 10 2006 - 08:23:14 CDT