Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Control file does not back up
i have a backup script (YES i also use rman!!!), that does a hot backup
everthing except the control file.
if i run the line
alter database backup controlfile to 'F:\MyBackups\Ast20051026.ctl';
from sqlplus, it executes without problem. if i run it in the backup script, this line alone doesn't run, everthing else in the script runs fine. i have searched everywhere for an error message but there is none.
can anyone explain?
edit of the script:
alter tablespace XYZ begin backup;
host copy C:\XX\XYZ.DBF F:\MyBackups\*.*;
alter tablespace XYZ end backup;
host copy C:\XX\SPFILEASSIST.ORA F:\MyBackups\*.*; host copy C:\XX\init.ora F:\MyBackups\*.*;
alter system archive log current;
host copy F:\XX\archive\*.* F:\MyBackups\*.*
//everything above works fine
//this line fails to execute!!
alter database backup controlfile to 'F:\MyBackups\Ast20051026.ctl';
//this line works fine
alter database backup controlfile to TRACE as
'F:\MyBackups\Ast20051026.trc' NORESETLOGS;
exit;
regards
Edwinah63 Received on Tue Oct 25 2005 - 23:53:07 CDT
![]() |
![]() |