ORA-19755 ORA-19750 ORA-27037

While I was recovering the production database backup in staging environment. I got the below errors.

ORA-19755: could not open change tracking file
ORA-19750: change tracking file: ‘/u02/oradata/test/ofsap_blk_change.dbf’
ORA-27037: unable to obtain file status

This error occurred because “The block change tracking file got deleted or the file is not backed up”. The block change tracking file is mainly used to speedup the backup processes. We can disable this and proceed further.

Solution :-

alter database disable block change tracking ;

recover database;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s