We are having the following problem trying to restore production databases. It appears that all our backups are non-retrievable because of this problem. Basically if the backup fileset is given a 16 digit identifier we can't restore it. Any ideas would be most appreciated!!
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.
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.
