聯機熱備份的步驟
2024-07-21 02:36:46
供稿：網友
1 使數據庫處于ARCHIVELOG模式
$svrmgrl
SVRMGR> connect internal
SVRMGR> ALTER DATABASE ARCHIVELOG;
SVRMGR>ARCHIVE log start
SVRMGR>ALTER DATABASE OPEN;
2 獲取最早的聯機日志序列號
SVRMGR> archive log list
3 將要備份的表空間設為熱備份模式
SVRMGR> ALTER TABLESPACE tablespace_name BEGIN BACKUP;
4 使用操作系統命令備份改表空間的datafile
5 取消該表空間的熱備份模式
SVRMGR> ALTER TABLESPACE tablespace_name END BACKUP;
6 如還有其他要備份的表空間，重復3-5
7 強制日志切換
SVRMGR> ALTER SYSTEM SWITCH LOGFILE ;
8 使用os命令備份所有歸檔日志文件
9 備份control file
SVRMGR>ALTER DATABASE BACKUP CONTROL FILE TO 'filespecif' ;
-------------------------------------------------------------------
STARTUP [DBA] [FORCE] [PFILE=filespec] [EXCLUSIVE SHARED]
[MOUNT dbname OPEN dbname] [NOMOUNT]
SHUTDOWN [NORMAL IMMEDIATE ABORT]
MONITOR For graphical modes only, bring up a monitor
ARCHIVE LOG [START] [STOP] [LIST] [NEXT] [] [ALL] ['destination']
RECOVER { [DATABASE [MANUAL] ] [TABLESPACE ts-name [,tsname]] }
CONNECT [username [/passWord] ] [INTERNAL] ['@'instance-spec]
DISCONNECT
SET options: INSTANCE, ECHO, TERMOUT, TIMING, NUMWIDTH, CHARWIDTH
SHOW LONGWIDTH, DATEWIDTH, AUTOPRINT and for SHOW: ALL, SPOOL
EXIT
REM
SQL statements can also be executed.
