1753257 Members
5304 Online
108792 Solutions
New Discussion юеВ

ORA-27040

 
sh5490
Frequent Advisor

ORA-27040

hi,
while executing rman script, we receive the following error

Starting backup at 06-NOV-08
channel t1:starting incremental level 0 datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00007 name=/u02/oradata/cieho/itoslive01.dbf
channel t1: starting piece 1 at 06-NOV-08
released channel: t1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================
MAN-03015: error occurred in stored script full_backup
RMAN-03009: failure of backup command on t1 channel at 11/06/2008 12:43:06
ORA-19504: failed to create file "/u02archivelogabackup/oracle/bk_CIEHO_1ujv14qp_1086_1"

ORA-27040: file create error, unable to create file
HPUX-ia64 Error: 2: No such file or directory

kindlu provide me input to solove the problem
3 REPLIES 3
Oviwan
Honored Contributor

Re: ORA-27040

I think you forgot a "/" after /u02:

/u02/archivelogabackup/oracle/bk_CIEHO_1ujv14qp_1086_1"
sh5490
Frequent Advisor

Re: ORA-27040

hi,
pls find the backup script

RMAN> print script full_backup;
printing stored script: full_backup
{allocate channel t1 type disk;

configure controlfile autobackup on;
configure backup optimization on;
configure retention policy to recovery window of 7 days;
backup
format '/archivelog/backup/oracle/bk_%d_%u_%s_%p'
incremental level 0 tag ='FULL_BACKUP' database filesperset 2;
sql 'alter system switch logfile';
sql 'alter system archive log current';
backup
format '/archivelog/backup/oracle/bk_%d_%u_%s_%p'
archivelog all;
DELETE ARCHIVELOG UNTIL TIME 'SYSDATE-7';}
sh5490
Frequent Advisor

Re: ORA-27040

Hi,
Waiting your valuable inputs

regards
(Shabir)