RMAN备份恢复测试

最新推荐文章于 2024-05-16 05:46:54 发布
最新推荐文章于 2024-05-16 05:46:54 发布
阅读量2.5k 收藏
点赞数 1
分类专栏： DBA 文章标签： oracle 数据库 dba
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/hezuijiudexiaobai/article/details/122772911
版权 
[oracle@modb ~]$ sqlplus / as sysdba

SQL*Plus: Release 21.0.0.0.0 - Production on Wed Feb 2 22:46:56 2022
Version 21.3.0.0.0

Copyright (c) 1982, 2021, Oracle.  All rights reserved.


Connected to:
Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /opt/oracle/homes/OraDBHome21cXE/dbs/arch
Oldest online log sequence     1
Next log sequence to archive   3
Current log sequence           3
SQL> exit
Disconnected from Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0

[oracle@modb ~]$ rman target /

Recovery Manager: Release 21.0.0.0.0 - Production on Wed Feb 2 22:47:10 2022
Version 21.3.0.0.0

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

connected to target database: XE (DBID=2976754108)

RMAN> backup as compressed backupset database format '/home/oracle/backup/XE_full_%U.bak' plus archivelog format '/home/oracle/backup/XE_arch_%U.bak' delete input;


Starting backup at 02-FEB-22
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=131 device type=DISK
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=3 RECID=1 STAMP=1095634038
channel ORA_DISK_1: starting piece 1 at 02-FEB-22
channel ORA_DISK_1: finished piece 1 at 02-FEB-22
piece handle=/home/oracle/backup/XE_arch_010ks33n_1_1_1.bak tag=TAG20220202T224719 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_1: deleting archived log(s)
archived log file name=/opt/oracle/homes/OraDBHome21cXE/dbs/arch1_3_1095633404.dbf RECID=1 STAMP=1095634038
Finished backup at 02-FEB-22

Starting backup at 02-FEB-22
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/opt/oracle/oradata/XE/system01.dbf
input datafile file number=00003 name=/opt/oracle/oradata/XE/sysaux01.dbf
input datafile file number=00004 name=/opt/oracle/oradata/XE/undotbs01.dbf
input datafile file number=00007 name=/opt/oracle/oradata/XE/users01.dbf
channel ORA_DISK_1: starting piece 1 at 02-FEB-22
channel ORA_DISK_1: finished piece 1 at 02-FEB-22
piece handle=/home/oracle/backup/XE_full_020ks33q_2_1_1.bak tag=TAG20220202T224722 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00010 name=/opt/oracle/oradata/XE/XEPDB1/sysaux01.dbf
input datafile file number=00009 name=/opt/oracle/oradata/XE/XEPDB1/system01.dbf
input datafile file number=00011 name=/opt/oracle/oradata/XE/XEPDB1/undotbs01.dbf
input datafile file number=00012 name=/opt/oracle/oradata/XE/XEPDB1/users01.dbf
channel ORA_DISK_1: starting piece 1 at 02-FEB-22
channel ORA_DISK_1: finished piece 1 at 02-FEB-22
piece handle=/home/oracle/backup/XE_full_030ks35h_3_1_1.bak tag=TAG20220202T224722 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00006 name=/opt/oracle/oradata/XE/pdbseed/sysaux01.dbf
input datafile file number=00005 name=/opt/oracle/oradata/XE/pdbseed/system01.dbf
input datafile file number=00008 name=/opt/oracle/oradata/XE/pdbseed/undotbs01.dbf
channel ORA_DISK_1: starting piece 1 at 02-FEB-22
channel ORA_DISK_1: finished piece 1 at 02-FEB-22
piece handle=/home/oracle/backup/XE_full_040ks360_4_1_1.bak tag=TAG20220202T224722 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 02-FEB-22

Starting backup at 02-FEB-22
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=4 RECID=2 STAMP=1095634127
channel ORA_DISK_1: starting piece 1 at 02-FEB-22
channel ORA_DISK_1: finished piece 1 at 02-FEB-22
piece handle=/home/oracle/backup/XE_arch_050ks36g_5_1_1.bak tag=TAG20220202T224848 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: deleting archived log(s)
archived log file name=/opt/oracle/homes/OraDBHome21cXE/dbs/arch1_4_1095633404.dbf RECID=2 STAMP=1095634127
Finished backup at 02-FEB-22

Starting Control File and SPFILE Autobackup at 02-FEB-22
piece handle=/opt/oracle/homes/OraDBHome21cXE/dbs/c-2976754108-20220202-00 comment=NONE
Finished Control File and SPFILE Autobackup at 02-FEB-22

