Oracle rman备份和恢复

最新推荐文章于 2024-02-26 21:13:10 发布
最新推荐文章于 2024-02-26 21:13:10 发布
阅读量357 收藏 2
点赞数
文章标签： linux oracle
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_45833902/article/details/106748081
版权

使用rman备份

使用rman备份前Oracle必须要先开启归档日志

SQL> archive log list;

在这里插入图片描述
当前是处于开启归档状态如未开启可借鉴Oracle开启归档模式https://blog.csdn.net/weixin_45833902/article/details/106634230

登录rman工具

[oracle@zzw ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Sun Jun 14 16:28:54 2020

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: CISDB (DBID=87462260, not open)

对数据库进行全备份


RMAN> backup database;

Starting backup at 2020-06-14 15:43:46
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=9 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00005 name=/home/db/oracle/oradata/cisdb/ogg_tbs_01.dbf
input datafile file number=00001 name=/home/db/oracle/oradata/cisdb/system01.dbf
input datafile file number=00002 name=/home/db/oracle/oradata/cisdb/sysaux01.dbf
input datafile file number=00003 name=/home/db/oracle/oradata/cisdb/undotbs01.dbf
input datafile file number=00004 name=/home/db/oracle/oradata/cisdb/users01.dbf
channel ORA_DISK_1: starting piece 1 at 2020-06-14 15:43:46
channel ORA_DISK_1: finished piece 1 at 2020-06-14 15:45:03
piece handle=/home/db/oracle/fast_recovery_area/CISDB/backupset/2020_06_14/o1_mf_nnndf_TAG20200614T154346_hgco9m0o_.bkp tag=TAG20200614T154346 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:17
Finished backup at 2020-06-14 15:45:03

Starting Control File and SPFILE Autobackup at 2020-06-14 15:45:03
piece handle=/home/db/oracle/fast_recovery_area/CISDB/autobackup/2020_06_14/o1_mf_s_1043077503_hgcocz45_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2020-06-14 15:45:04

查看备份是否成功或查看之前备份

RMAN> list backup;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
1       Full    1.03G      DISK        00:03:02     2020-06-09 17:05:40
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20200609T170238
        Piece Name: /home/db/oracle/fast_recovery_area/CISDB/backupset/2020_06_09/o1_mf_nnndf_TAG20200609T170238_hfyn1g4h_.bkp
  List of Datafiles in backup set 1
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1       Full 1353764    2020-06-09 17:02:38 /home/db/oracle/oradata/cisdb/system01.dbf
  2       Full 1353764    2020-06-09 17:02:38 /home/db/oracle/oradata/cisdb/sysaux01.dbf
  3       Full 1353764    2020-06-09 17:02:38 /home/db/oracle/oradata/cisdb/undotbs01.dbf
  4       Full 1353764    2020-06-09 17:02:38 /home/db/oracle/oradata/cisdb/users01.dbf
  5       Full 1353764    2020-06-09 17:02:38 /home/db/oracle/oradata/cisdb/ogg_tbs_01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
2       Full    9.36M      DISK        00:00:01     2020-06-09 17:05:52
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20200609T170238
        Piece Name: /home/db/oracle/fast_recovery_area/CISDB/backupset/2020_06_09/o1_mf_ncsnf_TAG20200609T170238_hfyn7j77_.bkp
  SPFILE Included: Modification time: 2020-06-09 15:21:17
  SPFILE db_unique_name: CISDB
  Control File Included: Ckp SCN: 1353831      Ckp time: 2020-06-09 17:05:50

BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
3       Full    1.03G      DISK        00:09:59     2020-06-09 22:10:41
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20200609T220042
        Piece Name: /home/db/oracle/fast_recovery_area/CISDB/backupset/2020_06_09/o1_mf_nnndf_TAG20200609T220042_hfz5jn00_.bkp
  List of Datafiles in backup set 3
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1       Full 1378912    2020-06-09 22:00:43 /home/db/oracle/oradata/cisdb/system01.dbf
  2       Full 1378912    2020-06-09 22:00:43 /home/db/oracle/oradata/cisdb/sysaux01.dbf
  3       Full 1378912    2020-06-09 22:00:43 /home/db/oracle/oradata/cisdb/undotbs01.dbf
  4       Full 1378912    2020-06-09 22:00:43 /home/db/oracle/oradata/cisdb/users01.dbf
  5       Full 1378912    2020-06-09 22:00:43 /home/db/oracle/oradata/cisdb/ogg_tbs_01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
4       Full    9.36M      DISK        00:00:02     2020-06-09 22:10:53
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: TAG20200609T221051
        Piece Name: /home/db/oracle/fast_recovery_area/CISDB/autobackup/2020_06_09/o1_mf_s_1042668651_hfz63dld_.bkp
  SPFILE Included: Modification time: 2020-06-09 19:25:28
  SPFILE db_unique_name: CISDB
  Control File Included: Ckp SCN: 1383081      Ckp time: 2020-06-09 22:10:51

BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
5       Full    9.36M      DISK        00:00:01     2020-06-14 15:19:33
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: TAG20200614T151932
        Piece Name: /home/db/oracle/fast_recovery_area/CISDB/autobackup/2020_06_14/o1_mf_s_1043075972_hgcmw53l_.bkp
  SPFILE Included: Modification time: 2020-06-14 15:11:36
  SPFILE db_unique_name: CISDB
  Control File Included: Ckp SCN: 1409100      Ckp time: 2020-06-14 15:19:32

BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
6       Full    1.06G      DISK        00:01:12     2020-06-14 15:44:58
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20200614T154346
        Piece Name: /home/db/oracle/fast_recovery_area/CISDB/backupset/2020_06_14/o1_mf_nnndf_TAG20200614T154346_hgco9m0o_.bkp
  List of Datafiles in backup set 6
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1       Full 1410727    2020-06-14 15:43:47 /home/db/oracle/oradata/cisdb/system01.dbf
  2       Full 1410727    2020-06-14 15:43:47 /home/db/oracle/oradata/cisdb/sysaux01.dbf
  3       Full 1410727    2020-06-14 15:43:47 /home/db/oracle/oradata/cisdb/undotbs01.dbf
  4       Full 1410727    2020-06-14 15:43:47 /home/db/oracle/oradata/cisdb/users01.dbf
  5       Full 1410727    2020-06-14 15:43:47 /home/db/oracle/oradata/cisdb/ogg_tbs_01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
7       Full    9.36M      DISK        00:00:00     2020-06-14 15:45:03
        BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: TAG20200614T154503
        Piece Name: /home/db/oracle/fast_recovery_area/CISDB/autobackup/2020_06_14/o1_mf_s_1043077503_hgcocz45_.bkp
  SPFILE Included: Modification time: 2020-06-14 15:20:09
  SPFILE db_unique_name: CISDB
  Control File Included: Ckp SCN: 1410759      Ckp time: 2020-06-14 15:45:03

可以看到我一共进行过三次全备份

使用rman备份实现恢复

现在假设有一个数据文件被我误删除了
先把数据库给停了

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

[oracle@zzw dbhome_1]$ cd /home/db/oracle/oradata/cisdb
[oracle@zzw cisdb]$ ll
total 7335952
-rwxr-xr-x. 1 oracle oinstall    9748480 Jun 14 15:15 control01.ctl
-rwxr-xr-x. 1 oracle oinstall 5368717312 Jun 14 15:03 ogg_tbs_01.dbf
-rwxr-xr-x. 1 oracle oinstall  209715712 Jun 14 13:58 redo01.log
-rwxr-xr-x. 1 oracle oinstall  209715712 Jun 14 13:03 redo02.log
-rwxr-xr-x. 1 oracle oinstall  209715712 Jun 14 13:03 redo03.log
-rwxr-xr-x. 1 oracle oinstall  587210752 Jun 14 15:13 sysaux01.dbf
-rwxr-xr-x. 1 oracle oinstall  786440192 Jun 14 15:13 system01.dbf
-rwxr-xr-x. 1 oracle oinstall   47194112 Jun 14 13:04 temp01.dbf
-rwxr-xr-x. 1 oracle oinstall   73408512 Jun 14 15:12 undotbs01.dbf
-rw-r-----. 1 oracle oinstall   53747712 Jun 14 15:12 users01.dbf
[oracle@zzw cisdb]$ rm users01.dbf 
[oracle@zzw cisdb]$ ll
total 7283464
-rwxr-xr-x. 1 oracle oinstall    9748480 Jun 14 16:19 control01.ctl
-rwxr-xr-x. 1 oracle oinstall 5368717312 Jun 14 16:19 ogg_tbs_01.dbf
-rwxr-xr-x. 1 oracle oinstall  209715712 Jun 14 16:19 redo01.log
-rwxr-xr-x. 1 oracle oinstall  209715712 Jun 14 15:19 redo02.log
-rwxr-xr-x. 1 oracle oinstall  209715712 Jun 14 15:19 redo03.log
-rwxr-xr-x. 1 oracle oinstall  587210752 Jun 14 16:19 sysaux01.dbf
-rwxr-xr-x. 1 oracle oinstall  786440192 Jun 14 16:19 system01.dbf
-rwxr-xr-x. 1 oracle oinstall   47194112 Jun 14 16:07 temp01.dbf
-rwxr-xr-x. 1 oracle oinstall   73408512 Jun 14 16:19 undotbs01.dbf

数据库启为mount状态

SQL> startup mount
ORACLE instance started.

Total System Global Area 1887350784 bytes
Fixed Size                  2254344 bytes
Variable Size             503319032 bytes
Database Buffers         1375731712 bytes
Redo Buffers                6045696 bytes
Database mounted.

登录到rman工具进行备份恢复

[oracle@saperp admin]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Sat May 2 20:47:10 2020

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ERP (DBID=278491646)

恢复users01.dbf 文件

通过list backup可知users01.dbf为datafile 4

6       Full    1.06G      DISK        00:01:12     2020-06-14 15:44:58
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20200614T154346
        Piece Name: /home/db/oracle/fast_recovery_area/CISDB/backupset/2020_06_14/o1_mf_nnndf_TAG20200614T154346_hgco9m0o_.bkp
  List of Datafiles in backup set 6
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1       Full 1410727    2020-06-14 15:43:47 /home/db/oracle/oradata/cisdb/system01.dbf
  2       Full 1410727    2020-06-14 15:43:47 /home/db/oracle/oradata/cisdb/sysaux01.dbf
  3       Full 1410727    2020-06-14 15:43:47 /home/db/oracle/oradata/cisdb/undotbs01.dbf
  4       Full 1410727    2020-06-14 15:43:47 /home/db/oracle/oradata/cisdb/users01.dbf
  5       Full 1410727    2020-06-14 15:43:47 /home/db/oracle/oradata/cisdb/ogg_tbs_01.dbf

开始恢复users01.dbf文件

RMAN> restore datafile 4;

Starting restore at 2020-06-14 21:12:32
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=249 device type=DISK

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 /home/db/oracle/oradata/erp/system01.dbf
channel ORA_DISK_1: restoring datafile 00002 to /home/db/oracle/oradata/erp/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /home/db/oracle/oradata/erp/undotbs1.dbf
channel ORA_DISK_1: restoring datafile 00004 to /home/db/oracle/oradata/erp/PARTTBS103.dbf
channel ORA_DISK_1: restoring datafile 00005 to /home/db/oracle/oradata/erp/PARTTBS102.dbf
channel ORA_DISK_1: restoring datafile 00006 to /home/db/oracle/oradata/erp/PARTTBS101.dbf
channel ORA_DISK_1: restoring datafile 00007 to /home/db/oracle/oradata/erp/USERS01.dbf
channel ORA_DISK_1: restoring datafile 00008 to /home/db/oracle/oradata/erp/JYCTBS03.dbf
channel ORA_DISK_1: restoring datafile 00009 to /home/db/oracle/oradata/erp/JYCTBS02.dbf
channel ORA_DISK_1: restoring datafile 00010 to /home/db/oracle/oradata/erp/JYCTBS01.dbf
channel ORA_DISK_1: restoring datafile 00011 to /home/db/oracle/oradata/erp/TESTTBS103.dbf
channel ORA_DISK_1: restoring datafile 00012 to /home/db/oracle/oradata/erp/TESTTBS102.dbf
channel ORA_DISK_1: restoring datafile 00013 to /home/db/oracle/oradata/erp/TESTTBS101.dbf
channel ORA_DISK_1: restoring datafile 00014 to /home/db/oracle/oradata/erp/TESTTBS202.dbf
channel ORA_DISK_1: restoring datafile 00015 to /home/db/oracle/oradata/erp/TESTTBS201.dbf
channel ORA_DISK_1: restoring datafile 00016 to /home/db/oracle/oradata/erp/APEX_1301369653334498.dbf
channel ORA_DISK_1: restoring datafile 00017 to /home/db/oracle/oradata/erp/APEX_1706321139930175.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/dmp/bk_20_1_1039381174
channel ORA_DISK_1: piece handle=/home/oracle/dmp/bk_20_1_1039381174 tag=HOT_DB_BK_LEVEL0
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
Finished restore at 2020-06-14 21:12:32

RMAN> recover datafile 4;

Starting recover at 2020-06-14 21:12:32
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: /home/db/oracle/oradata/erp/system01.dbf
destination for restore of datafile 00002: /home/db/oracle/oradata/erp/sysaux01.dbf
destination for restore of datafile 00003: /home/db/oracle/oradata/erp/undotbs1.dbf
destination for restore of datafile 00004: /home/db/oracle/oradata/erp/PARTTBS103.dbf
destination for restore of datafile 00005: /home/db/oracle/oradata/erp/PARTTBS102.dbf
destination for restore of datafile 00006: /home/db/oracle/oradata/erp/PARTTBS101.dbf
destination for restore of datafile 00007: /home/db/oracle/oradata/erp/USERS01.dbf
destination for restore of datafile 00008: /home/db/oracle/oradata/erp/JYCTBS03.dbf
destination for restore of datafile 00009: /home/db/oracle/oradata/erp/JYCTBS02.dbf
destination for restore of datafile 00010: /home/db/oracle/oradata/erp/JYCTBS01.dbf
destination for restore of datafile 00011: /home/db/oracle/oradata/erp/TESTTBS103.dbf
destination for restore of datafile 00012: /home/db/oracle/oradata/erp/TESTTBS102.dbf
destination for restore of datafile 00013: /home/db/oracle/oradata/erp/TESTTBS101.dbf
destination for restore of datafile 00014: /home/db/oracle/oradata/erp/TESTTBS202.dbf
destination for restore of datafile 00015: /home/db/oracle/oradata/erp/TESTTBS201.dbf
destination for restore of datafile 00016: /home/db/oracle/oradata/erp/APEX_1301369653334498.dbf
destination for restore of datafile 00017: /home/db/oracle/oradata/erp/APEX_1706321139930175.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/dmp/bk_22_1_1039381211
channel ORA_DISK_1: piece handle=/home/oracle/dmp/bk_22_1_1039381211 tag=HOT_DB_BK_LEVEL1
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

starting media recovery

archived log for thread 1 with sequence 44 is already on disk as file /home/db/oracle/oradata/erp/redo02.log
archived log file name=/home/db/oracle/oradata/erp/redo02.log thread=1 sequence=44
media recovery complete, elapsed time: 00:00:00
Finished recover at 2020-06-14 21:12:32


RMAN> alter database open；

database opened

全库恢复

RMAN> restore database;

Starting restore at 2020-05-02 21:12:32
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=249 device type=DISK

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 /home/db/oracle/oradata/erp/system01.dbf
channel ORA_DISK_1: restoring datafile 00002 to /home/db/oracle/oradata/erp/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /home/db/oracle/oradata/erp/undotbs1.dbf
channel ORA_DISK_1: restoring datafile 00004 to /home/db/oracle/oradata/erp/PARTTBS103.dbf
channel ORA_DISK_1: restoring datafile 00005 to /home/db/oracle/oradata/erp/PARTTBS102.dbf
channel ORA_DISK_1: restoring datafile 00006 to /home/db/oracle/oradata/erp/PARTTBS101.dbf
channel ORA_DISK_1: restoring datafile 00007 to /home/db/oracle/oradata/erp/USERS01.dbf
channel ORA_DISK_1: restoring datafile 00008 to /home/db/oracle/oradata/erp/JYCTBS03.dbf
channel ORA_DISK_1: restoring datafile 00009 to /home/db/oracle/oradata/erp/JYCTBS02.dbf
channel ORA_DISK_1: restoring datafile 00010 to /home/db/oracle/oradata/erp/JYCTBS01.dbf
channel ORA_DISK_1: restoring datafile 00011 to /home/db/oracle/oradata/erp/TESTTBS103.dbf
channel ORA_DISK_1: restoring datafile 00012 to /home/db/oracle/oradata/erp/TESTTBS102.dbf
channel ORA_DISK_1: restoring datafile 00013 to /home/db/oracle/oradata/erp/TESTTBS101.dbf
channel ORA_DISK_1: restoring datafile 00014 to /home/db/oracle/oradata/erp/TESTTBS202.dbf
channel ORA_DISK_1: restoring datafile 00015 to /home/db/oracle/oradata/erp/TESTTBS201.dbf
channel ORA_DISK_1: restoring datafile 00016 to /home/db/oracle/oradata/erp/APEX_1301369653334498.dbf
channel ORA_DISK_1: restoring datafile 00017 to /home/db/oracle/oradata/erp/APEX_1706321139930175.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/dmp/bk_20_1_1039381174
channel ORA_DISK_1: piece handle=/home/oracle/dmp/bk_20_1_1039381174 tag=HOT_DB_BK_LEVEL0
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
Finished restore at 2020-05-02 21:12:35

RMAN> recover database;

Starting recover at 2020-05-02 21:13:21
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: /home/db/oracle/oradata/erp/system01.dbf
destination for restore of datafile 00002: /home/db/oracle/oradata/erp/sysaux01.dbf
destination for restore of datafile 00003: /home/db/oracle/oradata/erp/undotbs1.dbf
destination for restore of datafile 00004: /home/db/oracle/oradata/erp/PARTTBS103.dbf
destination for restore of datafile 00005: /home/db/oracle/oradata/erp/PARTTBS102.dbf
destination for restore of datafile 00006: /home/db/oracle/oradata/erp/PARTTBS101.dbf
destination for restore of datafile 00007: /home/db/oracle/oradata/erp/USERS01.dbf
destination for restore of datafile 00008: /home/db/oracle/oradata/erp/JYCTBS03.dbf
destination for restore of datafile 00009: /home/db/oracle/oradata/erp/JYCTBS02.dbf
destination for restore of datafile 00010: /home/db/oracle/oradata/erp/JYCTBS01.dbf
destination for restore of datafile 00011: /home/db/oracle/oradata/erp/TESTTBS103.dbf
destination for restore of datafile 00012: /home/db/oracle/oradata/erp/TESTTBS102.dbf
destination for restore of datafile 00013: /home/db/oracle/oradata/erp/TESTTBS101.dbf
destination for restore of datafile 00014: /home/db/oracle/oradata/erp/TESTTBS202.dbf
destination for restore of datafile 00015: /home/db/oracle/oradata/erp/TESTTBS201.dbf
destination for restore of datafile 00016: /home/db/oracle/oradata/erp/APEX_1301369653334498.dbf
destination for restore of datafile 00017: /home/db/oracle/oradata/erp/APEX_1706321139930175.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/dmp/bk_22_1_1039381211
channel ORA_DISK_1: piece handle=/home/oracle/dmp/bk_22_1_1039381211 tag=HOT_DB_BK_LEVEL1
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

starting media recovery

archived log for thread 1 with sequence 44 is already on disk as file /home/db/oracle/oradata/erp/redo02.log
archived log file name=/home/db/oracle/oradata/erp/redo02.log thread=1 sequence=44
media recovery complete, elapsed time: 00:00:00
Finished recover at 2020-05-02 21:13:23
冥净
关注
  • 0
    点赞
  • 踩
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
【非归档模式下使用RMAN进行全库备份（适用于培训和测试环境）】
AllanHwang的博客
11-18 1611
非归档模式下使用RMAN进行全库备份，实验分别演示了数据库不同状态下删除不同文件的恢复操作。
Oracle 11g R2 Rman备份与恢复_刘耀龙的博客-CSDN博客_rman备份.pdf
09-13
Oracle 11g R2 Rman备份与恢复_刘耀龙的博客-CSDN博客_rman备份
Oracle-RMAN备份恢复
weixin_42410464的博客
08-17 1024
Oracle提供的recovery manager工具简称RMAN。极大简化我们的备份工作1.备份数据文件、归档日志、控制文件、spfile2.自动维护备份相关的元数据，例如备份文件的名称，完成备份的SCN号3.以数据块为单位进行备份，只备份使用过的数据块4.对备份出来的文件进行压缩5.自动检测数据库是否损坏6.支持增量备份......
Oracle RMAN 备份与恢复
独醉的博客
01-07 7774
这里写目录标题一、RMAN 备份与恢复1.RMAN备份（1）连接数据库（2）通道分配（3）RMAN 备份类型（4）BACKUP 命令（5）FORMAT 参数替换变量2.RMAN 恢复(1)数据库进行完全介质恢复（2）表空间的恢复（3）恢复数据文件（4）恢复控制文件二级目录三级目录 一、RMAN 备份与恢复        RMAN (Recovery Manager)是 Oracle 恢复管理器的简称，是集数据库备份（Backup）、还原（
Oracle RMAN 备份恢复
最新发布
weixin_63131036的博客
02-26 1797
RMAN在数据库服务器的帮助下实现数据库文件、控制文件、数据库文件和控制文件的映像副本，以及归档日志文件，数据库服务器参数文件的备份。RMAN也允许使用脚本文件实现数据的备份与恢复，而且这些脚本保存在数据库内，而不需要编写基于OS的脚本文件。RMAN备份的文件自动保存在一个系统指定的目录下，文件的名称也由RMAN自己维护。当实现数据库恢复操作时，恢复指令简洁，RMAN自动寻找需要的文件实现数据恢复。减少了传统的导出程序中人为错误的发生。
顶级DBA漫谈Oracle Rman备份与恢复
09-01
以下是Oracle RMAN备份与恢复的相关知识点： 备份恢复概述 备份恢复是DBA管理员的基本技能之一，旨在保护数据库中的数据免受意外损坏或丢失。 Oracle RMAN提供了强大的备份和恢复功能，帮助DBA管理员快速恢复...
实战Oracle rman还原和恢复
04-22
Oracle RMAN（Recovery Manager）是Oracle数据库管理系统中用于备份、恢复和维护的重要工具。它提供了全面的数据保护功能，能够帮助管理员在发生数据丢失或系统故障时迅速恢复数据。本篇将详细介绍Oracle RMAN的还原...
傻瓜式实战OracleRMAN数据库备份和恢复视频
07-23
教程名称：傻瓜式实战Oracle RMAN数据库备份和恢复视频课程目录：【】数据库备份和恢复系列].ITBOBA_RMAN_1【】数据库备份和恢复系列].ITBOBA_RMAN_10【】数据库备份和恢复系列].ITBOBA_RMAN_2【】数据库备份和恢复...
RMAN备份和恢复笔记
新月的专栏
04-16 1613
RMAN备份和恢复
超经典的Oraclerman增量备份恢复策略.pdf
07-04
超经典的Oracle rman增量备份恢复策略，DBA工作过程中，在对数据库进行备份的时候可以参考此文档
oracle RMAN备份与恢复
Linucle的专栏
01-16 4612
rman命令的使用 连接rman [oracle@localhost ~]$ rlwrap rman target /           把所有的信息输出到一个文件中 [oracle@hxy archivelog]$ rlwrap rman target / log '/home/oracle/backuplog/rman_log.txt'     注意：使用rman备份，数据库必须运
oracle学习38-rman备份-全库恢复
qq_41632427的博客
08-08 364
oracle
Oracle：RMAN备份和恢复
燕双嘤
05-16 1556
一，基本命令 一，使用RMAN-cmd运行 rman target / rman target system/123456 rman target scott/tiger 二，备份查询 list backup; 备份集列表【归档日志文件、数据文件、spfile、control file】 report obsolete; 用于列出rman资料库中能够被删除的全备份、数据文件...
oracle rman备份和恢复,oracleRMAN备份与恢复实验
weixin_35589806的博客
04-10 351
========================RMAN数据库全库备份=========================================[oracle@localhost ~]$ rman target /RMAN> backup incremental level =0 database format='/home/oracle/db_bak/%u';Starting ba...
oracle adg 备份,Oracle Physical Dataguard环境使用RMAN备份和恢复
weixin_35326667的博客
04-08 988
Oracle Physical Dataguard环境使用RMAN备份和恢复由于Physical Dataguard使用的是块恢复技术来保持和PRIMARY的一致性，因此可以在STANDBY上进行rman备份，从而减轻PRIMARY的压力.当PRIMARY出现数据库故障时，可以使用在STANDBY上的备份来进行恢复.先决条件：需要配置catalog.在PRIMARY上以catalog方式连接，并且...
oracle 安全备份与rman_Oracle备份与恢复--RMAN篇
weixin_34702885的博客
01-11 107
一．整体数据库的备份与恢复1.备份：(在10G版本中测试)增量备份会自动备份数据库中的数据库文件，控制文件，参数文件，备份完成后会有两个备份集生成，一个是由数据文件组成，另一个是由控制文件和参数文件组成。之所以自动备份控制文件，也许是由于RMAN是在非目录(nocatalog)的环境下工作的结果，因为此时所有的备份信息都存放在控制文件中。问题1：如何记录下控制文件备份集的名字，以便在特定情况下单独...
Oracle RMAN备份与还原 - 脱机备份讲解
YunWisdom
08-01 744
Oracle RMAN备份与还原 - 脱机备份讲解 　　 　　RMAN在数据库服务器的帮助下实现数据库文件、控制文件、数据库文件与控制文件的映像副本、归档日志文件、数据库服务器参数文件的备份。 　　RMAN的特点： (1) 支持增量备份：传统的exp与expdp备份工具，只能实现一个完整备份而不能增量备份，RMAN采用备份级别实现增量备份，在一个完整的备份基础上采用增量备份可以大大减少备份...
rman备份恢复详细方案和介绍
热门推荐
Brent的专栏
06-28 1万+
文档下载地址:https://download.csdn.net/download/su377486/11262567 备份工具 rman简介 RMAN（Recovery Manager）是随Oracle服务器软件一同安装的工具软件，它可以用来备份和恢复数据库文件、归档日志和控制文件，用来执行完全或不完全的数据库恢复。与传统工具相比，RMAN具有独特的优势：跳过未使...
Oracle_RMAN(备份与恢复管理器)
04-03
Oracle RMAN (备份与恢复管理器) 是一个用于Oracle数据库备份和恢复的工具。在使用RMAN进行备份之前，必须启动Oracle的归档日志功能。 为了检查数据库的归档日志模式，首先需要使用DBA用户登录系统，并执行如下的...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值