You will receive ORA-19755 under following circumstances
1. When moving the Change tracking file
2. During Database Recovery
3. During Database startup
The reason is due to missing or corrupted Block change tracking file.
Errors during database startup
ORA-19755: could not open change tracking file
ORA-19750: change tracking file: '+DATA/testdb/changetracking/ctf.411. 5567291'
ORA-17503: ksfdopn:2 Failed to open file +DATA/testdb/changetracking/ctf.411.5567291'
ORA-15012: ASM file '+DATA/testdb/changetracking/ctf.411. 5567291' does not exist
Errors during Recovery:-
RMAN-03002: failure of recover command at 05/05/2009 08:13:29
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile ‘/oradata/testdb/flash_recovery_area/archivelog/arch_1_532_432353.arc‘
ORA-00283: recovery session canceled due to 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
Solution:-
Disable Block change tracking and perform recover and enable the tracking.
Click here learn Enable/Disable and moving the Block change tracking file
Regards,
Satishbabu Gunukula
http://www.oracleracexpert.com/
Subscribe to:
Post Comments (Atom)
One of the questions that I always come across as a DBA is what % of data is changing in the database on a daily basis. I often wonder if I can use v$block_change_tracking and v$backup_database views to get this details. I do take level 0 image copy backups over the weendend and then take a level 1 backup daily (which I then merge with level 0). What SQL statement can I use to get this info which shows % block changes. Thank you for the wonderful post.
ReplyDelete2gb micro sd karte
You write really great i must say.
ReplyDeleteAbout Independence Day in Malayalam