RMAN记录

最新推荐文章于 2022-10-01 01:37:56 发布
最新推荐文章于 2022-10-01 01:37:56 发布
阅读量366 收藏
点赞数
分类专栏： 数据库 linux 文章标签： rman
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_35201754/article/details/89643324
版权

rman备份脚本：

##======================================================================
##  
## 
##  
##  usage: db_bak_rman.sh <$ORACLE_SID> <$BACKUP_LEVEL>
##         BACKUP_LEVEL:
##                    F: full backup
##                    0: level 0
##                    1: level 1
##======================================================================
#!/bin/bash
# User specific environment and startup programs

if [ -f ~/.bash_profile ];
then
  . ~/.bash_profile
fi

ORACLE_SID=${1};                           export ORACLE_SID
RMAN_LEVEL=${2};                           export RMAN_LEVEL
TIMESTAMP=`date +%Y%m%d%H%M`;              export TIMESTAMP
DATE=`date +%Y%m%d`;                       export DATE
#RMAN_DIR=/backup_db_rman/rman;            export RMAN_DIR  #marked by elaine 160603
RMAN_DIR=/mnt/bak/${1};                         export RMAN_DIR
RMAN_DATA=${RMAN_DIR}/${DATE};             export RMAN_DATA
#RMAN_LOG=/backup_db_rman/rman/log;        export RMAN_LOG  #marked by elaine 160603
RMAN_LOG=${RMAN_DIR}/${DATE};                     export RMAN_LOG

# check rman level
#=======================================================================

if [ "$RMAN_LEVEL" == "F" ];
then
  unset INCR_LVL
  BACKUP_TYPE=full
else
  INCR_LVL="INCREMENTAL LEVEL ${RMAN_LEVEL}"
  BACKUP_TYPE=lev${RMAN_LEVEL}
fi

RMAN_FILE=${RMAN_DATA}/${ORACLE_SID}_${BACKUP_TYPE}_${TIMESTAMP};    export RMAN_FILE
SSH_LOG=${RMAN_LOG}/${ORACLE_SID}_${BACKUP_TYPE}_${TIMESTAMP}.log;   export SSH_LOG

MAXPIECESIZE=2G;                                                     export MAXPIECESIZE

#check RMAN Backup Path
#=======================================================================

if ! test -d ${RMAN_DATA}
then
  mkdir -p ${RMAN_DATA}
fi

echo "------------------------------------" >>${SSH_LOG}
echo "      " >>${SSH_LOG}
echo "Rman Begin to Working .............." >>${SSH_LOG}
echo "Begin time at:" `date` -- `date +%Y%m%d%H%M` >>${SSH_LOG}

#Startup rman to backup
#=======================================================================
$ORACLE_HOME/bin/rman log=${RMAN_FILE}.log <<EOF

connect target /
run {
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '${RMAN_FILE}_%F';
ALLOCATE CHANNEL ch1 TYPE DISK;
ALLOCATE CHANNEL ch2 TYPE DISK;
#set limit channel ch1 readrate=10240;
#set limit channel ch1 kbytes=4096000;
#set limit channel ch2 readrate=10240;
#set limit channel ch2 kbytes=4096000;
CROSSCHECK ARCHIVELOG ALL;
DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;
BACKUP ${INCR_LVL} DATABASE FORMAT '${RMAN_FILE}_%U' TAG '${ORACLE_SID}_${BACKUP_TYPE}_${TIMESTAMP}';
SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
BACKUP ARCHIVELOG ALL FORMAT '${RMAN_FILE}_arc_%U' TAG '${ORACLE_SID}_arc_${TIMESTAMP}'
DELETE INPUT;
#DELETE NOPROMPT OBSOLETE;
DELETE ARCHIVELOG UNTIL TIME 'SYSDATE-7'; 
RELEASE CHANNEL ch1;
RELEASE CHANNEL ch2;
}

sql "alter database backup controlfile to ''${RMAN_DATA}/cntl_${BACKUP_TYPE}.bak''";

