All in Oracle database.

Tuesday, July 14, 2009

Errors and Failures Without Requiring Recovery from Backup

Errors and Failures Without Requiring Recovery from Backup
July 15, 2009
Oracle Database RMAN
1. Process Failure
   PMON will automatically perform the process recovery and rollback all involved transactions.
2. Program Failure
   It occurs when data violate the contrains, or data do not meet the data types, and so on, Oracle will automatically raise ORA- errors and Oracle will rollback the transactions automatically, or will wait for program's determination.
3. Instance Crash
   When an instance is shutdown abort or abnormally, SMON will perform recovery automatically(roll forward, then, open the database[uses can access the instance/database at this time], then, roll back the uncommitted transactions) when the instance starts up.

No comments:

Post a Comment