Home » RDBMS Server » Server Administration » how to change database archieve mode or non archieve mode
how to change database archieve mode or non archieve mode [message #54280] Fri, 08 November 2002 06:47 Go to next message
Gurdeep Singh
Messages: 64
Registered: October 2002
Member
how to change database archieve mode and non archieve mode.

Report message to a moderator

Re: how to change database archieve mode or non archieve mode [message #54281 is a reply to message #54280] Fri, 08 November 2002 07:59 Go to previous message
B
Messages: 327
Registered: August 1999
Senior Member
ALTER DATABASE ARCHIVELOG

ALTER DATABASE NOARCHIVELOG

Database should MOUNT not OPEN

Don't forget to start ARCH and define init.ora like log_archive_dest, log_archive_start, log_archive_format

Report message to a moderator

Previous Topic: dB crash/restore problem
Next Topic: PROBLEM WITH UTL_FILE
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 16:31:59 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.