备案控制台
探索云世界
开发者社区 数据库 文章 正文

Oracle dataGuard专题：Rman通过duplicate创建standby

2017-11-20 966
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《 阿里云开发者社区用户服务协议》和 《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写 侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
简介：

rman提供了更便捷的方式来创建standby，方法就是通过duplicate命令，下面做一个详细介绍：

1. 试验环境

[oracle@gaojf orcl]$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Dec 6 08:54:45 2006
Copyright (c) 1982, 2005, Oracle.  All rights reserved.

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

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

SQL>

2. 确认主库处于归档模式

SQL> archive log list
Database log mode            Archive Mode
Automatic archival             Enabled
Archive destination            /free/oracle/orabak
Oldest online log sequence     275
Next log sequence to archive   277
Current log sequence           277
SQL>
 

3：创建备库instance

windows平台利用oradim工具创建一个新的instance，unix/linux平台设置新的ORACLE_SID即可，我的是linux平台，设置ORACLE_SID即可。


4：准备好备库的参数文件

本次试验在两个系统上建主备库，另外如果主备库都在一起的话，db_name设置为主库名，lock_name_space设置为备库名，同时要注意设置好DB_FILE_NAME_CONVERT和LOG_FILE_NAME_CONVERT参数。

备库主要的几个参数如下：
*.log_archive_config='DG_CONFIG=(PRIMARY,STANDBY)' 
*.LOG_ARCHIVE_DEST_1='LOCATION=/free/oracle/orabak VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=STANDBY'
*.LOG_ARCHIVE_DEST_2='SERVICE=primary VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PRIMARY LGWR SYNC AFFIRM'
*.db_unique_name='STANDBY'
*.FAL_CLIENT='STANDBY'
*.FAL_SERVER='PRIMARY'
*.log_archive_dest_state_1='enable'
*.log_archive_dest_state_2='enable'
*.STANDBY_ARCHIVE_DEST='/free/oracle/orabak'
*.STANDBY_FILE_MANAGEMENT='AUTO'

主库几个主要参数如下：

*.log_archive_config='DG_CONFIG=(PRIMAYR,STANDBY)'
*.DB_UNIQUE_NAME='PRIMARY'
*.LOG_ARCHIVE_DEST_1= 'LOCATION=/free/oracle/orabak'
#*.LOG_ARCHIVE_DEST_2='SERVICE=STANDBYVALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=STANDBY LGWR SYNC AFFIRM' ＃LGWR方式
*.LOG_ARCHIVE_DEST_2='SERVICE=STANDBY DB_UNIQUE_NAME=STANDBY ARCH SYNC REOPEN=10' ＃arch方式
*.LOG_ARCHIVE_DEST_STATE_1=ENABLE
*.LOG_ARCHIVE_DEST_STATE_2=ENABLE
*.LOG_ARCHIVE_FORMAT='arc%s%t%r.arc'
*.FAL_SERVER='STANDBY'
*.FAL_CLIENT='PRIMARY'
*.STANDBY_FILE_MANAGEMENT='AUTO'
*.standby_archive_dest='/free/oracle/orabak'

5.在备库生成password file

[oracle@gaojfdbs]$Orapwd file=/free/oracle/product/10.2.0/db_1/orapworcl.ora password=orcl entries=5

或者可以直接复制主库密码文件到备库相应的位置也可。

6.配置网络

配置主备库的listener.ora,tnsnames.ora。修改完lisner.ora后注意重启监听。

主库Listener.ora

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /free/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.60.144)(PORT = 1521))
    )
  )

备库Listener.ora

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /free/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.60.253)(PORT = 1521))
    )
  )

tnsnames.ora（主备库配置一样）

PRIMARY =
  (DESCRIPTION =
    (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.60.144)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = primary)
    )
  )

STANDBY =
  (DESCRIPTION =
    (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.60.253)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = standby)
    )
  )

 

7.利用rman备份主库
注意同时备库控制文件
[oracle@gaojf ~]$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Thu Dec 7 10:10:02 2006
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
connected to target database: ORCL (DBID=1132959697)
RMAN> backup full format='/free/oracle/FULL_%d_%T_%s' database  include current controlfile for standby
2> plus archivelog format='/free/oracle/arch_%d_%T_%s';
Starting backup at 07-DEC-06
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=159 devtype=DISK
skipping archive log file /free/oracle/orabak/arc2951605985194.arc; already backed up 1 time(s)
skipping archive log file /free/oracle/orabak/arc2961605985194.arc; already backed up 1 time(s)
skipping archive log file /free/oracle/orabak/arc2971605985194.arc; already backed up 1 time(s)
skipping archive log file /free/oracle/orabak/arc2981605985194.arc; already backed up 1 time(s)
skipping archive log file /free/oracle/orabak/arc2991605985194.arc; already backed up 1 time(s)
skipping archive log file /free/oracle/orabak/arc3001605985194.arc; already backed up 1 time(s)
skipping archive log file /free/oracle/orabak/arc3011605985194.arc; already backed up 1 time(s)
skipping archive log file /free/oracle/orabak/arc3021605985194.arc; already backed up 1 time(s)
skipping archive log file /free/oracle/orabak/arc3031605985194.arc; already backed up 1 time(s)
skipping archive log file /free/oracle/orabak/arc3041605985194.arc; already backed up 1 time(s)
skipping archive log file /free/oracle/orabak/arc3051605985194.arc; already backed up 1 time(s)
skipping archive log file /free/oracle/orabak/arc3061605985194.arc; already backed up 1 time(s)
skipping archive log file /free/oracle/orabak/arc3071605985194.arc; already backed up 1 time(s)
skipping archive log file /free/oracle/orabak/arc3081605985194.arc; already backed up 1 time(s)
skipping archive log file /free/oracle/orabak/arc3091605985194.arc; already backed up 1 time(s)
skipping archive log file /free/oracle/orabak/arc3101605985194.arc; already backed up 1 time(s)
skipping archive log file /free/oracle/orabak/arc3111605985194.arc; already backed up 1 time(s)
skipping archive log file /free/oracle/orabak/arc3121605985194.arc; already backed up 1 time(s)
skipping archive log file /free/oracle/orabak/arc3131605985194.arc; already backed up 1 time(s)
skipping archive log file /free/oracle/orabak/arc3141605985194.arc; already backed up 1 time(s)
skipping archive log file /free/oracle/orabak/arc3151605985194.arc; already backed up 1 time(s)
skipping archive log file /free/oracle/orabak/arc3161605985194.arc; already backed up 1 time(s)
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=317 recid=436 stamp=608584285
input archive log thread=1 sequence=318 recid=439 stamp=608585430
input archive log thread=1 sequence=319 recid=441 stamp=608585703
channel ORA_DISK_1: starting piece 1 at 07-DEC-06
channel ORA_DISK_1: finished piece 1 at 07-DEC-06
piece handle=/free/oracle/arch_ORCL_20061207_56 tag=TAG20061207T193504 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 07-DEC-06

