Home » RDBMS Server » Backup & Recovery » regading spfile vs pfile while perform rman backup (10g)
regading spfile vs pfile while perform rman backup [message #296118] Thu, 24 January 2008 12:36 Go to next message
pavan27
Messages: 50
Registered: December 2006
Location: bangalore
Member
hi,

i have one question regarding spfile vs pfile while taking rman backup.

i read one document about rman in that, they mentioned that

"note: if you are not using spfile, then you can not backup your
database text based init.ora parameter file with rman"


if i started my database using pfile. what impact it does while taking backup.
what is the main difference between spfile and pfile in RMAN case.

is there any disadvantages by using pfile while RMAN enveronment.

Regards,

Report message to a moderator

Re: regading spfile vs pfile while perform rman backup [message #296146 is a reply to message #296118] Thu, 24 January 2008 20:10 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
If you are using an spfile, RMAN can back it up, however it can not backup a pfile. There really isn't need to backup the pfile since it can be created from the spfile anyway.

Report message to a moderator

Previous Topic: How to connect RMAN.
Next Topic: duplicate database weekly using rman
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 15 02:21:33 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.