Restoring an entire Oracle database

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.

C:\Program Files\Veritas\NetBackup\bin>bplist -C sdbora10h1-vip.sesisenaisp.org.br -t 4 -l -R /

-rw-rw---- oracle oinstall 15466496 ago 02 15:52 ctrl_u1umj0a2i_s62_p1_t758130770:\

-rw-rw---- oracle oinstall 1588224K ago 02 15:46 arch_u1tmj09ma_s61_p1_t758130378:\

-rw-rw---- oracle oinstall 15466496 ago 02 15:45 bk_u1smj09k0_s60_p1_t758130304:\

-rw-rw---- oracle oinstall 890241024 ago 02 15:41 bk_u1rmj09e6_s59_p1_t758130118:\

C:\Program Files\Veritas\NetBackup\bin>

How can I restore these images on the client?

Regards.

7.1.x and Earlier

Backup and Recovery

NetBackup

Zailar
13 years ago
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.

On UNIX and Linux, the following is the output:

SQL> startup nomount pfile=$ORACLE_HOME/dbs/inittest.ora

%rman catalog rman/rman@rcat

RMAN> set dbid=<dbid of source database on camel

RMAN> connect target/

RMAN> run {

RMAN> ALLOCATE CHANNEL CH00 TYPE 'SBT_TAPE';

RMAN> SEND 'NB_ORA_SERV=lion, NB_ORA_CLIENT=camel';

RMAN> restore controlfile;

RMAN> }

SQL> alter database mount;

%orapwd file=$ORACLE_HOME/dbs/orapwtest password=<oracle>

%rman catalog rman/rman@RCVCAT

RMAN>set dbid=<Saved dbID of Source Target>

RMAN>connect target/

RMAN>run {

RMAN> ALLOCATE CHANNEL CH00 TYPE 'SBT_TAPE';

RMAN> ALLOCATE CHANNEL CH01 TYPE 'SBT_TAPE';

RMAN> SEND 'NB_ORA_SERV=lion, NB_ORA_CLIENT=camel';

RMAN> restore database;

RMAN> restore archivelog all;

RMAN> }

SQL>recover database until cancel using backup controlfile;

Regards

14 Replies

Will_Restore
Level 6
13 years ago
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
Anderson_R__Gom
Level 5
13 years ago
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,
Anderson_R__Gom
Level 5
13 years ago
I'm running the script with this command.

[root@sdbora10h1 netbackup]# sh restore.tpl

: command not found0:

: command not found5:

: command not found7:

: command not found1:

: command not found3:

: command not found8:

restore.tpl: line 188: syntax error: unexpected end of file

It's returne that errors.

Line 188 Don't exist in script.

I attached the script in this topic.

Tks.
restore.zip2 KB
Will_Restore
Level 6
13 years ago
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
Anderson_R__Gom
Level 5
13 years ago
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'
Yogesh9881
Level 6
13 years ago
For POC ...

can you install X on client & start BAR GUI ?? ./jbpSA

you can do backup & restore by easy way
Anderson_R__Gom
Level 5
13 years ago
Yes, X is installed on the client...

But, this script was generated from BAR GUI.

How more easy can be this?
David_McMullin
Level 6
13 years ago
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.
Anderson_R__Gom
Level 5
13 years ago

INF - Begin progress logging for process: (21068)

INF - Starting Oracle Recovery Manager.

INF - Using: /u01/app/oracle/product/10.2.0/db_1/bin/rman

INF - Connection info: target 'orabackup/*****@SGIH1' rcvcat 'rman_user/*****@rmancat'

INF - Start of Recovery Manager input.

INF - # -----------------------------------------------------------------

INF - # RMAN command section

INF - # -----------------------------------------------------------------

INF - RUN {

INF - ALLOCATE CHANNEL ch00

INF - TYPE 'SBT_TAPE';

INF - SEND 'NB_ORA_SERV=snetbackupp3.sp.local';

INF - RESTORE

INF - TABLESPACE

INF - 'CPMBRAXIS';

INF - RECOVER

INF - TABLESPACE

INF - 'CPMBRAXIS';

INF - RELEASE CHANNEL ch00;

INF - }

INF - End of Recovery Manager input.

INF - Start of Recovery Manager output.

INF - Begin progress logging for process: (21199)

INF - Start restore of backup piece: (bk_u2dmj5cah_s77_p1_t758296913)

INF - Backup id: sdbora10h1-vip.sesisenaisp.org.br_1312477322

INF - Policy: POL-SESI-ORACLE

INF - Master server: snetbackupp3.sp.local

INF - Restore id: 109.001

INF - Beginning restore from server snetbackupp3.sp.local to client sdbora10h1.

INF - Server status = 0

INF - End restore of backup piece: (bk_u2dmj5cah_s77_p1_t758296913)

INF - Recovery Manager: Release 10.2.0.4.0 - Production on Thu Aug 4 15:18:04 2011

INF - connected to target database: SGIH (DBID=1834298670, not open)

INF - connected to recovery catalog database

INF - allocated channel: ch00

INF - Starting restore at 04-AUG-11

INF - channel ch00: starting datafile backupset restore

INF - restoring datafile 00006 to /ud70/oradata/SGIH/CPM1.dbf

INF - channel ch00: reading from backup piece bk_u2dmj5cah_s77_p1_t758296913

INF - released channel: ch00

INF - RMAN-00571: ===========================================================

INF - RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

INF - RMAN-00571: ===========================================================

INF - RMAN-03002: failure of restore command at 08/04/2011 15:18:49

INF - ORA-19870: error reading backup piece bk_u2dmj5cah_s77_p1_t758296913

INF - ORA-19573: cannot obtain exclusive enqueue for datafile 6

INF - Recovery Manager complete.

INF - End of Recovery Manager output.

INF - End Oracle Recovery Manager.
Anderson_R__Gom
Level 5
13 years ago
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.