Database Reference
In-Depth Information
e xeRCiSe 1.1 (continued)
5. Next, shut down the database in a consistent manner with the SHUTDOWN IMMEDIATE
command:
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
6. Now mount the database with the STARTUP MOUND command:
SQL> startup mount;
ORACLE instance started.
Total System Global Area 418484224 bytes
Fixed Size 1333592 bytes
Variable Size 348128936 bytes
Database Buffers 62914560 bytes
Redo Buffers 6107136 bytes
Database Mounted.
7. Put the database in ARCHIVELOG mode with the ALTER DATABASE ARCHIVELOG
command:
SQL> alter database archivelog;
Database altered.
8. Open the database for operations:
SQL> alter database open;
Database altered.
9. Make sure the database is in ARCHIVELOG mode:
SQL> Select log_mode from v$database;
LOG_MODE
------------
ARCHIVELOG
10. It is a good idea to make sure that everything is configured correctly and that the
archived redo logs are getting generated in the place where you expect them to
be generated. So, first you will force an archive-log switch with the ALTER SYSTEM
Search WWH ::




Custom Search