|
使数据库处于ARCHIVELOG模式 $svrmgrl SVRMGR> connect internal SVRMGR> ALTER DATABASE ARCHIVELOG; SVRMGR>ARCHIVE log start SVRMGR>ALTER DATABASE OPEN; 获取最早的联机日志序列号 SVRMGR> archive log list 将要备份的表空间设为热备份模式 SVRMGR> ALTER TABLESPACE tablespace_name BEGIN BACKUP; 使用操作系统命令备份改表空间的datafile 取消该表空间的热备份模式 SVRMGR> ALTER TABLESPACE tablespace_name END BACKUP; 如还有其他要备份的表空间重复 强制日志切换 SVRMGR> ALTER SYSTEM SWITCH LOGFILE ; 使用os命令备份所有归档日志文件 备份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 tsname [tsname]] } CONNECT [username [/password] ] [INTERNAL] [@instancespec] 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 |
