ALTER SYSTEM FLUSH REDO TO shsnc_standby;报错 ORA-00922
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup mount;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 246386688 bytes
Fixed Size 2212208 bytes
Variable Size 188747408 bytes
Database Buffers 50331648 bytes
Redo Buffers 5095424 bytes
Database mounted.
SQL> ALTER SYSTEM FLUSH REDO TO shsnc_standby;
ALTER SYSTEM FLUSH REDO TO shsnc_standby
*
ERROR at line 1:
ORA-00922: missing or invalid option
SQL> ALTER SYSTEM FLUSH REDO TO "shsnc_standby";
ALTER SYSTEM FLUSH REDO TO "shsnc_standby"
*
ERROR at line 1:
ORA-00922: missing or invalid option
解决方案：
SQL> ALTER SYSTEM FLUSH REDO TO 'shsnc_standby';
System altered.
ORACLE instance shut down.
SQL> startup mount;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 246386688 bytes
Fixed Size 2212208 bytes
Variable Size 188747408 bytes
Database Buffers 50331648 bytes
Redo Buffers 5095424 bytes
Database mounted.
SQL> ALTER SYSTEM FLUSH REDO TO shsnc_standby;
ALTER SYSTEM FLUSH REDO TO shsnc_standby
*
ERROR at line 1:
ORA-00922: missing or invalid option
SQL> ALTER SYSTEM FLUSH REDO TO "shsnc_standby";
ALTER SYSTEM FLUSH REDO TO "shsnc_standby"
*
ERROR at line 1:
ORA-00922: missing or invalid option
解决方案：
SQL> ALTER SYSTEM FLUSH REDO TO 'shsnc_standby';
System altered.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29446986/viewspace-1727355/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
