Monthly Archives: April 2011

ORA-27092: size of file exceeds file size limit of the process

Database restore was needed.  SYSADMIN restored the backup to a filesystem.  I mounted the database and started checking the available backups. RMAN> list datafilecopy all; using target database control file instead of recovery catalog List of Datafile Copies Key     File S … Continue reading

Posted in Oracle Database Backup, Oracle Recovery Manager | Tagged , , , | Leave a comment

RMAN block recovery & ORA-600

Recently database alertlog started complaining about the data block corruption. To check the corruption, I’ve used rman> validate database; rman> backup validate check logical database; Then to check the corrupted block queried the database_block_corruption view & check FILE#, BLOCK# columns … Continue reading

Posted in Oracle Recovery Manager | Tagged , | Leave a comment