Home -> Usenet -> c.d.o.server -> backup question

backup question

From: cptkirkh <khill_at_scic.com>
Date: Tue, 29 Jan 2008 14:41:43 -0800 (PST)
Message-ID: <17fd27ec-869b-4897-a7a3-7180735e8cc8@e6g2000prf.googlegroups.com> 





I am reviewing my backup strategy and i came across errors in our
backups.  Here is the backup script we run daily.



$rman_script="backup incremental level 1 cumulative device type disk
tag '%TAG' database;


recover copy of database;


backup device type disk tag '%TAG' archivelog all not backed up delete
all input;


allocate channel for maintenance type 'SBT_TAPE';
delete noprompt obsolete device type disk;
release channel;


";


&br_save_agent_env();


&br_prebackup($l_db_connect_string, $l_is_cold_backup, $l_use_rcvcat,
$l_db_10_or_higher, $l_backup_strategy, "TRUE");
my $result = &br_backup();


exit($result);



Here is the log from the backup script.  It looks like it is
performing the backup fine but has seems to be having a problem with
parallelism being set and it seems to have a problem with trying to
backup to a tape which we actually backup to a drive nto a tape.  I
also don't understadn no data file to recover.  What should i do to
work out these problems?  Thnaks for your help.  Oh and yes i am
reading the backup and recovery guides as we speak I woud just liek
some help from the experts.  Thanks for the help in advance.



Recovery Manager: Release 10.2.0.3.0 - Production on Mon Jan 28
18:00:24 2008





Copyright (c) 1982, 2005, Oracle.  All rights reserved.





RMAN>


connected to target database: PORKY (DBID=890890261)



using target database control file instead of recovery catalog





RMAN>


echo set on







RMAN> set command id to 'BACKUP_PORKY_INC_012808060013';



executing command: SET COMMAND ID







RMAN> backup incremental level 1 cumulative device type disk tag
'BACKUP_PORKY_INC_012808060013' database;



Starting backup at 28-JAN-08



allocated channel: ORA_DISK_1



channel ORA_DISK_1: sid=42 devtype=DISK



channel ORA_DISK_1: starting compressed incremental level 1 datafile
backupset



channel ORA_DISK_1: specifying datafile(s) in backupset



input datafile fno=00004 name=F:\ORACLE\PRODUCT\10.2.0\DB_1\ORADATA


\PORKY\USERS01.DBF



input datafile fno=00005 name=F:\ORACLE\PRODUCT\10.2.0\DB_1\ORADATA


\PORKY\USERS02.DBF



input datafile fno=00002 name=F:\ORACLE\PRODUCT\10.2.0\DB_1\ORADATA


\PORKY\UNDOTBS01.DBF



input datafile fno=00003 name=F:\ORACLE\PRODUCT\10.2.0\DB_1\ORADATA


\PORKY\SYSAUX01.DBF



input datafile fno=00001 name=F:\ORACLE\PRODUCT\10.2.0\DB_1\ORADATA


\PORKY\SYSTEM01.DBF



input datafile fno=00006 name=F:\ORACLE\PRODUCT\10.1.0\ORADATA\PORKY


\PERFSTAT.DBF



input datafile fno=00007 name=F:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE


\TOOLS.DBF



channel ORA_DISK_1: starting piece 1 at 28-JAN-08



channel ORA_DISK_1: finished piece 1 at 28-JAN-08



piece handle=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\5UJ7ABEB_1_1
tag=BACKUP_PORKY_INC_012808060013 comment=NONE



channel ORA_DISK_1: backup set complete, elapsed time: 00:31:49



Finished backup at 28-JAN-08





Starting Control File and SPFILE Autobackup at 28-JAN-08



piece handle=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\C-890890261-20080128-00 comment=NONE




Finished Control File and SPFILE Autobackup at 28-JAN-08







RMAN> recover copy of database;



Starting recover at 28-JAN-08



using channel ORA_DISK_1



no copy of datafile 1 found to recover



no copy of datafile 2 found to recover



no copy of datafile 3 found to recover



no copy of datafile 4 found to recover



no copy of datafile 5 found to recover



no copy of datafile 6 found to recover



no copy of datafile 7 found to recover



Finished recover at 28-JAN-08







RMAN> backup device type disk tag 'BACKUP_PORKY_INC_012808060013'
archivelog all not backed up delete all input;



Starting backup at 28-JAN-08



current log archived



using channel ORA_DISK_1



channel ORA_DISK_1: starting compressed archive log backupset



