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@xxxxxxxxx> wrote: > > > On Wed, Feb 13, 2008 at 8:03 PM, Ram Raman <veeeraman@xxxxxxxxx> 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 >