通过RMAN备份搭建单节点ADG（oracle11g）

最新推荐文章于 2023-02-03 16:03:31 发布
最新推荐文章于 2023-02-03 16:03:31 发布
阅读量617 收藏
点赞数
文章标签： 数据库

1、修改/etc/hosts  建议：生产端和DG端保持一致

生产端：

[root@primary ~]# more /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

 

192.168.186.87 primary

192.168.186.88 standby

DG端：

[root@standby ~]# more /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

 

192.168.186.88 standby

192.168.186.87 primary

2、修改数据库为归档日志模式、强制日志模式

[oracle@primary ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Aug 4 22:15:54 2015

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

Connected to an idle instance.

SQL> startup mount;

ORACLE instance started.

Total System Global Area  409194496 bytes

Fixed Size                  2228864 bytes

Variable Size             276827520 bytes

Database Buffers          125829120 bytes

Redo Buffers                4308992 bytes

Database mounted.

SQL> archive log list

Database log mode              No Archive Mode

Automatic archival             Disabled

Archive destination            /u01/app/base/product/11.2.0/db_1/dbs/arch

Oldest online log sequence     4

Current log sequence           6

SQL> alter database archivelog;

Database altered.

SQL> select force_logging from v$database;

FOR

---

NO

SQL> alter database force logging;

Database altered.

3、在生产端修改参数文件

SQL> alter system set log_archive_dest_1 = 'LOCATION=/archive/orcl' scope=both;

System altered.

SQL> alter system set log_archive_dest_2 = 'SERVICE=standby arch ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orcl' scope=both;

System altered.

SQL> alter system set log_archive_dest_state_1 = ENABLE scope=both;

System altered.

SQL> alter system set log_archive_dest_state_2 = ENABLE scope=both;

System altered.

SQL> alter system set db_file_name_convert = '/oradata/orcl/ ','/oradata/orcl_standby ' scope = spfile;

System altered.

SQL> alter system set log_file_name_convert = '/oradata/orcl/ ','/oradata/orcl_standby ' scope = spfile;

System altered.

4、配置生产端和DG端网络服务名tnsnames.ora 建议：保持一致 验证：tnsping

生产端：

[oracle@primary admin]$ more tnsnames.ora

# tnsnames.ora Network Configuration File: /u01/app/base/product/11.2.0/db_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

 

STANDBY =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = standby)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = orcl)

    )

  )

 

ORCL =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = primary)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl)

    )

  )

DG端：

[oracle@standby admin]$ more tnsnames.ora

# tnsnames.ora Network Configuration File: /u01/app/base/product/11.2.0/db_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

 

STANDBY =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = standby)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = orcl)

    )

  )

 

ORCL =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = primary)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl)

    )

  )

Tnsping service_names验证

5、将生产端$ORACLE_HOME/dbs/下的密码文件orapwORACLE_SID传至备机,可以用ssh/ftp

orapwd file=orapworcl password=oracle(建议拷贝，不然报ORA-16191)

6、创建生产端的pfile并传至DG端

生产端：

[oracle@primary ~]$ scp initorcl.ora oracle@192.168.186.88:/u01/app/base/product/11.2.0/db_1/dbs

oracle@192.168.186.88's password:

initorcl.ora                                                                                                                      100%  769     0.8KB/s   00:00

 

DG端：

[oracle@standby dbs]$ ls -rlt

total 8

-rw-r-----. 1 oracle oinstall 1536 Aug  4 23:53 orapworcl

-rw-r--r--. 1 oracle oinstall  769 Aug  4 23:55 initorcl.ora

7、创建standby控制文件、数据文件、归档日志，并传至DG端的相同路径下

[oracle@primary ~]$ rman target /

 

Recovery Manager: Release 11.2.0.3.0 - Production on Tue Aug 4 23:26:09 2015

 

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

 

connected to target database: ORCL (DBID=1414669689)

 

RMAN> backup database format '/home/oracle/temp/%U';

 

Starting backup at 04-AUG-15

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=37 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=00001 name=/oradata/orcl/system01.dbf

input datafile file number=00002 name=/oradata/orcl/sysaux01.dbf

input datafile file number=00005 name=/oradata/orcl/example01.dbf

input datafile file number=00003 name=/oradata/orcl/undotbs01.dbf

input datafile file number=00004 name=/oradata/orcl/users01.dbf

channel ORA_DISK_1: starting piece 1 at 04-AUG-15

channel ORA_DISK_1: finished piece 1 at 04-AUG-15

piece handle=/home/oracle/temp/02qdpreh_1_1 tag=TAG20150804T232713 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:01:16

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

