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博客 ” ,链接:http://blog.itpub.net/29446986/viewspace-1727355/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29446986/viewspace-1727355/
最后
以上就是专注人生最近收集整理的关于ALTER SYSTEM FLUSH REDO TO shsnc_standby;报错 ORA-00922的全部内容,更多相关ALTER内容请搜索靠谱客的其他文章。
本图文内容来源于网友提供,作为学习参考使用,或来自网络收集整理,版权属于原作者所有。
发表评论 取消回复