Received: by 10.68.135.106 with SMTP id pr10mr11811932pbb.3.1335130750835;
        Sun, 22 Apr 2012 14:39:10 -0700 (PDT)
Path: r9ni86873pbh.0!nntp.google.com!news2.google.com!postnews.google.com!r32g2000yqj.googlegroups.com!not-for-mail
From: ddf <orat...@msn.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: rman creates spfile, but pfile created from it has 0 kb
Date: Sun, 22 Apr 2012 14:39:10 -0700 (PDT)
Organization: http://groups.google.com
Lines: 52
Message-ID: <885f7235-d2a9-424f-81df-510316584636@r32g2000yqj.googlegroups.com>
References: <f1eb3667-92b5-436d-9de2-7d3e7c2998ea@g38g2000yqh.googlegroups.com>
NNTP-Posting-Host: 69.4.5.254
Mime-Version: 1.0
X-Trace: posting.google.com 1335130750 30983 127.0.0.1 (22 Apr 2012 21:39:10 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Sun, 22 Apr 2012 21:39:10 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: r32g2000yqj.googlegroups.com; posting-host=69.4.5.254; posting-account=KXUmygkAAABvBFmgDBe4RBLFwhTRAMZC
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1;
 Trident/4.0; .NET4.0C; .NET4.0E; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152;
 .NET CLR 3.5.30729; InfoPath.3; MS-RTC LM 8),gzip(gfe)
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Apr 20, 4:55=A0pm, Big George <jbet...@gmail.com> wrote:
> Hello,
> Oracle 10g, Windows Server 2003.
> I create a spfile with RMAN:
>
> *************************************************************************=
**=AD**
> 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=3D492 devtype=3DDISK
> 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=3DC:\SPFILE.ORA comment=3DNONE
> 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=3D\\192.168.1.149\G$\JNESRV4-ARCLOGS\MTDPROD\RMAN
> \C-2169285856-201204
> 20-04 comment=3DNONE
> Finished Control File and SPFILE Autobackup at 20-APR-12
>
> *************************************************************************=
**=AD**
>
> 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=3D'C:\pfile.ora' from SPFILE=3D'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