oracle RMAN

[click007]

i cant find the data that backuped by schedule to restore back from the client GUI...
the client is AIX tdp oracle n use RMAN to backup
the tsm server is window

how can i find the data to restore back from client GUI

thanks for any help....

 

[dylu]

you must use rman.
for example:

....
connect catalog rman_user/rman_pass@rman_sid;
connect target sys/sys_pass@SID;

run
{
resync catalog;
allocate channel ch1 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
set until time 'AUG 8 2007 15:30:00';
resync catalog;
set newname for datafile '/old_dir/old_file.dbf' TO '/new_dir/new_file.dbf';
restore new_file.dbf;
}

if I remember rightly ...

 

[click007]

so i cant use web gui to backup & restore for oracle?... i can use only RMAN to backup & restore ?.. plz guide me to use ur code also
i m new to tsm n start learing... so thanks for ur reply & being patient

you must use rman.
for example:

....
connect catalog rman_user/rman_pass@rman_sid;
connect target sys/sys_pass@SID;

run
{
resync catalog;
allocate channel ch1 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
set until time 'AUG 8 2007 15:30:00';
resync catalog;
set newname for datafile '/old_dir/old_file.dbf' TO '/new_dir/new_file.dbf';
restore new_file.dbf;
}

if I remember rightly ...

 

[dhaue]

Yes, you can only use RMAN to restore a backup that was created with the TDPO integration. Additionally, you can only expire/delete those backups using RMAN (otherwise, they will NEVER expire and will fill up your tapes and TSM database).

 

[sgabriel62]

Agreed, when it comes to Oracle - there is no TSM GUI for the TDP for Oracle. There is only one filespace listed in TSM as well - take a look at your tdpo.conf file located in the installation directory to identify the filespace name. It may be tcpmux or something like that - which is default. Its better to get a copy of the RMAN backup routine Oracle team is using - take a read through so you can understand their process flow. Alot of questions will be answered internal just by reading this script.

Good luck