Re: rman creates spfile, but pfile created from it has 0 kb

From: ddf <oratune_at_msn.com>
Date: Sun, 22 Apr 2012 14:39:10 -0700 (PDT)
Message-ID: <885f7235-d2a9-424f-81df-510316584636_at_r32g2000yqj.googlegroups.com>

On Apr 20, 4:55 pm, Big George <jbet..._at_gmail.com> wrote:
> Hello,
> Oracle 10g, Windows Server 2003.
> I create a spfile with RMAN:
>
> ***************************************************************************­**
> RMAN> BACKUP SPFILE format 'C:\spfile.ora';
>
> Starting backup at 20-APR-12
> using target database controlfile instead of recovery catalog
> allocated channel: ORA_DISK_1
> channel ORA_DISK_1: sid=492 devtype=DISK
> channel ORA_DISK_1: starting full datafile backupset
> channel ORA_DISK_1: specifying datafile(s) in backupset
> including current SPFILE in backupset
> channel ORA_DISK_1: starting piece 1 at 20-APR-12
> channel ORA_DISK_1: finished piece 1 at 20-APR-12
> piece handle=C:\SPFILE.ORA comment=NONE
> channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
> Finished backup at 20-APR-12
>
> Starting Control File and SPFILE Autobackup at 20-APR-12
> piece handle=\\192.168.1.149\G$\JNESRV4-ARCLOGS\MTDPROD\RMAN
> \C-2169285856-201204
> 20-04 comment=NONE
> Finished Control File and SPFILE Autobackup at 20-APR-12
>
> ***************************************************************************­**
>
> Strange thing is that C:\spfile.ora created is 96 Kb, when original
> spfile.ora is 4 kb.
>
> Now I try to create pfile.ora (init.ora) from sql plus:
>
> SQL> connect sys/**** as sysdba
> Connected.
> SQL> CREATE PFILE='C:\pfile.ora' from SPFILE='C:\spfile.ORA';
>
> File created.
>
> SQL>
>
> Strange thing is that C:\pfile.ora created is 0 kb !!
> What is happening?

Are you certain the generated spfile on c:\ is spfile.ORA and not spfile.ora? Case does matter here.

David Fitzjarrell Received on Sun Apr 22 2012 - 16:39:10 CDT