Showing posts with label archive log. Show all posts
Showing posts with label archive log. Show all posts

Thursday, 16 May 2013

Change The Database Into Archive Log Mode

Change The Database Into Archive Log Mode



STEPS ARE:–

1.CHECK THE DATABASE ARCHIVE LOG MODE BY

ARCHIVE LOG LIST

2.FOR ENABLING ARCHIVE MODE.

ALTER DATABASE ARCHIVE LOG

3. FOR ENABLING ARCHIVAL OF ARCHIVE LOG AUTOMATICALLY.

ALTER SYSTEM ARCHIVE LOG START.

4.FOR DISABLING ARCHIVAL OF ARCHIVE LOG AUTOMATICALLY.

ALTER DATABASE ARCHIVE LOG STOP.

5.AND CHECK THE ARCHIVE PARAMTERS BY

ARCHIVE LOG LIST