including current control file in backup set

including current SPFILE in backup set

channel ORA_DISK_1: starting piece 1 at 04-AUG-15

channel ORA_DISK_1: finished piece 1 at 04-AUG-15

piece handle=/home/oracle/temp/03qdprgt_1_1 tag=TAG20150804T232713 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 04-AUG-15

 

RMAN> backup archivelog all format '/home/oracle/temp/%U';

 

Starting backup at 04-AUG-15

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=6 RECID=1 STAMP=886894834

input archived log thread=1 sequence=7 RECID=2 STAMP=886894835

input archived log thread=1 sequence=8 RECID=3 STAMP=886894838

input archived log thread=1 sequence=9 RECID=4 STAMP=886894846

input archived log thread=1 sequence=10 RECID=5 STAMP=886894847

input archived log thread=1 sequence=11 RECID=6 STAMP=886894848

input archived log thread=1 sequence=12 RECID=7 STAMP=886894849

input archived log thread=1 sequence=13 RECID=8 STAMP=886894947

channel ORA_DISK_1: starting piece 1 at 04-AUG-15

channel ORA_DISK_1: finished piece 1 at 04-AUG-15

piece handle=/home/oracle/temp/04qdpsb3_1_1 tag=TAG20150804T234227 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 04-AUG-15

 

RMAN> backup current controlfile for standby format '/home/oracle/temp/%U';

 

Starting backup at 04-AUG-15

using channel ORA_DISK_1

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

including standby control file in backup set

channel ORA_DISK_1: starting piece 1 at 04-AUG-15

channel ORA_DISK_1: finished piece 1 at 04-AUG-15

piece handle=/home/oracle/temp/05qdpsdq_1_1 tag=TAG20150804T234354 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 04-AUG-15

 

RMAN>

 

[oracle@primary temp]$ scp * oracle@192.168.186.88:/home/oracle/temp/

oracle@192.168.186.88's password:

02qdpreh_1_1                                                                                                                      100% 1156MB  32.1MB/s   00:36   

03qdprgt_1_1                                                                                                                      100% 9600KB   9.4MB/s   00:01   

04qdpsb3_1_1                                                                                                                      100% 4332KB   4.2MB/s   00:00   

05qdpsdq_1_1                                                                                                                      100% 9568KB   9.3MB/s   00:00   

 

[oracle@standby temp]$ ls -rlt

total 1207040

-rw-r-----. 1 oracle oinstall 1211940864 Aug  5 00:22 02qdpreh_1_1

-rw-r-----. 1 oracle oinstall    9830400 Aug  5 00:22 03qdprgt_1_1

-rw-r-----. 1 oracle oinstall    4435968 Aug  5 00:22 04qdpsb3_1_1

-rw-r-----. 1 oracle oinstall    9797632 Aug  5 00:22 05qdpsdq_1_1

8、在DG端修改pfile，并启动实例到NOMOUNT状态

[oracle@standby dbs]$ sqlplus / as sysdba

 

SQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 5 16:56:13 2015

 

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

 

Connected to an idle instance.

 

SQL> startup nomount;

ORACLE instance started.

 

Total System Global Area  242208768 bytes

Fixed Size                  2227176 bytes

Variable Size             184550424 bytes

Database Buffers           50331648 bytes

Redo Buffers                5099520 bytes

SQL> create spfile from pfile;

 

File created.

 

SQL> startup nomount force;

ORACLE instance started.

 

Total System Global Area  242208768 bytes

Fixed Size                  2227176 bytes

Variable Size             184550424 bytes

Database Buffers           50331648 bytes

Redo Buffers                5099520 bytes

SQL> exit

9、在DG端，通过RMAN连接到生产库和auxiliary数据库，结束后备库自动启到MOUNT状态

[oracle@standby dbs]$ rman target sys/oracle@orcl auxiliary sys/oracle

 

Recovery Manager: Release 11.2.0.3.0 - Production on Wed Aug 5 16:57:14 2015

 

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

 

connected to target database: ORCL (DBID=1414669689)

connected to auxiliary database: ORCL (not mounted)

 

RMAN> duplicate target database for standby dorecover;

 

Starting Duplicate Db at 05-AUG-15

using target database control file instead of recovery catalog

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=19 device type=DISK

 

contents of Memory Script:

{

   set until scn  1099341;

   restore clone standby controlfile;

}

executing Memory Script

 

executing command: SET until clause

 

Starting restore at 05-AUG-15

using channel ORA_AUX_DISK_1

 

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: restoring control file

channel ORA_AUX_DISK_1: reading from backup piece /home/oracle/temp/03qdprgt_1_1

