Re: [Q] RMAN backup as one big file problem?

From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Mon, 18 Jul 2005 12:56:01 -0700 (PDT)
Message-ID: <20050718195601.55221.qmail@web60825.mail.yahoo.com>

Thank you to your info. I set to "unlimit". following are "show all":

RMAN> show all;

using target database controlfile instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2; CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u4/RMANTEST/legl_cf_%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/u4/RMANTEST/legl_%U.bak';
RMAN configuration has no stored or default parameters CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO
'/home/app/oracle/product/9.2/dbs/snapcf_legl.f'; # default
RMAN configuration has no stored or default parameters RMAN configuration has no stored or default parameters

• Ron Rogers <RROGERS_at_galottery.org> wrote:

> Have you set the channel limit in the RMAN command
> structure?
> If the channel limit is set "set limit channel d1
> kbytes 50000;" will produce a file of 5 gig and
> include
> only the files that will fit in the backup file.
> How big are the files you are trying to backup?
> Ron
>
> >>> dba1 mcc <mccdba1_at_yahoo.com> 07/18/05 10:22 AM
> >>>
> We have ORACLE 9.2.0.6 on LINUX server. The
> database
> have 4 datafiles
>
> system
> undo
> data
> index
> While we doing RMAN backup we specify "backup
> database
> filesperset=6;", RMAN does NOT backup all 4
> datafiles
> to one big file. It backup system, undo and data
> files as one file. It also backup index as another
> file.
>
> Does their has way to make RMAN backup all datafile
> as
> one big file?
>
> Thanks.
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam
> protection around
> http://mail.yahoo.com
> --
> http://www.freelists.org/webpage/oracle-l
>
>
                

---

Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs  

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jul 18 2005 - 14:58:00 CDT