Tuning instance recovery performance

[Laquan]

We have a database server for our small organization was running very smoothly,I was taking backup of database weekly but we are facing some problem regarding restoration. one day I feel when performing recovery operation , it is taking so much time to restoration and recovery of database. As I mentioned you above,this is small organization with small amount of data.Please suggest me to tune my database server.

[Praetor]

If a database running with an instance and has been failed because of some
disturbance like power failure or network failure then Oracle database performs instance recovery automatically at the next startup.
If more than instance is running and one of the instance has been crashed then the surviving instance will perform the crash recovery operation.

The instance recovery takes two phases to complete:
Oracle applies all redo logs for effected data blocks and in the second phase database applies the content of rollback segments for undo changes made by uncommitted transactions in data blocks.

[Katty]

There are some parameters used to influence the performance of instance and crash recovery of the database.
You can check the values of those parameters to ensure the efficiency of your database performance using SQL>show parameter command.This statement will show you all the parameter that are currently configured for database, its the read only property of database.You can't change the values of the parameter here.
To change the value,you need to refer the parameter file of database.

[kelfro]

There are so many ways to tune the duration of instance and crash recovery which is discussed here:

* Use of initialization parameter to influence the unit of redo log record and data blocks that is being used in the recovery operation.
* Resizing of redo log files that enforce the checkpoint.
* Use ALTER....,SQL statement to influence the checkpoint manually.

[Zecho]

These are some parameter which influence the checkpoint for tuning of database :

1. LOG_CHECKPOINT_TIMEOUT: You can set this parameter for duration of checkpoint .

2. FAST_START_IO_TARGET : It limits the instance recovery time to control the use of data block units during instance recovery.