Archivelog mode

[supergod]

Hi all
Now my company oracle db is NOARCHIVELOG mode.
How do i change it to Archivelog mode if not destroy any data?

[samahit]

If u want to change from no archive to archive log no data will be lost.for details go thru. this following documentation.
To switch a database's archiving mode between NOARCHIVELOG and ARCHIVELOG mode, use the SQL statement ALTER DATABASE with the ARCHIVELOG or NOARCHIVELOG option. The following statement switches the database's archiving mode from NOARCHIVELOG to ARCHIVELOG:

ALTER DATABASE ARCHIVELOG;


Before switching the database's archiving mode, perform the following operations:

Shut down the database instance.

An open database must be closed and dismounted and any associated instances shut down before you can switch the database's archiving mode. You cannot disable archiving if any datafiles need media recovery.

Back up the database.

Before making any major change to a database, always back up the database to protect against any problems.

Start a new instance and mount but do not open the database.

To enable or disable archiving, the database must be mounted but not open.
Switch the database's archiving mode.

After using the ALTER DATABASE command to switch a database's archiving mode, open the database for normal operation. If you switched to ARCHIVELOG mode, you should also set the archiving options--decide whether to enable Oracle to archive groups of online redo log files automatically as they fill.

For enabling automatic archive mode channge it in parameter file.
LOG_ARCHIVE_START=TRUE

Hope this will solve the things u required.

samahit

[rohitsn]

Hi,
In order to change the database mode from ARCHIVELOG to NONARCHIVELOG mode perform the following steps:

1) Shutdown the database
2)Take a cold database backup of all the
datafiles,controlfiles,logfiles(if possible,recommended)
3) In init.ora parameter file add the following parameters
LOG_ARCHIVE_START=true
LOG_ARCHIVE_DEST=
LOG_ARCHIVE_FORMAT=orcl%s_T%t.arc

%T = Thread Number,left zero padded
%t = Thread number,not padded
%S = Log sequence number,left zero padded
%s = Log sequence number,not padded

4) Start the instance and mount the database(dont open it) and at Server Manager enter the follwowing command
SVRMGR> alter database archivelog;

5)Open the database
SVRMGR>alter database open;

6)Check it whether archivelog is set or not with the follwing 2 queries:
sql>select * from v$database;
svrmgr>archive log list

In case of any help please be free to ask me at rohitsn@altavista.com

Regards,
Rohit Nirkhe,Oracle DBA,OCP 8i
rohitsn@altavista.com