Code Snippet

Just another Code Snippet site

error

How to Resolve ORA-19809 Limit Exceeded for Recovery Files – Ed Chen Logic

There are five possible solutions to solve ORA-19809: limit exceeded for recovery files: 1) Take frequent backup of recovery area using RMAN. 2) Consider changing RMAN retention policy. 3) Consider changing RMAN archived log deletion policy. 4) Add disk space and increase DB_RECOVERY_FILE_DEST_SIZE. 5) Delete files from recovery area using RMAN. Source: How to Resolve […]

, , , ,

[Oracle] Recover Database from ORA-00333: redo log read error

In development environment, it is very common scenario that we have multiple databases in a single machine by using VMware (i.e, each VMware contains one database). Again those machines doesn’t have consistant power backup. Therefore we have to face power failure or VMware hang-up. So, we are forced to restart the machine while databases are […]

, ,