HP Data Protector Manual Download Page 38

Page: 38 / 60

piece handle=RAC_POOL_RAC1..4<RAC_548:635712145:1>.dbf tag=TAG20071011T184224 comment=API Version 2.0,MMS
Version 65.6.0.0

channel dev_1: backup set complete, elapsed time: 00:47:42

Finished backup at 11-OCT-07

Starting Control File and SPFILE Autobackup at 11-OCT-07

[Normal]

From: OB2BAR_Oracle8@ita018 "RAC" Time: 11.10.2007 19:30:56

Starting OB2BAR Backup: ita018-vip:c-2216826430-20071011-03 "Oracle8"

[Normal]

From: OB2BAR_Oracle8@ita018 "RAC" Time: 11.10.2007 19:30:58

Backup

Profile:

Run Time ........... 0:00:02

Backup Speed ....... 9600,00 (KB/s)

[Normal]

From: OB2BAR_Oracle8@ita018 "RAC" Time: 11.10.2007 19:30:59

Completed OB2BAR Backup: ita018-vip:c-2216826430-20071011-03 "Oracle8"

piece handle=c-2216826430-20071011-03 comment=API Version 2.0,MMS Version 65.6.0.0

Finished Control File and SPFILE Autobackup at 11-OCT-07

released channel: dev_0

released channel: dev_1

Recovery Manager complete.

[Normal]

From: ob2rman@ita018 "RAC" Time: 10/11/07 19:31:15

Oracle Recovery Manager completed.

[Normal]

From: ob2rman@ita018 "RAC" Time: 10/11/07 19:31:15

Backup of target database completed.

[Normal]

From: BSM@ita017 "RAC_POOL_RAC1..4" Time: 11.10.2007 19:31:11

OB2BAR application on "ita018-vip" disconnected.

[Normal]

From: BMA@ita018 "COMPAQ:SDLT320_2" Time: 11.10.2007 19:31:49

/dev/rmt/1mn

Medium header verification completed, 0 errors found

[Normal]

From: BMA@ita018 "COMPAQ:SDLT320_2" Time: 11.10.2007 19:32:05

By:

UMA@ita018@/dev/rac/c20t0d0

Unloading medium to slot 18 from device /dev/rmt/1mn

[Normal]

From: BMA@ita018 "COMPAQ:SDLT320_2" Time: 11.10.2007 19:32:17

COMPLETED Media Agent "COMPAQ:SDLT320_2"

[Normal]

From: BMA@ita018 "COMPAQ:SDLT320_1" Time: 11.10.2007 19:32:24

/dev/rmt/0mn

Medium header verification completed, 0 errors found

[Normal]

From: BMA@ita018 "COMPAQ:SDLT320_1" Time: 11.10.2007 19:32:39

By:

UMA@ita018@/dev/rac/c20t0d0

Unloading medium to slot 24 from device /dev/rmt/0mn

[Normal]

From: BMA@ita018 "COMPAQ:SDLT320_1" Time: 11.10.2007 19:32:53

COMPLETED Media Agent "COMPAQ:SDLT320_1"

[Normal]

From: BSM@ita017 "RAC_POOL_RAC1..4" Time: 11.10.2007 19:32:49

Backup

Statistics:

Session Queuing Time (hours) 0,00

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

Completed Disk Agents ........ 3

Failed Disk Agents ........... 0

Aborted Disk Agents .......... 0

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

Summary of Contents for Data Protector

Page 1: ...ackup 12 Use a VIP and a service name to configure the backup 12 Use a VIP and allocate the channels to the instances manually 13 Storing the connection string in the Recovery Catalog 14 Backup Configuration Recommendations 16 SAN Backup versus LAN Backup 18 Disk Agent and Media Agent are NOT allocated on the same host 18 Disk Agent and Media Agent are allocated on the same host 18 File System Bac...