channel ORA_DISK_1: specifying archive log(s) in backup set



input archive log thread=1 sequence=110094 recid=216108
stamp=645147920



input archive log thread=1 sequence=110095 recid=216110
stamp=645150501



input archive log thread=1 sequence=110096 recid=216112
stamp=645150530



input archive log thread=1 sequence=110097 recid=216114
stamp=645150598



input archive log thread=1 sequence=110098 recid=216116
stamp=645156160



input archive log thread=1 sequence=110099 recid=216119
stamp=645156509



input archive log thread=1 sequence=110100 recid=216120
stamp=645156531



input archive log thread=1 sequence=110101 recid=216122
stamp=645156552



input archive log thread=1 sequence=110102 recid=216124
stamp=645156573



input archive log thread=1 sequence=110103 recid=216126
stamp=645156611



input archive log thread=1 sequence=110104 recid=216128
stamp=645156674



input archive log thread=1 sequence=110105 recid=216130
stamp=645158437



input archive log thread=1 sequence=110106 recid=216133
stamp=645160122



input archive log thread=1 sequence=110107 recid=216134
stamp=645160150



input archive log thread=1 sequence=110108 recid=216136
stamp=645166868



input archive log thread=1 sequence=110109 recid=216138
stamp=645166874



input archive log thread=1 sequence=110110 recid=216140
stamp=645166903



input archive log thread=1 sequence=110111 recid=216142
stamp=645166922



input archive log thread=1 sequence=110112 recid=216145
stamp=645166950



input archive log thread=1 sequence=110113 recid=216146
stamp=645172213



input archive log thread=1 sequence=110114 recid=216149
stamp=645181259



input archive log thread=1 sequence=110115 recid=216150
stamp=645192189



input archive log thread=1 sequence=110116 recid=216152
stamp=645192198



input archive log thread=1 sequence=110117 recid=216154
stamp=645192227



input archive log thread=1 sequence=110118 recid=216156
stamp=645192245



input archive log thread=1 sequence=110119 recid=216158
stamp=645192267



input archive log thread=1 sequence=110120 recid=216160
stamp=645194646



input archive log thread=1 sequence=110121 recid=216162
stamp=645210269



input archive log thread=1 sequence=110122 recid=216164
stamp=645213568



input archive log thread=1 sequence=110123 recid=216167
stamp=645213593



input archive log thread=1 sequence=110124 recid=216168
stamp=645213612



input archive log thread=1 sequence=110125 recid=216170
stamp=645213653



input archive log thread=1 sequence=110126 recid=216172
stamp=645213653



input archive log thread=1 sequence=110127 recid=216174
stamp=645214361



input archive log thread=1 sequence=110128 recid=216176
stamp=645214396



input archive log thread=1 sequence=110129 recid=216178
stamp=645214414



input archive log thread=1 sequence=110130 recid=216180
stamp=645214449



input archive log thread=1 sequence=110131 recid=216182
stamp=645214455



input archive log thread=1 sequence=110132 recid=216184
stamp=645215588



channel ORA_DISK_1: starting piece 1 at 28-JAN-08



channel ORA_DISK_1: finished piece 1 at 28-JAN-08



piece handle=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\60J7ADB7_1_1
tag=BACKUP_PORKY_INC_012808060013 comment=NONE



channel ORA_DISK_1: backup set complete, elapsed time: 00:04:27



channel ORA_DISK_1: deleting archive log(s)



archive log filename=E:\ARCHIVELOGS\ARC110094_0548171989.001
recid=216108 stamp=645147920



archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110094_0548171989.001 recid=216109 stamp=645147920




archive log filename=E:\ARCHIVELOGS\ARC110095_0548171989.001
recid=216110 stamp=645150501



archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110095_0548171989.001 recid=216111 stamp=645150501




archive log filename=E:\ARCHIVELOGS\ARC110096_0548171989.001
recid=216112 stamp=645150530



archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110096_0548171989.001 recid=216113 stamp=645150530




archive log filename=E:\ARCHIVELOGS\ARC110097_0548171989.001
recid=216114 stamp=645150598



archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110097_0548171989.001 recid=216115 stamp=645150598




archive log filename=E:\ARCHIVELOGS\ARC110098_0548171989.001
recid=216116 stamp=645156160



archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110098_0548171989.001 recid=216117 stamp=645156160




archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110099_0548171989.001 recid=216119 stamp=645156509




archive log filename=E:\ARCHIVELOGS\ARC110099_0548171989.001
recid=216118 stamp=645156508



