question

OracleApprender avatar image
OracleApprender asked

How do you put database is ARCHIVELOG mode, explain procedure ?

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.

oraclerecoverylogging
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

dmann avatar image
dmann answered

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).

-Dave

1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thank you for your suggestion. I require it for 9i. I'll try to find it as you suggested.
0 Likes 0 ·
user-251 (google) avatar image
user-251 (google) answered

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,

LOG_ARCHIVE_DEST='PATH'

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.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.