Page 2: ...tor RMAN channels current speed 30 Appendix C Session Reports 31 Session 1 Backup using ita018 and RAC1 31 Session 2 Backup using ita018 vip and RAC1 RAC2 RAC3 RAC4 35 Session 3 Backup using ita018 vip and service BACKUP 40 Session 4 Backup using ita018 vip and service MSL5000 45 Session 5 Backup allocating channels manually on RAC1 and RAC2 49 Session 6 Restore allocating channels manually on RAC...

Page 3: ...oviding optimal performance With Oracle 10g the concept of Services was introduced It enables to group database workloads and distribute them over specific instances Integrating HP Software Data Protector with Oracle 10g Real Application Clusters helps you benefit from using the workload management functionality by distributing the backup and restore load over more than one instance in the cluster...

Page 4: ...datafiles Note that they are all of equal size FILE_NAME MB DG_DB rac datafile tbs_pool_001 dbf 4095 DG_DB rac datafile tbs_pool_002 dbf 4095 DG_DB rac datafile tbs_pool_003 dbf 4095 DG_DB rac datafile tbs_pool_004 dbf 4095 DG_DB rac datafile tbs_pool_005 dbf 4095 DG_DB rac datafile tbs_pool_006 dbf 4095 DG_DB rac datafile tbs_pool_007 dbf 4095 DG_DB rac datafile tbs_pool_008 dbf 4095 DG_DB rac da...

Page 5: ...on ita018 ora RAC RAC2 inst ONLINE ONLINE on ita021 ora RAC RAC3 inst ONLINE ONLINE on ita022 ora RAC RAC4 inst ONLINE ONLINE on ita023 ora RAC db ONLINE ONLINE on ita021 ora ita018 ASM1 asm ONLINE ONLINE on ita018 ora ita018 LISTENER_ITA018 lsnr ONLINE ONLINE on ita018 ora ita018 gsd ONLINE ONLINE on ita018 ora ita018 ons ONLINE ONLINE on ita018 ora ita018 vip ONLINE ONLINE on ita018 ora ita021 A...

Page 6: ... an extra approach has to be addressed to have all archived logs accessible by all RAC instances This is needed for backup and recovery purposes Two possible approaches are to Define an archivelog destination local on each node i e arch1 on RAC1 arch2 on RAC2 and export it and cross mount it on every system In case one of the nodes is down the archivelog directory is also not available Define a sh...

Page 7: ...nageable way based on Service Level Agreements High Availability needs or business needs and route them to the optimal instances assigned It is recommended to group load with the same service level Load balancing among the available instances is provided by Oracle Net Services When defining a new service we can specify on which RAC instances the service should run on Preferred service should run o...

Page 8: ...g figure is a graphical representation of the BACKUP service which expands over all available instances Figure 5 Oracle Service BACKUP We define also a service called MSL5000 allowed to run on two of the four instances we set two instances to Preferred and two instances to Not Used ...

Page 9: ...ure 6 Database Configuration Assistant Database Service MSL5000 For the Oracle Service MSL5000 we can see below how only instances RAC1 and RAC2 are available for this service Figure 7 Oracle Service MSL5000 ...

Page 10: ...es not replace the Data Protector Oracle online integration manual 1 Install the Data Protector Oracle agent on each and every RAC Node 2 Add a root account has to the Data Protector Admin User group in the Users configuration menu for every RAC Node and every virtual hostname 1 1 3 Add the oracle account to the Data Protector Admin User group in the Users configuration menu for every RAC Node and...

Page 11: ...P Configure the backup using a VIP and allocate the channels manually We perform an Online Backup of the tablespace POOL for all following backups As it has a large number of datafiles we can observe how the distribution of datafiles over channels is achieved The session report for each of these sessions can be found in the Appendix C Use the hostname and the Instance name to configure the backup ...

Page 12: ...e instance of the list running First of all Data Protector verifies the connection to all specified instances and performs the Backup on just one of them in our case all channels are allocated on the instance which is local to the VIP configured in our case RAC1 running on ita018 Refer the Backup Session 2 Appendix C for more details As shown in the following output node ita018 is currently listen...

