Oracle认证专家视频教程-OCP全套教程之学习笔记-RMAN备份
发布时间:2020-12-12 14:45:53 所属栏目:百科 来源:网络整理
导读:知识要点 RMAN连接到当前实例 RMAN备份方式COPY RMAN备份方式BACKUP RMAN查看曾经做过的备份 RMAN连接到当前实例 [oracle@host ~]$ rman target / Recovery Manager: Release 11.2 .0 .4 .0 - Production on Sat Jun 17 18 : 49 : 53 2017 Copyright (c) 198
知识要点
RMAN连接到当前实例[oracle@host ~]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Sat Jun 17 18:49:53 2017
Copyright (c) 1982,2011,Oracle and/or its affiliates. All rights reserved.
connected to target database: SKY2 (DBID=3847463125)
RMAN>
RMAN备份方式COPY物理备份,源文件和备份文件是一样大的(不推荐使用) RMAN>copy current controlfile to '/u01/bak01.ctl';
等价于 SQLPLUS>alter database backup controlfile to '/u01/bak02.ctl';
RMAN>backup as copy database
等价于 SQLPLUS>alter database begin backup
SQLPLUS>ho cp ... ...
SQLPLUS>alter database end backup
RMAN备份方式BACKUP逻辑物理备份。基于块级别的备份,100M的快,只有10M使用。那么利用COPY,备份文件还是100M,BACKUP仅仅备份10M的大小。下面列出几个备份方式:
backup database;
backup spfile
backup current controlfile;
backup datafile 4;
backup tablespace users,sysaux;
backup archivelog all;
backup archivelog all delete input;
backup full database plus archivelog;
sqlplus:alter tablespace users read only rman backup database skip readonly/offline;
backup database format '/u01/bakfull_%U';
sqlplus:show parameter db_recovery_file_dest
查看曾经做过的备份list backup of database/controlfile (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |