脚踏实地、勇往直前!
全部博文(1005)
发布时间:2019-02-27 17:03:50
dg环境从库报错:ORA-00338: log 5 of thread 1 is more recent than control fileORA-00312: online log 5 thread 1: '/u01/app/oracle/oradata/slnngkdg/stdbyredo05.log'Wed Feb 27 16:48:39 2019RFS[2]: Selected log 4 for thread 1 sequence 580 dbid -882553477 branch 994182077Wed Feb 27 16:48:39 2019Archi.........【阅读全文】
发布时间:2019-02-21 09:16:53
需求:因为端口调整,需要改变副本的备份集1.查看当前的副本集信息[root@localhost bin]# ./mongo 192.168.1.134:10001repltest:PRIMARY> use adminrepltest:PRIMARY> db.auth("sa","123456")repltest:PRIMARY> rs.config(){ "_id" : "repltest", "version" .........【阅读全文】
发布时间:2019-01-04 16:54:25
1.数据库开启审计alter system set audit_trail=db,extended scope=spfile;shutdown immediatestartup2.对某个表进行审计connect / as sysdbaSQL> show user;USER is "SYS"SQL> audit select table by hxl by session;Audit succeeded.以上语句执行后在 dba_stmt_audit_opt 视图会有相应的记录SQL> set line.........【阅读全文】