Tuesday, April 29, 2008

How to reset an oracle parameter.

Hello,

Recently I mistakenly set up the log_archive_start=TRUE parameter on a 10g database when switched it into archive log mode. This parameter is obsolete in the 10g.

To erase this parameter from an spfile we can use the following command:
ALTER SYSTEM RESET log_archive_start SCOPE=SPFILE SID='*';


Thanks,
Sergey.

No comments: