Help with my RMAN setup
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 1piece 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