Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Control file does not back up

Control file does not back up

From: Edwinah63 <edwinah_at_customercare.com.au>
Date: 25 Oct 2005 21:53:07 -0700
Message-ID: <1130302387.325965.29380@g49g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US