Hello,

Could someone please look at my RMAN setiup and tell me if it is correct?
I have Oracle 9i.
Oracle Archive logs saved to c:\oracle\archive
I am runnning RMAN every night I also backup c:\oracle\backup to tape later
that night as well.
I am assuming I do not have to backup the archive logs since I include those
in RMAN.
I have gotten this far on my own, but I am confused if what I am doing is
correct.
I included my RMAN show all, rcv, and backup log below. Sorry for the
length of post.

Thanks

Larry C

This is my "show all"
using target database controlfile instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 3;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO
'c:\oracle\backu
p\ora_cf%F';
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 DEVICE TYPE DISK FORMAT
'c:\oracle\backup\ora_df%t_s%s_s%p';

CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO
'C:\ORACLE\ORA92\DATABASE\SNCFOBIAN.ORA';
# default

This is my "RMAN.rcv"

backup database plus archivelog;
restore database validate;
delete noprompt obsolete;

host 'copy c:\oracle\ora92\database\PWDORCL.ora c:\oracle\backup';
host 'copy c:\oracle\ora92\network\admin\tnsnames.ora c:\oracle\backup';
host 'copy c:\oracle\ora92\network\admin\listener.ora c:\oracle\backup';

This is my "RMAN.log"

Starting backup at 04-MAR-07
current log archived
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=856 recid=523 stamp=616366648
channel ORA_DISK_1: starting piece 1 at 04-MAR-07
channel ORA_DISK_1: finished piece 1 at 04-MAR-07
piece handle=C:\ORACLE\BACKUP\ORA_DF616366648_S748_S1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 04-MAR-07

Starting Control File and SPFILE Autobackup at 04-MAR-07
piece handle=C:\ORACLE\BACKUP\ORA_CFC-3341977951-20070304-00 comment=NONE
Finished Control File and SPFILE Autobackup at 04-MAR-07

Starting restore at 04-MAR-07

using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting validation of datafile backupset
channel ORA_DISK_2: starting validation of datafile backupset
channel ORA_DISK_1: restored backup piece 1
piece handle=C:\ORACLE\BACKUP\ORA_DF616366533_S746_S1 tag=TAG20070304T205533
params=NULL
channel ORA_DISK_1: validation complete
channel ORA_DISK_2: restored backup piece 1
piece handle=C:\ORACLE\BACKUP\ORA_DF616366533_S747_S1 tag=TAG20070304T205533
params=NULL
channel ORA_DISK_2: validation complete
Finished restore at 04-MAR-07

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 3
using channel ORA_DISK_1
using channel ORA_DISK_2
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 730 01-MAR-07
Backup Piece 730 01-MAR-07
C:\ORACLE\BACKUP\ORA_DF616107323_S730_S1
Backup Set 731 01-MAR-07
Backup Piece 731 01-MAR-07
C:\ORACLE\BACKUP\ORA_DF616107323_S731_S1
Backup Set 732 01-MAR-07
Backup Piece 732 01-MAR-07
C:\ORACLE\BACKUP\ORA_DF616107447_S732_S1
Backup Set 733 01-MAR-07
Backup Piece 733 01-MAR-07
C:\ORACLE\BACKUP\ORA_CFC-3341977951-20070301-00
Backup Set 734 02-MAR-07
Backup Piece 734 02-MAR-07
C:\ORACLE\BACKUP\ORA_DF616193711_S735_S1
Backup Set 735 02-MAR-07
Backup Piece 735 02-MAR-07
C:\ORACLE\BACKUP\ORA_DF616193711_S734_S1
Archive Log 518 02-MAR-07
C:\ORACLE\ARCHIVE\ARC00851.001
Archive Log 517 02-MAR-07
C:\ORACLE\ARCHIVE\ARC00850.001
Archive Log 516 01-MAR-07
C:\ORACLE\ARCHIVE\ARC00849.001
deleted backup piece
backup piece handle=C:\ORACLE\BACKUP\ORA_DF616107323_S730_S1 recid=730
stamp=616107324
deleted backup piece
backup piece handle=C:\ORACLE\BACKUP\ORA_DF616107323_S731_S1 recid=731
stamp=616107328
deleted backup piece
backup piece handle=C:\ORACLE\BACKUP\ORA_DF616107447_S732_S1 recid=732
stamp=616107449
deleted backup piece
backup piece handle=C:\ORACLE\BACKUP\ORA_CFC-3341977951-20070301-00
recid=733 stamp=616107450
deleted backup piece
backup piece handle=C:\ORACLE\BACKUP\ORA_DF616193711_S735_S1 recid=734
stamp=616193714
deleted backup piece
backup piece handle=C:\ORACLE\BACKUP\ORA_DF616193711_S734_S1 recid=735
stamp=616193712
deleted archive log
archive log filename=C:\ORACLE\ARCHIVE\ARC00851.001 recid=518
stamp=616193709
deleted archive log
archive log filename=C:\ORACLE\ARCHIVE\ARC00850.001 recid=517
stamp=616176829
deleted archive log
archive log filename=C:\ORACLE\ARCHIVE\ARC00849.001 recid=516
stamp=616107447
Deleted 9 objects


host command complete

host command complete

host command complete

Recovery Manager complete.

On Mar 6, 4:13 pm, "L C" <lccro... (AT) hotmail (DOT) com> wrote:
Parallelism 2 doesn't make much sense, as everything goes to one
single disk.
I would correct s%p in p%p, and instead of df_%t, I would use %d_%T
(get the date in the saveset name)
I would also try to use tags (currently implementing those myself,
easy to do so on Unix, more difficult on Winblows, you would need
Windows Scripting Host for that, or generate an adhoc rman script
using a template)

Your output log looks very strange as usually RMAN would list all
tablespaces included in a backup set.
Did you run
list backup of database
to verify which tablespaces are included in the backup?

--
Sybrand Bakker
Senior Oracle DBA

"sybrandb" <sybrandb (AT) gmail (DOT) com> wrote


Thanks for the input, I will take a look at the suggestions and see if I can
figure out what is going on.