Re: Help: How can I get the spfile out of ASM disk
Date: Sat, 9 Feb 2008 17:33:34 -0800 (PST)
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???????
> SQL*Plus: Release 188.8.131.52.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 184.108.40.206.0 - Production
> With the Partitioning, OLAP, Data Mining and Real Application Testing
> 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 --