Oracle
ORACLE12C归档模式下RMAN全数据库备份
阿开 2021-01-19 14:05:09 36068 0 0 0 0

网站名称：ORACLE12C归档模式下RMAN全数据库备份

网站地址：

[SEO信息] [Alexa信息]

-->>直达网站

ORACLE12C归档模式下RMAN全数据库备份

--首先，确认当前模式，为归档模式
SQL> archive log list
Database log mode	       Archive Mode
Automatic archival	       Enabled
Archive destination	       /home/oracle/archivelog/
Oldest online log sequence     15
Next log sequence to archive   17
Current log sequence	       17
...
以系统备份的角色，登录rman工具，DBID号最好保留记录，以后在特定情况下恢复数据库可能用得到(例如用rman全数据库备份,然后rman恢复到异机，就是非本机)
[oracle@host01 archivelog]$ rman target "'/ as sysbackup'"
Recovery Manager: Release 18.0.0.0.0 - Production on Mon Jan 18 21:27:06 2021
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates.  All rights reserved.
connected to target database: ORCL (DBID=1535621266)   #DBID号非常重要，最好单独记录下来
...
--进行全数据库的备份
当前数据库不用关闭，直接热备
RMAN> backup database plus archivelog;
...
Starting backup at 18-JAN-21       #开始归档日志文件的备份（seq14-15）
current log archived                        
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=79 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=14 RECID=16 STAMP=1062185952
input archived log thread=1 sequence=15 RECID=17 STAMP=1062192475
channel ORA_DISK_1: starting piece 1 at 18-JAN-21
channel ORA_DISK_1: finished piece 1 at 18-JAN-21
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/ORCL/backupset/2021_01_18/o1_mf_annnn_TAG20210118T212757_j0c36z0g_.bkp tag=TAG20210118T212757 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:16
Finished backup at 18-JAN-21      #完成归档日志文件的备份（seq14-15）
...
Starting backup at 18-JAN-21       #开始数据文件备份
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/ORCL/system01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/ORCL/sysaux01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/ORCL/undotbs01.dbf
input datafile file number=00007 name=/u01/app/oracle/oradata/ORCL/users01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/ORCL/noarchivetest.dbf
channel ORA_DISK_1: starting piece 1 at 18-JAN-21
channel ORA_DISK_1: finished piece 1 at 18-JAN-21
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/ORCL/backupset/2021_01_18/o1_mf_nnndf_TAG20210118T212816_j0c37l4v_.bkp tag=TAG20210118T212816 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:04:22
Finished backup at 18-JAN-21   #完成数据文件备份
...
Starting backup at 18-JAN-21    #开始归档日志文件的备份（seq16）
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=16 RECID=18 STAMP=1062192759
channel ORA_DISK_1: starting piece 1 at 18-JAN-21
channel ORA_DISK_1: finished piece 1 at 18-JAN-21
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/ORCL/backupset/2021_01_18/o1_mf_annnn_TAG20210118T213240_j0c3hr5o_.bkp tag=TAG20210118T213240 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 18-JAN-21  #完成归档日志文件的备份（seq16）
...
Starting Control File and SPFILE Autobackup at 18-JAN-21 #开始控制文件和参数文件的备份
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/ORCL/autobackup/2021_01_18/o1_mf_s_1062192761_j0c3hthv_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 18-JAN-21 #完成了控制文件和参数文件的备份
...
--查看备份集，BS Key1和2 是非归档模式下的rman备份（冷备），3到6是归档模式下的备份，也就是上面操作的备份文件（热备）
RMAN> list backupset;
List of Backup Sets
===================
BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1       Full    1.22G      DISK        00:02:46     17-JAN-21      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20210117T182716
        Piece Name: /u01/app/oracle/fast_recovery_area/ORCL/ORCL/backupset/2021_01_17/o1_mf_nnndf_TAG20210117T182716_j084850o_.bkp
  List of Datafiles in backup set 1
  File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name
  ---- -- ---- ---------- --------- ----------- ------ ----
  1       Full 2019591    17-JAN-21              NO    /u01/app/oracle/oradata/ORCL/system01.dbf
  3       Full 2019591    17-JAN-21              NO    /u01/app/oracle/oradata/ORCL/sysaux01.dbf
  4       Full 2019591    17-JAN-21              NO    /u01/app/oracle/oradata/ORCL/undotbs01.dbf
  5       Full 2019591    17-JAN-21              NO    /u01/app/oracle/oradata/ORCL/noarchivetest.dbf
  7       Full 2019591    17-JAN-21              NO    /u01/app/oracle/oradata/ORCL/users01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2       Full    10.20M     DISK        00:00:01     17-JAN-21      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20210117T183018
        Piece Name: /u01/app/oracle/fast_recovery_area/ORCL/ORCL/autobackup/2021_01_17/o1_mf_s_1062095142_j084fvvy_.bkp
  SPFILE Included: Modification time: 17-JAN-21
  SPFILE db_unique_name: ORCL
  Control File Included: Ckp SCN: 2019591      Ckp time: 17-JAN-21

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
3       100.02M    DISK        00:00:08     18-JAN-21      
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20210118T212757
        Piece Name: /u01/app/oracle/fast_recovery_area/ORCL/ORCL/backupset/2021_01_18/o1_mf_annnn_TAG20210118T212757_j0c36z0g_.bkp

  List of Archived Logs in backup set 3
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    14      2323212    17-JAN-21 2377530    18-JAN-21
  1    15      2377530    18-JAN-21 2382029    18-JAN-21

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Full    1.24G      DISK        00:04:11     18-JAN-21      
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: TAG20210118T212816
        Piece Name: /u01/app/oracle/fast_recovery_area/ORCL/ORCL/backupset/2021_01_18/o1_mf_nnndf_TAG20210118T212816_j0c37l4v_.bkp

  List of Datafiles in backup set 4
  File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name
  ---- -- ---- ---------- --------- ----------- ------ ----
  1       Full 2382053    18-JAN-21              NO    /u01/app/oracle/oradata/ORCL/system01.dbf
  3       Full 2382053    18-JAN-21              NO    /u01/app/oracle/oradata/ORCL/sysaux01.dbf
  4       Full 2382053    18-JAN-21              NO    /u01/app/oracle/oradata/ORCL/undotbs01.dbf
  5       Full 2382053    18-JAN-21              NO    /u01/app/oracle/oradata/ORCL/noarchivetest.dbf
  7       Full 2382053    18-JAN-21              NO    /u01/app/oracle/oradata/ORCL/users01.dbf

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5       24.50K     DISK        00:00:00     18-JAN-21      
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: TAG20210118T213240
        Piece Name: /u01/app/oracle/fast_recovery_area/ORCL/ORCL/backupset/2021_01_18/o1_mf_annnn_TAG20210118T213240_j0c3hr5o_.bkp

  List of Archived Logs in backup set 5
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    16      2382029    18-JAN-21 2382159    18-JAN-21

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6       Full    10.20M     DISK        00:00:01     18-JAN-21      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20210118T213241
        Piece Name: /u01/app/oracle/fast_recovery_area/ORCL/ORCL/autobackup/2021_01_18/o1_mf_s_1062192761_j0c3hthv_.bkp
  SPFILE Included: Modification time: 18-JAN-21
  SPFILE db_unique_name: ORCL
  Control File Included: Ckp SCN: 2382172      Ckp time: 18-JAN-21
