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

No comments:

Post a Comment