RMAN> list backup of database;


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


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2       Full    412.09M    DISK        00:00:53     02-FEB-22      
        BP Key: 2   Status: AVAILABLE  Compressed: YES  Tag: TAG20220202T224722
        Piece Name: /home/oracle/backup/XE_full_020ks33q_2_1_1.bak
  List of Datafiles in backup set 2
  File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name
  ---- -- ---- ---------- --------- ----------- ------ ----
  1       Full 2624842    02-FEB-22              NO    /opt/oracle/oradata/XE/system01.dbf
  3       Full 2624842    02-FEB-22              NO    /opt/oracle/oradata/XE/sysaux01.dbf
  4       Full 2624842    02-FEB-22              NO    /opt/oracle/oradata/XE/undotbs01.dbf
  7       Full 2624842    02-FEB-22              NO    /opt/oracle/oradata/XE/users01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3       Full    100.07M    DISK        00:00:15     02-FEB-22      
        BP Key: 3   Status: AVAILABLE  Compressed: YES  Tag: TAG20220202T224722
        Piece Name: /home/oracle/backup/XE_full_030ks35h_3_1_1.bak
  List of Datafiles in backup set 3
  Container ID: 3, PDB Name: XEPDB1
  File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name
  ---- -- ---- ---------- --------- ----------- ------ ----
  9       Full 2624869    02-FEB-22              NO    /opt/oracle/oradata/XE/XEPDB1/system01.dbf
  10      Full 2624869    02-FEB-22              NO    /opt/oracle/oradata/XE/XEPDB1/sysaux01.dbf
  11      Full 2624869    02-FEB-22              NO    /opt/oracle/oradata/XE/XEPDB1/undotbs01.dbf
  12      Full 2624869    02-FEB-22              NO    /opt/oracle/oradata/XE/XEPDB1/users01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Full    97.66M     DISK        00:00:14     02-FEB-22      
        BP Key: 4   Status: AVAILABLE  Compressed: YES  Tag: TAG20220202T224722
        Piece Name: /home/oracle/backup/XE_full_040ks360_4_1_1.bak
  List of Datafiles in backup set 4
  Container ID: 2, PDB Name: PDB$SEED
  File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name
  ---- -- ---- ---------- --------- ----------- ------ ----
  5       Full 2617387    02-FEB-22              NO    /opt/oracle/oradata/XE/pdbseed/system01.dbf
  6       Full 2617387    02-FEB-22              NO    /opt/oracle/oradata/XE/pdbseed/sysaux01.dbf
  8       Full 2617387    02-FEB-22              NO    /opt/oracle/oradata/XE/pdbseed/undotbs01.dbf

RMAN> set line 999

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "archivelog, autobackup, auxiliary, auxname, backup, catalog, command, compression, controlfile, database, dbid, decryption, default, echo, encryption, high, incarnation, incremental, long, maxcorrupt, maxseq, newname, nocfau, numwidth, passphrase, preplugin, restore, snapshot, tenantid, to restore point, until restore point, until, "
RMAN-01008: the bad identifier was: line
RMAN-01007: at line 1 column 5 file: standard input

RMAN> list backup of controlfile;


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


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6       Full    17.95M     DISK        00:00:00     02-FEB-22      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20220202T224849
        Piece Name: /opt/oracle/homes/OraDBHome21cXE/dbs/c-2976754108-20220202-00
  Control File Included: Ckp SCN: 2624914      Ckp time: 02-FEB-22

RMAN> list backup of archivelog all;


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


BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
1       13.90M     DISK        00:00:01     02-FEB-22      
        BP Key: 1   Status: AVAILABLE  Compressed: YES  Tag: TAG20220202T224719
        Piece Name: /home/oracle/backup/XE_arch_010ks33n_1_1_1.bak

  List of Archived Logs in backup set 1
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    3       2615375    02-FEB-22 2624817    02-FEB-22

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5       48.50K     DISK        00:00:00     02-FEB-22      
        BP Key: 5   Status: AVAILABLE  Compressed: YES  Tag: TAG20220202T224848
        Piece Name: /home/oracle/backup/XE_arch_050ks36g_5_1_1.bak

  List of Archived Logs in backup set 5
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    4       2624817    02-FEB-22 2624893    02-FEB-22
喝醉酒的小白
关注
  • 1
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
rman 备份策略及恢复测试
上帝之手&传奇 - MartinLee
01-29 649
版本：    os      redhat 6.4x86_64bit                                       db:  oracle 11.2.0.4  增量差异备份： incremental backup 第一步：   备份 策略：    lv0    --  周日                                    
rman备份恢复测试
weixin_34198797的博客
07-29 161
2019独角兽企业重金招聘Python工程师标准>>> ...
Mysql必知必会：物理备份与恢复测试
最新发布
2301_76379671的博客
05-16 879
不论是通过停机冷备份，还是通过 NDB Cluster 自行提供的在线联机备份工具，或者是第三方备份软件来进行备份，都需要备份以上三种物理文件才能构成一个完整有效的备份集。当然，相关的配置文件，尤其是管理节点上面的配置信息，同样也需要备份。
clickhouse-backup 备份恢复测试
Hehuyi_In的博客
03-23 4946
一、安装配置 1. 下载 https://github.com/AlexAkulov/clickhouse-backup/releases 2. 安装 [root@backup-db ~]# rpm -ivh clickhouse-backup-1.3.1-1.x86_64.rpm Preparing... ################################# [100%] Updating / installing... 1:clickhouse-backup-1.3.1-1 #
达梦数据库_备份恢复测试，验证物理备份可以支持指定时间点的还原
qq_36642229的博客
08-13 510
备份恢复测试
阿里面试官：知道-MySQL-逻辑备份与恢复测试么？，江苏银行面试时间
2401_84102956的博客
04-11 662
谈到面试，其实说白了就是刷题刷题刷题，天天作死的刷。。。。。为了准备这个“金三银四”的春招，狂刷一个月的题，狂补超多的漏洞知识，像这次美团面试问的算法、数据库、Redis、设计模式等这些题目都是我刷到过的并且我也将自己刷的题全部整理成了PDF或者Word文档（含详细答案解析）66个Java面试知识点架构专题（MySQL，Java，Redis，线程，并发，设计模式，Nginx，Linux，框架，微服务等）+大厂面试题详解（百度，阿里，腾讯，华为，迅雷，网易，中兴，北京中软等）算法刷题（PDF）
Oracle-RMAN增量备份恢复测试记录
12-28
Oracle-RMAN增量备份恢复测试记录 Oracle-RMAN增量备份恢复测试记录是指使用Oracle Recovery Manager（RMAN）工具对Oracle数据库进行增量备份和恢复的测试记录。本记录涵盖了增量备份的基本概念、备份策略及恢复、...
Oracle RMAN增量备份恢复测试记录.docx
05-20
Oracle RMAN增量备份恢复测试记录
Oracle-RMAN增量备份恢复测试记录.docx
11-16
Oracle-RMAN增量备份恢复测试记录 Oracle-RMAN增量备份恢复测试记录是对Oracle数据库进行增量备份和恢复的测试记录，旨在记录增量备份和恢复的过程、命令和结果。下面是该测试记录的详细说明和知识点： 1. 概述： ...
RMAN备份恢复方案（亲手实验）
07-30
这是自己亲手研究完oracle 的rman备份后写的备份和恢复方案
完整Oracle rman备份恢复成功案例
03-04
Oracle RMAN 备份恢复成功案例 Oracle RMAN（Recovery Manager）是一款强大的数据库备份恢复工具，能够保护数据库免受灾难影响，从而确保业务连续性。本文将详细介绍完整的 Oracle RMAN 备份恢复步骤，并提供实践...
MySQL备份与恢复
qq_44363920的博客
06-22 1102
数据库的备份主要的目的是灾难恢复，备份还可以测试应用、回滚数据修改、查询历史数据、审计等。
DB2 备份 恢复 详细测试 .
怪手大分的专栏
06-07 3004
本文测试环境：Windows  XP、IBM  DB2  Express V9.5、 DB2  Quest  Center  V9.5 在这里举个应用场景以说明数据库恢复备份的思路： 那么假设我们周一晚上做了一个数据库的备份，周二中午12点数据库存储介质出现了故障。如何能够实现恢复呢 ? 那么首先是把数据库恢复到我们备份的那个时刻（周一晚上），但是备份之后和周二12 点之间对数
oracle rman备份和恢复,oracleRMAN备份与恢复实验
weixin_35589806的博客
04-10 350
========================RMAN数据库全库备份=========================================[oracle@localhost ~]$ rman target /RMAN> backup incremental level =0 database format='/home/oracle/db_bak/%u';Starting ba...
RMAN恢复简单实验
不忘初心、方得始终
03-10 2616
一、恢复初始化参数文件： 1、自动备份还原 SQL> shutdown immediate; ORA-01109: database not open Database dismounted. ORACLE instance shut down. SQL> startup nomount; ORACLE instance started. Total System Glob
ORACLE RMAN恢复测试脚本
gaobudong1234的博客
06-12 993
此恢复测试脚本在redhat6.5环境，oracle11g可以直接运行： 次恢复测试脚本省略了恢复pfile文件的步骤，pfile由于恢复至做一次，以后的恢复测试不需要再恢复pfile，因此不需要脚本化。 SID=prdtestdb export ORACLE_SID=$SID logfile=shrman_$SID.log #设置rman备份文件目录，和要恢
RMAN完全恢复与不完全恢复测试
Kay的博客
02-08 5101
RMAN完全恢复与不完全恢复测试一、完全恢复二、不完全恢复2.1 基于时间点2.2 基于日志序列号2.3 基于SCN 恢复2.4 通过INCARNATION不完全恢复2.5 基于表空间时间点的不完全恢复(TSPITR)2.6 12c RMAN 表级恢复三、总结 一、完全恢复 场景：在T0时间点存在RMAN全备，在T1时间点由于介质损坏，数据文件丢失。redo以及归档文件完整。 解决方法： 可用RM...
rman 增量备份恢复
07-02
首先，需要定义RMAN备份策略。这包括确定全备份和增量备份的频率、备份存储位置和保留策略等。通过合理的备份策略，可以减少备份资源和时间的消耗，提高备份效率。 其次，在需要进行增量备份时，RMAN会比较数据库的...

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值