...
--最后在系统终端用系统命令再次确认备份文件
[oracle@host01 trace]$ cd /u01/app/oracle/fast_recovery_area/ORCL/ORCL/backupset/
[oracle@host01 backupset]$ ls
2021_01_17  2021_01_18
[oracle@host01 backupset]$ cd 2021_01_18
[oracle@host01 2021_01_18]$ ls      #存放数据文件和归档日志
o1_mf_annnn_TAG20210118T212757_j0c36z0g_.bkp  o1_mf_annnn_TAG20210118T213240_j0c3hr5o_.bkp  o1_mf_nnndf_TAG20210118T212816_j0c37l4v_.bkp
[oracle@host01 2021_01_18]$ cd /u01/app/oracle/fast_recovery_area/ORCL/ORCL/
[oracle@host01 ORCL]$ ls
archivelog  autobackup  backupset  onlinelog
[oracle@host01 ORCL]$ cd autobackup
[oracle@host01 autobackup]$ ls
2021_01_17  2021_01_18
[oracle@host01 autobackup]$ cd 2021_01_18
[oracle@host01 2021_01_18]$ ls     #存放控制文件和参数文件
o1_mf_s_1062192761_j0c3hthv_.bkp
[oracle@host01 2021_01_18]$ cd /u01/app/oracle/fast_recovery_area/ORCL/ORCL/
[oracle@host01 ORCL]$ ls
archivelog  autobackup  backupset  onlinelog
[oracle@host01 ORCL]$ cd onlinelog/
[oracle@host01 onlinelog]$ ls
[oracle@host01 onlinelog]$ cd ..
[oracle@host01 ORCL]$ ls
archivelog  autobackup  backupset  onlinelog
[oracle@host01 ORCL]$ cd archivelog/
[oracle@host01 archivelog]$ ls
2021_01_16  2021_01_17  2021_01_18
[oracle@host01 archivelog]$ cd 2021_01_18
[oracle@host01 2021_01_18]$ ls
[oracle@host01 2021_01_18]$ cd ..
[oracle@host01 archivelog]$ ls
2021_01_16  2021_01_17  2021_01_18
[oracle@host01 archivelog]$ cd 2021_01_17
[oracle@host01 2021_01_17]$ ls
[oracle@host01 2021_01_17]$ 

