主库模型调整需要做一个全库备份,备份与恢复脚本如下:
一、备份脚本:
jldcdb01:/home/oracle$ rman target /
Recovery Manager: Release 10.2.0.4.0 - Production on Fri Aug 19 16:49:09 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: DCMDS01 (DBID=410194126)
RMAN> run{
2> ALLOCATE CHANNEL CH1 DEVICE TYPE DISK FORMAT '/orabk/rman/full_%T_%s_%p';
3> ALLOCATE CHANNEL CH2 DEVICE TYPE DISK FORMAT '/orabk/rman/full_%T_%s_%p';
BACKUP DATABASE SKIP INACCESSIBLE FILESPERSET 10
INCLUDE CURRENT CONTROLFILE
4> 5> 6> PLUS ARCHIVELOG FILESPERSET 20
7> DELETE ALL INPUT;
8> RELEASE CHANNEL CH1;
9> RELEASE CHANNEL CH2;
10> }
二、恢复脚本如下:
1、
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/orabk/rman/full_%T_%s_%p';b #配置到目标备份集位置的通道
2、恢复脚本
run
{
startup force mount;
set until time "to_date('2011-08-19 16:49:09','YYYY-MM-DD hh24:mi:ss')";
restore database;
recover database;
sql 'alter database open resetlogs';
}
3、CONFIGURE CHANNEL DEVICE TYPE DISK clear; #恢复正常的备份集目击地