You initialize an existing database instance on a local or remote computer using the Database Manager GUI.
When you initialize a database instance, all the data is deleted.
However, you can copy your database parameters and the configuration of your volumes and backup media.
· You have administrator rights for the database instance. This is guaranteed if you log on as the first DBM operator.
· Database instance on a local computer: as an operating system user, you have administrator rights for the computer.
· Database instance on a remote computer: you have an operating system user for the remote computer with administrator rights and also the log on as batch job right (for Microsoft Windows operating systems) or a similar right (information on managing operating system users is provided in the documentation for your operating system).
...
Select the required database instance in the list of database instances.
Choose Instance ® Initialize...
...
Choose Next to start each of the required steps.
1.
Choose Initialize the database
instance <database_name>.
An empty database instance is created under the existing name (the database
instance is initialized and all of the data from the previous version is
lost).
2. If necessary, transfer the database instance to the OFFLINE operational state.
3. Choose Use current parameters.
4. The database parameters you configured for the database instance are proposed. In other words, you do not have to change them.
5. The volumes you configured for the database instance are proposed. In other words, you do not have to change them.
6. The backup media you configured for the database instance are proposed. In other words, you do not have to change them.
7. Choose from the following options:
¡
Create and start instance
Specify the database system
administrator (SYSDBA user). The database instance is initialized and
transferred to the operational state ONLINE.
¡
Create instance
for recovery
The database instance is
initialized and transferred to the ADMIN operational state. You can use this
database instance for a recovery only. The
details for the SYSDBA user are taken from the data backup.
8. Choose Start.
9. Choose Close.