ITPub博客

1、首先热备份数据库alter tablespace SYSTEM begin backup;! cp/u01/app/oracle/oradata/SAFE/system01.dbf /u02/backup/SAFEalter tablespace SYSTEM end backup;alter tablespace UNDOTBS1 begin backup;! cp /u01/app/oracle/oradata/SAFE/undotbs01.dbf/u02/backup/SAFEalter tablespace ...

热备必须在归档模式下进行用logmnr做日志挖掘需要用到最小补充日志1、添加最小补充日志idle>alter database add supplemental logdata; Database altered.2、  查询一下数据文件及其表空间 idle>select file_name,file_id,tablespace_name from dba_data_files;...