exit;
EOF
RC=$?

cat ${RMAN_FILE}.log >>${SSH_LOG}

echo "Rman Stop working @ time:"`date` `date +%Y%m%d%H%M` >>${SSH_LOG}

echo >>${SSH_LOG}
echo "----------------------------------------" >>${SSH_LOG}
echo "------------------ Disk Space ----------" >>${SSH_LOG}
df -h >>${SSH_LOG}

echo >>${SSH_LOG}

if [ $RC -ne "0" ]; then
  echo "-------------------- error --------------------" >>${SSH_LOG}
else
  echo "------ no error found during RMAN backup period --------" >>${SSH_LOG}
  rm -rf ${RMAN_FILE}.log
fi

#Remove old backup than 5 days
#===========================================================================================
RMDIR=${RMAN_DIR}/`/bin/date +%Y%m%d -d "7 days ago"`;        export RMDIR
echo >>${SSH_LOG}
echo -e "---------------Remove old backup than 7 days -------------\n" >>${SSH_LOG}

if test -d ${RMDIR}
then
  rm -rf ${RMDIR}
  RC=$?
fi

echo >>${SSH_LOG}

if [ $RC -ne "0" ]; then
  echo -e "----------- Remove old backup exception-------------- \n" >>${SSH_LOG}
else
  echo -e "----------- no error found during remove old backup set period------ \n" >>${SSH_LOG}
fi

exit

1.开启归档

（1）查看归档模式

没有开启归档，备份失败

1.expoer ORACLE_SID=stg
2.archive log list
3.shutdown immediate;
4.startup mount;
5.alter database archivelog;
6. alter database open;

因为没归档之前备份了一下，所以想清空一下之前的备份

2.rman操作

进入rman连接不上数据库，使用connect target /

但是仍报错 ora-06002 在没有连接至恢复目录时不允许使用命令,用命令crosscheck archivelog all使用目标数据库控制文件替代恢复目录

删除成功了，重新备份

3.测试恢复

删除所有文件

(1)恢复spfile文件

a.export ORACLE_SID=stg
b.sqlplus / as sysdba
c.startup force nomount
d.quit;
e.rman target / nocatalog
f.restore spfile to pfile '/u01/app/oracle/stg/stg/spfilestg.ora'
 from '/bak/stg/20190428/stg_lev0_201904281826_c-1124575224-20190428-04'
#此时参数文件已恢复成功，不知道是那个备份文件可以一个一个尝试
恢复成功后重启记得数据库

（2）恢复控制文件

g.restore controlfile from '/bak/stg/20190428/cntl_lev0.bak';
f.alter database mount;

(3)恢复数据文件

a.sql下  alter database open resetlogs;
b.rman下 根据报错输入restore datafile xx

记录：我将data下的数据文件全部清空后，所作的操作：

开启两个终端sql 和 ramn
sql ：
export ORACLE_SID=stg;
sqlplus / as  sysdba
sql> startup force nomount;
SQL> startup mount;
ORACLE instance started.

Total System Global Area  576221184 bytes
Fixed Size		    2215464 bytes
Variable Size		  243270104 bytes
Database Buffers	  327155712 bytes
Redo Buffers		    3579904 bytes
Database mounted.


rman :
export ORACLE_SID=stg;
rman target / nocatalog
RMAN> recover database;

Starting recover at 29-APR-19
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 04/29/2019 15:39:46
ORA-00210: cannot open the specified control file

RMAN> restore controlfile from '//bak/stg/20190428/cntl_lev0.bak';  

Starting restore at 29-APR-19
using channel ORA_DISK_1

channel ORA_DISK_1: copied control file copy
output file name=/u01/app/oracle/stg/stg/control01.ctl
output file name=/u01/app/oracle/flash_recovery_area/stg/control02.ctl
Finished restore at 29-APR-19

RMAN> recover database;

Starting recover at 29-APR-19
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 04/29/2019 15:45:36
ORA-00210: cannot open the specified control file
#此时需要mount

