question

jhunu avatar image
jhunu asked

How can I confirm whether my Backup file is usable or not ?

I have created a backup File. How can I confirm whether my Backup file is usable or not ?
oracle11g
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

salum avatar image
salum answered
you can use restore with verifyonly option to check backup file. here is more details http://www.mssqltips.com/sqlservertip/1093/verifying-backups-with-the-restore-verifyonly-statement/
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

This is a question toward Oracle, if you go by how the OP tagged the question.
1 Like 1 ·
Shawn_Melton avatar image
Shawn_Melton answered
You can find the answer in Oracle's documentation: [Validating Database Files with BACKUP VALIDATE][1] [1]: http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmvalid.htm#CHDCEHFD
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ramesh 1 avatar image
ramesh 1 answered
use this script RESTORE verifyonly from disk = 'C:\Database\TfsIntegration.bak' ---full path with file name of backup file RESTORE filelistonly from disk = 'C:\Database\TfsIntegration.bak'---full path with file name of backup fil
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Again, the OP is referring to Oracle, not SQL Server.
1 Like 1 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.