cancel
Showing results for 
Search instead for 
Did you mean: 

Reg Oracle DB backup

Govarthanagiri
Level 4
Hi all, netbackup appliance with version 7.5 Client : RHEL 5.9 Oracle DB :11G I have planed to take a backup of Oracle DB with archive logs using RMAN. so I have read the document related that but I am not clear about the below point. So please help me to get clear the below point 1. If I have created a policy with full back of the DB , are the archive logs also be backed up while run the policy ? Or must need a separate policy for the archive logs ? Thanks , Giri
23 REPLIES 23

Govarthanagiri
Level 4

Thanks Walker and Marianne,

the DB bakcup works fine after executing the command

RMAN> crosscheck archivelog all;

RMAN>delete expired archivelog all;

 

also i want to clear a doubt with you as below

if i want to exclude the DB files from my another full bakcup policy ( entire server) which is configured for BMR  for the same server, i can add the below home dir in the exclude list , am i correct ?

com09:oracle # echo $ORACLE_HOME
/opt/PlexView/Oracle/ora01/app/oracle/product/11.2.0
com09:oracle #

 

regards,

Giri

Govarthanagiri
Level 4

i am getting the  below error when try to restore ...kindly help me

 

com09:oracle # /usr/openv/netbackup/ext/db_ext/oracle/samples/rman/database_restore.sh
com09:oracle # cat database_restore.sh.out

Script /usr/openv/netbackup/ext/db_ext/oracle/samples/rman/database_restore.sh
==== started on Sun Aug 17 16:39:17 UTC 2014 ====


RMAN: /opt/PlexView/Oracle/ora01/app/oracle/product/11.2.0/bin/rman
ORACLE_SID: plxdb
ORACLE_USER: oracle
ORACLE_HOME: /opt/PlexView/Oracle/ora01/app/oracle/product/11.2.0
Last login: Sun Aug 17 16:38:47 UTC 2014

Recovery Manager: Release 11.2.0.1.0 - Production on Sun Aug 17 16:39:17 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: PLXDB (DBID=3747984712)
using target database control file instead of recovery catalog

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10>
allocated channel: ch00
channel ch00: SID=28 device type=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 7.5 (2013061020)

allocated channel: ch01
channel ch01: SID=129 device type=SBT_TAPE
channel ch01: Veritas NetBackup for Oracle - Release 7.5 (2013061020)

Starting restore at 17-AUG-14

channel ch00: starting datafile backup set restore
channel ch00: specifying datafile(s) to restore from backup set
channel ch00: restoring datafile 00005 to /opt/PlexView/Oracle/ora02/oradata/plxdb/audit_data.dbf
channel ch00: restoring datafile 00006 to /opt/PlexView/Oracle/ora02/oradata/plxdb/cfma01.dbf
channel ch00: restoring datafile 00008 to /opt/PlexView/Oracle/ora02/oradata/plxdb/tablespace_es4m_indx.dbf
channel ch00: restoring datafile 00009 to /opt/PlexView/Oracle/ora02/oradata/plxdb/tablespace_es128k_data.dbf
channel ch00: restoring datafile 00010 to /opt/PlexView/Oracle/ora02/oradata/plxdb/tablespace_es128k_indx.dbf
channel ch00: reading from backup piece bk_84_1_855851605
channel ch01: starting datafile backup set restore
channel ch01: specifying datafile(s) to restore from backup set
channel ch01: restoring datafile 00001 to /opt/PlexView/Oracle/ora02/oradata/plxdb/system01.dbf
channel ch01: restoring datafile 00002 to /opt/PlexView/Oracle/ora02/oradata/plxdb/sysaux01.dbf
channel ch01: restoring datafile 00003 to /opt/PlexView/Oracle/ora02/oradata/plxdb/undotbs01.dbf
channel ch01: restoring datafile 00004 to /opt/PlexView/Oracle/ora02/oradata/plxdb/users01.dbf
channel ch01: restoring datafile 00007 to /opt/PlexView/Oracle/ora02/oradata/plxdb/tablespace_es4m_data.dbf
channel ch01: reading from backup piece bk_85_1_855851606
released channel: ch00
released channel: ch01
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/17/2014 16:39:27
ORA-19870: error while restoring backup piece bk_84_1_855851605
ORA-19573: cannot obtain exclusive enqueue for datafile 6

RMAN> RMAN>

Recovery Manager complete.
Last login: Sun Aug 17 16:38:47 UTC 2014

Script /usr/openv/netbackup/ext/db_ext/oracle/samples/rman/database_restore.sh
==== ended in error on Sun Aug 17 16:39:27 UTC 2014 ====

com09:oracle #

regards,

Giri

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

I have moved your restore issue to a new discussion:

https://www-secure.symantec.com/connect/forums/oracle-restore-ora-19573-cannot-obtain-exclusive-enqu...

You will agree that the question in your opening post about backup policy for database and archive logs was answered, right?

Please find a post that answered that question and Mark as Solution.
Or select 'Request split solution' to mark more than one post as solution.

Please continue with restore issue in the new discussion.

Govarthanagiri
Level 4

Yes Agree ...Thanks for your support