This content has been marked as final. Show 9 replies
The following is my Rman script for database backup which is running on scheduler. i have to add *'BACKUP DATABASE FORMAT 'J:\Rman_Prod\Backup%d_DB_%u_%s_%p_%a''* this to the script or i have to run separately.
BACKUP CURRENT CONTROLFILE;
Sql 'Alter system archive log current';
This command not working ans it shows following error...
RMAN> BACKUP tablespace orissa_master COPIES 2 FORMAT 'd:\Rman_Prod\Backup%d_DB_%u_%s_%p_%a','d:\Rman\Backup%d_DB_%u_%s_%p_%a' ;
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "copies": expecting one of: "archivelog, backup, backupset, channel, comma, copy, controlfilecopy, current, database, datafile, datafilecopy, delete, diskratio, db_recovery_file_
dest, filesperset, format, from, force, include, keep, (, maxsetsize, noexclude, nokeep, not, pool, plus, reuse, recovery, ;, skip, spfile, setsize, tablespace, tag, to"
RMAN-01007: at line 1 column 33 file: standard input
Oh. You are running 10.2
The COPIES option appears in the 11.2 documentation. See Example 2-22 at http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta007.htm#CHDJIJDH
In 10.2 you'd have to add a separate BACKUP DATABASE FORMAT 'J:....' command in the backup script.
The two backups would not be the same as each other (copies of each other) as the second backup would begin after the first backup completes.
Hemant K Chitale
Edited by: Hemant K Chitale on Jan 29, 2013 2:56 PM
Duplexing Backup with the COPIES parameter does appear in the 10.2 documentation.
Can you retry it ? See the example "Duplexing a Backup Set: Example"
Hemant K Chitale