Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Closed TopicStart new topic
> Can Oracle Secure backup run using SAS interface on an IBM autoloader model TS2900?, Can Oracle Secure backup run using SAS interface on an IBM autoloader
Nolimer
post Mar 23 2012, 04:48 AM
Post #1


Newbie
*

Group: Members
Posts: 6
Joined: 23-March 12
Member No.: 46,973



We would like to used Oracle secure backup using SAS interface on an IBM Autoloader Model TS-2900. Would it be possible to configure oracle secure backup using SAS?



Your Response will be highly Appreciated.

Nolimer Cabanilla rolleyes.gif
Go to the top of the page
 
+Quote Post
burleson
post Mar 23 2012, 05:35 AM
Post #2


Advanced Member
***

Group: Members
Posts: 11,400
Joined: 26-January 04
Member No.: 13



Hi Nolimer,

Good Question!

Oracle Secure Backup (OSB) enables you to use RMAN to backup directly to tape library without using the costly third-party MML layer.
OSB can be controlled and administered via Oracle Enterprise Manager or the obtool command-line.

The obtool is a command-0line interface, executed from the OS level using the "ob" prompt.

Here are the obtool commands:


The "backup --go" command forwards a secure backup command to the Oracle job scheduler

ob> backup --go
Here is how to execute a sqlplus command from a remote host, this may be modifiable for obtool:

**********************************************

>> We would like to used Oracle secure backup using SAS interface on an IBM Autoloader Model TS-2900.

Anywhere that you can invoke Oracle processes will be able to run an RMAN backup, you need only invoke it from the calling environment. I have not done SAS in 25 years, but yes, I'll bet that you can embed an obtool command.

If you can create a shell script from the SAS encironment thast will be able to remotely execute obtool then you will be home free.

http://www.dba-oracle.com/t_obtool_commands.htm

For a definitive answer, and working examples, go to MOSC:

http://support.oracle.com

Good Luck!


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
Nolimer
post Apr 11 2012, 04:40 AM
Post #3


Newbie
*

Group: Members
Posts: 6
Joined: 23-March 12
Member No.: 46,973



Hi sir burleson,

Thank you for a good idea.. But we are trying to run Oracle Secure Backup using SAS interface on an IBM autoloader model TS-2900? Is that possible?

thankyou and best regards,

Noli


QUOTE (burleson @ Mar 23 2012, 06:35 PM) *
Hi Nolimer,

Good Question!

Oracle Secure Backup (OSB) enables you to use RMAN to backup directly to tape library without using the costly third-party MML layer.
OSB can be controlled and administered via Oracle Enterprise Manager or the obtool command-line.

The obtool is a command-0line interface, executed from the OS level using the "ob" prompt.

Here are the obtool commands:


The "backup --go" command forwards a secure backup command to the Oracle job scheduler

ob> backup --go
Here is how to execute a sqlplus command from a remote host, this may be modifiable for obtool:

**********************************************

>> We would like to used Oracle secure backup using SAS interface on an IBM Autoloader Model TS-2900.

Anywhere that you can invoke Oracle processes will be able to run an RMAN backup, you need only invoke it from the calling environment. I have not done SAS in 25 years, but yes, I'll bet that you can embed an obtool command.

If you can create a shell script from the SAS encironment thast will be able to remotely execute obtool then you will be home free.

http://www.dba-oracle.com/t_obtool_commands.htm

For a definitive answer, and working examples, go to MOSC:

http://support.oracle.com

Good Luck!

Go to the top of the page
 
+Quote Post
burleson
post Apr 11 2012, 06:57 AM
Post #4


Advanced Member
***

Group: Members
Posts: 11,400
Joined: 26-January 04
Member No.: 13



Hi,


>> But we are trying to run Oracle Secure Backup using SAS interface on an IBM autoloader model TS-2900? Is that possible?

I have no idea, sorry! Try it and see!


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
Nolimer
post Apr 12 2012, 12:11 AM
Post #5


Newbie
*

Group: Members
Posts: 6
Joined: 23-March 12
Member No.: 46,973



hi sir burleson,


Thank you for the answer. Sir donald, Is SAS connectivity is not supported on AIX media servers?


best regards,

noli
Go to the top of the page
 
+Quote Post
burleson
post Apr 12 2012, 01:26 PM
Post #6


Advanced Member
***

Group: Members
Posts: 11,400
Joined: 26-January 04
Member No.: 13



Hi Noli,


Is this you posting this question on OTN as Romel Dela Fuente?


https://forums.oracle.com/forums/thread.jsp...69&tstart=0

>> Sir donald, Is SAS connectivity is not supported on AIX media servers?

No, according to Donna in the link above, SAS connectivity is not supported on AIX media servers.


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
Nolimer
post Apr 12 2012, 08:32 PM
Post #7


Newbie
*

Group: Members
Posts: 6
Joined: 23-March 12
Member No.: 46,973



Hi sir donald,

Yes sir donald, Romel is my colleague. by the way sir, what is the difference between SCSI with SAS? And what is the importance of the two connection?

Thank you for the info sir donald.

best regards,

Noli

Go to the top of the page
 
+Quote Post
burleson
post Apr 13 2012, 06:55 AM
Post #8


Advanced Member
***

Group: Members
Posts: 11,400
Joined: 26-January 04
Member No.: 13



>> what is the difference between SCSI with SAS?

Hardware: SCSI (pronounced "scuzzy") is an ultra-fast, high-power communications bus that connects up to 15 devices to your computer.

Software: SAS: Statistical Analysis Software.


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Closed TopicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 22nd August 2014 - 04:48 AM