TDP Oracle on Virtual Machine.

Status
Not open for further replies.
C

chris_magic

ADSM.ORG Member
Joined
May 17, 2007
Messages
178
Reaction score
0
Points
0
Location
Quebec, Qc, Canada
Hi Guys,

I have a problem with the use of a TPDO on a virtual machine.
The virtual machine where I installed the TDP is a Windows 2003 server.
The oracle version is 10g.

Log Backup

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of delete command on channel1 channel at 02/11/2010 15:32:58
ORA-27191: sbtinfo2 returned error

Script RMAN

run
{
allocate channel channel1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=C:\Program Files\Tivoli\TSM\AgentOBA64\tdpo_iundbsqim.opt)';
delete noprompt obsolete;
backup as compressed backupset incremental level 0 format 'DBFULL_%d_%u_%p_%c' database include current controlfile plus archivelog;
delete noprompt archivelog until time 'sysdate -1';
}

Thanks in advance for your help.
 
So, you are trying to use a tape resource? I do not believe you can assign specific hardware entities, such as a SAN channel, to individual virtual machines, and so RMAN wouldn't be able to open it. You also need a storage agent, and last I checked, they are not supported on individual guest machines. You need to go through the LAN.
 
VMWare Consolidated Backup. A little bit involved and you'll need to read up on that. That would be a separate physical server with Storage agent running and attached to tape drives, utilizing the VM technology to move the data to the VCB server for backup...

...or, if you don't want to use VCB, you can install Storage Agent on ServerB, a physical machine and simply direct your BA client on your Oracle machine ServerB's storage agent to backup your database.

Change your LANFreeTCPAddress to point to ServerB instead of point to itself.
 