sql :
sql>alter database mount;
SQL> alter database mount; 

Database altered.

rman :
RMAN> recover database;

Starting recover at 29-APR-19
Starting implicit crosscheck backup at 29-APR-19
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1 device type=DISK
Crosschecked 6 objects
Finished implicit crosscheck backup at 29-APR-19

Starting implicit crosscheck copy at 29-APR-19
using channel ORA_DISK_1
Crosschecked 2 objects
Finished implicit crosscheck copy at 29-APR-19

searching for all files in the recovery area
cataloging files...
no files cataloged

using channel ORA_DISK_1
RMAN-06900: WARNING: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row
RMAN-06901: WARNING: disabling update of the V$RMAN_STATUS and V$RMAN_OUTPUT rows
ORACLE error from target database: 
ORA-19922: there is no parent row with id 0 and level 1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 04/29/2019 15:47:38
RMAN-06094: datafile 1 must be restored

RMAN> restore datafile 1;

Starting restore at 29-APR-19
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /u01/app/oracle/stg/stg/system01.dbf
channel ORA_DISK_1: reading from backup piece /bak/stg/20190428/stg_lev0_201904281826_0ku052ao_1_1
channel ORA_DISK_1: piece handle=/bak/stg/20190428/stg_lev0_201904281826_0ku052ao_1_1 tag=STG_LEV0_201904281826
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:35
Finished restore at 29-APR-19

RMAN>  restore datafile 2;

Starting restore at 29-APR-19
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00002 to /u01/app/oracle/stg/stg/sysaux01.dbf
channel ORA_DISK_1: reading from backup piece /bak/stg/20190428/stg_lev0_201904281826_0ku052ao_1_1
channel ORA_DISK_1: piece handle=/bak/stg/20190428/stg_lev0_201904281826_0ku052ao_1_1 tag=STG_LEV0_201904281826
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:25
Finished restore at 29-APR-19

RMAN>  restore datafile 3;

Starting restore at 29-APR-19
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/stg/stg/undotbs01.dbf
channel ORA_DISK_1: reading from backup piece /bak/stg/20190428/stg_lev0_201904281826_0ju052ao_1_1
channel ORA_DISK_1: piece handle=/bak/stg/20190428/stg_lev0_201904281826_0ju052ao_1_1 tag=STG_LEV0_201904281826
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
Finished restore at 29-APR-19

RMAN>  restore datafile 4;

Starting restore at 29-APR-19
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/stg/stg/users01.dbf
channel ORA_DISK_1: reading from backup piece /bak/stg/20190428/stg_lev0_201904281826_0ju052ao_1_1
channel ORA_DISK_1: piece handle=/bak/stg/20190428/stg_lev0_201904281826_0ju052ao_1_1 tag=STG_LEV0_201904281826
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:02:05
Finished restore at 29-APR-19

RMAN> recover database;

Starting recover at 29-APR-19
using channel ORA_DISK_1

starting media recovery

channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=15
channel ORA_DISK_1: reading from backup piece /bak/stg/20190428/stg_lev0_201904281826_arc_0mu052ef_1_1
channel ORA_DISK_1: piece handle=/bak/stg/20190428/stg_lev0_201904281826_arc_0mu052ef_1_1 tag=STG_ARC_201904281826
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/u01/app/oracle/flash_recovery_area/STG/archivelog/2019_04_29/o1_mf_1_15_gdfc8l6b_.arc thread=1 sequence=15
channel default: deleting archived log(s)
archived log file name=/u01/app/oracle/flash_recovery_area/STG/archivelog/2019_04_29/o1_mf_1_15_gdfc8l6b_.arc RECID=7 STAMP=1006876306
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=16
channel ORA_DISK_1: reading from backup piece /bak/stg/20190428/stg_lev0_201904281826_arc_0nu052ef_1_1
channel ORA_DISK_1: piece handle=/bak/stg/20190428/stg_lev0_201904281826_arc_0nu052ef_1_1 tag=STG_ARC_201904281826
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/u01/app/oracle/flash_recovery_area/STG/archivelog/2019_04_29/o1_mf_1_16_gdfc8mfp_.arc thread=1 sequence=16
channel default: deleting archived log(s)
archived log file name=/u01/app/oracle/flash_recovery_area/STG/archivelog/2019_04_29/o1_mf_1_16_gdfc8mfp_.arc RECID=8 STAMP=1006876307
unable to find archived log
archived log thread=1 sequence=17
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 04/29/2019 15:51:48
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 17 and starting SCN of 10220387304368
#此错误的原因是恢复需要的日志记录在控制文件或恢复目录中找不到。解决方法分两种情况：
#1.如果相关的日志存在且可用的话，就将此日志记录添加到控制文件或恢复目录中。
#2.如果相关的日志已经被删除了或不可用了，那么就按照错误的提示scn将数据库恢复到此scn，本案例是#10220387304368。也就是说此时数据库只能进行不完全恢复了（可能是因为我恢复的是rman level 0，增量#是今天备份的，没有恢复今天的备份），在打开数#据库时得使用resetlogs打开。
RMAN> recover database until scn 10220387304368;

Starting recover at 29-APR-19
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:00

Finished recover at 29-APR-19
#此时恢复完成
sql :
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


SQL> alter database resetlogs;
alter database resetlogs
                       *
ERROR at line 1:
ORA-02231: missing or invalid option to ALTER DATABASE


SQL> alter database open resetlogs; 

Database altered.
#此时数据库已能使用

ps:1.关于dbid，备份的文件名字包含dbid

2.在报RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 17 and starting SCN of 10220387304368错误时的另种操作方式

unable to find archived log
archived log thread=1 sequence=17
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 04/29/2019 16:51:46
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 17 and starting SCN of 10220387304368

RMAN> list failure;

List of Database Failures
=========================

Failure ID Priority Status    Time Detected Summary
---------- -------- --------- ------------- -------
1722       CRITICAL OPEN      29-APR-19     Control file needs media recovery

RMAN> advise failure;

List of Database Failures
=========================

Failure ID Priority Status    Time Detected Summary
---------- -------- --------- ------------- -------
1722       CRITICAL OPEN      29-APR-19     Control file needs media recovery

analyzing automatic repair options; this may take some time
using channel ORA_DISK_1
analyzing automatic repair options complete

Mandatory Manual Actions
========================
no manual actions available

Optional Manual Actions
=======================
1. If you have the correct version of the control file, then shutdown the database and replace the old control file

Automated Repair Options
========================
Option Repair Description
------ ------------------
1      Perform incomplete database recovery  
  Strategy: The repair includes point-in-time recovery with some data loss
  Repair script: /u01/app/oracle/diag/rdbms/stg/stg/hm/reco_3805060484.hm

RMAN> repair failure;

Strategy: The repair includes point-in-time recovery with some data loss
Repair script: /u01/app/oracle/diag/rdbms/stg/stg/hm/reco_3805060484.hm

contents of repair script:
   # database point-in-time recovery until a missing log
   restore database until scn 10220387304368;
   recover database until scn 10220387304368;
   alter database open resetlogs;

Do you really want to execute the above repair (enter YES or NO)? yes
executing repair script

Starting restore at 29-APR-19
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /u01/app/oracle/stg/stg/system01.dbf
channel ORA_DISK_1: restoring datafile 00002 to /u01/app/oracle/stg/stg/sysaux01.dbf
channel ORA_DISK_1: reading from backup piece /bak/stg/20190428/stg_lev0_201904281826_0ku052ao_1_1
channel ORA_DISK_1: piece handle=/bak/stg/20190428/stg_lev0_201904281826_0ku052ao_1_1 tag=STG_LEV0_201904281826
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/stg/stg/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/stg/stg/users01.dbf
channel ORA_DISK_1: reading from backup piece /bak/stg/20190428/stg_lev0_201904281826_0ju052ao_1_1
channel ORA_DISK_1: piece handle=/bak/stg/20190428/stg_lev0_201904281826_0ju052ao_1_1 tag=STG_LEV0_201904281826
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:02:16
Finished restore at 29-APR-19

