08-10-2014 08:25 AM
Solved! Go to Solution.
08-17-2014 07:33 AM
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
08-17-2014 11:46 AM
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
08-17-2014 10:31 PM
I have moved your restore issue to a new discussion:
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.
08-17-2014 11:34 PM
Yes Agree ...Thanks for your support