Re: Help: How can I get the spfile out of ASM disk

On Feb 9, 6:14 pm, "Ana C. Dent" <anaced..._at_hotmail.com> wrote:
> "joe bayer" <joebay..._at_hotmail.com> wrote innews:Dnorj.130$eU3.92_at_trndny04:
>
> > How can I create spfile if I can not even start the instance with the
> > spfile?
>
> What makes you think the DB needs to be up to create the pfile???????
>
>  sqlplus
>
> SQL*Plus: Release 11.1.0.6.0 - Production on Sat Feb 9 15:02:46 2008
>
> Copyright (c) 1982, 2007, Oracle.  All rights reserved.
>
> Enter user-name: / as sysdba
>
> Connected to:
> Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
> With the Partitioning, OLAP, Data Mining and Real Application Testing
> options
>
> SQL> shutdown immediate
> Database closed.
> Database dismounted.
> ORACLE instance shut down.
> SQL> create pfile from spfile;
>
> File created.
>
> SQL> startup  
> ORACLE instance started.
>
> Total System Global Area  401743872 bytes
> Fixed Size                  1300212 bytes
> Variable Size             356518156 bytes
> Database Buffers           37748736 bytes
> Redo Buffers                6176768 bytes
> Database mounted.
> Database opened.

Nice example. Note that the just created pfile could have been edited then used to strat the database or used to re-create the spfile.

• Mark D Powell --