ORACLE 冷、热备份权威课堂笔记.doc

ORACLE 冷、热备份-QING-查看归档模式SQL archive log list;数据库日志模式 存档模式自动存档 启用存档终点 USE_DB_RECOVERY_FILE_DEST最早的联机日志序列 48下一个存档日志序列 49当前日志序列 49既可以冷备份 热备份如果在非归档模式下，只能做冷备份数据文件SQL select name from v$datafile;NAME-D:ORACLEPRODUCT10.2.0ORADATAORCLSYSTEM01.DBFD:ORACLEPRODUCT10.2.0ORADATAORCLUNDOTBS01.DBFD:ORACLEPRODUCT10.2.0ORADATAORCLSYSAUX01.DBFD:ORACLEPRODUCT10.2.0ORADATAORCLUSERS01.DBFD:ORACLEPRODUCT10.2.0ORADATAORCLEXAMPLE01.DBFD:ORACLETAS1A.DBFD:ORACLETAS1B.DBFD:ORACLETEST1A.DBFD:ORACLETBS1A.DBFD:ORACLETBS1B.DBF日志文件SQL select member from v$logfile;MEMBER-D:ORACLELOG11A.LOGD:ORACLELOG1A.LOGD:ORACLELOG11B.LOGD:ORACLELOG1B.LOG控制文件SQL show parameter control;NAME TYPE VALUE- - -control_file_record_keep_time integer 7control_files string D:ORACLEPRODUCT10.2.0ORADA TAORCLCONTROL01.CTL热备份SQL select file_name,tablespace_name from dba_data_files;FILE_NAME-TABLESPACE_NAME-D:ORACLEPRODUCT10.2.0ORADATAORCLEXAMPLE01.DBFEXAMPLED:ORACLEPRODUCT10.2.0ORADATAORCLUSERS01.DBFUSERSD:ORACLEPRODUCT10.2.0ORADATAORCLSYSAUX01.DBFSYSAUXFILE_NAME-TABLESPACE_NAME-D:ORACLEPRODUCT10.2.0ORADATAORCLUNDOTBS01.DBFUNDOTBS1D:ORACLEPRODUCT10.2.0ORADATAORCLSYSTEM01.DBFSYSTEMD:ORACLETAS1A.DBFTBS1FILE_NAME-TABLESPACE_NAME-D:ORACLETAS1B.DBFTBS1D:ORACLETEST1A.DBFTESTD:ORACLETBS1A.DBFTBS2FILE_NAME-TABLESPACE_NAME-D:ORACLETBS1B.DBFTBS2先控制文件备份SQL alter database backup controlfile to trace;开始备份数据文件SQL alter tablespace system begin backup;复制粘贴结束备份SQL alter tablespace system end backup;恢复非system数据文件恢复还原路径磁盘没有损坏alter database datafile 4 offline;alter database open;还原recover datafile 4;alter database datafile 4 online;磁盘损坏alter database datafile 4 offline;alter database open;还原alter database rename file 路径 to路径 recover datafile 4;alter database datafile 4 online;损坏没备份,但是所有日志文件存在alter database datafile ttt offline;alter database open;还原|alter database create datafile d:ttt.dbf as d:oraclettt.dbf;recover datafile ttt;alter database datafile rrr online;系统表空间alter tablespace system begin backup;alter tablespace system end backup;shutdown;startup;还原|alter database create datafile d:ttt.dbf as d:oraclettt.dbf;alter database rename file 路径 to路径