channel ORA_AUX_DISK_1: piece handle=/home/oracle/temp/03qdprgt_1_1 tag=TAG20150804T232713

channel ORA_AUX_DISK_1: restored backup piece 1

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01

output file name=/oradata/standby/control01.ctl

output file name=/oradata/standby/control02.ctl

Finished restore at 05-AUG-15

 

contents of Memory Script:

{

   sql clone 'alter database mount standby database';

}

executing Memory Script

 

sql statement: alter database mount standby database

 

contents of Memory Script:

{

   set until scn  1099341;

   set newname for tempfile  1 to

 "/oradata/standby/temp01.dbf";

   switch clone tempfile all;

   set newname for datafile  1 to

 "/oradata/standby/system01.dbf";

   set newname for datafile  2 to

 "/oradata/standby/sysaux01.dbf";

   set newname for datafile  3 to

 "/oradata/standby/undotbs01.dbf";

   set newname for datafile  4 to

 "/oradata/standby/users01.dbf";

   set newname for datafile  5 to

 "/oradata/standby/example01.dbf";

   restore

   clone database

   ;

}

executing Memory Script

 

executing command: SET until clause

 

executing command: SET NEWNAME

 

renamed tempfile 1 to /oradata/standby/temp01.dbf in control file

 

executing command: SET NEWNAME

 

executing command: SET NEWNAME

 

executing command: SET NEWNAME

 

executing command: SET NEWNAME

 

executing command: SET NEWNAME

 

Starting restore at 05-AUG-15

using channel ORA_AUX_DISK_1

 

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_AUX_DISK_1: restoring datafile 00001 to /oradata/standby/system01.dbf

channel ORA_AUX_DISK_1: restoring datafile 00002 to /oradata/standby/sysaux01.dbf

channel ORA_AUX_DISK_1: restoring datafile 00003 to /oradata/standby/undotbs01.dbf

channel ORA_AUX_DISK_1: restoring datafile 00004 to /oradata/standby/users01.dbf

channel ORA_AUX_DISK_1: restoring datafile 00005 to /oradata/standby/example01.dbf

channel ORA_AUX_DISK_1: reading from backup piece /home/oracle/temp/02qdpreh_1_1

channel ORA_AUX_DISK_1: piece handle=/home/oracle/temp/02qdpreh_1_1 tag=TAG20150804T232713

channel ORA_AUX_DISK_1: restored backup piece 1

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:46

Finished restore at 05-AUG-15

 

contents of Memory Script:

{

   switch clone datafile all;

}

executing Memory Script

 

datafile 1 switched to datafile copy

input datafile copy RECID=2 STAMP=886957114 file name=/oradata/standby/system01.dbf

datafile 2 switched to datafile copy

input datafile copy RECID=3 STAMP=886957114 file name=/oradata/standby/sysaux01.dbf

datafile 3 switched to datafile copy

input datafile copy RECID=4 STAMP=886957114 file name=/oradata/standby/undotbs01.dbf

datafile 4 switched to datafile copy

input datafile copy RECID=5 STAMP=886957114 file name=/oradata/standby/users01.dbf

datafile 5 switched to datafile copy

input datafile copy RECID=6 STAMP=886957114 file name=/oradata/standby/example01.dbf

 

contents of Memory Script:

{

   set until scn  1099341;

   recover

   standby

   clone database

    delete archivelog

   ;

}

executing Memory Script

 

executing command: SET until clause

 

Starting recover at 05-AUG-15

using channel ORA_AUX_DISK_1

 

starting media recovery

 

channel ORA_AUX_DISK_1: starting archived log restore to default destination

channel ORA_AUX_DISK_1: restoring archived log

archived log thread=1 sequence=6

channel ORA_AUX_DISK_1: restoring archived log

archived log thread=1 sequence=7

channel ORA_AUX_DISK_1: restoring archived log

archived log thread=1 sequence=8

channel ORA_AUX_DISK_1: restoring archived log

archived log thread=1 sequence=9

channel ORA_AUX_DISK_1: restoring archived log

archived log thread=1 sequence=10

channel ORA_AUX_DISK_1: restoring archived log

archived log thread=1 sequence=11

channel ORA_AUX_DISK_1: restoring archived log

archived log thread=1 sequence=12

channel ORA_AUX_DISK_1: restoring archived log

archived log thread=1 sequence=13

channel ORA_AUX_DISK_1: reading from backup piece /home/oracle/temp/04qdpsb3_1_1

channel ORA_AUX_DISK_1: piece handle=/home/oracle/temp/04qdpsb3_1_1 tag=TAG20150804T234227

