Copy files from master backup server ( netbackup )

[raj555551]

Hi,

We have oracle databases on unix.Our rman backup goes to master server ( netbackup ).

I want to copy files like backup piece,control files from the master backup server.

Is it possible?I don'y have root previleges.I have only oracle previleges.

Is it possible to do by GUI mode from client machine.

Thanks,

[RamNagalla]

you should be able to iniciate the recovery/restore from Rman for the files that you are looking for..

I am not expert in RMAN/Oracle but the restore request should come from the Oracle sever though RMAN as for as netbackup concern.

[raj555551]

Hi,

Thanks for your reply.

I agree.

Oracle backup goes to netbackup via rman.Restore also same.

But i want to copy one file or few file from master server.Without RMAN.

Thanks,

[RamNagalla · Accepted solution]

you can not do that..

you have to follow the restore process and trigger the restore though RMAN..

[Marianne]

The answer remains the same as over here (4 days ago):

https://www-secure.symantec.com/connect/forums/netbackup-client-bplist#comment-10698521 

Plus you never replied to Nicolai's post over here?

https://www-secure.symantec.com/connect/forums/rman-restore-netbackup#comment-10698791

[raj555551]

Hi,

My question is restore file from master server without rman.

us45(16:22)[/v01/app/oracle]$ /usr/openv/netbackup/bin/bprestore -L /softwares/log1.log  -C uctlm.na.ns.net -R /softwares/c-981689279-20140831-08 -f /c-981689279-20140831-08

The rename file /softwares/c-981689279-20140831-08 is not accessible.
EXIT STATUS 144: invalid command usage

why can't restore it directly?

Anyhelp?

Thanks,

[Marianne]

The answer is not going to change. Same as the format of the backup is not going to change from Oracle/Rman (-t 4) to filesystem (-t 0).

If you want to change the way to restore, you need to change the way you perform backups.

If you want to use bprestore this way, you need to take a backup with bpbackup or a Standard policy with a filesystem or list of files in the policy.

So, if you change the rman backup from sbt_tape to sbt_disk, it will write your backup to a file. 
If you then backup that file using bpbackup or automatic through Standard policy, you can later restore that file using bprestore.

Using rman with sbt_tape gives you one-step backup and one-step restore.

Have you had a look at the links in Nicolai's post that I referred you to earlier?
Especially this TN: http://www.symantec.com/docs/HOWTO63971 

PS: 
When you have a Standard (filesystem) backup to restore from, we can help you with correct bprestore command usage.

[Nicolai]

To add to Mariannes post

You can only control files as "regular" files. RMAN backup are not normal files but binary data streams created by RMAN. It not possible to restore tabelspace files as normal files.

So a high levelplan of action would be:

Restore control file (see HOWTO63971 - Netbackup side)

Recover tabelspace and archive filesd based on control file (RMAN side)

Perform media recovery (RMAN side)

Open database (RMAN)