archive log filename=E:\ARCHIVELOGS\ARC110100_0548171989.001
recid=216120 stamp=645156531



archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110100_0548171989.001 recid=216121 stamp=645156531




archive log filename=E:\ARCHIVELOGS\ARC110101_0548171989.001
recid=216122 stamp=645156552



archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110101_0548171989.001 recid=216123 stamp=645156552




archive log filename=E:\ARCHIVELOGS\ARC110102_0548171989.001
recid=216124 stamp=645156573



archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110102_0548171989.001 recid=216125 stamp=645156573




archive log filename=E:\ARCHIVELOGS\ARC110103_0548171989.001
recid=216126 stamp=645156611



archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110103_0548171989.001 recid=216127 stamp=645156611




archive log filename=E:\ARCHIVELOGS\ARC110104_0548171989.001
recid=216128 stamp=645156674



archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110104_0548171989.001 recid=216129 stamp=645156674




archive log filename=E:\ARCHIVELOGS\ARC110105_0548171989.001
recid=216130 stamp=645158437



archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110105_0548171989.001 recid=216131 stamp=645158437




archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110106_0548171989.001 recid=216133 stamp=645160122




archive log filename=E:\ARCHIVELOGS\ARC110106_0548171989.001
recid=216132 stamp=645160121



archive log filename=E:\ARCHIVELOGS\ARC110107_0548171989.001
recid=216134 stamp=645160150



archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110107_0548171989.001 recid=216135 stamp=645160150




archive log filename=E:\ARCHIVELOGS\ARC110108_0548171989.001
recid=216136 stamp=645166868



archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110108_0548171989.001 recid=216137 stamp=645166868




archive log filename=E:\ARCHIVELOGS\ARC110109_0548171989.001
recid=216138 stamp=645166874



archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110109_0548171989.001 recid=216139 stamp=645166874




archive log filename=E:\ARCHIVELOGS\ARC110110_0548171989.001
recid=216140 stamp=645166903



archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110110_0548171989.001 recid=216141 stamp=645166903




archive log filename=E:\ARCHIVELOGS\ARC110111_0548171989.001
recid=216142 stamp=645166922



archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110111_0548171989.001 recid=216143 stamp=645166922




archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110112_0548171989.001 recid=216145 stamp=645166950




archive log filename=E:\ARCHIVELOGS\ARC110112_0548171989.001
recid=216144 stamp=645166949



archive log filename=E:\ARCHIVELOGS\ARC110113_0548171989.001
recid=216146 stamp=645172213



archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110113_0548171989.001 recid=216147 stamp=645172213




archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110114_0548171989.001 recid=216149 stamp=645181259




archive log filename=E:\ARCHIVELOGS\ARC110114_0548171989.001
recid=216148 stamp=645181258



archive log filename=E:\ARCHIVELOGS\ARC110115_0548171989.001
recid=216150 stamp=645192189



archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110115_0548171989.001 recid=216151 stamp=645192189




archive log filename=E:\ARCHIVELOGS\ARC110116_0548171989.001
recid=216152 stamp=645192198



archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110116_0548171989.001 recid=216153 stamp=645192198




archive log filename=E:\ARCHIVELOGS\ARC110117_0548171989.001
recid=216154 stamp=645192227



archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110117_0548171989.001 recid=216155 stamp=645192227




archive log filename=E:\ARCHIVELOGS\ARC110118_0548171989.001
recid=216156 stamp=645192245



archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110118_0548171989.001 recid=216157 stamp=645192245




archive log filename=E:\ARCHIVELOGS\ARC110119_0548171989.001
recid=216158 stamp=645192267



archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110119_0548171989.001 recid=216159 stamp=645192267




archive log filename=E:\ARCHIVELOGS\ARC110120_0548171989.001
recid=216160 stamp=645194646



archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110120_0548171989.001 recid=216161 stamp=645194646




archive log filename=E:\ARCHIVELOGS\ARC110121_0548171989.001
recid=216162 stamp=645210269



archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110121_0548171989.001 recid=216163 stamp=645210269




archive log filename=E:\ARCHIVELOGS\ARC110122_0548171989.001
recid=216164 stamp=645213568



archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110122_0548171989.001 recid=216165 stamp=645213568




archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110123_0548171989.001 recid=216167 stamp=645213593




archive log filename=E:\ARCHIVELOGS\ARC110123_0548171989.001
recid=216166 stamp=645213592



