加入收藏 | 设为首页 | 会员中心 | 我要投稿 东莞站长网 (https://www.0769zz.com/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 站长百科 > 正文

【Oracle】RMAN duplicate复制库

发布时间:2020-12-27 08:23:02 所属栏目:站长百科 来源:网络整理
导读:基础环境: 172.17.4.60 操作系统:Linux 6.4 数据库:Oracle11gR2 (源数据库) 172.17.4.61 操作系统:Linux 6.4 数据库:Oracle11gR2 (测试库) 目的:从源数据库以RMAN的物理恢复的方式,恢复至测试库中。 如何验证,在源数据库,插入几条数据如下: [email?protec

测试端(172.17.4.61):测试源数据库

[[email?protected] ~]$ tnsping zsddb

TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 29-DEC-2018 16:21:23

Copyright (c) 1997,Oracle.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = db1)(PORT = 1521))) (CONNECT_DATA = 

(SERVICE_NAME = oradb.zsd.com)))
OK (70 msec)

[[email?protected] ~]$ sqlplus sys/[email?protected] as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sat Dec 29 16:21:47 2018

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning,OLAP,Data Mining and Real Application Testing options

[email?protected]>

Step 6.测试数据库(172.17.4.61)以nomout的格式打开。

[[email?protected] ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sat Dec 29 16:23:55 2018

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

Connected to an idle instance.

[email?protected]> startup nomount pfile=$ORACLE_HOME/dbs/dummy.ora
ORACLE instance started.

Total System Global Area  263090176 bytes
Fixed Size                  2252256 bytes
Variable Size             205521440 bytes
Database Buffers           50331648 bytes
Redo Buffers                4984832 bytes

(编辑:东莞站长网)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!