OraFAQ Forum: Backup & Recovery » Backup current controlfile

Home » RDBMS Server » Backup & Recovery » Backup current controlfile (AIX 9.2.0.6)

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

Backup current controlfile [message #346926]

Wed, 10 September 2008 02:14

pokhraj_das
Messages: 64
Registered: February 2008

Member

Hi,

I want to backup the 3 controlfiles through RMAN.
When I am executing the below command the following error I found.

RMAN> backup current controlfile to '?/backup';

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "to": expecting one of: "archivelog, backup, backupset, channel, controlfilecopy, current, database, datafile, datafilecopy, delete, diskratio, filesperset, for, format, force, include, keep, (, maxsetsize, noexclude, nokeep, not, parms, pool, plus, ;, skip, spfile, setsize, tablespace, tag"
RMAN-01007: at line 1 column 28 file: standard input

Is there is any way to take all the controlfile backups through RAMN?

Regards-
Pokhraj.

Report message to a moderator

Re: Backup current controlfile [message #346930 is a reply to message #346926]

Wed, 10 September 2008 02:24

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You will be better off with these options.

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmconc1006.htm#sthref261

Report message to a moderator

Re: Backup current controlfile [message #346935 is a reply to message #346926]

Wed, 10 September 2008 02:36

pokhraj_das
Messages: 64
Registered: February 2008

Member

Hi,

Thanx for the link.
I have my controlfile autobackup on.
I only want to take the controlfile backup through RMAN without taking the DB backup.

Is it possible?

Pokhraj

Report message to a moderator

Re: Backup current controlfile [message #346939 is a reply to message #346935]

Wed, 10 September 2008 02:41

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

RMAN> backup current controlfile format   'yourLocation';

[Updated on: Wed, 10 September 2008 02:41]

Report message to a moderator

Re: Backup current controlfile [message #346941 is a reply to message #346926]

Wed, 10 September 2008 02:42

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Maybe you should reread the BACKUP command syntax depending of if you want a backup or a copy.

Regards
Michel

Report message to a moderator

Re: Backup current controlfile [message #349153 is a reply to message #346926]

Fri, 19 September 2008 02:19

pokhraj_das
Messages: 64
Registered: February 2008

Member

Hi,

The below command I fired but still getting the error:-
================
RMAN> run
2> {
3> allocate channel ch1 device type disk;
4> backup current controlfile format '/backup/ghrms_to_qa/ctl/CTL_%F';
5> }

released channel: ORA_DISK_1
allocated channel: ch1
channel ch1: sid=128 devtype=DISK

Starting backup at 19-SEP-08
channel ch1: starting full datafile backupset
channel ch1: specifying datafile(s) in backupset
including current controlfile in backupset
channel ch1: starting piece 1 at 19-SEP-08
released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch1 channel at 09/19/2008 03:14:32
ORA-19715: invalid format for piece name

I am not sure what is meant by "invalid format for piece name".

Please help.

Pokhraj

Report message to a moderator

Re: Backup current controlfile [message #349168 is a reply to message #349153]

Fri, 19 September 2008 03:07

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Check the valid and mandatory % values you can give of format option.

Regards
Michel

Report message to a moderator

Re: Backup current controlfile [message #349203 is a reply to message #346926]

Fri, 19 September 2008 05:42

pokhraj_das
Messages: 64
Registered: February 2008

Member

Hi,

I have checked the format.
Its same what I have entered.

but when I am firing the below command, its working.....

RMAN>backup current controlfile;

But the path where I want to save is not working.
Instead the above command saves the backup set at "$ORACLE_HOME/dbs".

Is there is any way to take the backup at my preferred location?

Pokhraj

Report message to a moderator

Re: Backup current controlfile [message #349257 is a reply to message #346926]

Fri, 19 September 2008 09:25

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

19715, 00000, "invalid format %s for generated name"
// *Cause: A restricted format or undefined format was used incorrectly.
// *Action: Change the format specified in the additional information
//          by removing the restricted format.

Report message to a moderator

Previous Topic:	RMAN recovery using a new database
Next Topic:	Checking block corruption, why in alert it is saying Error in trace file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Apr 28 19:34:56 CDT 2024