Home » RDBMS Server » Backup & Recovery » backup from oracle to tape under windows 2000 server
backup from oracle to tape under windows 2000 server [message #275039] Thu, 18 October 2007 02:51 Go to next message
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
Re: backup from oracle to tape under windows 2000 server [message #275044 is a reply to message #275039] Thu, 18 October 2007 02:56 Go to previous messageGo to next message
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.
Re: backup from oracle to tape under windows 2000 server [message #275047 is a reply to message #275044] Thu, 18 October 2007 03:00 Go to previous messageGo to next message
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 ??
Re: backup from oracle to tape under windows 2000 server [message #275048 is a reply to message #275047] Thu, 18 October 2007 03:02 Go to previous messageGo to next message
ziadaher
Messages: 70
Registered: October 2007
Location: lebanon
Member

i am still new at this, how do i configure rman ?
Re: backup from oracle to tape under windows 2000 server [message #275049 is a reply to message #275039] Thu, 18 October 2007 03:05 Go to previous messageGo to next message
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.
Re: backup from oracle to tape under windows 2000 server [message #275050 is a reply to message #275048] Thu, 18 October 2007 03:07 Go to previous messageGo to next message
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.
Re: backup from oracle to tape under windows 2000 server [message #275055 is a reply to message #275050] Thu, 18 October 2007 03:26 Go to previous messageGo to next message
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
Re: backup from oracle to tape under windows 2000 server [message #275057 is a reply to message #275055] Thu, 18 October 2007 03:29 Go to previous messageGo to next message
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

Re: backup from oracle to tape under windows 2000 server [message #275058 is a reply to message #275039] Thu, 18 October 2007 03:35 Go to previous messageGo to next message
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?
Re: backup from oracle to tape under windows 2000 server [message #275070 is a reply to message #275058] Thu, 18 October 2007 04:04 Go to previous messageGo to next message
ziadaher
Messages: 70
Registered: October 2007
Location: lebanon
Member

i did, it says nothing related to media parameters
do u have a media library ?
Re: backup from oracle to tape under windows 2000 server [message #275411 is a reply to message #275039] Fri, 19 October 2007 16:30 Go to previous messageGo to next message
ziadaher
Messages: 70
Registered: October 2007
Location: lebanon
Member

does anyone have a media library ??? that i can use for windows 2000 server ???
Re: backup from oracle to tape under windows 2000 server [message #275412 is a reply to message #275411] Fri, 19 October 2007 17:49 Go to previous messageGo to next message
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.
Re: backup from oracle to tape under windows 2000 server [message #275494 is a reply to message #275412] Sat, 20 October 2007 15:17 Go to previous messageGo to next message
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 179 times)
Re: backup from oracle to tape under windows 2000 server [message #275495 is a reply to message #275494] Sat, 20 October 2007 15:38 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: backup from oracle to tape under windows 2000 server [message #275521 is a reply to message #275520] Sun, 21 October 2007 01:04 Go to previous messageGo to next message
ziadaher
Messages: 70
Registered: October 2007
Location: lebanon
Member

i have a hp surestore dat 40 tap drive. its compatibale
Re: backup from oracle to tape under windows 2000 server [message #275717 is a reply to message #275521] Mon, 22 October 2007 08:50 Go to previous message
ziadaher
Messages: 70
Registered: October 2007
Location: lebanon
Member

waiting for ur help
Previous Topic: ORA-01194: file 1 needs more recovery to be consistent
Next Topic: Recovering from Corrupted blocks in my data file
Goto Forum:
  


Current Time: Sun Dec 11 00:14:20 CST 2016

Total time taken to generate the page: 0.06630 seconds