| Alter system kill session ‘sid,serial#,@sid_number’ immediate; |
Select * from v$active_instances
2 资源管理
crsctl status resource ora.tjnmmp.db –p
crsctl status res -t -init
crsctl start resource ora.crs.D -init
crs_stat –p resourcename
crs_stat ora.tjnmmp.db -v –t
lsof -p 查看进程打开的文件 来定位log以及trc文件。
Alter system set sql_trace=false;
Alter system set sql_trace=false sid=’*’
Alter system set sql_trce=false sid=‘orcl1’
| Alter database add logfile group 5; --当前实例 Alter database add logfile instance ‘orcl2’ group 6 --- orcl2
Alter system archive log instance ‘orcl2’ Alter system archive log instance ‘orcl2’ current; alter system checkpoint local； alter system checkpoint global； |