Originally posted by: sajid1

Hi,

How could i restore the backup from tape?
For yoyr information below command is not working

tar xvf /dev/rmt/0

Originally posted by: tony.evans

Restoring from backup usually involves using the opposite command to the one you used to take the backup.

Assuming the contents of the tape are a straight tar, you might try,

tar -xvf /dev/rmt0

(This also assumes your tape drive is rmt0).

Originally posted by: sajid1

Hi,

Many Thanks Tony for replying.

Provided command not worked,error occured as below
$ tar -xvf /dev/rmt0
tar: /dev/rmt0: The device is not ready for operation.
For your information find below command What i use to take backup of database direct on tape.Might be it is helpful to give me the solution.

run
{
sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';

allocate channel t1 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';

Regards

Originally posted by: SystemAdmin

;-) sorry, cant help it: thats great comedy

Originally posted by: sajid1

how could you correlate it that it is great comedy

Originally posted by: tony.evans

Looks like you back up using TSM, maybe you should restore using TSM?

Why do you think you're backing up to local tape drives?

Also, that doesn't look like full script fragment to me. Maybe you need to understand how you backed your data up more clearly before worrying about how to restore it.

Originally posted by: sajid1

Hi,

Actually i have to restore rman backup to another server to make clone because of this i need rman backup which is located on tape.
As per my knowlege i have to install tape sowtware on server where can i get this s/w or how can i install if there is way to restore as per my requirement.

Can you explain me if rman backup is being taken to tape then can i use tar command to restore it?

Thanks

Originally posted by: tony.evans

Ok I think you're missing some significant fundamentals, but this isn't the right place to resolve that. I suggest you investigate in more detail how the existing backup works, how you would restore it if it was to the same server and understand how your data is stored on tape.

Originally posted by: sajid1

Hi,

Thank you Tony for prompt reply,
I know the existing backup how to it works and i know how to restore it on same server but for the another server i do not know.
As far as i know for restoring rman backup i have to install tape s/w on another server and the tape software would most likely be installed in the same directory structure on the auxiliary server as it is on the source machine but i do not know how to check where tape s/w is installed on source server and how to install it on target server?

Regards

Originally posted by: sajid1

Hi,

Any update?

Tivoli is using for backup It is located on /usr/tivoli.

Thanks

Originally posted by: hdkutz

Hello,
maybe reading this
http://www.redbooks.ibm.com/abstracts/SG246249.html?Open
would help?
Cheers,
ku

Originally posted by: dave-e

When you say "Tivoli is using for backup" I assume Tivoli Storage Manager (TSM). So from the command line use dsmc at the tsm> prompt type help, or from cde desktop dsmj.

Originally posted by: sajid1

Hi,

Now I am tsm prompt find below.
Can you guide me what is next steps.

1. dsmc

IBM Tivoli Storage Manager
Command Line Backup/Archive Client Interface
Client Version 5, Release 5, Level 0.0
Client date/time: 05/01/10 16:27:28
(c) Copyright by IBM Corporation and other(s) 1990, 2007. All Rights Reserved.

Node Name: RDW_AIX_D
Session established with server FR-TSMPRD: Windows
Server Version 5, Release 5, Level 0.0
Server date/time: 05/01/10 16:16:33 Last access: 04/29/10 21:02:45

tsm>

Thanks

Originally posted by: hdkutz

Hi,
hm, switching from TDPO to TSM Backup Client?

Which problem are you trying to solve???

Maybe this
adsm-l@vm.marist.edu/msg57150.html">http://www.mail-archive.com/adsm-l@vm.marist.edu/msg57150.html
helps for your TDPO Problems?

What do you want to restore? Oracle via TDPO or Files via TSM Backup Client?

Cheers,
ku

Originally posted by: sajid1

Hi,
switching from TDPO to TSM Backup Client?
--I am doing as per this ticket.I am not awared what way are using?
Which problem are you trying to solve???
--I am not able to restore rman backup which is being taken on daily basis using rman on tape
look at this ticket from begining.

Maybe this
adsm-l@vm.marist.edu/msg57150.html">http://www.mail-archive.com/adsm-l@vm.marist.edu/msg57150.html
helps for your TDPO Problems?
--Issue is almost same but there is no solution.

What do you want to restore? Oracle via TDPO or Files via TSM Backup Client?
---rman backup and from backup to make clone

Thanks,

Originally posted by: hdkutz

Hello,
first read
http://www.redbooks.ibm.com/abstracts/SG246249.html?Open
then act!

What "issue"?
You can't restore, if you did not configure right TDPO!

In the link from mail-archive.com they show
tdpoconf showenv
What does this command show up?
If nothing, once again, you did not configure right TDPO on your System!
So you are not able to restore or clone anything.

Don't expect us to do your work.

Cheers,
ku

Originally posted by: sajid1

Hi,
Thanks for responding.

Find the output as required by you.it is configured i think so.

$tdpoconf showenv
Data Protection for Oracle Information
Version: 5
Release: 4

IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 5, Release 4, Level 1.0
(C) Copyright IBM Corporation 1997, 2007. All rights reserved.
Data Protection for Oracle Information
Version: 5
Release: 4
Level: 1
Sublevel: 0
Platform: 64bit TDP Oracle AIX

