1.创建standby控制文件
SQL> alter database create standby controlfile as '/tmp/c.ctl';
alter database create standby controlfile as '/tmp/c.ctl'
*
ERROR at line 1:
ORA-07446: sdnfy: bad value '/oracle/admin/oradb54/udump' for parameter
user_dump_dest.
2.检查udump参数
SQL> show parameter dump
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_core_dump string partial
background_dump_dest string /oracle/admin/oradb54/bdump
core_dump_dest string /oracle/admin/oradb54/cdump
max_dump_file_size string UNLIMITED
shadow_core_dump string partial
user_dump_dest string /oracle/admin/oradb54/udump
3.检查该目录是否存在
$ cd /oracle/admin/oradb54/udump
ksh: /oracle/admin/oradb54/udump: not found.
4。创建udump目录
$ mkdir udump
5.创建成功
SQL> alter database create standby controlfile as '/tmp/c.ctl';
Database altered.
从以上可以看出,客户在建库的时候没有建立udump目录,但数据库能起来,但ORACLE在产生跟踪文件的时候就会报错
SQL> alter database create standby controlfile as '/tmp/c.ctl';
alter database create standby controlfile as '/tmp/c.ctl'
*
ERROR at line 1:
ORA-07446: sdnfy: bad value '/oracle/admin/oradb54/udump' for parameter
user_dump_dest.
2.检查udump参数
SQL> show parameter dump
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_core_dump string partial
background_dump_dest string /oracle/admin/oradb54/bdump
core_dump_dest string /oracle/admin/oradb54/cdump
max_dump_file_size string UNLIMITED
shadow_core_dump string partial
user_dump_dest string /oracle/admin/oradb54/udump
3.检查该目录是否存在
$ cd /oracle/admin/oradb54/udump
ksh: /oracle/admin/oradb54/udump: not found.
4。创建udump目录
$ mkdir udump
5.创建成功
SQL> alter database create standby controlfile as '/tmp/c.ctl';
Database altered.
从以上可以看出,客户在建库的时候没有建立udump目录,但数据库能起来,但ORACLE在产生跟踪文件的时候就会报错