In summary, we can't use the TDP for Oracle to backup an Oracle DB who is on a virtual server, isn't it?[FONT="Georgia"
 
chris_magic said:
In summary, we can't use the TDP for Oracle to backup an Oracle DB who is on a virtual server, isn't it?[FONT="Georgia"
Click to expand...

Nope - you can.

I have a Linux guest on VM Ware and it backs up well to TSM using TDP for Oracle. This should be no different than using Windows as OS instead of Linux.
 
Ed,

Okay, but have you made a particular configuration of TDP?

I've made a standard configuration and it does not work ... Can you help me?
 
chris_magic said:
Ed,

Okay, but have you made a particular configuration of TDP?

I've made a standard configuration and it does not work ... Can you help me?
Click to expand...

First of all, I would like to understand how are you connecting the Virtual partition to the LAN. Are you using the same network as the host is connected to - bridged mode?

No LAN-Free backup can be setup if the guest DOES NOT have direct access to the SAN which is not possible with VM Ware.

I use the LAN to backup Oracle using TDP which is a plain vanilla setup.
 
Ed,

Yes, this is the same network.

The Oracle server is hosted on an ESX server.
The partition where the Oracle DB is on a SAN.
 
chris_magic said:
Ed,

Yes, this is the same network.

The Oracle server is hosted on an ESX server.
The partition where the Oracle DB is on a SAN.
Click to expand...

Same setup as I have.

So the disk allocated to the Guest system is being managed by the ESX (Version 4?) server, right?

Therefor, you should not have an issue.
 
chris_magic said:
Ed,

Okay, but have you made a particular configuration of TDP?

I've made a standard configuration and it does not work ... Can you help me?
Click to expand...

Again, plain vanilla configuration. Here is what dsmc returns when I query for the schedule:

Node Name: TESTLNXORA01_ORA
Session established with server TSMSERV: AIX-RS/6000
Server Version 5, Release 4, Level 3.2
Server date/time: 02/12/2010 17:55:10 Last access: 02/12/2010 10:02:03

tsm> q sched
Schedule Name: TEST105LNXORA01_ORA_LOGARC
Description: LOG backup for TEST105LNXORA01
Schedule Style: Classic
Action: Command
Options:
Objects: /opt/tivoli/tsm/client/oracle/bin64/ora_logarc
Priority: 5
Next Execution: 4 Hours and 5 Minutes
Duration: 1 Hour
Period: 12 Hours
Day of Week: Any
Month:
Day of Month:
Week of Month:
Expire: Never

Schedule Name: TEST105LNXORA01_ORA_DBBKP
Description: Daily database backup for TEST105LNXORA01
Schedule Style: Enhanced
Action: Command
Options:
Objects: /opt/tivoli/tsm/client/oracle/bin64/ora_bkup
Priority: 5
Next Execution: 11 Hours and 50 Minutes
Duration: 1 Hour
Period:
Day of Week: Any
Month: Any
Day of Month: Any
Week of Month: Any
Expire: Never
 
Christophe,

By the way, what does dsmc -optfile=/what/ever/path/to/tdp.opt return? Can TDP for Oracle see the TSM server? Have you defined the TDP node to allow backup delete?
 
On you're original post, I picked up on your RMAN script entry "allocate channel channel1 type 'sbt_tape' parms ..." and assumed you were trying LAN-free. At this point, you are probably quite confudled! So, let's review:

Yes, you CAN use TDP on a virtual guest machine.
You can NOT use LAN-free.

If you have no long-term retention requirements and just need physical (hot) backups, you can use VCB instead. (You'll need to use the pre-freeze/post-thaw guest scripts to quiesce the database.) You can use LAN-free on the VCB machine, as GregE points out.

So, let's revisit your error. You are not getting any kind of channel allocation error, but "failure of delete command ". I think I've made everyone chase the wrong squirrel up the wrong tree!

What it looks like to me is that RMAN thinks it has an obsolete file it wants to get rid of, but TSM doesn't have said file. The management class you use for TDPO should NOT have a version or time limit, or else you'll get this problem. Everything should be set to NOLIMIT and let RMAN clean things out.
 
I agree with moon-buddy, you have to configure node on TSM server to allow your node to delete its own backups
as far as I Know, "sbt_tape" is correct statement in RMAN script when you backup to TSM, no matter if backup goes to tape or disk, lan based or lan-free.
 
@ Moon-Buddy:

C:\Program Files\Tivoli\TSM\baclient>dsmc -optfile="C:\Program Files\Tivoli\TSM\ AgentOBA64\dsm_iundbsqim.opt"
ANS0106E Message index not found for message 1691.
IBM Tivoli Storage Manager
Command Line Backup/Archive Client Interface
Client Version 5, Release 5, Level 2.1
Client date/time: 02/15/2010 08:36:25
(c) Copyright by IBM Corporation and other(s) 1990, 2009. All Rights Reserved.

Node Name: IUNITORAD0101_IUNDBSQIM_DB
Session established with server PPRODTSMG0001_SERVER1: Windows
Server Version 5, Release 5, Level 4.1
Server date/time: 02/15/2010 08:36:26 Last access: 02/12/2010 11:39:36
tsm>

tsm> q se
TSM Server Connection Information

Server Name.............: PPRODTSMG0001_SERVER1
Server Type.............: Windows
Archive Retain Protect..: "No"
Server Version..........: Ver. 5, Rel. 5, Lev. 4.1
Last Access Date........: 02/12/2010 11:39:36
Delete Backup Files.....: "Yes"
Delete Archive Files....: "Yes"

Node Name...............: IUNITORAD0101_IUNDBSQIM_DB
User Name...............:

Yes, the node has the right to delete data.

tsm: PPRODTSMG0001_SERVER1>q node IUNITORAD0101_IUNDBSQIM_DB f=d
Node Name: IUNITORAD0101_IUNDBSQIM_DB
Platform: WinNT
Client OS Level: 5.02
Client Version: Version 5, release 5, level 2.1
Policy Domain Name: ENVIRONNEMENT_INTRODUCTION_DB
Last Access Date/Time: 02/15/2010 08:36:26
Days Since Last Access: <1
Password Set Date/Time: 02/11/2010 14:53:19
Days Since Password Set: 4
Invalid Sign-on Count: 0
Locked?: No
Contact:
Compression: Client
Archive Delete Allowed?: Yes
Backup Delete Allowed?: Yes
Registration Date/Time: 02/11/2010 10:38:14
Registering Administrator: ADMIN
Last Communication Method Used:
Bytes Received Last Session: 0
Bytes Sent Last Session: 0
Duration of Last Session: 0.00
Pct. Idle Wait Last Session: 0.00
more... (<ENTER> to continue, 'C' to cancel)
Pct. Comm. Wait Last Session: 0.00
Pct. Media Wait Last Session: 0.00
Optionset:
URL:
Node Type: Client
Password Expiration Period:
Keep Mount Point?: No
Maximum Mount Points Allowed: 2
Auto Filespace Rename : No
Validate Protocol: No
TCP/IP Name: IUNITORAD0101
TCP/IP Address: 172.21.32.21
Globally Unique ID: bc.d3.69.21.0a.08.11.dc.a0.95.47.0e.5a.58.b9.be
Transaction Group Max: 0
Data Write Path: ANY
Data Read Path: ANY
Session Initiation: ClientOrServer
High-level Address:
Low-level Address:
Collocation Group Name:
Proxynode Target:
Proxynode Agent:
Node Groups:

@DanGiles:

DOMAIN_NAME: ENVIRONNEMENT_INTRODUCTION_DB
SET_NAME: ACTIVE
CLASS_NAME: STANDARD
DEFAULTMC: Yes
VEREXISTS: 2
VERDELETED: 1
RETEXTRA: 30
RETONLY: 60
DESTINATION: POOL_LTO_INTRODB
 
Additional Information:

IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 5, Release 5, Level 1.0
(C) Copyright IBM Corporation 1997, 2008. All rights reserved.


Catalog 1 User Name: rman_user

Catalog 1 Password: XXXXXXX

Catalog 1 Connect String: iundbsqim


From Date (01/01/1990):

To Date (02/15/2010):


SQL*Plus: Release 10.2.0.4.0 - Production on Mon Feb 15 10:24:08 2010

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64
bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Gathering Catalog information...Please wait

ANS1088E (RC124) File space '*' does not exist
 
Perhaps I was not clear enough ... I wish to make my backup of DB Oracle directly on tape using the TDP Oracle via the LAN.

The problem could be come from the Oracle side.

In the log I found the oracle following error message:

RMAN-06207: WARNING: 3518 objects could not be deleted for DISK channel(s) due
RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status
RMAN-06210: List of Mismatched objects
RMAN-06211: ==========================
RMAN-06212: Object Type Filename/Handle
RMAN-06213: --------------- ---------------------------------------------------

We performed a crosscheck and delete expired.
 
@ Mita201

I made updates to the management class but I still have the same problem.

TDPOSYNC:

SQL*Plus: Release 10.2.0.4.0 - Production on Mon Feb 15 15:12:35 2010

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64
bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Gathering Catalog information...Please wait

ANS1088E (RC124) File space '*' does not exist

LOG script RMAN:

backup piece handle=D:\IUNDBSQIM\DBFULL_IUNDBSQI_N7JT88RH_1_1 recid=3711 stamp=668214129
deleted backup piece
backup piece handle=D:\IUNDBSQIM\C-2828326295-20081015-00 recid=3713 stamp=668214137
deleted backup piece
backup piece handle=D:\IUNDBSQIM\DBFULL_IUNDBSQI_NDJTAT75_1_1 recid=3717 stamp=668300517
deleted backup piece
backup piece handle=D:\IUNDBSQIM\C-2828326295-20081016-00 recid=3719 stamp=668300526
Deleted 121 objects

released channel: channel1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of delete command on channel1 channel at 02/15/2010 14:37:34
ORA-19509: failed to delete sequential file, handle="c-2828326295-20070809-05", parms=""
ORA-27027: sbtremove2 returned error
ORA-19511: Error received from media manager layer, error text:
ANS1088E (RC124) File space '*' does not exist

Recovery Manager complete.
========================================== Fin iundbsqim 2010-02-15 - 14:37:35,21 ===========================================
 
Status
Not open for further replies.

Data Privacy Impact Assessment

Compliance Assurance in Every Byte: Discover the Impact of Our DPIA Services.

Sponsor ADSM.ORG

If you are reading this, so are your potential customer. Advertise at ADSM.ORG right now.

Navigation Menu

Forums
   IBM TSM
   EMC Backup and Recovery
   Symantec NetBackup  
   SAN  
   NAS
   Platforms / OS
Mailing List Archives
   ADSM-L
User Groups

NordVPN 3 Months FREE

Help Support ADSM.ORG and Get NordVPN with 64% Off and 3 Months FREE.

NordVPN with 64% off + 3 months FREE

Forum statistics

Threads
31,979
Messages
135,463
Members
21,953
Latest member
jrogers
Back
Top