Configuring an Archive Database

Use create archive database to create an archive database.

See the Reference Manual: Commands.

• Sizing the Modified Pages Section
  The modified pages section stores modified or newly allocated database pages.
• Increasing the Amount of Space Allocated to the Modified Pages Section
  Use alter database to add space to the modified pages section of the archive database.
• Materializing an Archive Database
  An archive database is a placeholder that is useful only once it has been loaded with a database dump: the load process does not actually copy pages, however, it materializes the database using page mapping.
• Bringing an Archive Database Online
  Use online database to bring an archive database online. online database performs undo recovery during which modified and allocated pages may be remapped to the modified pages section.
• Loading a Transaction Log into an Archive Database
  When you load a transaction log into an archive database, load tran runs the recovery redo pass. Modified and new database pages are written to the permanent changes segment.
• Dropping an Archive Database
  When dropping an archive database, all the rows for that database are deleted from the sysaltusages table in the scratch database. This requires log space in the scratch database.