【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 (编辑:东莞站长网) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |
站长推荐