I am creating a tar.gz of database hot backup files.

During execution of tar command, I am getting this warning for only this file every time I run tar:

/u01/app/oracle/oradata/db5/sysaux01.dbf: file changed as we read it

I intend to perform clones and recoveries of Oracle database using this tar file. Will it cause problems?


As you have said, you are trying to create hot image copy backup for cloning and recovery purposes, it's not the recommended way to take image copy backup. The file may contain fractured blocks-which have been changed during the copy command(tar in your case). The tar command has no intelligence to check whether the block has been changed or not during the archving process resulting broken block known as split or fractured blocks included in the file.

Warning from tar command has spoken the same theme as I mentioned here. The file was being modified by Oracle processes, possibly doing read/write operations, as you said, you were trying to archive these files while the database is up and running.

Instead, if you use RMAN it has the ability to know whether the block is fine or changed by comparing the header and tail of a data block.

Documentation: RMAN Backup Concept/Image Copy Backup

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.