Database Administration (MOSC)

MOSC Banner

Database - no archive mode

edited Aug 24, 2009 1:38AM in Database Administration (MOSC) 8 commentsAnswered
Hi,

In our environment we have 3 instances. One is Production and the other 2 are test instances.

3 instances are in db version:10.2.0.3 and in archive log mode.

Previously we have upgraded from 9.2.0.7 to 10.2.0.3. As in 9.2.0.7 our Production was in archive mode and the test instances was in no-archive mode.

But after upgrade, 3 instances were in archivelog mode, since the log_archice_start parameter is deprecated in 10g.

We would like to make the test instances in no-archive mode.

We'll usually use the addbctl.sh to down and start the database.

Kindly suggest to do the same.

Thanks in advance,

Sathya.S

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center