archive log filename=E:\ARCHIVELOGS\ARC110124_0548171989.001
recid=216168 stamp=645213612



archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110124_0548171989.001 recid=216169 stamp=645213612




archive log filename=E:\ARCHIVELOGS\ARC110125_0548171989.001
recid=216170 stamp=645213653



archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110125_0548171989.001 recid=216171 stamp=645213653




archive log filename=E:\ARCHIVELOGS\ARC110126_0548171989.001
recid=216172 stamp=645213653



archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110126_0548171989.001 recid=216173 stamp=645213653




archive log filename=E:\ARCHIVELOGS\ARC110127_0548171989.001
recid=216174 stamp=645214361



archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110127_0548171989.001 recid=216175 stamp=645214361




archive log filename=E:\ARCHIVELOGS\ARC110128_0548171989.001
recid=216176 stamp=645214396



archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110128_0548171989.001 recid=216177 stamp=645214396




archive log filename=E:\ARCHIVELOGS\ARC110129_0548171989.001
recid=216178 stamp=645214414



archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110129_0548171989.001 recid=216179 stamp=645214414




archive log filename=E:\ARCHIVELOGS\ARC110130_0548171989.001
recid=216180 stamp=645214449



archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110130_0548171989.001 recid=216181 stamp=645214449




archive log filename=E:\ARCHIVELOGS\ARC110131_0548171989.001
recid=216182 stamp=645214455



archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110131_0548171989.001 recid=216183 stamp=645214455




archive log filename=E:\ARCHIVELOGS\ARC110132_0548171989.001
recid=216184 stamp=645215588



archive log filename=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\ARC110132_0548171989.001 recid=216185 stamp=645215588




Finished backup at 28-JAN-08





Starting Control File and SPFILE Autobackup at 28-JAN-08



piece handle=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\C-890890261-20080128-01 comment=NONE




Finished Control File and SPFILE Autobackup at 28-JAN-08







RMAN> allocate channel for maintenance type 'SBT_TAPE';



released channel: ORA_DISK_1



RMAN-00571:






RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS






RMAN-00571:






RMAN-03009: failure of allocate command on ORA_MAINT_SBT_TAPE_1
channel at 01/28/2008 18:38:11



ORA-19554: error allocating device, device type: SBT_TAPE, device
name:



ORA-27211: Failed to load Media Management Library







RMAN> delete noprompt obsolete device type disk;



RMAN retention policy will be applied to the command



RMAN retention policy is set to recovery window of 7 days



RMAN-06908: WARNING: operation will not run in parallel on the
allocated channels



RMAN-06909: WARNING: parallelism require Enterprise Edition



allocated channel: ORA_DISK_1



channel ORA_DISK_1: sid=86 devtype=DISK



Deleting the following obsolete backups and copies:


Type                 Key    Completion Time    Filename/Handle

-------------------- ------ ------------------ --------------------

Backup Set           3196   20-JAN-08

  Backup Piece       5261   20-JAN-08          F:\ORACLE\PRODUCT




\10.2.0\FLASH_RECOVERY_AREA\4UJ6L8DO_1_1



Backup Set           3198   20-JAN-08



  Backup Piece       5263   20-JAN-08          F:\ORACLE\PRODUCT


\10.2.0\FLASH_RECOVERY_AREA\50J6LA61_1_1



Backup Set           3199   20-JAN-08



  Backup Piece       5264   20-JAN-08          F:\ORACLE\PRODUCT


\10.2.0\FLASH_RECOVERY_AREA\C-890890261-20080120-01



Backup Set           3201   21-JAN-08



  Backup Piece       5266   21-JAN-08          F:\ORACLE\PRODUCT


\10.2.0\FLASH_RECOVERY_AREA\C-890890261-20080121-00



deleted backup piece



backup piece handle=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\4UJ6L8DO_1_1 recid=5261 stamp=644522427




deleted backup piece



backup piece handle=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\50J6LA61_1_1 recid=5263 stamp=644524227




deleted backup piece



backup piece handle=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\C-890890261-20080120-01 recid=5264 stamp=644524335




deleted backup piece



backup piece handle=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA


\C-890890261-20080121-00 recid=5266 stamp=644610577




Deleted 4 objects









RMAN> release channel;



RMAN-00571:






RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS






RMAN-00571:






RMAN-03002: failure of release command at 01/28/2008 18:38:55



RMAN-06474: maintenance channels are not allocated







RMAN> exit;





Recovery Manager complete.
Received on Tue Jan 29 2008 - 16:41:43 CST












Original text of this message