1：热备份：
1 SHUTDOWN IMMEDIATE; 2 STARTUP MOUNT; 3 alter database archivelog; 4 --ALTER SYSTEM SET LOG_ARCHIVE_START=TRUE SCOPE=SPFILE; 5 6 ALTER SYSTEM RESET log_archive_start SCOPE=SPFILE SID='MyOrcl'; 7 ALTER DATABASE OPEN; 8 ALTER TABLESPACE USERS BEGIN BACKUP; 9 HOST COPY G:appzhaobinoradataMyOrcl*.dbf G:BAK; 10 ALTER TABLESPACE USERS END BACKUP; 11 ALTER SYSTEM SWITCH LOGFILE;
2：热备份恢复：
1 ALTER DATABASE DATAFILE 4 OFFLINE DROP;//让这个出故障的文件暂时先脱机 2 ALTER DATABASE OPEN;//打开数据库 3 HOST COPY G:BAK*.dbf G:appzhaobinoradataMyOrcl//将前面备份的文件拷贝到系统目录中 4 RECOVER DATAFILE 6;//这一步，偶尔会出错，无法正确执行，而且无法正常关闭数据库，请如此这般 5 6 操作，SHUTDOWN ABORT; STARTUP; 7 ALTER DATABASE DATAFILE 6 ONLINE;