Re: Help with my RMAN setup

From: sybrandb <sybrandb_at_gmail.com>
Date: 7 Mar 2007 02:20:42 -0800
Message-ID: <1173262842.496925.78510_at_j27g2000cwj.googlegroups.com>


[Quoted] On Mar 6, 4:13 pm, "L C" <lccro..._at_hotmail.com> wrote:
> 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.

[Quoted] 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)

[Quoted] 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?

--
[Quoted] Sybrand Bakker
Senior Oracle DBA
Received on Wed Mar 07 2007 - 11:20:42 CET

Original text of this message