ALTER SYSTEM FLUSH REDO TO shsnc_standby;报错 ORA-00922

51 阅读 0 评论 34 点赞

我是靠谱客的博主专注人生，最近开发中收集的这篇文章主要介绍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.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29446986/viewspace-1727355/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29446986/viewspace-1727355/