Using Instance Manager to enable archivelog mode
- After you've shut down and backed up your database, it's time to put it into archivelog mode. To use Instance Manager, start by logging on as SYSDBA. Enter
SYSTEM
for the username, MANAGER
for the password, and COIN
for the service. Then click the Connect as drop-down list box.
- The drop-down list will give you the choice between a normal connection and connecting as either SYSDBA or SYSOPER. Click SYSDBA to select it.
- Now that all your connection information has been entered, go ahead and click OK to connect.
- This is Instance Manager's opening screen. Click the Database icon to check the current status of the database.
- As you can see, the database is currently shut down. It needs to be mounted to change the archivelog mode, so click the Mounted radio button to select that state.
- Now, click the Apply button to apply your change and mount the database.
- Here, Instance Manager is asking you where it should look for the database initialization parameters. Normally, you would need to browse and find your initialization file. For this simulation, just accept the default choice by clicking OK.
- While Instance Manager mounts the instance, this progress window will display. Click anywhere in the image to advance past this window.
- Finally, Instance Manager will display this confirmation dialog. Press OK to continue.
- The instance is now mounted. To place it into archivelog mode, click the Database drop-down menu.
- Note that the box next to the Archive Log menu item is not checked. Click that item to check the box, telling Instance Manager that you want
archivelog mode enabled.
- Instance Manager will display this confirmation dialog. Go ahead and click Yes.
- Instance Manager will ask if you want automatic archival enabled. For this simulation, click No.
- Instance Manager will display a confirmation that the archiver process was not started. Click the OK button to continue.
- You will now be returned to the Instance Manager window. Click the Database menu one more time to confirm that the database is indeed in
archivelog mode.
- Notice that now the Archive Log box is checked, indicating that the database is now running in archivelog mode. The last thing that you need
to do is to open the database. Click the Open radio button to indicate that you want to open the database.
- Click the Apply button to open the database.
- Instance Manager will ask you to confirm your intention to open the database. Click the Yes button to continue.
- The database will be opened, and Instance Manager will display this confirmation. Click OK to continue.
- The database is now open.