Showing posts with label Enable Archiving on already installed oracle 10g. Show all posts
Showing posts with label Enable Archiving on already installed oracle 10g. Show all posts

Tuesday, 10 January 2012

How to Enable Archiving

Perform the following operation step wise to enable Archiving in Oracle 10g archiving.

1. SQL> startup 
First start oracle to check that oracle is installed or not
2. SQL> shutdown immediate
Shutdown oracle to start in mount state
3. SQL> startup mount;
 Your oracle is now in mount state
4. SQL> alter database archivelog;
Use the above command to alter database to use archivelogs
5. SQL> alter database open;
Use command # 5 to open database