Re: Help with my RMAN setup

From: L C <lccronin_at_hotmail.com>
Date: Wed, 07 Mar 2007 12:23:53 GMT
Message-ID: <t9yHh.212$Ah.167_at_trnddc07>


"sybrandb" <sybrandb_at_gmail.com> wrote in message news:1173262842.496925.78510_at_j27g2000cwj.googlegroups.com...
> 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.

>

> 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
>

Thanks for the input, I will take a look at the suggestions and see if I can figure out what is going on. Received on Wed Mar 07 2007 - 13:23:53 CET

Original text of this message