How to enable Archive log mode for the database in applications 11i and also to customise the auto-config utility to make the changes permanent or consistent even in future running of autoconfig.

Interview Candidate
Sep 19th, 2007
1
2280

Showing Answers 1 - 1 of 1 Answers

sandeepmohanty

Sep 24th, 2007

Hi ,
you can enable the Archive mode for your database by
    1     SQL>shutdown immediate            (if database is open)
    2  login to your database as sys user or any user with sysdba privilege
           SQL> startup nomount
    3     SQL>alter database archivelog
    4 crosscheck the mode
           SQL>archive log list
NOTE:enable automatic or manual archiving as needed

AUTOCINFIG: please explain about what customizations .you can make any changes using context editor. As i'm not very sure of what you want to know please refer oracle metalink
Doc ID: Note:165195.1
sandeep