Starting recover at 29-APR-19
using channel ORA_DISK_1

starting media recovery

channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=15
channel ORA_DISK_1: reading from backup piece /bak/stg/20190428/stg_lev0_201904281826_arc_0mu052ef_1_1
channel ORA_DISK_1: piece handle=/bak/stg/20190428/stg_lev0_201904281826_arc_0mu052ef_1_1 tag=STG_ARC_201904281826
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/u01/app/oracle/flash_recovery_area/STG/archivelog/2019_04_29/o1_mf_1_15_gdfh20pj_.arc thread=1 sequence=15
channel default: deleting archived log(s)
archived log file name=/u01/app/oracle/flash_recovery_area/STG/archivelog/2019_04_29/o1_mf_1_15_gdfh20pj_.arc RECID=9 STAMP=1006880193
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=16
channel ORA_DISK_1: reading from backup piece /bak/stg/20190428/stg_lev0_201904281826_arc_0nu052ef_1_1
channel ORA_DISK_1: piece handle=/bak/stg/20190428/stg_lev0_201904281826_arc_0nu052ef_1_1 tag=STG_ARC_201904281826
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/u01/app/oracle/flash_recovery_area/STG/archivelog/2019_04_29/o1_mf_1_16_gdfh21s6_.arc thread=1 sequence=16
channel default: deleting archived log(s)
archived log file name=/u01/app/oracle/flash_recovery_area/STG/archivelog/2019_04_29/o1_mf_1_16_gdfh21s6_.arc RECID=10 STAMP=1006880193
media recovery complete, elapsed time: 00:00:01
Finished recover at 29-APR-19

database opened
repair failure complete

 

