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.

more ▼

asked Dec 23, 2009 at 11:41 AM in Default

avatar image

771 73 75 79

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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


more ▼

answered Dec 23, 2009 at 12:05 PM

avatar image

437 2 3 8

Thank you for your suggestion. I require it for 9i. I'll try to find it as you suggested.

Dec 23, 2009 at 12:52 PM OracleApprender
(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Apr 16, 2011 at 04:42 PM

avatar image

user-251 (google)

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Dec 23, 2009 at 11:41 AM

Seen: 4674 times

Last Updated: Dec 26, 2009 at 02:08 PM

Copyright 2017 Redgate Software. Privacy Policy