Home » RDBMS Server » Backup & Recovery » RMAN : format specifier %F
RMAN : format specifier %F [message #262226] Sat, 25 August 2007 08:07 Go to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello ALL,

I tried to use the following command in RMAN environment:
RMAN> backup database format 'c:\cm3b\rman\myrmanbkp_%F';

RMAN says that F specifier is not valid.
I want a specifier that apply DBID in the file name.
What is the file format specifiers that show DBID?

I know these below: (none show DBID)
%t ==> 4-byte time stamp
%s ==> backup set number
%p ==> backup piece number

I don't know:
What does %U stand for? (its meaning)

Where can I find a reference about rman file name specifiers? (just a URL/link)

Thanks,

mson77
Re: RMAN : format specifier %F [message #262233 is a reply to message #262226] Sat, 25 August 2007 09:17 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
%I will provide DBID and %U specifies a system-generated unique name.

Check formatSpec for details.
Re: RMAN : format specifier %F [message #262234 is a reply to message #262233] Sat, 25 August 2007 09:23 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello ebrian,

THANK YOU!
Your answer solved my problem.
But... any reason to fail the command below using specifier %F?
RMAN> backup database format 'c:\cm3b\rman\myrmanbkp_%F';

Regards,

mson77
Re: RMAN : format specifier %F [message #262236 is a reply to message #262234] Sat, 25 August 2007 09:27 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
I believe the %F is for CONTROLFILE AUTOBACKUP formatting only, however the documentation doesn't clearly explain that.
Re: RMAN : format specifier %F [message #262238 is a reply to message #262236] Sat, 25 August 2007 09:47 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
THANK YOU EBRIAN!
I agree that documentation does not clearly explain it.
Your opinion consolidates the mine.

Regards,

mson77
Re: RMAN : format specifier %F [message #470046 is a reply to message #262226] Sat, 07 August 2010 11:18 Go to previous messageGo to next message
Aston
Messages: 3
Registered: August 2010
Junior Member
'%F', it can only be used in mode 'automatically backs up the current controlfile'.
eg:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'E:\ORACLE\BACKUP\%F';

[Updated on: Sat, 07 August 2010 11:44] by Moderator

Report message to a moderator

Re: RMAN : format specifier %F [message #470051 is a reply to message #470046] Sat, 07 August 2010 11:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I can't see the' reason why you register to answer a question that already been answered 3 years ago.

Anyway I take the opportunity to tell you to avoid using bold red color font but you can use code tags to post code.
Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.

Regards
Michel
Re: RMAN : format specifier %F [message #470056 is a reply to message #470051] Sat, 07 August 2010 12:05 Go to previous messageGo to next message
Aston
Messages: 3
Registered: August 2010
Junior Member
Some people answer a question when the questioner had died 100 years
I think, it never be late to give a correct answer to a old question.
Re: RMAN : format specifier %F [message #470057 is a reply to message #470056] Sat, 07 August 2010 12:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, but this one was already answered, so my reply.
There are many questions without answer, why don't you pick one of them?

Regards
Michel
Re: RMAN : format specifier %F [message #470058 is a reply to message #470057] Sat, 07 August 2010 12:25 Go to previous message
Aston
Messages: 3
Registered: August 2010
Junior Member
ok
Previous Topic: Media Recovery failed due to the missing Log files.
Next Topic: Is there any kind of "Transparent Data Archival" in Oracle
Goto Forum:
  


Current Time: Fri Mar 29 01:05:12 CDT 2024