Page 13: ...ld happen that channel distribution is not optimal for the backup that is only two of the four instances have channels or one instance gets three out of four channels To overcome this situation channels can also be allocated to specific instances manually In this case it is recommended that one channel is allocated per drive device The optimal situation is to have the same number of drives as inst...

Page 14: ...RAC1 and one on instance RAC2 For each of these channels we have to specify the connection string using the instance name not a service In this scenario if one of the instances is not available the channel allocation fails and the session will abort The backup session report is in the Appendix C under Session 5 Storing the connection string in the Recovery Catalog Security concerns may arise when ...

Page 15: ...e of the backup specification defined in the first step RAC_POOL_sbt_rcvcat CONNECT connection information for the instance RMAN CONFIGURE CHANNEL 1 DEVICE TYPE SBT_TAPE PARMS ENV OB2BARTYPE Oracle8 OB2APPNAME RAC OB2BARLIST RAC_POOL_sbt_rcvcat CONNECT sys xxx RAC1 RMAN CONFIGURE CHANNEL 2 DEVICE TYPE SBT_TAPE PARMS ENV OB2BARTYPE Oracle8 OB2APPNAME RAC OB2BARLIST RAC_POOL _sbt_rcvcat CONNECT sys ...

Page 16: ...is paper this is a list of recommendations and best practices to follow when configuring Data Protector with Oracle 10g RAC Service versus channel allocated manually The following table summarizes all four alternatives discussed previously Configuration Failover Load Balancing Performance Hostname Instance NO NO One Instance is used for the backup VIP all instances YES NO Any available instance is...

Page 17: ...writing to the SBT device TAPE Oracle allocates also 4 output buffers per channel each buffer 256Kb 1MB in total The size of the write buffers can be adjusted with the BLKSIZE channel parameter While the default output buffer size of 256K may be adequate for most environments it may be worth increasing the RMAN output buffer size and Tape block size to 1MB An example of an RMAN script with output ...

Page 18: ... Agent are NOT allocated on the same host 1 A Disk Agent DA is started on host ita018 which reads data from the shared storage disks 2 Once the data is on the host it is sent to host ita023 via LAN 3 Ita023 starts a Media Agent MA to write the data to the SAN tape This is obviously extremely inefficient as host ita018 should write directly to the SAN device Figure 14 Backup data flow DA sends data...

Page 19: ... configuration of the RAC database we need to focus on the backup of the Oracle software directories and the cluster configuration files As these components are not addressed in the Online backup we need to define an additional File System backup specification Important Note These files need to be backed up on a regular basis or when there are configuration changes ...

Page 20: ...ackups which are kept oracle ita018 RAC1 opt oracle product CRS cdata crs date Mon Sep 10 14 14 12 METDST 2007 oracle ita018 RAC1 opt oracle product CRS cdata crs ll rta total 109026 drwxrwxr x 4 oracle oinstall 96 Jul 20 17 02 rw r r 1 root root 8654848 Sep 4 14 43 week ocr rw r r 1 root root 9433088 Sep 9 02 43 day ocr rw r r 1 root root 9433088 Sep 10 02 43 day_ ocr rw r r 1 root root 9433088 S...

Page 21: ...QL create pfile ORACLE_HOME dbs init ORACLE_SID ora back from spfile DG_DB rac spfileRAC ora SQL HOST mv ORACLE_HOME dbs init ORACLE_SID ora bak ORACLE_HOME dbs init ORACLE_SID ora date Y m d_ H M S SQL HOST ls lrt ORACLE_HOME dbs init ORACLE_SID ora rw r r 1 oracle oinstall 2016 Sep 10 13 07 initRAC1 ora 20070910_13 07 32 The second command will add the date and time when the PFILE copy was gener...