end

对于数据库备份与还原这一部分理解或许有些帮助，供参考。

结合之前整理的非归档模式的实验，归档模式下备份的信息正好可以互相做个对比

整理的有点乱，主要是看看实际操作时的相关信息。知识点还是要看老师的PPT和视频。抛砖引玉~大家有操作中的体会也可以共同讨论~

--本资料由同学【星动行働】制作整理

Tag: Oracle Oracle备份 Oracle恢复
我也要发一个   ·   返回首页     ·   返回[Oracle]   ·    前一个  ·   下一个
评论
还没有评论，快来抢沙发吧！ ↓
相关内容

关于点击广告单价

 2021-01-19 

注册了几个Dot.tk域名—功能强大的免费国际顶级域名

 2021-01-19 

微软的面试题及答案 (试题篇)

 2021-01-19 

昨天看了天下无贼，今天贼就把我的手机偷了

 2021-01-19 

oracle数据泵expdp导出错误UDE-31623,OR

 2021-01-19 

php gd等比例缩放压缩图片函数(好像也不能保证比例，不是

 2021-01-19 

试用ChatGPT最强对手：Claude

 2021-01-19 

硬盘里有些电视剧，有什么程序能挂到网站上么

 2021-01-19 

关于LightSNS，觉得还是很不放心

 2021-01-19 

韩语班-20200723-韩国上学讨论YJ.mp3

 2021-01-19 

php爬虫示例，queryList示例

 2021-01-19 

JPNV导入完成

 2021-01-19 

新手想通过被动收入赚钱，Adsense是最佳选择

 2021-01-19 

Tao-20201214-六哥盖房讨论.mp3

 2021-01-19 

chuqiao-20231019-美签直播

 2021-01-19 

ASP错误 ^80040e14‘ UPDATE 语句的语法错

 2021-01-19 

Thinkphp6学习笔记04：TP6控制器定义，控制器路径

 2021-01-19 

艺考-20221122-疫情沦陷不能回去.mp3

 2021-01-19 

Windows系统中任务计划命令：schtasks命令，取代

 2021-01-19 

奶茶店咨询-07-李经理17037647173-202007

 2021-01-19 
欢迎评论
未登录，
请先 [ 注册 ] or [ 登录 ]
(一分钟即可完成注册!)
返回首页     ·   返回[Oracle]   ·   返回顶部  
热门推荐
热门标签
安全 社会 感悟 创业 教育 Oracle 骗子 技术 留学 美国签证 英文网站 GoogleAdsense Thinkphp 社区 日本 Google Mysql 留学 CSS 流行歌曲
最新主题
友情链接
更多...