Hi guys, its me, the Oracle 8i guy again.
I put together the script below to do my database and archive log backups. However, I would like to backup my controlfile to a file and not to trace. Is there a way to do this within the script?
ALLOCATE CHANNEL CH1 TYPE DISK;
ALLOCATE CHANNEL CH2 TYPE DISK;
ALLOCATE CHANNEL CH3 TYPE DISK;
BACKUP FORMAT ‘E:\ORACLE\ORADATA\ORABKP\%d_t%t_p%p’ (database);
SQL ‘ALTER SYSTEM ARCHIVELOG CURRENT’;
BACKUP (ARCHIVELOG ALL DELETE INPUT);
SQL ‘ALTER DATABASE BACKUP CONTROLFILE TO TRACE’;