Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 9i rman question
Ok,
I came up with another script, but I need to do the following:
- backup database to a location on the network
What command will accomplish that?
RUN
{
CROSSCHECK ARCHIVELOG ALL;
ALLOCATE CHANNEL ch1 DEVICE TYPE DISK FORMAT 'r:\rman_RET2\%d_%s.bk';
ALLOCATE CHANNEL ch2 DEVICE TYPE DISK FORMAT 'r:\rman_RET2\%d_%s.bk';
BACKUP DATABASE SKIP OFFLINE SKIP INACCESSIBLE;
BACKUP ARCHIVELOG ALL DELTE INPUT UNTIL TIME 'SYSDATE-3';
}
SQL "alter database backup controlfile to trace";
exit;
Eugene Received on Mon Dec 12 2005 - 12:30:21 CST