Page 22: ...dbf 13 0 Incr 32918890 2007 10 05 DG_DB rac datafile tbs_pool_002 dbf 15 0 Incr 32918890 2007 10 05 DG_DB rac datafile tbs_pool_003 dbf 17 0 Incr 32918890 2007 10 05 DG_DB rac datafile tbs_pool_004 dbf 19 0 Incr 32918890 2007 10 05 DG_DB rac datafile tbs_pool_006 dbf 21 0 Incr 32918890 2007 10 05 DG_DB rac datafile tbs_pool_008 dbf 23 0 Incr 32918890 2007 10 05 DG_DB rac datafile tbs_pool_005 dbf ...

Page 23: ...rac datafile tbs_pool_019 dbf The Media ID matches the Medium ID used by Data Protector on every Tape Figure 18 Media Information If we query the rc_backup_piece view on the recovery catalog ita017 we obtain the same information SQL select BS_KEY DEVICE_TYPE HANDLE MEDIA from rc_backup_piece where BS_KEY 9266 BS_KEY DEVICE_TYPE HANDLE MEDIA 9266 SBT_TAPE RAC_POOL_man_ch_1_2 RAC_460 635189150 1 dbf...

Page 24: ...owing situation the backup session we want to restore was performed using the Oracle service MSL5000 Backup session 4 During the backup two RMAN channels were allocated on RAC2 ita021 For the restore however instead of connecting through a service we would like to have instances RAC1 and RAC2 running the restore with one channel each As described in the above section we can have Data Protector wri...

Page 25: ...recommendations apply In our environment the highest recovery performance improvement was achieved by increasing the Oracle parameter PARALLEL_EXECUTION_MESSAGE_SIZE For more information review the Media recovery best practices for 10g in the Appendix A Although media recovery is done in parallel it is important to note that media recovery just takes place on ONE RAC instance As in a backup scenar...

Page 26: ...an incremental backup instead of using archived logs recovery The total backup size is 16GB Although is an incremental backup oracle has to read every single block belonging to the POOL datafiles in memory to determine if the block has been modified since last backup For this reason it can happen that the tape devices are not streaming This may cause the incremental backup to take longer than the ...

Page 27: ...determines the buffer size for the message exchanged among parallel processes Use the dynamic view V RECOVERY_PROGRESS to monitor the recovery progress Summary As it has been shown throughout this paper Data Protector offers several possibilities to perform the configuration in an Oracle10g RAC environment It is not necessarily a complex task but limitations and implications need to be understood ...

Page 28: ...g Backup and Recovery Advanced User s Guide Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide Tuning Oracle Recovery Manager Data Guard Redo Apply and Media Recovery Best Practices Oracle Backup and Recovery Papers at OTN Metalink Note 237083 1 Using V BACKUP_ASYNC_IO to monitor RMAN Tools AxWork benchmark Suite ...

Page 29: ...8576 16 4293918720 7900 4293918720 54353402 4096 0 572 INPUT FINISHED DG_DB rac datafile tbs_pool_003 dbf 1048576 16 4293918720 8000 4293918720 53673984 4096 0 537 INPUT FINISHED DG_DB rac datafile tbs_pool_004 dbf 1048576 16 4293918720 8100 4293918720 53011342 4096 0 603 INPUT FINISHED DG_DB rac datafile tbs_pool_006 dbf 1048576 16 4293918720 8200 4293918720 52364862 4096 0 586 INPUT FINISHED DG_...

Page 30: ...man channel dev_1 4793 Backup sbtwrite2 3 WAITING rman channel dev_0 B 4 How to monitor RMAN channels current speed In the output below we can see two RMAN channels running on one instance each over 70MB s In this view it can also be verified which the current MAXOPENFILES setting is the value maxopenfiles is only present when type is AGGREGATE col type format a10 select TYPE maxopenfiles ELAPSED_...

