|
|
Hi Arsalan,
window 2008
oracle R2
when ever i call or execute batch file which called name (daily_backup.sql)
it not success give error like below ,but when every i test in my pc it work fine.
Argument Value Description
-----------------------------------------------------------------------------
target quoted-string connect-string for target database
catalog quoted-string connect-string for recovery catalog
nocatalog none if specified, then no recovery catalog
cmdfile quoted-string name of input command file
log quoted-string name of output message log file
trace quoted-string name of output debugging message log file
append none if specified, log is opened in append mode
debug optional-args activate debugging
msgno none show RMAN-nnnn prefix for all messages
send quoted-string send a command to the media manager
pipe string building block for pipe names
timeout integer number of seconds to wait for pipe input
checksyntax none check the command file for syntax errors
-----------------------------------------------------------------------------
Both single and double quotes (' or ") are accepted for a quoted-string.
Quotes are not required unless the string contains embedded white-space.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00556: could not open CMDFILE "C:\Windows\DAILY_BACKUP.SQL"
rman@C:\Windows\DAILY_BACKUP.SQL>D:\SIGTASDWH\DAILY_SCRIPT\rman_backup_%date:~0,3%.LOG
------rman script file name is daily_backup.sql
connect target 'SYS/*****@dwh'
RUN
{
CROSSCHECK BACKUP;
CROSSCHECK ARCHIVELOG ALL;
DELETE NOPROMPT EXPIRED BACKUP;
DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;
DELETE NOPROMPT OBSOLETE;
ALLOCATE CHANNEL CH1 TYPE DISK;
ALLOCATE CHANNEL CH2 TYPE DISK;
ALLOCATE CHANNEL CH3 TYPE DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
BACKUP DATABASE;
BACKUP AS COMPRESSED BACKUPSET ARCHIVELOG ALL FORMAT 'C:\app\sigtas\flash_recovery_area\dwh\ARCHIVEBK\arch_%d_%T_%s_%t';
BACKUP CURRENT CONTROLFILE;
DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-5';
DELETE NOPROMPT OBSOLETE DEVICE TYPE DISK;
RELEASE CHANNEL CH1;
RELEASE CHANNEL CH2;
RELEASE CHANNEL CH3;
}
|
Locked
