INSTALLATION DOCUMENTS BY RAVI

Saturday, May 5, 2018

Enabling archive mode in oracle database

Connect to the database as below










Check whether archive log mode is enabled or not as below






It shows there is no archive log mode

To enable archive log mode, follow the below steps

Shutdown the database





Start the database in mount







Alter the database to archive log mode





Open the database




Check for archive log mode








No comments:

Post a Comment

Loading xml file data to oracle table using python

Sample xml file (test.xml): <?xml version="1.0"?> <data>     <customer name="Ravi" >     ...