Page 31: ...RHOSTNAME ita018 maxopenfiles 1 6 allocate channel dev_1 type sbt_tape 7 parms ENV OB2BARTYPE Oracle8 OB2APPNAME RAC OB2BARLIST RAC_POOL_RAC1 OB2BARHOSTNAME ita018 maxopenfiles 1 8 backup incremental level 0 9 format RAC_POOL_RAC1 RAC_ s t p dbf 10 tablespace POOL 11 12 EXIT connected to target database RAC DBID 2216826430 connected to recovery catalog database allocated channel dev_0 channel dev_...

Page 32: ...channel dev_1 specifying datafile s in backupset input datafile fno 00010 name DG_DB rac datafile tbs_pool_064 dbf input datafile fno 00012 name DG_DB rac datafile tbs_pool_066 dbf input datafile fno 00014 name DG_DB rac datafile tbs_pool_063 dbf input datafile fno 00016 name DG_DB rac datafile tbs_pool_062 dbf input datafile fno 00018 name DG_DB rac datafile tbs_pool_061 dbf input datafile fno 00...

Page 33: ...shed piece 1 at 11 OCT 07 piece handle RAC_POOL_RAC1 RAC_544 635708461 1 dbf tag TAG20071011T174100 comment API Version 2 0 MMS Version 65 6 0 0 channel dev_0 backup set complete elapsed time 00 48 09 Normal From OB2BAR_Oracle8 ita018 RAC Time 11 10 2007 18 29 18 Backup Profile Run Time 0 47 25 Backup Speed 42059 50 KB s Normal From OB2BAR_Oracle8 ita018 RAC Time 11 10 2007 18 29 18 Completed OB2B...

Page 34: ...10 2007 18 31 46 By UMA ita018 dev rac c20t0d0 Unloading medium to slot 16 from device dev rmt 1mn Normal From BMA ita018 COMPAQ SDLT320_1 Time 11 10 2007 18 31 49 By UMA ita018 dev rac c20t0d0 Unloading medium to slot 15 from device dev rmt 0mn Normal From BMA ita018 COMPAQ SDLT320_2 Time 11 10 2007 18 31 59 COMPLETED Media Agent COMPAQ SDLT320_2 Normal From BMA ita018 COMPAQ SDLT320_1 Time 11 10...

Page 35: ...N Instance name RAC2 Database DBID 2216826430 Database control file type CURRENT Database log mode ARCHIVELOG Net service name RAC3 Instance status OPEN Instance name RAC3 Database DBID 2216826430 Database control file type CURRENT Database log mode ARCHIVELOG Normal From ob2rman ita018 RAC Time 10 11 07 18 42 20 Starting Oracle Recovery Manager Recovery Manager Release 10 2 0 3 0 Production on Th...

Page 36: ...dbf input datafile fno 00045 name DG_DB rac datafile tbs_pool_020 dbf input datafile fno 00047 name DG_DB rac datafile tbs_pool_018 dbf input datafile fno 00049 name DG_DB rac datafile tbs_pool_023 dbf input datafile fno 00051 name DG_DB rac datafile tbs_pool_024 dbf input datafile fno 00053 name DG_DB rac datafile tbs_pool_030 dbf input datafile fno 00055 name DG_DB rac datafile tbs_pool_029 dbf ...

Page 37: ...ng piece 1 at 11 OCT 07 Normal From BMA ita018 COMPAQ SDLT320_1 Time 11 10 2007 18 42 32 STARTING Media Agent COMPAQ SDLT320_1 Normal From BMA ita018 COMPAQ SDLT320_1 Time 11 10 2007 18 42 37 By UMA ita018 dev rac c20t0d0 Loading medium from slot 24 to device dev rmt 0mn Normal From BMA ita018 COMPAQ SDLT320_2 Time 11 10 2007 18 42 37 STARTING Media Agent COMPAQ SDLT320_2 Normal From BMA ita018 CO...

Page 38: ...eted Normal From ob2rman ita018 RAC Time 10 11 07 19 31 15 Backup of target database completed Normal From BSM ita017 RAC_POOL_RAC1 4 Time 11 10 2007 19 31 11 OB2BAR application on ita018 vip disconnected Normal From BMA ita018 COMPAQ SDLT320_2 Time 11 10 2007 19 31 49 dev rmt 1mn Medium header verification completed 0 errors found Normal From BMA ita018 COMPAQ SDLT320_2 Time 11 10 2007 19 32 05 B...

Page 39: ...sk Agents Total 3 Completed Media Agents 2 Failed Media Agents 0 Aborted Media Agents 0 Media Agents Total 2 Mbytes Total 233898 MB Used Media Total 2 Disk Agent Errors Total 0 Session completed successfully ...

Page 40: ...PE Oracle8 OB2APPNAME RAC OB2BARLIST RAC_POOL_BACKUP OB2BARHOSTNAME ita018 vip maxopenfiles 1 8 allocate channel dev_2 type sbt_tape 9 parms ENV OB2BARTYPE Oracle8 OB2APPNAME RAC OB2BARLIST RAC_POOL_BACKUP OB2BARHOSTNAME ita018 vip maxopenfiles 1 10 allocate channel dev_3 type sbt_tape 11 parms ENV OB2BARTYPE Oracle8 OB2APPNAME RAC OB2BARLIST RAC_POOL_BACKUP OB2BARHOSTNAME ita018 vip maxopenfiles ...

Page 41: ...rac datafile tbs_pool_057 dbf input datafile fno 00026 name DG_DB rac datafile tbs_pool_058 dbf input datafile fno 00030 name DG_DB rac datafile tbs_pool_054 dbf input datafile fno 00034 name DG_DB rac datafile tbs_pool_053 dbf input datafile fno 00038 name DG_DB rac datafile tbs_pool_056 dbf input datafile fno 00042 name DG_DB rac datafile tbs_pool_055 dbf input datafile fno 00046 name DG_DB rac ...

Page 42: ...t datafile fno 00056 name DG_DB rac datafile tbs_pool_036 dbf input datafile fno 00060 name DG_DB rac datafile tbs_pool_043 dbf input datafile fno 00064 name DG_DB rac datafile tbs_pool_038 dbf input datafile fno 00068 name DG_DB rac datafile tbs_pool_039 dbf input datafile fno 00072 name DG_DB rac datafile tbs_pool_037 dbf channel dev_3 starting piece 1 at 11 OCT 07 Normal From OB2BAR_Oracle8 ita...

Page 43: ...MS Version 65 6 0 0 channel dev_3 backup set complete elapsed time 01 33 48 Finished backup at 11 OCT 07 Starting Control File and SPFILE Autobackup at 11 OCT 07 Normal From OB2BAR_Oracle8 ita021 RAC Time 11 10 2007 21 50 51 Starting OB2BAR Backup ita018 vip c 2216826430 20071011 04 Oracle8 Normal From OB2BAR_Oracle8 ita021 RAC Time 11 10 2007 21 50 54 Backup Profile Run Time 0 00 04 Backup Speed ...

Page 44: ...11 10 2007 21 53 01 By UMA ita018 dev rac c20t0d0 Unloading medium to slot 23 from device dev rmt 1mn Normal From BMA ita021 COMPAQ SDLT320_2 Time 11 10 2007 21 53 13 COMPLETED Media Agent COMPAQ SDLT320_2 Normal From BSM ita017 RAC_POOL_BACKUP Time 11 10 2007 21 53 14 Backup Statistics Session Queuing Time hours 0 00 Completed Disk Agents 5 Failed Disk Agents 0 Aborted Disk Agents 0 Disk Agents T...

Page 45: ...cremental level 0 9 format RAC_POOL_MSL5000 RAC_ s t p dbf 10 tablespace POOL 11 12 EXIT connected to target database RAC DBID 2216826430 connected to recovery catalog database allocated channel dev_0 channel dev_0 sid 2203 instance RAC2 devtype SBT_TAPE channel dev_0 Data Protector A 06 00 PHSS_35908 PHSS_35909 DPSOL_00261 DPLNX_ allocated channel dev_1 channel dev_1 sid 2212 instance RAC2 devtyp...

