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.htmFor a definitive answer, and working examples, go to MOSC:
http://support.oracle.comGood Luck!