cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle HOT backup to be restored as backup pieces

V4
Level 6
Partner Accredited

Hi all

 

We have Oracle 10G and 11G and is getting protected via NetBackup 7.0.1 backup destination is LTO 4 Tape. Previously my DBA used to backup the DB and used to store into native disk from where we used to backup the same into tape media.

Later on after procuring Oracle lic we enabled RMAN backups (same script which DBA used to do for Disk based backups) DBA requested us to restore the backup pices into any system and give those backup pices to him so he can proceed with further restoration. He doesn't wants NBU to restore directly.

As far as i've read , if Hot backup is enabled we can restore the Hot DB directly (Correct me if i'm wrong). Is it possible to restore only backup pices to any other directory where Oracle is not deployed and we can then give DBA those directory dumped??

 

1 ACCEPTED SOLUTION

Accepted Solutions

Yasuhisa_Ishika
Level 6
Partner Accredited Certified
NetBackup for Oracle can provide backup data to the host both NetBackup and Oracle configured on. And NetBack can only provide sbt_tape channel stream. NetBackup can not conver data to oracle's DISK channel data. DBA should tell you he doesn't want to change his way before.

View solution in original post

7 REPLIES 7

Yogesh9881
Level 6
Accredited

As your DBA requested you to restore the backup pices into any system that means

its a old file level backup for netbackup ..... 

so you can restore it normally no need to install Oracle software ...

V4
Level 6
Partner Accredited

But Yogesh i've backed up Oracle DB using Oracle Agent policy. Is it possible to restore the data from these backup set as file level Which script i've to follow or It can be done by using BAR gui

Yasuhisa_Ishika
Level 6
Partner Accredited Certified
NetBackup for Oracle can provide backup data to the host both NetBackup and Oracle configured on. And NetBack can only provide sbt_tape channel stream. NetBackup can not conver data to oracle's DISK channel data. DBA should tell you he doesn't want to change his way before.

Nicolai
Moderator
Moderator
Partner    VIP   

To RMAN netbackup is only a transport path providing storage (aka a media manager layer). All control lays in the hand of the DBA. He must tell RMAN what the want to do. If the wan't the flat files back, let him restore them with RMAN.

V4
Level 6
Partner Accredited

HI nicolai..

U meant using Hot backup also it is possible to restore only backup pieces. Who will be reponsible for this task can u share syntax for same. :)

Nicolai
Moderator
Moderator
Partner    VIP   

Restoring from a hot backup is the task for a Oracle DBA. He (should) know the syntax of RMAN and the state of the database (in recovery mode, mounted, not mounted etc etc). He/she is also trained in using Oracle, are you wink

Here are some RMAN restore examples for you:

http://www.colestock.com/blogs/2008/02/how-to-backup-and-restore-via-rman.html

http://download.oracle.com/docs/cd/B13789_01/server.101/b10734/rcmconc2.htm

http://download.oracle.com/docs/cd/B12037_01/server.101/b10734/rcmrecov.htm

http://ss64.com/ora/rman_restore.html

Altimate1
Level 6
Partner Accredited

Hi,

I have also a demo video here:

http://connect.distrilogie.com/p73607318/

Regards