Home » RDBMS Server » Backup & Recovery » Backup current controlfile (AIX 9.2.0.6)
Backup current controlfile [message #346926] Wed, 10 September 2008 02:14 Go to next message
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.
Re: Backup current controlfile [message #346930 is a reply to message #346926] Wed, 10 September 2008 02:24 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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
Re: Backup current controlfile [message #346935 is a reply to message #346926] Wed, 10 September 2008 02:36 Go to previous messageGo to next message
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
Re: Backup current controlfile [message #346939 is a reply to message #346935] Wed, 10 September 2008 02:41 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: Backup current controlfile [message #349153 is a reply to message #346926] Fri, 19 September 2008 02:19 Go to previous messageGo to next message
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
Re: Backup current controlfile [message #349168 is a reply to message #349153] Fri, 19 September 2008 03:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: Backup current controlfile [message #349203 is a reply to message #346926] Fri, 19 September 2008 05:42 Go to previous messageGo to next message
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
Re: Backup current controlfile [message #349257 is a reply to message #346926] Fri, 19 September 2008 09:25 Go to previous message
BlackSwan
Messages: 25033
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.
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:
  


Current Time: Sat Dec 03 09:56:34 CST 2016

Total time taken to generate the page: 0.11500 seconds