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

Home -> Community -> Mailing Lists -> Oracle-L -> 9i RMAN configuration setting

9i RMAN configuration setting

From: elain he <elainhe_at_hotmail.com>
Date: Tue, 23 Jul 2002 15:03:44 -0800
Message-ID: <F001.004A0402.20020723150344@fatcity.com>


Hi,
Does anyone know how I can specify in RMAN the size of the backup data files to be copied to each channel? For eg. if I have a 500MB database and would like to backup 100MB to channel 1 and 400MB to channel 2, how can I configure that?

Thanks.

elain

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 2; CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT
'D:\oracle\oradata\testing\1\%U' MAXPIECESIZE 50 M;
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT
'D:\oracle\oradata\testing\2\%U' MAXPIECESIZE 50 M;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO
'D:\ORACLE\ORA92\DATABASE\SNCFTEST.ORA'; # default



Send and receive Hotmail on your mobile device: http://mobile.msn.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: elain he
  INET: elainhe_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Tue Jul 23 2002 - 18:03:44 CDT

Original text of this message

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