Starting backup at 07-DEC-06
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/free/oracle/oradata/orcl/system01.dbf
input datafile fno=00003 name=/free/oracle/oradata/orcl/sysaux01.dbf
input datafile fno=00006 name=/free/oracle/oradata/orcl/gaojf1db.dbf
input datafile fno=00007 name=/free/oracle/oradata/orcl/gaojf2db.dbf
input datafile fno=00008 name=/free/oracle/oradata/orcl/gaojf3db.dbf
input datafile fno=00010 name=/free/oracle/oradata/orcl/cicrodb1.dbf
input datafile fno=00011 name=/free/oracle/oradata/orcl/cicrodb11.dbf
input datafile fno=00009 name=/free/oracle/oradata/orcl/gaojf4db.dbf
input datafile fno=00002 name=/free/oracle/oradata/orcl/undotbs01.dbf
input datafile fno=00005 name=/free/oracle/oradata/orcl/gaojfdb.dbf
input datafile fno=00004 name=/free/oracle/oradata/orcl/users01.dbf
channel ORA_DISK_1: starting piece 1 at 07-DEC-06                                                                                                                                                                                                                                                                                        channel ORA_DISK_1: finished piece 1 at 07-DEC-06
piece handle=/free/oracle/FULL_ORCL_20061207_57 tag=TAG20061207T193507 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:03:55
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including standby control file in backupset
channel ORA_DISK_1: starting piece 1 at 07-DEC-06
channel ORA_DISK_1: finished piece 1 at 07-DEC-06
piece handle=/free/oracle/FULL_ORCL_20061207_58 tag=TAG20061207T193507 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 07-DEC-06

Starting backup at 07-DEC-06
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=320 recid=443 stamp=608585946
channel ORA_DISK_1: starting piece 1 at 07-DEC-06
channel ORA_DISK_1: finished piece 1 at 07-DEC-06
piece handle=/free/oracle/arch_ORCL_20061207_59 tag=TAG20061207T193906 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 07-DEC-06

Starting Control File Autobackup at 07-DEC-06
piece handle=/free/oracle/orabak/c-1132959697-20061207-02 comment=NONE
Finished Control File Autobackup at 07-DEC-06
RMAN>
 

8：复制 rman全备份到备库
利用操作系统命令scp，或者ftp bin方式复制rman全备份到备库。
由于我rman主库备份时设置备份文件位置为/free/oracle，因此必须把此备份文件也放到备库同样的位置。
同时scp 控制文件standby.ctl到备库相应的位置。
 

9.启动备库到nomount
SQL> startup nomount
ORACLE instance started.
Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
 

10.利用rman恢复备库
oracle@linux:/free/oracle/oradata/orcl>
rman target sys/cicro@primary  auxiliary /
Recovery Manager: Release 10.2.0.1.0 - Production on 星期五 12月 8 12:09:23 2006
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
connected to target database: ORCL (DBID=1132959697)
connected to auxiliary database: ORCL (not mounted)

RMAN> duplicate target database for standby dorecover nofilenamecheck;

Starting Duplicate Db at 08-12月-06
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=156 devtype=DISK

contents of Memory Script:
{
   set until scn  1607552;
   restore clone standby controlfile;
   sql clone 'alter database mount standby database';
}
executing Memory Script
executing command: SET until clause
Starting restore at 08-12月-06
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /free/oracle/FULL_ORCL_20061207_58
channel ORA_AUX_DISK_1: restored backup piece 1
piece handle=/free/oracle/FULL_ORCL_20061207_58 tag=TAG20061207T193507
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
output filename=/free/oracle/oradata/orcl/standby.ctl
Finished restore at 08-12月-06

sql statement: alter database mount standby database
                  released channel: ORA_AUX_DISK_1

contents of Memory Script:
{
   set until scn  1607552;
   set newname for tempfile  1 to 
 "/free/oracle/oradata/orcl/temp01.dbf";
   switch clone tempfile all;
   set newname for datafile  1 to 
 "/free/oracle/oradata/orcl/system01.dbf";
   set newname for datafile  2 to 
 "/free/oracle/oradata/orcl/undotbs01.dbf";
   set newname for datafile  3 to 
 "/free/oracle/oradata/orcl/sysaux01.dbf";
   set newname for datafile  4 to 
 "/free/oracle/oradata/orcl/users01.dbf";
   set newname for datafile  5 to 
 "/free/oracle/oradata/orcl/gaojfdb.dbf";
   set newname for datafile  6 to 
 "/free/oracle/oradata/orcl/gaojf1db.dbf";
   set newname for datafile  7 to 
 "/free/oracle/oradata/orcl/gaojf2db.dbf";
   set newname for datafile  8 to 
 "/free/oracle/oradata/orcl/gaojf3db.dbf";
   set newname for datafile  9 to 
 "/free/oracle/oradata/orcl/gaojf4db.dbf";
   set newname for datafile  10 to 
 "/free/oracle/oradata/orcl/cicrodb1.dbf";
   set newname for datafile  11 to 
 "/free/oracle/oradata/orcl/cicrodb11.dbf";
   restore
   check readonly
   clone database
   ;
}
executing Memory Script
executing command: SET until clause
executing command: SET NEWNAME
renamed temporary file 1 to /free/oracle/oradata/orcl/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
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 08-12月-06
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=156 devtype=DISK

channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /free/oracle/oradata/orcl/system01.dbf
restoring datafile 00002 to /free/oracle/oradata/orcl/undotbs01.dbf
restoring datafile 00003 to /free/oracle/oradata/orcl/sysaux01.dbf
restoring datafile 00004 to /free/oracle/oradata/orcl/users01.dbf
restoring datafile 00005 to /free/oracle/oradata/orcl/gaojfdb.dbf
restoring datafile 00006 to /free/oracle/oradata/orcl/gaojf1db.dbf
restoring datafile 00007 to /free/oracle/oradata/orcl/gaojf2db.dbf
restoring datafile 00008 to /free/oracle/oradata/orcl/gaojf3db.dbf
restoring datafile 00009 to /free/oracle/oradata/orcl/gaojf4db.dbf
restoring datafile 00010 to /free/oracle/oradata/orcl/cicrodb1.dbf
restoring datafile 00011 to /free/oracle/oradata/orcl/cicrodb11.dbf
channel ORA_AUX_DISK_1: reading from backup piece /free/oracle/FULL_ORCL_20061207_57
                                                                                                                                                                                                                                                                             channel ORA_AUX_DISK_1: restored backup piece 1
piece handle=/free/oracle/FULL_ORCL_20061207_57 tag=TAG20061207T193507
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:04:07
Finished restore at 08-12月-06

