主库模型调整需要做一个全库备份,备份与恢复脚本

主库模型调整需要做一个全库备份,备份与恢复脚本如下:
一、备份脚本:
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; #恢复正常的备份集目击地
请使用浏览器的分享功能分享到微信等