Tivoli Storage Manager Server Information
Server Name: SERVER_O
Server Address: 172.25.124.40
Communication Method: TCP/IP

Session Information
Owner Name:
Node Name: RDW_AIX_ORA
DSMI_DIR: /usr/tivoli/tsm/client/api/bin64
DSMI_ORC_CONFIG: /usr/tivoli/tsm/client/oracle/bin64/dsm.opt
TDPO_OPTFILE: /usr/tivoli/tsm/client/oracle/bin64/tdpo.opt
Compression: FALSE
License Information: License file exists and contains valid license data.

ANS1353E (RC53) Session rejected: Unknown or incorrect ID entered
#

Regards,

Originally posted by: dave-e

here is a link to the TSM UNIX and Linux Backup-Archive Clients Installation and User’s Guide - see Chapter 5. Restoring your data

http://publib.boulder.ibm.com/infocenter/tivihelp/v1r1/topic/com.ibm.itsmfdt.doc/ans50000.pdf

Originally posted by: sajid1

Hi,

I peformed as per provided doc but it did not work.Find below for your information.

1. dsmc restore /vol02/test/stewart/ -subdir=yes -replace=all -tapeprompt=no

IBM Tivoli Storage Manager
Command Line Backup/Archive Client Interface
Client Version 5, Release 5, Level 0.0
Client date/time: 05/03/10 17:49:34
(c) Copyright by IBM Corporation and other(s) 1990, 2007. All Rights Reserved.

Node Name: RDW_AIX_D
Session established with server FR-TSMPRD: Windows
Server Version 5, Release 5, Level 0.0
Server date/time: 05/03/10 17:38:37 Last access: 05/03/10 17:38:06

Restore function invoked.

ANS1247I Waiting for files from the server...
< 0 B> -
Restore processing finished.

Thanks,

Originally posted by: tony.evans

"and i know how to restore it on same server"

You restore it on another server in the same way you restore it on the original server.

1. install the right code (database, tsm client, tdp code, etc.)
2. restore the data

Originally posted by: sajid1

Hi,

I did same got below error.
RMAN> run
2> {
3> allocate channel t1 type 'sbt_tape' parms
4> 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
5> RESTORE CONTROLFILE FROM AUTOBACKUP;
6> ALTER DATABASE MOUNT;
7> }

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on t1 channel at 05/01/2010 16:16:12
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
IBM AIX RISC System/6000 Error: 106: Reserved errno was encountered
Additional information: 7011
ORA-19511: Error received from media manager layer, error text:
SBT error = 7011, errno = 106, sbtopen: system error

Thanks,

Originally posted by: hdkutz

Hello,
what is the output of

1. tdpoconf showenv

?
Cheers,
ku

Originally posted by: sajid1

Hi,

Find below output as per desired.
IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 5, Release 4, Level 1.0
(C) Copyright IBM Corporation 1997, 2007. All rights reserved.
ANS1087E (RC106) Access to the specified file or directory is denied

Thanks,

Originally posted by: hdkutz

Hello,
could be a problem in your access rights on the Logfiles of TDPO.
Check your Config Files for the Position of the Logfiles - maybe you are not able to write to.

Cheers,
ku

Originally posted by: sajid1

Hi,

Find below error what i found in the error log files(tdpoerror.log,dsierror.log).

dsierror.log:
05/03/10 17:32:11 ANS1035S Options file '/usr/tivoli/tsm/client/api/bin64/dsm.
opt' could not be found.
05/03/10 17:32:11 ANS1087E Access to the specified file or directory is denied
05/03/10 17:32:11 ANS1035S Options file '/usr/tivoli/tsm/client/api/bin64/dsm.
opt' could not be found.
05/03/10 17:32:11 ANS1087E Access to the specified file or directory is denied

tdpoerror.log:
05/03/10 17:32:11 TID<626796> ==> ANS1087E (RC106) Access to the specified fi
le or directory is denied

Thanks

Originally posted by: sajid1

Hi,

I think you are right that was the issue of permission I just given 777 to tivoli direcotry that error is not coming.Now other issue is coming as below.

allocated channel: t1
channel t1: sid=2386 devtype=SBT_TAPE
channel t1: Data Protection for Oracle: version 5.4.1.0

Starting restore at 09-MAY-10

channel t1: looking for autobackup on day: 20100509
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/09/2010 11:57:01
ORA-27191: sbtinfo2 returned error
Additional information: 2

RMAN>

---What i found a solution in oracle meta documents to restart observiced.if it is the solution then how could i restart it.

Thanks,

Originally posted by: sajid1

Anyone who can give the solution

Originally posted by: sajid1

Hi Experts,

Any Update,

Thanks,

Originally posted by: tony.evans

We're not experts, we're people doing this to help our community of peers on an informal basis.

You appear to be trying to do something completely outside of your skill set, my advice is discuss with other people in your organisation who support the environments you're working on and get assistance from them first.

Originally posted by: zstarsales04

Zstar Electronic Co.Ltd, Sell fire cards for DS/NDSL/NDSi, also have Wii, DSiLL, NDSi, NDSL, PSP2000, PSP3000, PS2, PS3, PSP go, PSP, Xbox360 accessories, all kinds of phones are available
www.zstar.hk