oracle 冷、热备份权威课堂笔记

《oracle 冷、热备份权威课堂笔记》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、ORACLE冷、热备份---QING----查看归档模式SQL>archiveloglist;数据库日志模式存档模式自动存档启用存档终点USE_DB_RECOVERY_FILE_DEST最早的联机日志序列48下一个存档日志序列49当前日志序列49既可以冷备份热备份如果在非归档模式下，只能做冷备份数据文件SQL>selectnamefromv$datafile;NAME-------------------------------------------------------------------------------D:ORACLE

2、PRODUCT10.2.0ORADATAORCLSYSTEM01.DBFD:ORACLEPRODUCT10.2.0ORADATAORCLUNDOTBS01.DBFD:ORACLEPRODUCT10.2.0ORADATAORCLSYSAUX01.DBFD:ORACLEPRODUCT10.2.0ORADATAORCLUSERS01.DBFD:ORACLEPRODUCT10.2.0ORADATAORCLEXAMPLE01.DBFD:ORACLETAS1A.DBFD:ORACLETAS1

3、B.DBFD:ORACLETEST1A.DBFD:ORACLETBS1A.DBFD:ORACLETBS1B.DBF日志文件SQL>selectmemberfromv$logfile;MEMBER--------------------------------------------------------------------------------D:ORACLELOG11A.LOGD:ORACLELOG1A.LOGD:ORACLELOG11B.LOGD:ORACLELOG1B.LOG控制文件SQL>showp

4、arametercontrol;NAMETYPEVALUE-----------------------------------------------------------------------------control_file_record_keep_timeinteger7control_filesstringD:ORACLEPRODUCT10.2.0ORADATAORCLCONTROL01.CTL热备份SQL>selectfile_name,tablespace_namefromdba_data_files;FILE

5、_NAME-------------------------------------------------------------------------------TABLESPACE_NAME------------------------------D:ORACLEPRODUCT10.2.0ORADATAORCLEXAMPLE01.DBFEXAMPLED:ORACLEPRODUCT10.2.0ORADATAORCLUSERS01.DBFUSERSD:ORACLEPRODUCT10.2.0ORADATA

6、ORCLSYSAUX01.DBFSYSAUXFILE_NAME----------------------------------------------------------------------TABLESPACE_NAME------------------------------D:ORACLEPRODUCT10.2.0ORADATAORCLUNDOTBS01.DBFUNDOTBS1D:ORACLEPRODUCT10.2.0ORADATAORCLSYSTEM01.DBFSYSTEMD:ORACLETA

7、S1A.DBFTBS1FILE_NAME----------------------------------------------------------------------TABLESPACE_NAME------------------------------D:ORACLETAS1B.DBFTBS1D:ORACLETEST1A.DBFTESTD:ORACLETBS1A.DBFTBS2FILE_NAME------------------------------------------------------------

8、----------TABLESPACE_NAME------------------------------D:ORACLETBS1B.DBFTBS2先控制文