08-04-2011 06:03 AM
Hi,
I'm working in an POC of NBU with Oracle environment. I made the backup and it's working fine.
Now I need to make a restore and I'm lost for begin these tests.
The database is in restore state. I made the script but I'm not sure how do start this process.
Below, I will show the images that I have.
Solved! Go to Solution.
08-04-2011 11:29 PM
Hi Anderson,
The Database was open ?.(DBID=1834298670, not open)
This script from Netbackup Admin Guide For Oracle 7.1 page 104
Start up the database in a nomount state.
08-04-2011 06:23 AM
The operating system shell starts the database restore by running the Oracle shell
script file. The Oracle shell script file contains commands to run RMAN.
The NetBackup installation script writes sample scripts to the following location:
/usr/openv/netbackup/ext/db_ext/oracle/samples/rman
08-04-2011 06:37 AM
Ok wrobbins,
I made an script based int this example.
But how can I run this script and track the status?
Because, if I can do that after I can troubleshooting the erros.
Tks,
08-04-2011 06:51 AM
I'm running the script with this command.
08-04-2011 06:57 AM
The bpdbsbora command lets you run a recovery template that is created by the
NetBackup Recovery wizard.
At the command prompt, type this command and the following options:
bpdbsbora -restore -r -t templ_name [-L progress_file]
where:
-restore Specifies the template type.
-r Runs the template.
Specifies the full-path name of the template you want to use.
Unlike backup templates, restore templates do not reside in a
predetermined location on the master server. They are
considered to be temporary in nature and should reside on the
client. If the full path is not specified as part of the restore
template name, the file might not be found.
-t templ_name
Optional. Specifies a run-time process log. Enclose progress_file
in quotation marks (" ") if it contains space characters.
-L progress_file
For example:
bpdbsbora -restore -r -t /oracle/restore_templs/ORCL_MON_Full.tpl
08-04-2011 07:11 AM
I create an script by wizard...
The following message appear to me after run it.
./bpdbsbora -restore -r -t /usr/openv/netbackup/rst_SGIH.tpl
Could not execute /u01/app/oracle/product/10.2.0/db_1/bin/rman target 'orabackup/*****@SGIH_TAF' rcvcat 'rman_user/*****@rmancat'
08-04-2011 10:49 AM
For POC ...
can you install X on client & start BAR GUI ?? ./jbpSA
you can do backup & restore by easy way
08-04-2011 10:51 AM
Yes, X is installed on the client...
But, this script was generated from BAR GUI.
How more easy can be this?
08-04-2011 11:23 AM
are you restoring to the same client? the source client should be the 'NB_ORA_SERV' value in your script.
Is the media server the same? you may need to change ownership of the tapes if it is a different one.
We restore our Oracle database every month and it works fine.
All done via command line shell scripts from the destination client.
08-04-2011 11:25 AM
08-04-2011 11:31 AM
Yes, I'm trying to restor in the same client. The media server is snetbackupp3.sp.local.
The images are in snetbackupp3.sp.local. Need I to change the owner?
Tks.
08-04-2011 11:55 AM
Try setting the NB_ORA values to the source, you should not need the media server name.
90% of my DBA restore issues are typo in name of client or policy, lol...
Here is our restore script, runs on the client, edited for space and security:
connect target /
run
{
allocate channel t1 type 'SBT_TAPE';
allocate channel t2 type 'SBT_TAPE';
send 'NB_ORA_POLICY=original RMAN policy name';
send 'NB_ORA_CLIENT=original source client';
... oracle commands for what to restore...
set until time "to_date('29-JUN-2009 01:33:00','DD-MON-YYYY HH24:MI:SS')";
restore database;
#Update control file with new database locations
switch datafile all;
switch tempfile all;
recover database;
}
EXIT;
08-04-2011 01:40 PM
Follow the trace now...
08-04-2011 11:29 PM
Hi Anderson,
The Database was open ?.(DBID=1834298670, not open)
This script from Netbackup Admin Guide For Oracle 7.1 page 104
Start up the database in a nomount state.
08-08-2011 10:12 AM