Oracle database backup and recovery - Explain how to put a database into
ARCHIVELOG mode posted by
Babu Kunwar
Explain how to put a database into ARCHIVELOG mode
To make use of the ARCHIVELOG capability, the database must first be placed in
ARCHIVELOG mode. The following listing shows the steps needed to place a
database in ARCHIVELOG mode.
Run SQLPLUS and mount the database.
Then alter it as shown here:
SQL> connect system/manager as sysdba
SQL> startup mount mydb;
SQL> alter database archivelog;
SQL> alter database open;
Here mydb is database name.
Further if we want to see the current archive log execute the following command
from SQLPLUS.
Archive log list;
The following command will display the current ARCHIVELOG status of the
database from within SQLPLUS.
More links
What is the Oracle Web Cache?
Difference between the Database and Web Cache
Explain how to install and configure the Web Cache
Explain how to stop and start the Web Cache...............
|
