-
We have a number of databases on version 7.3.4.3 and back them up using ebu and tivoli storage manager. When backing them up all the logs look fine (hot backups) but when we run ebu_tool all of the files are reported as being removed from the media.
The archive logs have been backed up and removed but when we try and restore, ebu reports that the backup fileset cant be found. We use a repository and I can see the fileset in the OBK_BFS table. I don't know anything about these tables but it has a status of D. Can anyone dust down the the old grey cells and come up with any ideas?
Fraze
P.S AIX 4.3.3
-
Is there any expiration parameter that you have set in your tivoli backup server/client that would expedite the files ...
Sam
Thanx
Sam
Life is a journey, not a destination!
-
to my knowledge nothing has changed from the client setup. The last restore we did was on the 10th and that worked fine. Very strange
-
Did you check whether first whether the backup is reaching your tape storage? Do you have any batch scripts that would do the clean up part> If so did you check them?
Sam
Thanx
Sam
Life is a journey, not a destination!
-
We've just run the backup part of the scripts without any housekeeping etc and are getting the same problem. It does appear that the files are reaching the tapes - we just can't seem to get them back!
-
Some further info: - it appears the EBU cant handle 16 digit BFS identifiers:
From the log of the backup we get the following message:
Starting BFS "1106401000912925" on 19-SEP-01 16:23 (50.008 MB)
"/ORA/oradata/IGRL/tools01/toolsIGRLaaa.dbf" for 50.008 MB
Finished BFS "1106401000912925" (11 secs, 4.546 MB/s) on 19-SEP-01 16:23
Issuing Statement: ALTER TABLESPACE "TOOLS" END BACKUP;
Statement processed.
Issuing Statement: ALTER TABLESPACE "USER_DATA" BEGIN BACKUP;
Statement processed.
Note the BFS number is 16 digits.
When running ebutool -db_name=IGRL -bfslist we get the following:
WARNING, BFS 110640100091292 has been removed from Media
Note this is the same BFS but only 15 digits i.e missing the last 5.
On the EBU.OBK_BFS table the BFSNAME is the same as the 16 digit number.
Also the BFS numbers have only recently changed from 15 digits to 16 digits when doing the backups for one particular database. The backups that where given 15 digit numbers are recoverable but these are now over a week old.
dbhotarchdelparIGRL.070901.log: Starting BFS "108899999892279" on 07-SEP-01 21:40 (0.240 MB)
dbhotarchdelparIGRL.070901.log: Starting BFS "108915999895213" on 07-SEP-01 21:40 (382.188 MB)
dbhotarchdelparIGRL.090901.log: Starting BFS "1091851000063824" on 09-SEP-01 20:30 (100.008 MB)
dbhotarchdelparIGRL.090901.log: Starting BFS "1091861000063825" on 09-SEP-01 20:30 (500.008 MB)
i.e. we can recover from the backup taken on the 7th Sep but not the one from 9th Sep.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|