rman备份文档--catalog.docVIP

一次完整的oracle rman备份与恢复的例子目标数据库版本为oracle8.1.7，目录数据库版本是oracle9.2.0，丢失所有的数据文件（包括控制文件和联机日志文件），用rman做备份和恢复的例子:实验步骤： 1、在目录数据库中创建恢复目录所用表空间： SQL create tablespace rmants datafile /opt/oracle/db02/oradata/ORCL/rmants.dbf size 100M autoextend on next 1M maxsize unlimited;Tablespace created. 2、在目录数据库中创建RMAN用户并授权： SQL create user rman identified by rman default tablespace rmants temporary tablespace temp quota unlimited on rmants;User created. SQL grant recovery_catalog_owner to rman;Grant succeeded. 3、在目录数据库中创建恢复目录： $ rman catalog rman/rman Recovery Manager: Release 9.2.0.4.0 - 64bit Production Copyright (c) 1995, 2002, Oracle Corporation.? All rights reserved. connected to recovery catalog databaserecovery catalog is not installedRMANcreate catalog tablespace rmants;recovery catalog created 4、注册目标数据库到恢复目录我的目标数据库使用的服务名称是rcat$ rman target ?? (在目标数据库上执行该命令，首先用rman连接到目标数据库)????????? Recovery Manager: Release 8.1.7.3.0 - Production RMAN-06005: connected to target database: (DBID=1000277484)RMAN connect catalog rman/rman@oratest(连接到catalog目录数据库) RMAN-06008: connected to recovery catalog databaseRMAN register database;? （在catalog目录数据库上注册目标数据库） RMAN-03022: compiling command: registerRMAN-03023: executing command: registerRMAN-08006: database registered in recovery catalogRMAN-03023: executing command: full resyncRMAN-08002: starting full resync of recovery catalogRMAN-08004: full resync complete?准备工作已经作好，下面开始使用RMAN来进行备份和恢复了。5.做rman全备份：RMAN run {allocate channel c1 type disk;backup full? tag dbfull format /opt/oracle/full%u_%p_%c database include current controlfile;sql alter system archive log current;(在数据库mount状态下完成)backup filesperset 3? archivelog all delete input;release channel c1;} 6.查看数据库备份信息： $ rman target / catalog rman/rman@oratest Recovery Manager: Release 8.1.7.3.0 - Production RMAN-06005: connected to target database: ORCL (DBID=1000277484)RMAN-06008: connected to recovery catalog databaseRMANlist backup; 7.关闭数据库，模拟所有数据文件丢失，手工删除所有的数据