784786 wrote:No. It is better to take another backup of the same
I have taken export of 2 tables which are huge in volume. one of the table seems to be successfully exported yet another one failed due to space scarcity. Since both the tables share a single dumpfile.
I wanted to know.
1. Can we use the same dumpfile to import the table which is successfull or it can not be used because the second table got error while exporting?
2. Is there any way we can check the validity of dumpfile in unix plateform.Please check the export log backup. If it says that export terminated successfully, then the dump may be fine.
Niket Kumar wrote:Are you sure? really? you could just use import on that dump file into another schema/database and validate. If it is expdp dump, you can use certain builtin procedure that give you information about dump files. This method works on any platform that supports Oracle.
no method is there to check validity of export dump .if logs are ok then export dump is fine.
Niket Kumar wrote:if it is time consuming or not, that is the only true way. No point taking backups if you cannot validate them by restoring them and validating contents. I guess for a business, that time would well worth spent. It is like saying you invested millions in a DR datacenter, but never tried to failover and run your application from there. until you do, even that setup cannot be validated.
never heard of anything to validate export... please share more knowledge or link which you are specifying......
of cource you can validate backups by restoring that is best way but time consuming.....
i thought you are giving info about some PL/SQL procedure which validates exp backup.
If it is expdp dump, you can use certain builtin procedure that give you information about dump files. This method works on any platform that supports Oracle.
Niket Kumar wrote:you dont have to do it daily, but randomly. All good auditors ask that question ... when was the last time you restored a backup, restored from tape and re-created db (or something on those lines). We had to provide log files etc as proof.
so is it good to restore everytime to check validity of database? is it not time consuming?