川xc
关注
专栏目录
oracle历史命令查询,Oracle中查看sql命令历史,查看rman命令历史
weixin_30387635的博客
04-02 947
就像$HOME下的.bash_history 会存储当前用户的shell命令执行历史一样如果在oracle server上安装了uniread以解决SQL提示符下命令记录问题，那么，同样可以获得sql或rman命令的执行历史.当我们需要查找曾经执行过哪些命令时，直接从uniread历史文件中查找比从SQL>或RMAN>下通过上下方向键查找要方便得多.uniread --helpUsag...
Oracle-RMAN增量备份恢复测试记录.docx
最新发布
11-16
Oracle-RMAN增量备份恢复测试记录 Oracle-RMAN增量备份恢复测试记录是对Oracle数据库进行增量备份和恢复的测试记录，旨在记录增量备份和恢复的过程、命令和结果。下面是该测试记录的详细说明和知识点： 1. 概述： ...
Oracle RMAN
03-25
旧版Oracle Rman 备份！
Rman 常用命令
dbatravel的专栏
09-24 603
查看备份 list命令列出控制文件、RMAN恢复目录中备份信息，是我们对所有可见的数据库备份文件的一个最直观的了解的方法     list incarnation of database;    --查看对应物     list backup summary;     B 表示backup     A 表示Archivelog、 F 表示full backup、 0,1,2 表示i
RMAN输出到log文件中
' 忍一时风平浪静 退一步海阔天空 '
09-12 3453
一、RMAN输出： 1）只输出到log日志中： $rman LOG /u01/app/oracle/rman.log 2）输出到屏幕和log日志中： $rman | tee /u01/app/oracle/rman.log 二、rman备份副本： 1、使用configure  。。。 backup copies 2、在run块中使用set backup copies 3、在ba
rman 备份时启动写log功能
cucanqi9387的博客
12-19 85
C:\Documents and Settings\Paul Yi>rman target / catalog paultest/paultest@dev89log=d:\rman.logRMAN> backup...
Oracle RMAN增量备份恢复测试记录.docx
05-20
### Oracle RMAN增量备份恢复测试记录 #### 一、概述 **1.1、增量备份的基本概念** **1.1.1、概念** 增量备份是一种只备份自上次完整备份或上次增量备份以来发生变化的数据的技术。这种方法可以显著减少备份所需...
Oracle-RMAN增量备份恢复测试记录
12-28
Oracle-RMAN增量备份恢复测试记录 Oracle-RMAN增量备份恢复测试记录是指使用Oracle Recovery Manager（RMAN）工具对Oracle数据库进行增量备份和恢复的测试记录。本记录涵盖了增量备份的基本概念、备份策略及恢复、...
OracleRMAN增量备份恢复测试记录.docx
09-27
### Oracle RMAN 增量备份恢复测试记录 #### 一、概述 ##### 1.1、增量备份的基本概念 **1.1.1、概念** 增量备份是一种备份策略，只备份自上次完整备份或增量备份以来发生变化的数据。在Oracle RMAN中，这种备份...
rman备份时记录更多的log 或者trace信息
小麦苗DBA宝典
06-04 384
有时候，我们备份时会hang住，或出现莫名其妙的问题 有以下2种方法，可以多记录log 1: 分配通道时 RMAN> allocate channel t1 devic...
oracle RMAN 执行后只备份log 文件
oraly的博客
11-15 425
可能是因为没开启归档模式，所以要打开oracle 的归档模式 参考：http://www.cnblogs.com/xwdreamer/p/3793792.html 其实，只要打开那个log文件，就会就会发现里面写到 ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode  ...
rman 如何记录日志及如何对rman命令进行debug
wgz7747147820的博客
10-01 1756
rman如何记录日志及如何对rman命令进行debug
记录RMAN显示的结果
文档搬运工
05-01 484
1 使用tee命令2 使用script命令3 使用spool log命令4 使用v$rman_output -- 重启DB后会消失==============================================1 使用tee命令[oracle@orcl12c ~]$ rman target / | tee /tmp/rman.log Recovery Manager: Release...
RMAN
建伟博客
01-03 1356
RMAN是 ORACLE提供的一个备份与恢复的工具，可以用来备份和还原数据库文件、 归档日志和控制文件。它也可以用来执行完全或不完全的数据库恢复。 RMAN可以由命令行接口或者 OEM的 Backup Manager GUI 来控制。 4.1 基本知识 4.1.1 RMAN的组件、概念   1．  RMAN  主要包括以下组件：
Rman
小胡子
05-09 146
RMAN 备份详解
anjichan4261的博客
11-24 453
--====================== -- RMAN 备份详解 --====================== 一、数据库备份与RMAN备份的概念 1.数据库完全备份：按归档模式分为归档和非归档 归档模式 打开状态，属于非一致性备份 关闭状态，可以分为一致性和非一致性 ...
RMAN 简单介绍
阿磊的菜鸟
11-11 944
最近拜读Todd Bao《oracle 11g 数据库恢复技术》整理一下： 针对device type disk Rman： 主要组成部分： 1）目标数据库 2）Rman客户端（执行备份命令） 3）通道（channel） 4）RMAN备份资料库 5）备份地点 目标数据库：需要备份的数据库 Rman客户端：执行命令端 Channel（通道）： 是指由服务器进程发起并控制目标
RMAN详解（一）
cuanyileng9247的博客
09-23 174
先普及一下备份概念知识 逻辑备份：是利用SQL语言从数据库中抽取数据并存于二进制文件的过程 物理备份：是将实际组成数据库的操作系统文件（数据文件，日志文件，控制文件）从一处拷贝到另一处的备份过程。 ...
Oracle RMAN增量备份与恢复实战记录
Oracle-RMAN增量备份恢复测试记录是一篇详细的文档，由朱晓凯在2012年3月29日创建，针对Oracle数据库管理工具RMAN（Recovery Manager）进行了增量备份和恢复操作的记录。本文档主要分为三个部分：一、概述了增量备份...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值