OCM_Session3_2_Using RMAN

最新推荐文章于 2021-06-06 15:01:43 发布
最新推荐文章于 2021-06-06 15:01:43 发布
阅读量2.4k 收藏 1
点赞数
分类专栏： OCM experiment
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/rlhua/article/details/21715883
版权
2. Using RMAN
  •  2.1 Configure RMAN options for the PROD database
  •   2.1.1 Turn backup optimization on
  •   2.1.2 Set your default channel to write to /home/oracle/backup (you may have to create this directory )
  •   2.1.3 Turn on controlfile autobackups to write to /home/oracle/backup/control (you may have to create this directory)
  •   2.1.4 Configure a retention window of 7 days.

首先创建两个文件夹
[oracle@ocm1 ~]$   mkdir /home/oracle/backup
[oracle@ocm1 ~]$   mkdir /home/oracle/backup/control

按以下操作：
RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

RMAN>   CONFIGURE BACKUP OPTIMIZATION ON;

new RMAN configuration parameters:
CONFIGURE BACKUP OPTIMIZATION ON;
new RMAN configuration parameters are successfully stored

RMAN>  CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/home/oracle/backup/PROD_%U.bak';

new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/home/oracle/backup/PROD_%U.bak';
new RMAN configuration parameters are successfully stored

RMAN>   CONFIGURE CONTROLFILE AUTOBACKUP ON;

new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/PROD_%F.ctl';

new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/PROD_%F.ctl';
new RMAN configuration parameters are successfully stored

RMAN>   CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;

new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
new RMAN configuration parameters are successfully stored

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/PROD_%F.ctl';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/home/oracle/backup/PROD_%U.bak';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

RMAN> 



  • 2.2 Perform a backup 
  •   2.2.1 Perform a backup using your default channel with compression
  •   2.2.2 Include all datafiles in the backup
  •   2.2.3 Include your current control file and spfile
  •   2.2.4 Include all archive logs, then remove the originals.
备份，使用缺省通道，压缩备份，包括所有文件，包括当前的控制文件的spfile文件，包括所有的归档日志，并将原来的归档日志移除。

RMAN>   backup as compressed backupset database include current controlfile plus archivelog delete all input;


Starting backup at 21-MAR-14
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=268 devtype=DISK
skipping archive log file /u01/app/oracle/oradata/PROD/Disk2/arch/1_6_842523531.dbf; already backed up 1 time(s)
skipping archive log file /u01/app/oracle/oradata/PROD/Disk2/arch/1_7_842523531.dbf; already backed up 1 time(s)
channel ORA_DISK_1: starting compressed archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=8 recid=3 stamp=842717159
input archive log thread=1 sequence=9 recid=4 stamp=842790340
input archive log thread=1 sequence=10 recid=5 stamp=842796122
channel ORA_DISK_1: starting piece 1 at 21-MAR-14
channel ORA_DISK_1: finished piece 1 at 21-MAR-14
piece handle=/home/oracle/backup/PROD_06p3o334_1_1.bak tag=TAG20140321T140208 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:17
channel ORA_DISK_1: deleting archive log(s)
archive log filename=/u01/app/oracle/oradata/PROD/Disk2/arch/1_8_842523531.dbf recid=3 stamp=842717159
archive log filename=/u01/app/oracle/oradata/PROD/Disk2/arch/1_9_842523531.dbf recid=4 stamp=842790340
archive log filename=/u01/app/oracle/oradata/PROD/Disk2/arch/1_10_842523531.dbf recid=5 stamp=842796122
channel ORA_DISK_1: deleting archive log(s)
archive log filename=/u01/app/oracle/oradata/PROD/Disk2/arch/1_6_842523531.dbf recid=1 stamp=842627911
archive log filename=/u01/app/oracle/oradata/PROD/Disk2/arch/1_7_842523531.dbf recid=2 stamp=842644301
Finished backup at 21-MAR-14

