RE: Netbackup and RMAN
- From: "Harel Safra" <harel.safra@xxxxxxxxx>
- To: <niall.litchfield@xxxxxxxxx>, "'ORACLE-L'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 9 Jun 2010 22:33:29 +0300
I can't help with backup exec, but may I suggest a different approach:
You can take an incremental backup of the production database that's in sync
with the current standby SCN, restore it on the standby server an go on you
merry way without the lost archive files.
You can find the details here:
http://blogs.oracle.com/AlejandroVargas/How-To-Synchronize-Standby-When-Logs
-Lost.pdf
I've done this a couple of times.
Harel Safra
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Niall Litchfield
Sent: Wednesday, June 09, 2010 3:04 PM
To: ORACLE-L
Subject: Netbackup and RMAN
grrrr.I have a client who has the following issue
Oracle database backed up with backup exec 12.5 (formerly veritas
netbackup).Archivelogs are backed up weekly and deleted also via backup
exec. RMAN catalog (controlfile) knows about the tape backup of the
archlogs, though the media id column is not populated.rman restore preview
cannot find the backup piece on the tape as shown in the log extract below.
I'm reasonably hopeful that I just don't know what MML parameters to send to
backup exec. The backup exec interface seems to only know about archive logs
listed in the current controlfile and how to restore old controlfiles over
the top of the current one, neither of which is what I want.
I really need to be able to restore about 5 archive logs from tape ( 3gb) to
catch up a manual standby, rather than ship 1 tb of backup data down to a
remote site over a 10mb link to reinstantiate the standby. So my question
for those who use rman/backup exec regularly is how do you do "advanced"
rman stuff, like restore archive logs, spfile or whatever from an older
tape.
RMAN> @restore_archlogs.rcv
RMAN> #
2> run {
3> allocate channel c0 device type 'sbt_tape';
4> send "NBBSA_SOURCE_MACHINE_NAME=*********";
6> restore archivelog sequence 15702 preview;
7> release channel c0;
8> }
allocated channel: c0
channel c0: SID=1048 device type=SBT_TAPE
channel c0: Symantec/BackupExec/1.1.0
sent command to channel: c0
Starting restore at 09-JUN-10
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
766 334.75M SBT_TAPE 00:00:16 04-JUN-10
BP Key: 766 Status: AVAILABLE Compressed: NO Tag:
TAG20100604T232526
Handle: BE_oflfe2j6_1_1 Media:
List of Archived Logs in backup set 766
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 15702 5848294128 04-JUN-10 5849019051 04-JUN-10
could not locate pieces of backup set key 766
Finished restore at 09-JUN-10
released channel: c0
RMAN>
RMAN> **end-of-file**
Incidentally I've seen a number of blog posts about how to use RMAN to take
backups using backup exec, none about how to restore them. I hope this is an
indication of my bad search skills rather than an indication that our
industry thinks backup is more important than restore.
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Other related posts:
