Creating a Nonstandby Database from Shadow Copies

Use this procedure to create a nonstandby database from shadow copies.

This section assumes that you are duplicating the database on a host with the same file system structure as the primary database.

To create a nonstandby database from shadow copies:

1. Restore the database on the new host.
2. Start a SQL*Plus session on the duplicate database and obtain the DBID. You can query the DBID as follows:

   SELECT DBID FROM V$DATABASE;
   

3. Shut down the database consistently. You can shut down the database as follows:

   SHUTDOWN;
   

4. Use the DBNEWID utility to change the DBID.
5. Open the database.
6. Start a SQL*Plus session on the duplicate database and query the DBID. You can query the DBID as follows:

   SELECT DBID FROM V$DATABASE;

   See Also:

   Oracle Database Utilities for information about how to use DBNEWID