创建create catalog
create user rman identified by rman default tablespace tbs1 temporary tablespace tempts1;
alter user rman quota unlimited on tbs1;

GRANT RECOVERY_CATALOG_OWNER TO rman;

rman> connect catalog rman/rman@dbs11

CREATE CATALOG;

rman catalog rman/rman@test target /
register database

创建backup脚本
DROP SCRIPT. full_backup;

CREATE SCRIPT. full_backup
{    
  BACKUP AS COMPRESSED BACKUPSET DATABASE format '/u03/backup/oradb_%U%P%S.bak' include current controlfile;
  BACKUP ARCHIVELOG ALL format '/u03/backup/arch_%U%P%S.bak' delete all input;
}

RUN { EXECUTE SCRIPT. full_backup; }

配置rman
show all

configure controlfile autobackup on;
CONFIGURE DEVICE TYPE DISK PARALLELISM 2;
CONFIGURE BACKUP OPTIMIZATION ON;
configure channel device type disk format '/u03/backup/db_ful%U%S%P' rate 5m ;
configure controlfile autobackup format for device type disk to '/u03/backup/cf_%f';

恢复：丢失controlfile
set dbid = 2482080830
startup nomount
RESTORE CONTROLFILE FROM AUTOBACKUP;
sql 'alter database mount';
restore database;
recover database;
sql 'alter database open resetlogs';

恢复：丢失system01.dbf
startup mount
restore database;
recover database;
sql 'alter database open';

备份configure

自动备份控制文件和spfile

configure controlfile autobackup on

启动备份优化

CONFIGURE BACKUP OPTIMIZATION ON;

启动并行备份

CONFIGURE DEVICE TYPE disk PARALLELISM 2;

设置默认备份设备

CONFIGURE DEFAULT DEVICE TYPE TO disk;

设置压缩备份
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET;

设置备份的格式

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/u01/backup/ora_df%t_s%s_s%p';

可以通过下列表获取scn和时间的对应关系。

SELECT scn, to_char(TIME_DP,'yyyy-mm-dd hh24:mi:ss')
      FROM SMON_SCN_TIME
      where time_dp > to_date('2010-11-08', 'yyyy-mm-dd')
      order by time_dp;