Page 46: ...name DG_DB rac datafile tbs_pool_062 dbf input datafile fno 00018 name DG_DB rac datafile tbs_pool_061 dbf input datafile fno 00020 name DG_DB rac datafile tbs_pool_059 dbf input datafile fno 00022 name DG_DB rac datafile tbs_pool_057 dbf input datafile fno 00024 name DG_DB rac datafile tbs_pool_060 dbf input datafile fno 00026 name DG_DB rac datafile tbs_pool_058 dbf input datafile fno 00028 name...

Page 47: ...mplete elapsed time 00 46 29 Normal From OB2BAR_Oracle8 ita021 RAC Time 19 10 2007 10 09 24 Backup Profile Run Time 0 46 58 Backup Speed 42422 96 KB s Normal From OB2BAR_Oracle8 ita021 RAC Time 19 10 2007 10 09 24 Completed OB2BAR Backup ita018 vip RAC_POOL_MSL5000 RAC_602 636369706 1 dbf Oracle8 channel dev_0 finished piece 1 at 19 OCT 07 piece handle RAC_POOL_MSL5000 RAC_602 636369706 1 dbf tag ...

Page 48: ...T320_2 Normal From BMA ita018 COMPAQ SDLT320_1 Time 19 10 2007 10 12 22 dev rmt 0mn Medium header verification completed 0 errors found Normal From BMA ita018 COMPAQ SDLT320_1 Time 19 10 2007 10 12 38 By UMA ita018 dev rac c20t0d0 Unloading medium to slot 25 from device dev rmt 0mn Normal From BMA ita018 COMPAQ SDLT320_1 Time 19 10 2007 10 12 51 COMPLETED Media Agent COMPAQ SDLT320_1 Normal From B...

Page 49: ...OOL_man_ch_1_2 RAC_ s t p dbf 10 tablespace POOL 11 12 EXIT connected to target database RAC DBID 2216826430 connected to recovery catalog database allocated channel dev_0 channel dev_0 sid 2221 instance RAC1 devtype SBT_TAPE channel dev_0 Data Protector A 06 00 PHSS_35908 PHSS_35909 DPSOL_00261 DPLNX_ allocated channel dev_1 channel dev_1 sid 2209 instance RAC2 devtype SBT_TAPE channel dev_1 Data...

Page 50: ...atafile fno 00018 name DG_DB rac datafile tbs_pool_061 dbf input datafile fno 00020 name DG_DB rac datafile tbs_pool_059 dbf input datafile fno 00022 name DG_DB rac datafile tbs_pool_057 dbf input datafile fno 00024 name DG_DB rac datafile tbs_pool_060 dbf input datafile fno 00026 name DG_DB rac datafile tbs_pool_058 dbf input datafile fno 00028 name DG_DB rac datafile tbs_pool_051 dbf input dataf...

Page 51: ...ita018 vip RAC_POOL_man_ch_1_2 RAC_460 635189150 1 dbf Oracle8 channel dev_0 finished piece 1 at 05 OCT 07 piece handle RAC_POOL_man_ch_1_2 RAC_460 635189150 1 dbf tag TAG20071005T172549 comment API Version 2 0 MMS Version 65 6 0 0 channel dev_0 backup set complete elapsed time 00 45 32 channel dev_1 finished piece 1 at 05 OCT 07 piece handle RAC_POOL_man_ch_1_2 RAC_461 635189146 1 dbf tag TAG2007...

Page 52: ...ading medium to slot 6 from device dev rmt 1mn Normal From BMA ita018 COMPAQ SDLT320_1 Time 05 10 2007 18 13 46 By UMA ita018 dev rac c20t0d0 Unloading medium to slot 22 from device dev rmt 0mn Normal From BMA ita021 COMPAQ SDLT320_2 Time 05 10 2007 18 13 52 COMPLETED Media Agent COMPAQ SDLT320_2 Normal From BMA ita018 COMPAQ SDLT320_1 Time 05 10 2007 18 14 09 COMPLETED Media Agent COMPAQ SDLT320_...

