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

SQL query to find whether OdiSendMail is configured or not ODI 12c

In the SQL developer connect to the ODI work repository user (Ex: DEV_ODI_REPO) and run the below query. select SCEN_NAME,TASK_NAME3,DE...