重新启动数据库

--需要以dba登录
SQL> conn sys/orcl_chg@ORCL as sysdba;
SQL> $lsnrctl stop;

SQL> alter database backup controlfile to trace;

SQL> alter system switch logfile;

SQL> set head off;
SQL> set feedback off;
SQL> set newpage none;
SQL> spool c:\kill_all_session.sql;
SQL> select 'alter system kill session '''||sid||','||serial#||''';' from v$session where username is not null;
SQL> spool off;
SQL> @c:\kill_all_session.sql; --报异常不要理会
SQL> shutdown immediate;
SQL> $lsnrctl start;

SQL> $sqlplus /nolog

SQL> startup;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25086534/viewspace-682301/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25086534/viewspace-682301/