开发者

Validate Oracle dmp

I have a Oracle backup done开发者_StackOverflow中文版 with EXP utility.

How can I validate it? Is there any command/tool to validate the backup archive?

Thank you!


You can run:

imp file=xxx.dmp show=Y full=y userid=user@db

This will list the contents of the export file without actually doing any actual import operations. I would assume that if the import utility could make sense of the export file, then it's a valid export file.

EDIT:

"Validate" is a vague term. I have made the assumption that what you want is a tool to make sure the file can be imported at some point in the future. This should do that. If you're looking for something more, like a sanity or consistency check on the actual data, I know of nothing other than to do the export with CONSISTENT=Y, which will give you a read-consistent view of the data as of the time the export started.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