Account Options

  1. Sign in
The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Google Groups Home
« Groups Home
comp.databases.oracle.server
+ new post
About this group
Subscribe to this group
This is a Usenet group - learn more
rman creates spfile, but pfile created from it has 0 kb
Options
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
   4 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
Big George  
View profile  
 More options Apr 20 2012, 6:55 pm
Newsgroups: comp.databases.oracle.server
From: Big George <jbet...@gmail.com>
Date: Fri, 20 Apr 2012 15:55:04 -0700 (PDT)
Local: Fri, Apr 20 2012 6:55 pm
Subject: rman creates spfile, but pfile created from it has 0 kb
Print | Individual message | Show original | Report this message | Find messages by this author
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?


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
ddf  
View profile  
 More options Apr 22 2012, 5:39 pm
Newsgroups: comp.databases.oracle.server
From: ddf <orat...@msn.com>
Date: Sun, 22 Apr 2012 14:39:10 -0700 (PDT)
Local: Sun, Apr 22 2012 5:39 pm
Subject: Re: rman creates spfile, but pfile created from it has 0 kb
Print | Individual message | Show original | Report this message | Find messages by this author
On Apr 20, 4:55 pm, Big George <jbet...@gmail.com> wrote:

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

David Fitzjarrell


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
John Hurley  
View profile  
 More options Apr 23 2012, 2:04 pm
Newsgroups: comp.databases.oracle.server
From: John Hurley <johnthehur...@gmail.com>
Date: Mon, 23 Apr 2012 11:04:30 -0700 (PDT)
Local: Mon, Apr 23 2012 2:04 pm
Subject: Re: rman creates spfile, but pfile created from it has 0 kb
Print | Individual message | Show original | Report this message | Find messages by this author
On Apr 20, 6:55 pm, Big George <jbet...@gmail.com> wrote:

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 ...


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Mladen Gogala  
View profile  
 More options Apr 23 2012, 4:49 pm
Newsgroups: comp.databases.oracle.server
From: Mladen Gogala <gogala.mla...@gmail.com>
Date: Mon, 23 Apr 2012 20:49:13 +0000 (UTC)
Local: Mon, Apr 23 2012 4:49 pm
Subject: Re: rman creates spfile, but pfile created from it has 0 kb
Print | Individual message | Show original | Report this message | Find messages by this author

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


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2013 Google