can't execute force logging? [message #61947] |
Fri, 11 June 2004 16:53 |
Mark
Messages: 284 Registered: July 1998
|
Senior Member |
|
|
I trying to set up a standby db, and I need to set the primary db in force logging mode, but keep coming up with this error? What is missing? It is in archive mode and enabled...
SQL> alter DATABASE FORCE LOGGING;
alter DATABASE FORCE LOGGING
*
ERROR at line 1:
ORA-02231: missing or invalid option to ALTER DATABASE
|
|
|
Re: can't execute force logging? [message #61948 is a reply to message #61947] |
Fri, 11 June 2004 22:02 |
Frank Naude
Messages: 4580 Registered: April 1998
|
Senior Member |
|
|
Hi,
Are you using Oracle 9.2.0? If not, you need to upgrade to 9.2 first, as this command (alter database/tablespace force logging) is only available from Oracle 9i Release 2 onwards.
Best regards.
Frank
|
|
|