Starting backup at 21-MAR-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00004 name=/u01/app/oracle/oradata/PROD/Disk1/example01.dbf
input datafile fno=00001 name=/u01/app/oracle/oradata/PROD/Disk1/system01.dbf
input datafile fno=00003 name=/u01/app/oracle/oradata/PROD/Disk1/sysaux01.dbf
input datafile fno=00002 name=/u01/app/oracle/oradata/PROD/Disk1/undotbs01.dbf
input datafile fno=00007 name=/u01/app/oracle/oradata/PROD/Disk1/users01.dbf
input datafile fno=00008 name=/u01/app/oracle/oradata/PROD/Disk1/oltp01.dbf
input datafile fno=00005 name=/u01/app/oracle/oradata/PROD/Disk1/indx01.dbf
input datafile fno=00006 name=/u01/app/oracle/oradata/PROD/Disk1/tools01.dbf
channel ORA_DISK_1: starting piece 1 at 21-MAR-14
channel ORA_DISK_1: finished piece 1 at 21-MAR-14
piece handle=/home/oracle/backup/PROD_07p3o33u_1_1.bak tag=TAG20140321T140235 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:03:39
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_1: starting piece 1 at 21-MAR-14
channel ORA_DISK_1: finished piece 1 at 21-MAR-14
piece handle=/home/oracle/backup/PROD_08p3o3aq_1_1.bak tag=TAG20140321T140235 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 21-MAR-14

Starting backup at 21-MAR-14
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=11 recid=6 stamp=842796380
channel ORA_DISK_1: starting piece 1 at 21-MAR-14
channel ORA_DISK_1: finished piece 1 at 21-MAR-14
piece handle=/home/oracle/backup/PROD_09p3o3av_1_1.bak tag=TAG20140321T140620 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:05
channel ORA_DISK_1: deleting archive log(s)
archive log filename=/u01/app/oracle/oradata/PROD/Disk2/arch/1_11_842523531.dbf recid=6 stamp=842796380
Finished backup at 21-MAR-14

Starting Control File and SPFILE Autobackup at 21-MAR-14
piece handle=/home/oracle/backup/control/PROD_c-254361867-20140321-00.ctl comment=NONE
Finished Control File and SPFILE Autobackup at 21-MAR-14

RMAN> 


