Page Space Error

Last week we created a second database in our test server. Suddenly we encountered the following errors in the alert file of both the database.

ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3

Solution

Check for the page size.

$ lsps -a

It was 97% used. We increased the page space and the problem is solved.

Thanks.

Restore Vs Recovery

Restore

Restore means using the backup files to replace the original files after a media failure.

Recovery

Recovery means bringing the database up to date using the restored files, archive logs and online redo logs.

Thanks

Crash Vs Instance Recovery

Crash Recovery Vs Instance Recovery

When the instance suddenly fail due to power outage or issuing shut abort, the instance requires recovery during next startup. Oracle will perform crash recovery up on restarting the database.

Crash Recovery involves two steps Cache recovery and transaction recovery.

Cache Recovery (Roll Forward) : The committed and Uncommitted data from the online redolog files are applied to the datafiles.

Transaction Recovery (Roll Back): The uncommitted data are rolled back from the datafiles.

In an RAC environment, one of the surviving instance performs the crash recovery of failed instance. This is known as instance recovery. In a single instance database, crash recovery and instance recovery are synonymous.


Thanks