Creating a Secondary Database from an Online Backup of a Primary Database

An online backup of a primary database that is restored and recovered while it still has a primary database role results in a journal timestamp mismatch when the database is started in a secondary database role following the backup recovery.

To create a secondary database from an online backup of a primary database:

1. Restore the backup on the secondary host.

2. Restore the journals that would be required to recover the online backup to the secondary current journals subdirectory (only the first journal is actually required).

3. Start the secondary database server.

The secondary database initialization logic handles starting up from an online backup and takes the necessary steps to ensure that backup recovery is conditioned correctly for a secondary database role. (Secondary database backup recovery differs from the backup recovery for a primary database.)