基于catalog 创建RMAN存储脚本

谁借莪１个温暖的怀抱￠ 2022-05-15 01:39 159阅读 0赞

\--==============================

\-- 基于catalog 创建RMAN存储脚本

\--==============================

简言之，将rman的备份恢复命令写成脚本并保存在恢复目录内，恢复目录内的脚本可用性及通用性高于基于文件系统的脚本。

客户端只要能够登录到RMAN恢复目录，则这些脚本可用，尤其对于global脚本，可以被任意注册的数据库调度。

一、脚本的分类

local :在rman连接的目标数据库下创建的脚本，此类脚本仅仅适用于当前目标数据库。即是针对特定的数据库创建的rman脚本

global :能够在恢复目录注册的任意目标数据库中执行

二、创建脚本

\--创建全局备份脚本

RMAN> create global script global\_full\_backup

2> comment 'A script for full backup to be used with any database'

3> \{

4> backup database

5> plus archivelog

6> tag='Whole\_db\_bk';

7> delete obsolete;

8> \}

created global script global\_full\_backup

\--创建本地备份脚本

RMAN> create script full\_backup

2> comment 'A script for full backup to be used with current target database'

3> \{

4> backup as compressed backupset

5> database plus archivelog delete input

6> tag='Whole\_db\_bk';

7> delete obsolete;

8> \}

created script full\_backup

\--从文本文件创建脚本

\[oracle@oradb bk\]$ cat backup\_ctl\_spfile \--注意文本文件必须以"\{" 开头，以"\}" 结尾

allocate channel ch1 device type disk;

backup current controlfile

tag='ctl\_spfile'

format '/u01/oracle/bk/rmbk/ctl\_spfile\_%d\_%U';

release channel ch1;

RMAN> create script ctl\_spfile\_bk from file '/u01/oracle/bk/rmbk/backup\_ctl\_spfile';

script commands will be loaded from file /u01/oracle/bk/rmbk/backup\_ctl\_spfile

created script ctl\_spfile\_bk

三、查看脚本的内容

print \[global\] script script\_name

print \[global\] script script\_name to file '<dir>' \--将RMAN存储脚本转换到文件系统可读文件

RMAN> print script ctl\_spfile\_bk;

printing stored script: ctl\_spfile\_bk

allocate channel ch1 device type disk;

backup current controlfile

tag='ctl\_spfile'

format '/u01/oracle/bk/rmbk/ctl\_spfile\_%d\_%U';

release channel ch1;

RMAN> print script ctl\_spfile\_bk to file '/u01/oracle/bk/rmbk/backup\_ctl\_spfile2';

script ctl\_spfile\_bk written to file /u01/oracle/bk/rmbk/backup\_ctl\_spfile2

查看当前恢复目录内的脚本

list \[global | all\] script names

RMAN> list script names;

List of Stored Scripts in Recovery Catalog

Scripts of Target Database ORCL

Script Name

Description

\-----------------------------------------------------------------------

ctl\_spfile\_bk

full\_backup

A script for full backup to be used with current target database

Global Scripts

Script Name

Description

\-----------------------------------------------------------------------

global\_full\_backup

A script for full backup to be used with any database

四、更新脚本

replace \[global\] script scrip\_name \{....\}

replace \[global\] script script\_name from file '<dir>' \--从文件更新脚本

RMAN> replace global script global\_full\_backup

2> \{

3> backup as compressed backupset database plus archivelog

4> tag='whole\_db\_bk';

5> delete obsolete;

6> \}

replaced global script global\_full\_backup

五、执行脚本

方法：RUN \{  EXECUTE \[global\] SCRIPT script\_name; \}

从rman客户端直接执行恢复目录内的脚本

rman target sys/redhat@orcl catalog rman/rman@asmdb script 'script\_name';

RMAN> run \{  execute global script global\_full\_backup;\}

executing global script: global\_full\_backup

六、删除脚本

delete \[global\] script script\_name

RMAN> delete script ctl\_spfile\_bk;

deleted script: ctl\_spfile\_bk

七、其它

注意：使用EXECUTE SCRIPT, DELETE SCRIPT ,PRINT SCRIPT等命令时，如果一个本地的脚本未找到，则寻找全局的脚本来代替。

因此应当注意命名规范，尽可能的不使用重名的脚本名，当DELETE SCRIPT 找不到本地脚本，而找到同样名字的全局脚本，则全局

脚本被删除

八、更多参考

有关基于用户管理的备份和备份恢复的概念请参考：

[Oracle 冷备份][Oracle]

[Oracle 热备份][Oracle 1]

[Oracle 备份恢复概念][Oracle 2]

[Oracle 实例恢复][Oracle 3]

[Oracle 基于用户管理恢复的处理][Oracle 4](详细描述了介质恢复及其处理)

有关RMAN的恢复与管理请参考：

[RMAN 概述及其体系结构][RMAN]

[RMAN 配置、监控与管理][RMAN 1]

[RMAN 备份详解][RMAN 2]

[RMAN 还原与恢复][RMAN 3]

有关Oracle体系结构请参考：

[Oracle 实例和Oracle数据库(Oracle体系结构)][Oracle _Oracle_Oracle]

[Oracle 表空间与数据文件][Oracle 5]

[Oracle 密码文件][Oracle 6]

[Oracle 参数文件][Oracle 7]

[Oracle 数据库实例启动关闭过程][Oracle 8]

[Oracle 联机重做日志文件(ONLINE LOG FILE)][Oracle _ONLINE LOG FILE]

[Oracle 控制文件(CONTROLFILE)][Oracle _CONTROLFILE]

[Oracle 归档日志][Oracle 9]

[Oracle]: http://blog.csdn.net/robinson_0612/archive/2010/08/05/5791597.aspx
[Oracle 1]: http://blog.csdn.net/robinson_0612/archive/2010/08/16/5816012.aspx
[Oracle 2]: http://blog.csdn.net/robinson_0612/archive/2010/08/05/5791585.aspx
[Oracle 3]: http://blog.csdn.net/robinson_0612/archive/2010/07/27/5768233.aspx
[Oracle 4]: http://blog.csdn.net/robinson_0612/archive/2010/11/28/6041217.aspx
[RMAN]: http://blog.csdn.net/robinson_0612/archive/2010/11/24/6032525.aspx
[RMAN 1]: http://blog.csdn.net/robinson_0612/archive/2010/11/24/6032597.aspx
[RMAN 2]: http://blog.csdn.net/robinson_0612/archive/2010/11/24/6032739.aspx
[RMAN 3]: http://blog.csdn.net/robinson_0612/archive/2010/11/28/6041247.aspx
[Oracle _Oracle_Oracle]: http://blog.csdn.net/robinson_0612/archive/2010/04/26/5529239.aspx
[Oracle 5]: http://blog.csdn.net/robinson_0612/archive/2010/05/20/5611738.aspx
[Oracle 6]: http://blog.csdn.net/robinson_0612/archive/2010/05/20/5611672.aspx
[Oracle 7]: http://blog.csdn.net/robinson_0612/archive/2010/05/05/5559174.aspx
[Oracle 8]: http://blog.csdn.net/robinson_0612/archive/2010/04/29/5542983.aspx
[Oracle _ONLINE LOG FILE]: http://blog.csdn.net/robinson_0612/archive/2010/07/20/5749556.aspx
[Oracle _CONTROLFILE]: http://blog.csdn.net/robinson_0612/archive/2010/07/15/5737527.aspx
[Oracle 9]: http://blog.csdn.net/robinson_0612/archive/2010/08/03/5784713.aspx