channel ORA_AUX_DISK_1: restored backup piece 1

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01

archived log file name=/archive/orcl/1_6_886888956.dbf thread=1 sequence=6

channel clone_default: deleting archived log(s)

archived log file name=/archive/orcl/1_6_886888956.dbf RECID=8 STAMP=886957116

archived log file name=/archive/orcl/1_7_886888956.dbf thread=1 sequence=7

channel clone_default: deleting archived log(s)

archived log file name=/archive/orcl/1_7_886888956.dbf RECID=2 STAMP=886957116

archived log file name=/archive/orcl/1_8_886888956.dbf thread=1 sequence=8

channel clone_default: deleting archived log(s)

archived log file name=/archive/orcl/1_8_886888956.dbf RECID=1 STAMP=886957116

archived log file name=/archive/orcl/1_9_886888956.dbf thread=1 sequence=9

channel clone_default: deleting archived log(s)

archived log file name=/archive/orcl/1_9_886888956.dbf RECID=3 STAMP=886957116

archived log file name=/archive/orcl/1_10_886888956.dbf thread=1 sequence=10

channel clone_default: deleting archived log(s)

archived log file name=/archive/orcl/1_10_886888956.dbf RECID=4 STAMP=886957116

archived log file name=/archive/orcl/1_11_886888956.dbf thread=1 sequence=11

channel clone_default: deleting archived log(s)

archived log file name=/archive/orcl/1_11_886888956.dbf RECID=5 STAMP=886957116

archived log file name=/archive/orcl/1_12_886888956.dbf thread=1 sequence=12

channel clone_default: deleting archived log(s)

archived log file name=/archive/orcl/1_12_886888956.dbf RECID=6 STAMP=886957116

archived log file name=/archive/orcl/1_13_886888956.dbf thread=1 sequence=13

channel clone_default: deleting archived log(s)

archived log file name=/archive/orcl/1_13_886888956.dbf RECID=7 STAMP=886957116

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

Finished recover at 05-AUG-15

Finished Duplicate Db at 05-AUG-15

 

RMAN>

接下来就是检查生产端和DG端归档日志是否同步