Page 53: ...annel dev_1 channel dev_1 sid 2222 instance RAC2 devtype SBT_TAPE channel dev_1 Data Protector A 06 00 PHSS_35908 PHSS_35909 DPSOL_00261 DPLNX_ sql statement alter tablespace POOL offline immediate Starting restore at 2007 10 09 channel dev_0 starting datafile backupset restore channel dev_0 specifying datafile s to restore from backup set restoring datafile 00010 to DG_DB rac datafile tbs_pool_06...

Page 54: ..._007 dbf restoring datafile 00027 to DG_DB rac datafile tbs_pool_014 dbf restoring datafile 00029 to DG_DB rac datafile tbs_pool_011 dbf restoring datafile 00031 to DG_DB rac datafile tbs_pool_013 dbf restoring datafile 00033 to DG_DB rac datafile tbs_pool_012 dbf restoring datafile 00035 to DG_DB rac datafile tbs_pool_015 dbf restoring datafile 00037 to DG_DB rac datafile tbs_pool_009 dbf restori...

Page 55: ...0 dbf archive log thread 4 sequence 436 is already on disk as file DG_FRA rac 4_436_628844420 dbf archive log thread 4 sequence 437 is already on disk as file DG_FRA rac 4_437_628844420 dbf archive log thread 4 sequence 438 is already on disk as file DG_FRA rac 4_438_628844420 dbf archive log filename DG_FRA rac 1_1091_628844420 dbf thread 1 sequence 1091 archive log filename DG_FRA rac 2_442_6288...

Page 56: ...dbf restoring datafile 00022 to DG_DB rac datafile tbs_pool_060 dbf restoring datafile 00024 to DG_DB rac datafile tbs_pool_057 dbf restoring datafile 00026 to DG_DB rac datafile tbs_pool_058 dbf restoring datafile 00028 to DG_DB rac datafile tbs_pool_056 dbf restoring datafile 00030 to DG_DB rac datafile tbs_pool_054 dbf restoring datafile 00032 to DG_DB rac datafile tbs_pool_051 dbf restoring da...

Page 57: ... 00061 to DG_DB rac datafile tbs_pool_029 dbf restoring datafile 00063 to DG_DB rac datafile tbs_pool_021 dbf restoring datafile 00065 to DG_DB rac datafile tbs_pool_018 dbf restoring datafile 00067 to DG_DB rac datafile tbs_pool_019 dbf restoring datafile 00069 to DG_DB rac datafile tbs_pool_026 dbf restoring datafile 00071 to DG_DB rac datafile tbs_pool_024 dbf restoring datafile 00073 to DG_DB ...

Page 58: ...stination for restore of datafile 00026 DG_DB rac datafile tbs_pool_058 dbf destination for restore of datafile 00028 DG_DB rac datafile tbs_pool_056 dbf destination for restore of datafile 00030 DG_DB rac datafile tbs_pool_054 dbf destination for restore of datafile 00032 DG_DB rac datafile tbs_pool_051 dbf destination for restore of datafile 00034 DG_DB rac datafile tbs_pool_050 dbf destination ...

Page 59: ...59 Finished recover at 2007 11 07 sql statement alter tablespace POOL online released channel dev_0 released channel dev_1 Recovery Manager complete oracle ita018 RAC1 opt oracle ...

Page 60: ...is subject to change without notice The only warranties for HP products and services are set forth in the express warranty statements accompanying such products and services Nothing herein should be construed as constituting an additional warranty HP shall not be liable for technical or editorial errors or omissions contained herein 4AA1 7160ENW December 2007 ...

Search results

Summary of Contents for Data Protector

Reviews:

Related manuals for Data Protector

Brands by name

Popular brands

HP Data Protector, Manual

Search results

Summary of Contents for Data Protector

Reviews:

Related manuals for Data Protector

Brands by name

Popular brands