美文网首页Linux Troubleshooting
Oracle数据库rman备份

Oracle数据库rman备份

作者: yangqing | 来源:发表于2019-01-14 20:18 被阅读10次

命令行备份:

[oracle@localhost ~]$ rman target /

Recovery Manager: Release 10.2.0.4.0 - Production on Mon Jan 14 20:09:46 2019

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

connected to target database: SHLT (DBID=62565412)

RMAN> backup current controlfile format '/home/oracle/rmanbackup/123.ctl';
RMAN> backup database format '/home/oracle/rmanbackup/Full%U.bak';

脚本备份:

#!/bin/bash
# name: rman.sh
# date: 2019-01-14

. /home/oracle/.bash_profile
RMAN=$ORACLE_HOME/bin/rman
export RMAN
$RMAN  nocatalog TARGET / log  /home/oracle/rmanbackup/rman.log  <<EOF >/dev/null
backup current controlfile format '/home/oracle/rmanbackup/123.ctl';
backup database format '/home/oracle/rmanbackup/Full%U.bak';
backup current controlfile format '/home/oracle/rmanbackup/234.ctl';
exit
EOF


直接拷贝文件进行备份:

█ 拷贝控制文件:
/home/oracle/oracle10g/product/10.2.0/db_1/dbs
initDATAONE.ora
orapwDATAONE
spfileDATAONE.ora

/home/oracle/oracle10g/product/10.2.0/db_1/network/admin
listener.ora
tnsnames.ora

█ 拷贝备份文件:
[oracle@web1 oracle10g]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on Mon Jan 14 16:19:54 2019

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/home/oracle/oracle10g/oradata/DATAONE/system01.dbf
/home/oracle/oracle10g/oradata/DATAONE/undotbs01.dbf
/home/oracle/oracle10g/oradata/DATAONE/sysaux01.dbf
/home/oracle/oracle10g/oradata/DATAONE/users01.dbf
/home/oracle/oracle10g/oradata/DATAONE/bjccod_001.dbf
/home/oracle/oracle10g/oradata/DATAONE/record_001.dbf
/home/oracle/oracle10g/oradata/DATAONE/BJORA2.dbf

7 rows selected.

SQL> select * from v$logfile;

    GROUP# STATUS     TYPE
---------- -------------- --------------
MEMBER
--------------------------------------------------------------------------------
IS_REC
------
     1        ONLINE
/home/oracle/oracle10g/oradata/DATAONE/redo01.log
NO

     2        ONLINE
/home/oracle/oracle10g/oradata/DATAONE/redo02.log
NO

    GROUP# STATUS     TYPE
---------- -------------- --------------
MEMBER
--------------------------------------------------------------------------------
IS_REC
------

     3        ONLINE
/home/oracle/oracle10g/oradata/DATAONE/redo03.log
NO

     4        STANDBY
/home/oracle/oracle10g/oradata/DATAONE/stdby_redo04.log

    GROUP# STATUS     TYPE
---------- -------------- --------------
MEMBER
--------------------------------------------------------------------------------
IS_REC
------
NO

     5        STANDBY
/home/oracle/oracle10g/oradata/DATAONE/stdby_redo05.log
NO

     6        STANDBY

    GROUP# STATUS     TYPE
---------- -------------- --------------
MEMBER
--------------------------------------------------------------------------------
IS_REC
------
/home/oracle/oracle10g/oradata/DATAONE/stdby_redo06.log
NO

     7        STANDBY
/home/oracle/oracle10g/oradata/DATAONE/stdby_redo07.log
NO


7 rows selected.

SQL> show parameter control

NAME                     TYPE
------------------------------------ ----------------------
VALUE
------------------------------
control_file_record_keep_time        integer
7
control_files                string
/home/oracle/oracle10g/oradata/DATAONE/control01.ctl, 
/home/oracle/oracle10g/oradata/DATAONE/control02.ctl, 
/home/oracle/oracle10g/oradata/DATAONE/control03.ctl
SQL>

相关文章

  • Oracle 11g R2 Rman备份与恢复

    Oracle 11g R2 Rman备份 备份与恢复的定义及分类 备份的定义及分类: 备份就是把数据库复制到转储...

  • PostgreSQL使用PG_Rman进行物理备份

    背景 在Oracle下我们可以使用rman进行物理备份,支持数据库的全量、增量、归档的备份模式而PostgreSQ...

  • 第三步:oracle-备份与恢复

    oracle数据库可用的备份工具有很多,官方的比较靠谱呀,尤其是RMAN接下来就是RMAN相关使用 适用前提是必须...

  • Oracle-RMAN 使用详解

    RMAN 使用详解 一、连接方式 (一)、连接本地数据库 [oracle@oracle ~]$ rman targ...

  • Oracle数据库rman备份

    命令行备份: 脚本备份: 直接拷贝文件进行备份:

  • rman cross check命令分析

    RMAN下CROSSCHECK命令详解 - Oracle数据库栏目 - 红黑联盟 RMAN下CROSSCHECK命...

  • RMAN 备份 出错 RMAN-08132

    ORACLE RAC RMAN 备份报rman-08132 此错误说明控制文件快照没有放在共享存储上 查看后发现确...

  • RMAN笔记

    1. 连接RMAN 2. 配置RMAN参数 3. 配置RMAN脱机备份 4. 配置RMAN联机备份 开启归档 备份...

  • rman备份

    一、数据库备份与RMAN备份的概念 1.数据库完全备份:按归档模式分为归档和非归档 归档模式 ...

  • oracle里restore和recover的区别

    Oracle rman中restore和recover的区别 在Oracle的备份与恢复的知识点中,经常会出现Re...

网友评论

    本文标题:Oracle数据库rman备份

    本文链接:https://www.haomeiwen.com/subject/igojdqtx.html