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 -> Re: 9i rman question

Re: 9i rman question

From: <epipko_at_gmail.com>
Date: 12 Dec 2005 10:30:21 -0800
Message-ID: <1134412221.374013.70110@g14g2000cwa.googlegroups.com>


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

Original text of this message

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