Select max(sequence#) from v$archived_log;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30310891/viewspace-1762315/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30310891/viewspace-1762315/

cijuxk357157
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
利用RMAN复制功能在线或使用备份搭建单实例DG
03-14
搭建单实例文件系统ORACLE DG，分为2种情况： 1. 利用rman duplicate 在线搭建备库 2. 利用主库备份，离线方式搭建备库
一键 rman duplicate 搭建adg备库
whn1977的博客
09-29 398
在这里插入代码片 rman target sys/oracle@orcl auxiliary sys/oracle@orcl_dg <<EOF run { allocate channel prmy1 type disk; allocate channel prmy2 type disk; allocate channel prmy3 type disk; allocate channel prmy4 type disk; allocate auxiliary channel stby1 typ
Oracle ADG搭建
09-08 220
Oracle Active Data Guard搭建 一：安装 1.基础环境配置 1.1.开启强制日志记录 DG日志发送方式中ARCH进程和LGWR进程的ASYNC模式都是基于日志同步的，所以我们必须强制将数据库的所有操作记录到日志中 RAC2：关闭库 SQL> shutdown Database closed. Database dismounted. ORA...
Oracle 11g RAC to RAC ADG搭建 采用rman备份恢复方式
diandiandididi的博客
07-31 1138
Oracle 11g RAC to RAC ADG搭建（一）采用rman备份恢复方式 （一）基础环境 主库 备库 操作系统 RedHat6.7 RedHat6.7 服务器名称 primarydb1 primarydb2 standbydb1 standbydb2 IP地址规划 192.168.10.31 primarydb1 192.168.10.32 primarydb2 192.168.10.33 primarydb1-vip 192.168.10.34 primaryd
Windows 11.2.0.1单机使用ADG(RMAN)迁移至Linux11.2.0.4 RAC
最新发布
zongzizz的博客
02-03 867
Windows 11.2.0.1单机使用ADG(RMAN)迁移至Linux11.2.0.4 RAC
《Oracle Database 11g RMAN备份与恢复》PDF版本下载.txt
07-17
《Oracle Database 11g RMAN备份与恢复》PDF版本下载
oracle11g_rman备份还原初步方案（20190524）.docx
05-29
本文详细清楚地描述了oracle11g中的rman备份和恢复的所有步骤，亲测有效。
Oracle 11g R2 Rman备份与恢复_刘耀龙的博客-CSDN博客_rman备份.pdf
09-13
Oracle 11g R2 的 RMAN (Recovery Manager) 是 Oracle 数据库管理系统中的一个关键工具，主要用于数据库的备份和恢复。RMAN 提供了一种高效且灵活的方式来管理和保护数据库，确保在数据丢失或系统故障时能够快速恢复...
oracle 11g rman 备份与恢复
09-29
通过阅读《Oracle Database 11g RMAN备份与恢复》这本书，读者将深入学习RMAN的原理和实践操作，了解如何制定有效的备份策略，以及如何在灾难发生时迅速恢复数据库，保障业务连续性。书中详细讲解了RMAN的各种命令、...
Oracle 11g rman备份脚本 线上环境
04-29
Oracle 11g rman备份脚本 线上环境,
单节点ADG部署
03-18
两套单机oracle数据库部署搭建Oracle Active Dataguard环境
（绝对干货）Oracle ADG数据库完整部署、切换、备份、运维手册
09-11
阿里云上部署Oracle ADG，并且带有节点故障自动切换功能。同时，也包括数据库异常故障的处理，比如死锁、数据误删除进行恢复
利用RMAN备份集手动建立Dataguard备库
Kay的博客
02-13 1150
利用RMAN备份集手动建立Dataguard备库 之前的帖子使用的都是duplicate在线传输方式搭建备库，现已通过实验验证可以通过手动的方式建立ADG备库。 1、主库全备 run { backup database format '/u01/rman/fulldb_%d_%U.bak' tag 'full_db'; backup archivelog all format '/u01/rman...
rman 的部署DG的思路
Joyce
04-20 895
rman 的部署DG的思路和文档 主 archive log list; alter database force logging; ho mkdir /..../oradata/orcl/arch alter system set db_unique_name=pri scope=spfile; 同时查看主上的环境 例如 ip、 uname -r 、id oracle 、版本
rman恢复增加ADG(级联ADG)
weixin_30417487的博客
07-02 158
当前已经有一套ADG库，分别是prod1和prod1s计划从pord的ADG备库(prod1s)拷贝一个0级rman全备到新的服务器，恢复后，搭建成新增的ADG，SID叫prod2s，后面激活当做测试库 新服务器上设置export ORACLE_SID=pord2s 从源库porddb1s生成一个pfile,,拷贝pfile到目标库修改相关路径参数后，然后转换成spfile *.a...
rman恢复的方式搭建dataguard后redo log 的处理
changyanmanman的专栏
05-08 2781
转载：http://www.dbdream.org/?p=548 搭建DATA GUARD，利用RMAN备份恢复备库时，由于RMAN不会备份REDO文件，还原后的备库缺少REDO日志文件，对于用归档日志同步数据的备库，影响不是很大，依然可以应用日志同步主库的数据变更，但是如果主/备库切换的话，就不行了，对于这样控制文件里记录了REDO的信息，但是在存储上却没有对应的文件的备库，此时删除控制文
ORACLE之搭建DG（ADG方式）
demonson的专栏
02-07 1250
目录(?)[+] 1.准备工作         首先得准备两个能够PING通，并且装了Oracle软件且已经建库的Linux虚拟机。操作系统不限，至少有一个虚拟机已经建好库，最好两个都建好相同SID的库，这样少很多创建目录的麻烦，这里库的SID都是orcl，Linux严格区分大小写，所以SID的大小写得注意。         我这里有两个名为PD和ST的Linux虚拟机。    
利用NFS备份ORACLE数据库
cuanyanjie8781的博客
07-08 192
1、开启NFS服务 service nfs restart 2、创建需要挂载备份的目录及权限 3、配置授权访问的IP地址和目录 vi /etc/exports /dbbak 192.168.56.*(rw) 4、配置...
oracle adg 备份,Oracle Physical Dataguard环境使用RMAN备份和恢复
weixin_35326667的博客
04-08 992
Oracle Physical Dataguard环境使用RMAN备份和恢复由于Physical Dataguard使用的是块恢复技术来保持和PRIMARY的一致性，因此可以在STANDBY上进行rman备份，从而减轻PRIMARY的压力.当PRIMARY出现数据库故障时，可以使用在STANDBY上的备份来进行恢复.先决条件：需要配置catalog.在PRIMARY上以catalog方式连接，并且...
Oracle 11g OCP 053：RMAN备份策略与数据库交互实操
Oracle 11g OCP 053 是一项针对Oracle数据库管理的高级认证考试，主要考察数据库恢复管理器(RMAN)的使用、备份策略以及数据库内部工作原理。以下是一些关键知识点的解析： 1. **RMAN备份作为副本的因素**： 在选择...

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值