Oracle OCM考试系列教程_OCM考试实验笔记之六_备份恢复

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:29

Oracle OCM考试系列教程_OCM考试实验笔记之六_备份恢复

一、恢复目录的创建
Database Backup and Recovery Advanced User's Guide --> 10 Managing the
Recovery Catalog(第十章) --> Creating a Recovery Catalog(第一小节)
1、创建所需表空间
create tablespace cata datafile '/opt/oracle/oradata/mytwo/cata1.dbf' size
50m;

2、创建用户并授予权限
create user cata identified by abcde temporary tablespace tempts1 default
tablespace cata quota unlimited on cata;
grant recovery_catalog_owner to cata;

3、在RMAN中创建恢复目录
[oracle@vhv ~]$ rman target /
RMAN> connect catalog cata/abcde@mytwo
RMAN> create catalog;
recovery catalog created

4、向恢复目录中注册数据库
保证同时连接到目标库、目录库,发出如下命令:
RMAN> REGISTER DATABASE;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
此命令在第二小节:
Database Backup and Recovery Advanced User's Guide --> 10 Managing the
Recovery Catalog(第十章) --> Managing Target Database Records in the
Recovery Catalog(第二小节)

5、恢复目录的常用操作:同步
此命令在第三小节:c
Database Backup and Recovery Advanced User's Guide --> 10 Managing the
Recovery Catalog(第十章) --> Resynchronizing the Recovery Catalog(第三小
节)

二、压缩备份
1、直接备份:
backup as compressed backupset datafile 1
format='/opt/oracle/oradata/myone/arc/myone_%U';
文档Backup and Recovery Reference中,找到backup命令,向下翻四页,或搜索

465

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】