x

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

OracleApprender gravatar image

OracleApprender
771 70 73 75

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

-Dave

more ▼

answered Dec 23, 2009 at 12:05 PM

dmann gravatar image

dmann
437 1 1 4

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,

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.

more ▼

answered Apr 16, 2011 at 04:42 PM

user-251 (google) gravatar image

user-251 (google)
1

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

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x378
x18
x5

asked: Dec 23, 2009 at 11:41 AM

Seen: 3513 times

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