OraFAQ Forum: Backup & Recovery » backup from oracle to tape under windows 2000 server

Home » RDBMS Server » Backup & Recovery » backup from oracle to tape under windows 2000 server

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

backup from oracle to tape under windows 2000 server [message #275039]

Thu, 18 October 2007 02:51

ziadaher
Messages: 70
Registered: October 2007
Location: lebanon

Member

how can i backup from oracle to a tape directly under windows ???
i have oracle enterprise manager, i tried downloading media libraries and alot of other stuff nothing worked...
so i want your help, if there is any other way please advice
thank you very much

Report message to a moderator

Re: backup from oracle to tape under windows 2000 server [message #275044 is a reply to message #275039]

Thu, 18 October 2007 02:56

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Through RMAN, First install Media Management Library, then configure RMAN and then invoke backup command.

Report message to a moderator

Re: backup from oracle to tape under windows 2000 server [message #275047 is a reply to message #275044]

Thu, 18 October 2007 03:00

ziadaher
Messages: 70
Registered: October 2007
Location: lebanon

Member

i forgot to tell u that i use oracle 10g...
do i still need a media library ??

Report message to a moderator

Re: backup from oracle to tape under windows 2000 server [message #275048 is a reply to message #275047]

Thu, 18 October 2007 03:02

ziadaher
Messages: 70
Registered: October 2007
Location: lebanon

Member

i am still new at this, how do i configure rman ?

Report message to a moderator

Re: backup from oracle to tape under windows 2000 server [message #275049 is a reply to message #275039]

Thu, 18 October 2007 03:05

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Quote:

i forgot to tell u that i use oracle 10g...
do i still need a media library ??

Yes you still need to install MML if you want to backup to tape.

Report message to a moderator

Re: backup from oracle to tape under windows 2000 server [message #275050 is a reply to message #275048]

Thu, 18 October 2007 03:07

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

ziadaher wrote on Thu, 18 October 2007 14:02

i am still new at this, how do i configure rman ?

rman target /

show all

CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TYPE';

if you want to in tape.

Report message to a moderator

Re: backup from oracle to tape under windows 2000 server [message #275055 is a reply to message #275050]

Thu, 18 October 2007 03:26

ziadaher
Messages: 70
Registered: October 2007
Location: lebanon

Member

ok done.
i installed the tape drive, tivolo storage manager, tivolo data protection for oracle---> these are the media libraries , right
??
what parameter should i put in the media library parameter, in the oracle enterprise manager?
cant i backup without using OEM ??
thanks again

Report message to a moderator

Re: backup from oracle to tape under windows 2000 server [message #275057 is a reply to message #275055]

Thu, 18 October 2007 03:29

ziadaher
Messages: 70
Registered: October 2007
Location: lebanon

Member

RMAN> run {

2> allocate channel oem_sbt_backup type 'sbt_tape' format '%U';

3> backup as BACKUPSET current controlfile tag '10182007112258';

4> restore controlfile validate from tag '10182007112258';

5> release channel oem_sbt_backup;

6> }

RMAN-00571: ===========================================================

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

RMAN-00571: ===========================================================

RMAN-03009: failure of allocate command on oem_sbt_backup channel at 10/18/2007 11:23:03

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

ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer

OSD-02534: Message 2534 not found; product=RDBMS; facility=SOSD

Report message to a moderator

Re: backup from oracle to tape under windows 2000 server [message #275058 is a reply to message #275039]

Thu, 18 October 2007 03:35

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Quote:

what parameter should i put in the media library parameter, in the oracle enterprise manager?

Have you look at your readme.txt or documentation that comes with installation?

Report message to a moderator

Re: backup from oracle to tape under windows 2000 server [message #275070 is a reply to message #275058]

Thu, 18 October 2007 04:04

ziadaher
Messages: 70
Registered: October 2007
Location: lebanon

Member

i did, it says nothing related to media parameters
do u have a media library ?

Report message to a moderator

Re: backup from oracle to tape under windows 2000 server [message #275411 is a reply to message #275039]

Fri, 19 October 2007 16:30

ziadaher
Messages: 70
Registered: October 2007
Location: lebanon

Member

does anyone have a media library ??? that i can use for windows 2000 server ???

Report message to a moderator

Re: backup from oracle to tape under windows 2000 server [message #275412 is a reply to message #275411]

Fri, 19 October 2007 17:49

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Do you actually have a license for Tivoli Storage Manager? If so, have you read the Tivoli Install Guide?

If you don't have a license for TSM, you may want to consider Oracle Secure Backup Express which is free for one server and one tape backup.

Report message to a moderator

Re: backup from oracle to tape under windows 2000 server [message #275494 is a reply to message #275412]

Sat, 20 October 2007 15:17

ziadaher
Messages: 70
Registered: October 2007
Location: lebanon

Member

one last question.
i downloaded the oracle secure backup, and i am doing fine
i read the readme and every documents.
but there's a problem i am facing:
-the library that i add, i just pick a name and the OSB will create a library or do something or i need to have a library??
if i need to have a library is it the tape's library ? and how do i get OSB to figure that this is the library i need
thanks guys
check the attach.

Attachment: 2.JPG
(Size: 132.51KB, Downloaded 933 times)

Report message to a moderator

Re: backup from oracle to tape under windows 2000 server [message #275495 is a reply to message #275494]

Sat, 20 October 2007 15:38

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Is your tape device on Oracle's Compatibility list ? If so, you may want to review Configuring Libraries and Tape Drives on Windows: Overview or Configuring Tape Devices.

[Updated on: Sat, 20 October 2007 15:46]

Report message to a moderator

Re: backup from oracle to tape under windows 2000 server [message #275520 is a reply to message #275495]

Sun, 21 October 2007 01:00

ziadaher
Messages: 70
Registered: October 2007
Location: lebanon

Member

i did the same steps as they listed on how to add a library and a drive... but they dont tell if the library actually exists as i mentioned above.
i entered "lsvol -L lib" it gave me that it can not make a qlm connection and couldnt find the library

Report message to a moderator

Re: backup from oracle to tape under windows 2000 server [message #275521 is a reply to message #275520]

Sun, 21 October 2007 01:04

ziadaher
Messages: 70
Registered: October 2007
Location: lebanon

Member

i have a hp surestore dat 40 tap drive. its compatibale

Report message to a moderator

Re: backup from oracle to tape under windows 2000 server [message #275717 is a reply to message #275521]

Mon, 22 October 2007 08:50

ziadaher
Messages: 70
Registered: October 2007
Location: lebanon

Member

waiting for ur help

Report message to a moderator

Previous Topic:	ORA-01194: file 1 needs more recovery to be consistent
Next Topic:	Recovering from Corrupted blocks in my data file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 08:45:40 CST 2024