contents of Memory Script:
{
   switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy recid=17 stamp=608645655 filename=/free/oracle/oradata/orcl/system01.dbf
datafile 2 switched to datafile copy
input datafile copy recid=18 stamp=608645655 filename=/free/oracle/oradata/orcl/undotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=19 stamp=608645655 filename=/free/oracle/oradata/orcl/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy recid=20 stamp=608645655 filename=/free/oracle/oradata/orcl/users01.dbf
datafile 5 switched to datafile copy
input datafile copy recid=21 stamp=608645655 filename=/free/oracle/oradata/orcl/gaojfdb.dbf
datafile 6 switched to datafile copy
input datafile copy recid=22 stamp=608645655 filename=/free/oracle/oradata/orcl/gaojf1db.dbf
datafile 7 switched to datafile copy
input datafile copy recid=23 stamp=608645655 filename=/free/oracle/oradata/orcl/gaojf2db.dbf
datafile 8 switched to datafile copy
input datafile copy recid=24 stamp=608645655 filename=/free/oracle/oradata/orcl/gaojf3db.dbf
datafile 9 switched to datafile copy
input datafile copy recid=25 stamp=608645655 filename=/free/oracle/oradata/orcl/gaojf4db.dbf
datafile 10 switched to datafile copy
input datafile copy recid=26 stamp=608645656 filename=/free/oracle/oradata/orcl/cicrodb1.dbf
datafile 11 switched to datafile copy
input datafile copy recid=27 stamp=608645656 filename=/free/oracle/oradata/orcl/cicrodb11.dbf

contents of Memory Script:
{
   set until scn  1607552;
   recover
   standby
   clone database
    delete archivelog
   ;
}
executing Memory Script
executing command: SET until clause
Starting recover at 08-12月-06
using channel ORA_AUX_DISK_1

starting media recovery
channel ORA_AUX_DISK_1: starting archive log restore to default destination
channel ORA_AUX_DISK_1: restoring archive log
archive log thread=1 sequence=320
channel ORA_AUX_DISK_1: reading from backup piece /free/oracle/arch_ORCL_20061207_59
channel ORA_AUX_DISK_1: restored backup piece 1
piece handle=/free/oracle/arch_ORCL_20061207_59 tag=TAG20061207T193906
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
archive log filename=/free/oracle/orabak/1_320_605985194.dbf thread=1 sequence=320
channel clone_default: deleting archive log(s)
archive log filename=/free/oracle/orabak/1_320_605985194.dbf recid=1 stamp=608645661
media recovery complete, elapsed time: 00:00:03
Finished recover at 08-12月-06
 

11.将备库置于自动恢复状态

SQL> alter database recover managed standby database disconnect from session;
Database altered.

12.在主库上执行检查

SQL> conn /as sysdba
Connected.

SQL> select dest_name,status,error from v$archive_dest;
DEST_NAME                      STATUS    ERROR
------------------------------        -------- ----------
LOG_ARCHIVE_DEST_1             VALID
LOG_ARCHIVE_DEST_2             VALID
LOG_ARCHIVE_DEST_3             INACTIVE
LOG_ARCHIVE_DEST_4             INACTIVE
LOG_ARCHIVE_DEST_5             INACTIVE
LOG_ARCHIVE_DEST_6             INACTIVE
LOG_ARCHIVE_DEST_7             INACTIVE
LOG_ARCHIVE_DEST_8             INACTIVE
LOG_ARCHIVE_DEST_9             INACTIVE
LOG_ARCHIVE_DEST_10            INACTIVE

10 rows selected.

SQL> select * from v$archive_gap;

no rows selected

SQL> select sequence# from v$log_history;

SEQUENCE#
----------
1
2
...
321

13.在备库上执行检查

SQL> conn / as sysdba
Connected.
SQL> select * from v$archive_gap;

no rows selected

SQL> select sequence# from v$log_history;

SEQUENCE#
----------
1
2
...
321

SQL> select sequence#,applied from v$archived_log;

SEQUENCE# APPLIE
---------- ------
       320 YES
       321 YES
SQL> select process,status from v$managed_standby;

PROCESS            STATUS
------------------ ------------------------
ARCH               CLOSING
ARCH               CLOSING
RFS                IDLE
MRP0               WAIT_FOR_LOG

至此，备库创建成功。
可以看到，使用rman的duplicate来创建备库，过程简洁了不少，无需在手动创建备库控制文件。

本专题相关链接：

Oracle dataGuard专题：利用冷备创建standby：http://ixdba.blog.51cto.com/2895551/641184

Oracle dataGuard专题：利用rman创建standby：http://ixdba.blog.51cto.com/2895551/642906
















本文转自南非蚂蚁51CTO博客，原文链接：http://blog.51cto.com/ixdba/654797 ，如需转载请自行联系原作者




文章标签：
关系型数据库
Oracle
SQL
数据库
网络协议
关键词：
Oracle数据库一键上云rman
Oracle数据库一键上云dataguard
Oracle数据库一键上云standby
Oracle数据库一键上云创建
Oracle数据库一键上云rman duplicate
技术小甜
目录
相关文章
SarPro
|
8天前
|
SQL Oracle 关系型数据库
【Oracle】玩转Oracle数据库（七）：RMAN恢复管理器
【Oracle】玩转Oracle数据库（七）：RMAN恢复管理器
SarPro
35 5
snowofsummer
|
2月前
|
Oracle 关系型数据库
oracle 19c 搭建dataguard 简要命令
通过service 完成dg 搭建。
snowofsummer
49 0
小Lee
|
5月前
|
Oracle 关系型数据库 数据库
Flink CDC中oracle dataguard模式下，有没有cdc备库的方案？
Flink CDC中oracle dataguard模式下，有没有cdc备库的方案？
小Lee
70 1
小麦苗
|
Oracle 关系型数据库 5G
Oracle 12C rman备份占用大量临时表空间
Oracle 12C rman备份占用大量临时表空间
小麦苗
387 0
姚远OracleACE
|
11月前
|
Oracle 关系型数据库 内存技术
Oracle 闪回区(Oracle Flash recovery area)满了RMAN备份报错ORA-19804 ORA-19809
rman备份失败
姚远OracleACE
133 0
小麦苗
|
Oracle 关系型数据库 数据库
Oracle中的差异增量备份和累积增量备份的区别、rman全备+增量备份常用脚本
Oracle中的差异增量备份和累积增量备份的区别、rman全备+增量备份常用脚本
小麦苗
1097 0
小麦苗
|
SQL Oracle 关系型数据库
Oracle各种版本下“示例数据库的创建”的创建
Oracle各种版本下“示例数据库的创建”的创建
小麦苗
449 0
小麦苗
|
存储 网络协议 Oracle
Oracle 12c rman duplicate网卡offload引起文件坏块问题
Oracle 12c rman duplicate网卡offload引起文件坏块问题
小麦苗
163 0
笱局长
|
Oracle 关系型数据库 数据库
Oracle Dataguard 下块自动修复技术
在Oracle11gr2版本之后，若搭建实时应用日志的物理备库，那么在主库数据文件少量坏块的情况下，可以利用ABCR技术快速修复坏块
笱局长
2736 0
SarPro
|
8天前
|
SQL Oracle 关系型数据库
【Oracle】玩转Oracle数据库（一）：装上去，飞起来！
【Oracle】玩转Oracle数据库（一）：装上去，飞起来！
SarPro
45 7

热门文章

最新文章

  • 1
    Oracle 面试题及答案整理，最新面试题
  • 2
    Seata常见问题之oracle 数据库 报 just support mysql如何解决
  • 3
    PolarDB常见问题之PolarDB(Oracle兼容版) 执行命令报错如何解决
  • 4
    Dataphin实时集成Oracle CDC相关问题排查
  • 5
    【Oracle】玩转Oracle数据库（一）：装上去，飞起来！
  • 6
    【Oracle】玩转Oracle数据库（二）：体系结构、存储结构与各类参数
  • 7
    【Oracle】玩转Oracle数据库（七）：RMAN恢复管理器
  • 8
    struts+hibernate+oracle+easyui实现lazyout组件的简单案例——Emp实体类和对应的配置信息
  • 9
    oracle基本笔记整理及案例分析1
  • 10
    struts+hibernate+oracle+easyui实现lazyout组件的简单案例——EmpDao层代码
  • 1
    服务器Centos7 静默安装Oracle Database 12.2
    71
  • 2
    SpringBoot整合Mybatis连接Oracle数据库
    52
  • 3
    避坑，Oracle中rownum与order by的执行顺序
    25
  • 4
    避坑，Oracle中left join 与 (+) 的区别
    19
  • 5
    Oracle临时表详解
    17
  • 6
    Oracle insert数据时字符串中有‘单引号问题
    25
  • 7
    【Bug记录】Oracle中小数点前面的0不显示的问题
    37
  • 8
    Oracle中merge Into的用法
    17
  • 9
    Flink CDC产品常见问题之使用cdc-Oracle连接器报错如何解决
    48
  • 10
    Oracle系列十八：Oracle RAC
    47

    • 相关电子书

    更多
  • PostgresChina2018_樊文凯_ORACLE数据库和应用异构迁移最佳实践
  • PostgresChina2018_王帅_从Oracle到PostgreSQL的数据迁移
  • Oracle云上最佳实践

    • 推荐镜像

    更多
  • oracle
  • arch4edu
  • debian-archive
    • 下一篇
    阿里云oss简介和使用流程