Hi,

How did you do the backup of this data?  Did you use one of the NetWorker modules?   What does the NetWorker media database say has been backed up:

mminfo -q client=[client_name_here] -r ssid,name,level,savetime,ssbrowse,clretent,ssretent,sumflags,totalsize,nfiles -ot

-Bobby

Hi,

The NetWorker module would use RMAN to do the backup and NetWorker manages the tape management end of things.  You can check what's installed on linux with:

rpm -qa | grep -i lgto

If you find NMO (NetWorker Module for Oracle), then you should consult the NMO Administration Guide

If you find NMDA (NetWorker Module for Databases and Applications), then you should consult the NMDA Administration Guide

This documentation will provide you with instructions on how to recover the data you need.

-Bobby

Hi Bobby,

The backup actually done by RMAN, the backup triggered by RMAN then save the data into tape. Therefore, I not very sure how it configured. How I check the networker module in the linux client? Below is part of the output of the command

mminfo -q client=client -r ssid,name,level,savetime,ssbrowse,clretent,ssretent,sumflags,totalsize,nfiles -ot

3264321731 /oraclercv/MEDCO/bkp          manual 03/29/11 04/29/11 04/29/11 04/29/11 cb   23246728 1210
3079772484 /                               incr 03/29/11 04/29/11 04/29/11 04/29/11 cb    2539792   43
3029440839 /home                           incr 03/29/11 04/29/11 04/29/11 04/29/11 cb    3504500  732
3012663623 /opt                            incr 03/29/11 04/29/11 04/29/11 04/29/11 cb  495730024 4969
2995886407 /usr                            incr 03/29/11 04/29/11 04/29/11 04/29/11 cb          4    0
2979109191 /usr/local                      incr 03/29/11 04/29/11 04/29/11 04/29/11 cb          4    0
2912000427 /var                            incr 03/29/11 04/29/11 04/29/11 04/29/11 cb  207649224  167
2257694133 RMAN:ARCH_DRSEV_u_uqm8dnbj_s5082_p1 manual 03/29/11 04/29/11 04/29/11 04/29/11 cb 2782481516 1
2240917013 RMAN:ctlDRSEV_c-1387127476-20110329-01 manual 03/29/11 04/29/11 04/29/11 04/29/11 cb 32769192 1
2022816713 RMAN:ARCH_DRSSVC_u_n6m8dqs3_s4838_p1 manual 03/29/11 04/29/11 04/29/11 04/29/11 cb 249306740 1
2006039516 RMAN:ctlDRSSVC_c-1750584458-20110329-01 manual 03/29/11 04/29/11 04/29/11 04/29/11 cb 26215392 1
1687275996 RMAN:ARCH_DSGUC_u_k7m8duck_s3719_p1 manual 03/29/11 04/29/11 04/29/11 04/29/11 cb 247995980 1
1636944363 RMAN:ctlDSGUC_c-86018595-20110329-01 manual 03/29/11 04/29/11 04/29/11 04/29/11 cb 19399436 1
1385289707 RMAN:ARCH_DSCVG_u_vdm8e1t2_s3053_p1 manual 03/29/11 04/29/11 04/29/11 04/29/11 cb 590104340 1
1368512513 RMAN:ctlDSCVG_c-4065232887-20110329-01 manual 03/29/11 04/29/11 04/29/11 04/29/11 cb 17826528 1

I'm trying to restore the RMAN files. But I'm doubt the backup can be restore from networker since it was done by RMAN?

Thanks

You can't do ssid restore of RMAN data.  You need to use RMAN restore script.

Hi,

I have checked the backup is done by NMO.

lgtonmo-4.5-1.x86_64

lgtoclnt-7.4.2-1.x86_64

I have obtain the RMAN backup script from the DBA admin

allocate channel bkp1 device type SBT_TAPE format 'dbf_BASE_%d_u_%u_s%s_p%p' maxopenfiles 10; send 'NSR_ENV=(NSR_SERVER=BackupServer, NSR_CLIENT=ClientName, NSR_DATA_VOLUME_POOL=DBA)';

I am trying to restore some dbf files into different server. I have read the NMO documentation about the restore process but still confuse about it. Can anyone please guide me how I restore the file from RMAN scripts? What it means the  "Net service" , databases payroll and rcvcatdb?

Below statement is from the NMO guide:

If the RMAN restore script on page 121 is stored in the file /disk1/scripts/restore.txt and the Net service has been configured to connect to the databases payroll and rcvcatdb, the Oracle restore can be started with the following command:

rman target internal/oracle@payroll rcvcat rman/rman@rcvcatdb cmdfile

\’/disk1/scripts/restore.txt\’

Are you sure your DBAs are DBAs?  RMAN is Oracle thus backup script or restore script is something they do.  Most of the time this is simple script, but it may have some tuning added within time or might be even highly complex.  It really depends from one env to another.  I suppose you look after backup infra so you provide infra which in this case is module and you make sure data is available for restore, but oracle restore itself is something DBAs do.  With that said, all you need to do is to provide media manager string to be used in RMAN script in this case  - which happens to be identical to what you use already in backup rman script.

As you (or DBAs) wish to restore to different server, then there is additional task for you as admin of the backup server application - you must grant permission to target server to read index of the source server (so in short, you set remote permissions).  After that, DBAs should run RMAN restore from target database using NSR parms as in backup script and that's it.

honzone2 wrote: Hi, Yes, you are right. The permission may be the item I most concern. Since I do not have the access on the client side, I only can check backup server side. I have created the target client definition and added *@* in the remote access in the networker server. It these the only item to confirm these clients have sufficient privileges to perform the restore into different host? Thanks.

Correct... even *@* might not be the best thing to do from security point of view, but for start it will get you going.

Hi,

Yes, you are right. The permission may be the item I most concern. Since I do not have the access on the client side, I only can check backup server side.

I have created the target client definition and added *@* in the remote access in the networker server. It these the only item to confirm these clients have sufficient privileges to perform the restore into different host?

Thanks.