RE: rman
- From: "Chitale, Hemant K" <Hemant-K.Chitale@xxxxxx>
- To: <howard.latham@xxxxxxxxx>
- Date: Tue, 30 Sep 2014 09:41:20 +0800
If your MAXPIECESIZE is limited to 4GB, it won't have multiple datafiles
that add up to more than 4GB.
I see that this configuration seems to be for a STANDBY database ? What
about the Primary database ?
Hemant K Chitale
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Howard Latham
Sent: Monday, September 29, 2014 11:23 PM
To: Hemant K Chitale
Cc: ORACLE-L
Subject: Re: rman
show output
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01006: error signaled during parse
RMAN-02001: unrecognized punctuation symbol "*"
RMAN> 2>
using target database control file instead of recovery catalog RMAN
configuration parameters for database with db_unique_name STANDBY are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 10 DAYS; CONFIGURE
BACKUP OPTIMIZATION OFF; CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP
FORMAT FOR DEVICE TYPE DISK TO '/data/robt_%F'; CONFIGURE DEVICE TYPE
DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1; CONFIGURE
DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; CONFIGURE ARCHIVELOG
BACKUP COPIES FOR DEVICE TYPE DISK TO 1; CONFIGURE CHANNEL DEVICE TYPE
DISK MAXPIECESIZE 4 G FORMAT
'/data/oradata/rman/triples/ora_%n%T_%t_s%s_s%p.bkp';
CONFIGURE MAXSETSIZE TO UNLIMITED;
CONFIGURE ENCRYPTION FOR DATABASE OFF;
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; CONFIGURE COMPRESSION ALGORITHM
'BASIC' AS OF RELEASE 'DEFAULT'
OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; CONFIGURE SNAPSHOT
CONTROLFILE NAME TO
'/u01/app/oracle/product/11.2.0/dbhome_2/dbs/snapcf_triples.f'; #
default
RMAN>
On 29 September 2014 16:19, Hemant K Chitale <hemantkchitale@xxxxxxxxx>
wrote:
> Each datafile is larger than half the MAXSETSIZE ?
>
> Or FILESPERSET is set to 1 in the BACKUP command ?
>
> Or the BACKUP is BACKUP AS COPY ?
>
>
>
> On Mon, Sep 29, 2014 at 6:51 PM, Howard Latham
> <howard.latham@xxxxxxxxx>
> wrote:
>>
>> Oracle 11.2
>> Linux Redhat 5 Enterprise.
>>
>> I cant fathom for the life of me why rman on one particular database
>> seems to put every file in one backup piece or set of slices yet all
>> the others I have a maximum of 4 in in each slice.
>>
>> Anyone got a hint on this please? its causing me a head-ache. I've
>> checked the parameters but they seem ok.
>>
>>
>>
>>
>> --
>> Howard A. Latham
>> --
>> //www.freelists.org/webpage/oracle-l
>>
>>
>
>
>
> --
>
> Hemant K Chitale
> http://hemantoracledba.blogspot.com
> http://hemantscribbles.blogspot.com
>
--
Howard A. Latham
--
//www.freelists.org/webpage/oracle-l
This email and any attachments are confidential and may also be privileged. If
you are not the intended recipient, please delete all copies and notify the
sender immediately. You may wish to refer to the incorporation details of
Standard Chartered PLC, Standard Chartered Bank and their subsidiaries at
https://www.sc.com/en/incorporation-details.html.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
