為確保資料一致性並最小化業務影響,建議遵循以下十步驟:
$ lsnrctl stop
SQL> alter database backup controlfile to trace;
SQL> alter system switch logfile;
set head off; set feedback off; set newpage none; spool /oracle_backup/bin/kill_all_session.sql select 'alter system kill session '''||sid||','||serial#||''';' from v$session where username is not null; spool off;
SQL> @/oracle_backup/bin/kill_all_session.sql
SQL> shutdown immediate; -- 或 SVRMGR> shutdown immediate;
$ lsnrctl start
$ sqlplus /nolog SQL> connect / as sysdba SQL> startup; -- 或使用 svrmgrl $ svrmgrl SVRMGR> connect internal; SVRMGR> startup;