您好,欢迎访问一九零五行业门户网

ORA-16753 错误问题解决

1、使用dgmgrl将数据库设置为只读模式: dgmgrlgt;edit database dg_name set state=read-only; ora-16753 resource guard coul
1、使用dgmgrl将数据库设置为只读模式:
dgmgrl>edit database dg_name set state=read-only;
ora-16753 resource guard could not open standby database
cause:resource guard could not open standby database.
action:check the data guard console log for further details.
2、查看dg日志${bdump}/drc$sid.log记录
可以看到很关键的一条信息:
ora-16006: audit_trail destination incompatible with database open mode
原来如此,通过show parameter  audit_trail,可以看到audit_trail=db。
3、audit_trail参数说明
audit_trail = { none | os | db | db,extended | xml | xml,extended }
db:directs audit records to the database audit trail (the sys.aud$table), except for records that are always written to the operating systemaudit trail. use this setting for a general database for manageability.
if the database was started in read-onlymode with audit_trail set to db, then oracle database internally sets audit_trailto os. check the alert log for details.
详见官网
4、将audit_trail设置为none并重启数据库
alter system set audit_trail=none scope=spfile;
重启以后问题解决。
本文永久更新链接地址:

其它类似信息

推荐信息