11-06-2017 04:59 AM
Good morning.
I hope you can help me.
We are use a Vault system to tapes, these tapes are a secondary backup of a primary backup.
The primary backup expires in 6 months, but the vaults expire in 10 years.
The primary backups from Oracle's databases are make with RMAN and in netbackup policy we executes a script that launches the RMAN processes.
The Primary backup is copied to tape, and this tapes stay inside the robot, the secondary backup is a duplicated from de primary Copy, this second copy is saved into a tape and carrie on to another location.
A database's backup are approximately between 8 and 12 tapes.
When we need to restore a backup older than 6 months, we have to use the Vault tapes.
RMAN requests the ID_Tape from the primary copy.
We need to know if there is any command that tells us which copy of Vault is relevant to that primary ID_Tape.
for example:
Primary backup tapes Vault tapes
LTOBD123 LTOBD800
LTOBD153 LTOBD567
LTOBD238 LTOBD999
LTOBD279 LTOBD545
knowing the date of the backup, the ID_TAPES of the primary copy, and the name of the client, how can I get the list of respective Vault tapes?
Thank you very much for the help!
Solved! Go to Solution.
11-07-2017 11:56 PM - edited 11-07-2017 11:57 PM
My 2c:
There is no 1-to-1 relation between copy1 tapes and vault tapes.
Vault duplication copy images to a destination STU and pool.
It is therefore possible that the images on LTOBD123 will not be identical to images on LTOBD800.
Before copy 1 images expire, bpimagelist -L will show copy 1 and copy 2 media id's.
After copy 1 has expired, copy 2 automatically becomes the primary copy and information about tape used for copy 1 is removed from the image database.
After the 6 months when copy 1 tapes have expired, you can use bpimagelist command to list the tapes for the Oracle backups. Something like:
bpimagelist -client clientname -d mm/dd/yyyy -e mm/dd/yyyy -media -pt Oracle -U
(where -d is start-date and -e is end-date)
Please note that -e is note the date when the policy ended.
The -d and -e options will give a list of all Oracle backups started during the period.
HTH
11-07-2017 11:17 PM
no one knows?
11-07-2017 11:56 PM - edited 11-07-2017 11:57 PM
My 2c:
There is no 1-to-1 relation between copy1 tapes and vault tapes.
Vault duplication copy images to a destination STU and pool.
It is therefore possible that the images on LTOBD123 will not be identical to images on LTOBD800.
Before copy 1 images expire, bpimagelist -L will show copy 1 and copy 2 media id's.
After copy 1 has expired, copy 2 automatically becomes the primary copy and information about tape used for copy 1 is removed from the image database.
After the 6 months when copy 1 tapes have expired, you can use bpimagelist command to list the tapes for the Oracle backups. Something like:
bpimagelist -client clientname -d mm/dd/yyyy -e mm/dd/yyyy -media -pt Oracle -U
(where -d is start-date and -e is end-date)
Please note that -e is note the date when the policy ended.
The -d and -e options will give a list of all Oracle backups started during the period.
HTH
11-08-2017 04:39 AM
I know that command.
But the problem is that more than 100 tapes are recorded in a week. So determining which tapes are vaulting and which tapes are normal backups is difficult.
Now we have an EXCEL record with that information, but I was wanted to automate the process with some report or something similar.
I think after reviewing and reading the documentation, at least for the moment it is not possible!
thank you very much for your reply.
11-08-2017 03:00 PM
NBU actually has a Vault option, although it is a licensed feature (so not free).
You may wish to consider this if possible, it would make your life lot easier - NBU Vault has the abiity to make duplications, run 'vault' catalog backup and eject tapes. It automatically tracks tapes, and will notify which tapes need to be recalled once they expire.
11-09-2017 03:18 AM
Actually what Marianne suggested can work with a little more effort to script the bpimagelist and other commands.
A vaulted tape has additional attributes such as:
- vaulted date
- offsite volume group
So from bpimagelist output you can get the list of tapes for a single image, then using the list perform "vmquery -m" to get the above attributes and you will be able to tell which tapes are vaulted.
11-09-2017 05:17 AM
I think I understand what @Gadit is asking -
The issue is with RMAN that stores the media id's of the 1st copy.
The problem is that when copy 1 expires, RMAN still only knows about copy 1 media-id.
This is why the request is for a 'utility' to map copy1-media-id to copy2-media-id.
In my view, this is not possible as there is no one-to-one relation between copy1 and copy2 tapes.
Copy1 image for a particular day may be appended to a previous day's tape that continued onto another tape, while the duplicate may have fitted onto a single tape.
Best would be to script bpimagelist proactively to list all copy1 and copy2 tapes for each image done on a daily basis, or else when a restore is needed after copy1 has expired, run bpimagelist -media to list tapes needed for restore.
I'm pretty sure that is what most other users do with duplicated RMAN tapes.
11-09-2017 06:09 AM
I knew that this topic came up many times over the years - even before there were Symantec/Veritas forums.
All with no easy solution:
11-09-2017 07:50 AM
Exactly Marianne!
The problem is with RMAN, because RMAN only knows the copy 1.
if the copy 1 expires RMAN doesn't know what is the equivalent Vault's tapes.
However, when RMAN tells to NETBACKUP "I need this tape!, NETBACKUP tell me; give me this vaulting tape"
if the vault is 1 single tape, there is no problem, but when there are 10 tapes, RMAN requests one tape at a time, and until the first tape is not available, it doesn't ask for the second tape.
I can't call the storage guy 10 times to look for 10 tapes for only one restore. :(
if I look for the tapes by date. the listing returns all the vault tapes from this date, approximately 30 tapes.
so I try to select by date, client and by copy 2 but I can not get the list I need.