Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

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

92 views
Skip to first unread message

Big George

unread,
Apr 20, 2012, 6:55:04 PM4/20/12
to
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?

ddf

unread,
Apr 22, 2012, 5:39:10 PM4/22/12
to
On Apr 20, 4:55 pm, Big George <jbet...@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

John Hurley

unread,
Apr 23, 2012, 2:04:30 PM4/23/12
to
If you want to get a useable copy of an spfile then use one ( or
both ) of these options:

1) create pfile='somename_and_directory_path_included' from spfile;

2) alter database backup controlfile to trace as
'some_name_including_full_path';

You are somehow trying to get an rman backup of an spfile and then
somehow trying to create a pfile from the rman spfile backup? That
dog ain't going to hunt ...

Mladen Gogala

unread,
Apr 23, 2012, 4:49:13 PM4/23/12
to
On Mon, 23 Apr 2012 11:04:30 -0700, John Hurley wrote:

> You are somehow trying to get an rman backup of an spfile and then
> somehow trying to create a pfile from the rman spfile backup? That dog
> ain't going to hunt ...

The main problem is the path containing 'C:\'. File names should look
like this: /foo/bar/spfileSID.ora. No backslash or colon characters, it
doesn't begin with the letter.



--
http://mgogala.byethost5.com
0 new messages