12-02-2014 08:28 AM
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,
Solved! Go to Solution.
12-02-2014 09:19 AM
you can not do that..
you have to follow the restore process and trigger the restore though RMAN..
12-02-2014 08:40 AM
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.
12-02-2014 08:50 AM
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,
12-02-2014 09:19 AM
you can not do that..
you have to follow the restore process and trigger the restore though RMAN..
12-02-2014 11:36 AM
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
12-02-2014 01:29 PM
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,
12-02-2014 07:09 PM
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.
12-02-2014 11:52 PM
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)