Re: RMAN testing

From: Ram Raman <veeeraman_at_gmail.com>
Date: Thu, 14 Feb 2008 10:54:33 -0600
Message-ID: <effc058d0802140854q27f54026ua981ac81f1ce0902@mail.gmail.com>


I have the results of SHOW ALL related to the output location in the original post. Here is SHOW ALL unedited:

RMAN> show all;

using target database control file instead of recovery catalog 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 ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/psoft/u02/oracle10g/cds/ATES/bkup/%F'; CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COMPRESSED BACKUPSET;
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 '/psoft/u02/oracle10g/cds/ATES/bkup/%U'; CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/psoft/u02/oracle10g/cds/ATES/bkup/%U'; CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE ENCRYPTION FOR DATABASE OFF; # default CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO
'/psoft/u02/oracle10g/cds/ATES/bkup/snapcf_ATES.f';

RMAN> On 2/14/08, Jared Still <jkstill_at_gmail.com> wrote:
>
>
> On Wed, Feb 13, 2008 at 8:03 PM, Ram Raman <veeeraman_at_gmail.com> wrote:
>
> > Hi all,
> >
> > I am trying to simulate what is in production in dev box and test out
> > the existing setup. We have Oracle 10.2.0.2. ATES is a small database
> > that I created in dev. Here is the script that I take backup with:
> >
> >
>
> I think 'SHOW ALL;' from rman might be informative.
>
>
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 14 2008 - 10:54:33 CST

Original text of this message