If anyone knows the procedure to put the database in ARCHIVELOG mode then please explain me the procedure. I would be very much thankful to them. Thank you.
Answer by user-251 (google) ·
1)Check whether database is in ArchiveLog or Noarchive , SQL>archive log list
2)If it is in NoArchive log fllow below steps to enable database into ArchiveLog
3)To set a single location for ARchiveLogs open Parameter file and set the following parameter,
4)Start database in Mount state 5)Here also you can check about the mode of Database
SQL>select log_mode from v$database;
6)To bring database to Archivelog mode
SQL>alter database archivelog;
To bring database to Noarchivelog mode SQL>alter database noarchivelog;
7)Finally Open the database.
Answer by dmann ·
Instead of rehashing and possibly getting something wrong, it is all outlined in the Database Administrators Guide documentation Changing the Database Archiving Mode. (This is for 10g, see appropriate Database Administrators Guide for your version if you are using something different).