切换grid用户中执行一条命令查询是否可以正常翻滚操作
[grid@rac2:/home/grid]$sqlplus / as sysasm
SQL*Plus: Release 11.2.0.4.0 Production on Mon Jun 12 19:16:08 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> select * from v$disk_group;
select * from v$asm_diskgroup
*
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only
SQL> select * from v$disk_group;
select * from v$asm_diskgroup
*
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only
SQL>
经测试可以在SQL环境中翻滚