Riveore
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
（第75天）AutoUpgrade 升级：11GR2 到 19C
LuciferLiu_DBA
03-24 397
Oracle 从 12CR2 开始就开始大力推广 AutoUpgrade 升级工具，但是实际生产中使用并不广泛，但是这个工具已经发展的非常成熟了。本文介绍一下如何使用 AutoUpgrade 工具进行快速升级，操作非常简单。
rman异机增量备份恢复
freedompuge的专栏
07-13 4291
实验环境 a：oraclelinux6.5 ip地址：192.168.6.245 oracle版本：11.2.0.3 建库 b：oraclelinux6.5 ip地址：192.168.6.200 oracle版本：11.2.0.3 只安装oracle的软件，不建库 a备份==>b恢复 在a服务器上操作： 首先在a服务器上做0级备份
OCM考试经验--RMAN基础详解（二）--配置、监控与管理
Richie's 残酷舞台
03-16 469
--========================= -- RMAN 配置、监控与管理 --=========================     一、通道及通道分配     1.通道的概念         一个通道代表一个到设备(磁盘或磁带)的数据流并且在目标数据库或辅助数据库实例上产生一个相应的服务器会话(server session)         多个通道则产生多个
OCM考试经验--RMAN基础详解（一）--体系结构
Richie's 残酷舞台
03-16 559
--========================= -- RMAN 概述及其体系结构 --=========================   一、Recovery Manager（RMAN）特性     是一种用于集（set）备份(backup)、还原(restore)和恢复(recover)数据库于一体的Oracle 工具，支持命令行及图形界面操作     能够备份整个数据库
Oracle 11g单实例RMAN恢复到Oracle 11g RAC
weixin_34195142的博客
09-17 144
一、环境说明操作系统版本: RHEL 6.5 x641. 源数据库服务器Oracle版本: Oracle 11g 11.2.0.4 64位(单机)Oracle_SID: orcl db_name : orcl背景：一台生产oracle10g（10.2.0.5）数据库计划迁移到Oracle 11.2.0.4.0 RAC.1) 先oracle10g（10.2.0.5）升级...
Oracle RMAN 备份及不完全恢复(删除archievelog)
weixin_30646315的博客
06-18 214
RMAN备份命令 backup Database format='/home/oracle/backup/bak_full_%U_%T' tag='bak_full';sql 'alter system archive log current';backup archivelog all tag='arc_bak' format='/home/oracle/b...
RMAN Duplicate Database 的学习与测试_20100129
01-29 115
RMAN Duplicate Database 的学习与测试_20100129 如何快速Clone一个生产系统作为测试环境.1 拷贝生产库的冷备,到另一台机器上恢复.分析:影响业务,要求停机 2 RMAN Duplicate...
【12c】12c RMAN新特性之recover table（表级别恢复）
coco3600的博客
04-09 1578
【12c】12c RMAN新特性之recover table（表级别恢复） 在 RMAN 中提供了表级别恢复...
oracle11gAdg_搭建和切换法
weixin_54651775的博客
06-06 429
导读 作者：杨漆 16年关系型数据库管理，从oracle 9i 、10g、11g、12c到Mysql5.5、5.6、5.7、8.0 到TiDB获得3个OCP、2个OCM；运维路上不平坦，跌过不少坑、熬过许多夜。把工作笔记整理出来分享给大伙儿，希望帮到大家少走弯路、少熬夜。 1.先确认primary库处于归档模式 SQL> archive log list; 2.强制归档 SQL> alter database force logging; 3.增大日志组 ALTER DATABASE ADD
这样做，RMAN备份速度可提高6倍！
Enmotech的博客
05-25 1249
墨墨导读：本文来自读者投稿，详述一则给客户备份优化的实际案例，通过这次优化，数据库性能提高了6倍。数据库现状SQL> select * from v$version; BANN...
11g OCM备考2——第二场，数据可用性
liqiangyang的博客
05-28 612
题目1. catalog 配置Create a rman recovery catalog in woods database, the recovery catalog store in tablespace RC_DATA with a file size 200m,make sure the recovery catalog owner is RC_ADMIN password is sam...
EXP-00091和IMP-00010解决办法
热门推荐
一抹曦阳-Oracle
03-27 1万+
在session4的4小题需要用到SH.COUNTRIES表，而手工建库时，这个SH用户没有这个表，就想着将别处的这个表拷贝过来。 原来导出表的库：database ORACLE_SID=TEST0221 版本： 11.2.0.4 需要导进的库：database ORACLE_SID=PROD 版本：10.2.0.1 因为字符集的问题，出现了EXP-00091的错误 因为数据库版
OCM实验目录
一抹曦阳-Oracle
03-29 1万+
OCM实验目录     环境准备   http://blog.csdn.net/rlhua/article/details/21370431 session0   http://blog.csdn.net/rlhua/article/details/21475621 session1 1.Database
OCM_环境准备
一抹曦阳-Oracle
03-17 4891
虚拟机：VirtualBox-4.3.8 虚拟机里装的OS：OracleLinux-R5-U7-Server-i386 内存：1024MB 一、配置本地yum环境 1.创建介质装载目录/media/disk: [root@ocm1 /]# pwd / [root@ocm1 /]# mkdir /media/disk 2.插入OEL DVD光盘 3.
OCM_Session7_5_修改/etc/security/limits.conf和 /etc/pam.d/login和/etc/profile
一抹曦阳-Oracle
03-23 4748
五、修改/etc/security/limits.conf和 /etc/pam.d/login和/etc/profile   这个在OCM环境已经配置好。 参考官方文档：http://docs.oracle.com/cd/B19306_01/install.102/b14203/prelinux.htm To increase the shell limits:
OCM_Session1_1_Database Setup and Undo Management
一抹曦阳-Oracle
03-18 3972
TIMES: 45 minutes  1. Database Setup and Undo Management  1.1 Run the minimum required scripts to complete the basic configuration of the PROD database. 1.2 Set up automatic undo management in
OCM_session0手动建库实验
一抹曦阳-Oracle
03-18 3897
Section 0 :创建数据库(即手动建库) 1. Create a database the sid name is PROD 2. Don't run the Script catalog.sql and catproc.sql 参考联机文档： Reference ==> Basic Initialization Parameters http://docs.ora
OCM_Session4_3_Oracle_Loader External Tables
一抹曦阳-Oracle
03-27 3675
3. Oracle_Loader External Tables 3.1 In the scripts directory, you will find prod_master.dat and prod_master.ctl. Using the information found in these files, create an external table names PROD_MASTER
OCM_Session1_4_Client-side Network configuration
一抹曦阳-Oracle
03-18 3668
4. Client-side Network configuration  4.1 Create the client-side network configuration files providing connect descriptors to your databases using local naming and easy connect methods.   4.1.1 The 
Oracle_OCP课程实验：官网资源与Metalink指南
在Oracle Certified Master (OCM) 考试中，官方文档的熟练运用能节省大量时间。 "Administrator's Guide"是DBA入门的必备指南，包含了数据库管理的基础知识。此外，还有其他关键文档如"Reference"，用于查询参数和...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值