LOGGING ONLINE ARCHIVE ON begins the online archive process.
Use this statement for cluster archives.
where:
|
Syntax Element |
Description |
|
database |
Indicates the database that is included in online archive logging |
|
ALL |
[Optional] Indicates that the specified database and all of its child databases are included in the statement |
|
databasename.tablename |
Indicates the table and database that is included in online archive logging |
|
EXCLUDE |
[Optional] Specifies the databases that are excluded from the statement |
|
NOSYNC |
Enables online archive on all tables involved in the archive but does not require all tables to be enabled before access to those tables is allowed. Tables blocked during initial enabling request are retried as individual requests; as a result, those tables will have different sync points. As each table or group of tables is enabled for online logging, it becomes available for access by other jobs. |