Help with my RMAN setup

From: L C <lccronin_at_hotmail.com>
Date: Tue, 06 Mar 2007 15:13:28 GMT
Message-ID: <syfHh.1825$3i.560_at_trnddc01>



Hello,

[Quoted] Could someone please look at my RMAN setiup and tell me if it is correct? I have Oracle 9i.
[Quoted] 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.
[Quoted] I am assuming I do not have to backup the archive logs since I include those in RMAN.
[Quoted] I have gotten this far on my own, but I am confused if what I am doing is correct.
[Quoted] 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

[Quoted] 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
[Quoted] 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
[Quoted] 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. Received on Tue Mar 06 2007 - 16:13:28 CET

Original text of this message