物理dg上查询不到dba_free_space正常吗？

bj-jn

环境描述:oracle 10.2.0.5.0
问题描述：今天巡检dg时突然发现查询不到dba_free_space，这是什么情况，操作过程如下，求解惑？
SQL> show user
USER is "SYS"

SQL> select database_role from v$database;
DATABASE_ROLE
----------------
PHYSICAL STANDBY

SQL>  desc dba_free_space
ERROR:
ORA-04043: object dba_free_space does not exist

SQL> select count(*) from dba_free_space;
select count(*) from dba_free_space
                     *
ERROR at line 1:
ORA-00942: table or view does not exist

SQL> select count(*) from dba_data_files;
  COUNT(*)
----------
        29

Liu Maclean(刘相兵

physical standby处于何种模式下？

做一个errorstack trace出来

bj-jn

Liu Maclean(刘相兵 发表于 2014-12-12 10:43
physical standby处于何种模式下？

做一个errorstack trace出来

刘大你好，之前没怎么用过errorstack，按照网上的操作步骤在udmp文件夹始终无法生产对应的文件，不知道为什么，以下是alert日志中的操作记录：
OS Pid: 15973 executed alter system set events '942 trace name errorstack level 4'
Fri Dec 12 13:31:34 CST 2014
OS Pid: 15973 executed alter system set events ' 942 trace name errorstack off'


Fri Dec 12 13:35:12 CST 2014
OS Pid: 16148 executed alter system set events '942 trace name errorstack forever,level 3'
Fri Dec 12 13:36:38 CST 2014
OS Pid: 16148 executed alter system set events '942 trace name errorstack off'
Fri Dec 12 14:13:42 CST 2014
OS Pid: 16148 executed alter system set events '942 trace name errorstack forever,level 10'
Fri Dec 12 14:14:47 CST 2014
OS Pid: 16148 executed alter system set events '942 trace name errorstack off'

以下是在sqlplus中的操作记录
SQL> alter system set events='942 trace name errorstack forever,level 3';

System altered.

SQL> select count(*) from dba_free_space;
select count(*) from dba_free_space
                     *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> alter system set events='942 trace name errorstack forever,level 3';

System altered.

SQL> alter system set events='942 trace name errorstack forever,level 10';

System altered.

SQL> select count(*) from dba_free_space;
select count(*) from dba_free_space
                     *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> alter system set events='942 trace name errorstack off';

System altered.

bj-jn

Liu Maclean(刘相兵 发表于 2014-12-12 10:43
physical standby处于何种模式下？

做一个errorstack trace出来

刘大 phsical处于MAXIMUM PERFORMANCE模式。