Hi list,
Our DBA sent the following email and I went to the NetBackup reports
and listed what was out there for the isp-oracle class we created for
this purpose.
The output looks like this:
Client: isp-db.admin.Virginia.EDU
Backup ID: isp-db.admin.Virginia.EDU_0989761880
Class: isp-oracle
Class Type: Oracle
Sched Label: Default-Policy
Schedule Type: User Backup (Backup Policy)
Retention Level: infinity (9)
Backup Time: 05/13/2001 09:51:20
Elapsed Time: 000:04:08
Expiration Time: INFINITY
Compressed: no
Encrypted: no
Kilobytes: 48672
Number of Files: 1
Primary Copy: 1
Image Type: 0 (Regular)
Keyword: isp01
Ext Security Info: no
File Restore Raw: no
Image Dump Level: 0
File System Only: no
Object Descriptor: (none specified)
Multiplexed: no
TIR Available: no
The question to you is ....
Is there a way to prime the keyword field (from rman) with a unique entry to
distinguish the backups from one another? We realize the date/timestamp and
backupid are unique, but we would like a better way of getting delete scripts
to work based on DBA entered keywords.
Any ideas?
Thank you.
--
Diane Meeker ladydi AT virginia DOT edu
University of Virginia 804-924-4182
---------- Forwarded message ----------
Date: Tue, 15 May 2001 12:16:16 -0400 (Eastern Daylight Time)
From: Robert T. Remsberg <rtr3w AT cms.mail.virginia DOT edu>
To: "Diane M. Meeker (dmm4n)" <dmm4n AT virginia DOT edu>
Subject: NetBackup for Oracle
Diane,
I am making some progress with combining NetBackup and RMAN.
I developed a script that uses bpbackup to do a "user
backup" (versus immediate manual that must be done by the
"administrator" - root I guess) in conjunction with an rman
script to backup the database. Since several of the
filesystems have files owned by both oracle and applmgr,
bprestore has to be run multiple times to restore
subdirectories owned by applmgr into restored directories
owned by oracle. I identified the backup by using the
system date/time as part of the KEYWORD. This made it easy
to for bprestore to find the exact backup I was looking
for when restoring. Oracle can do the same thing using a
"TAG". However, Oracle does not support passing unix
environment variables to an rman command file. The TAG is
hard coded. Only way around this is to have the
script build the command file from a template each time it
is executed, inserting a TAG with date/time matching the
KEYWORD. Then I can run bprestore and rman restore with
KEYWORD matching TAG and ensure both the database and files
are restored from the exact same backup.
What I haven't been able to test yet is deleting backups
from rman and seeing the effect in NetBackup. RMAN creates
"backuppieces" that become files in NetBackup. File name
are based on a mask. Here are some examples from my testing:
df_3_429450256_1
df_2_429450256_1
df_4_429450256_1
df_5_429450256_1
df_1_429450256_1
df_8_429453783_1
ISP01_df_t429520060_s22_p1
ISP01_df_t429520060_s23_p1
ISP01_df_t429520060_s25_p1
ISP01_df_t429520060_s24_p1
ISP01_df_t429520060_s21_p1
I could not see these in NetBackup. Can you see them and
determine how and when they were created? The class for
for oracle backups has INFINITY as expiration date. The
RMAN catalog may be hosed from my testing. Would you be
able to delete these test files via NetBackup if I can
identify them all? There are 45 so far.
Thanks
Bob Remsberg, Database Administrator
ITC, Applications and Data Services Division
University of Virginia 804-243-5962
--- End Forwarded Message ---
|
