Manual mode (Using CREATE SHADOW)

Go Up to Auto Mode and Manual Mode (Using CREATE SHADOW)

The MANUAL keyword directs the CREATE SHADOW statement to create a shadow in manual mode:

CREATE SHADOW 1 MANUAL 'employee.shd';

Manual mode is useful when continuous shadowing is more important than continuous operation of the database. When a manual-mode shadow becomes unavailable, further connections to the database are prevented. To allow database connections again, the database administrator must remove the old shadow file, delete references to it, and create a new shadow.