OraFAQ Forum: Backup & Recovery » RMAN : format specifier %F

Home » RDBMS Server » Backup & Recovery » RMAN : format specifier %F

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RMAN : format specifier %F [message #262226]

Sat, 25 August 2007 08:07

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

Report message to a moderator

Re: RMAN : format specifier %F [message #262233 is a reply to message #262226]

Sat, 25 August 2007 09:17

ebrian
Messages: 2794
Registered: April 2006

Senior Member

%I will provide DBID and %U specifies a system-generated unique name.

Check formatSpec for details.

Report message to a moderator

Re: RMAN : format specifier %F [message #262234 is a reply to message #262233]

Sat, 25 August 2007 09:23

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

Report message to a moderator

Re: RMAN : format specifier %F [message #262236 is a reply to message #262234]

Sat, 25 August 2007 09:27

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.

Report message to a moderator

Re: RMAN : format specifier %F [message #262238 is a reply to message #262236]

Sat, 25 August 2007 09:47

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

Report message to a moderator

Re: RMAN : format specifier %F [message #470046 is a reply to message #262226]

Sat, 07 August 2010 11:18

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

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: RMAN : format specifier %F [message #470056 is a reply to message #470051]

Sat, 07 August 2010 12:05

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.

Report message to a moderator

Re: RMAN : format specifier %F [message #470057 is a reply to message #470056]

Sat, 07 August 2010 12:15

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: RMAN : format specifier %F [message #470058 is a reply to message #470057]

Sat, 07 August 2010 12:25

Aston
Messages: 3
Registered: August 2010

Junior Member

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 13:48:42 CST 2024