Applying AI files

P

pinne65

Member
In the roll forward script we are using there's a final -i (skip integrity or something) option to the _rfutil roll forward command. While applying the AI files the following messages are displayed:

** This session is being run with the no-integrity (-i) option. (512)
Rolling forward with the no-integrity (-i) option will require restarting from a backup in the event of a failure! (10577).

What does this mean. Why wouldn't you want to check the integrity?
(I couldn't find a description of the -i option in my db admin manual, 10.1B)

Anyway, I remvoed the -i, restored my backup and reapplied the AIs again without getting the message and the database came up OK again.

TIA for any input!
 
-i means "no integrity".

There is a popular myth that -i eliminates writes to the bi file. This is false. All bi notes continue to be written but the IO mode is changed so that IO ops complete faster. The downside to "faster" is "less robust". If the db crashes while -i is in effect then the db is not recoverable.

It speeds things up when you are in a situation that you can easily restart. For instance I often use it on the load side of a dump & load.

You should never use it for actual production processing.
 
You must log in or register to reply here.
Back
Top