RMAN冷拷贝搭建DataGuard物理备库 |
您所在的位置:网站首页 › oracle列转行函数 › RMAN冷拷贝搭建DataGuard物理备库 |
1.配置主库环境 启用归档 SQLgt; alter system set log_archive_dest_1= 1.配置主库环境 启用归档 SQL> alter system set log_archive_dest_1='location=/Oracle/archive_log/arch_%t_%s_%r.arc' scope=spfile; 系统已更改。 SQL> ALTER SYSTEM SET LOG_ARCHIVE_FORMAT='arch_%t_%s_%r.arc' scope=spfile; 系统已更改。 SQL> shutdown immediate数据库已经关闭。已经卸载数据库。ORACLE 例程已经关闭。 SQL> startup mountORACLE 例程已经启动。 Total System Global Area 2538741760 bytesFixed Size 2757504 bytesVariable Size 738200704 bytesDatabase Buffers 1778384896 bytesRedo Buffers 19398656 bytes数据库装载完毕。SQL> alter database archivelog; 数据库已更改。 SQL> alter database open; 数据库已更改。 SQL> archive log list数据库日志模式 存档模式自动存档 启用存档终点 /oracle/archive_log最早的联机日志序列 10下一个存档日志序列 12当前日志序列 12 SQL> alter database force logging; 数据库已更改。 SQL> select force_logging from v$database; FORCE_LOGGING--------------------------------------------------------------------------------YES 2.配置Oracle Net主Oracle Net SQL> !oracle@Sol_ORA:~$ cd $ORACLE_HOME/network/adminoracle@Sol_ORA:/oracle/12.1/network/admin$ cat tnsnames.ora # tnsnames.ora Network Configuration File: /oracle/12.1/network/admin/tnsnames.ora# Generated by Oracle configuration tools. TESTM = #主库的连接字符串 (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 188.188.1.176)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = TESTM) ) ) LISTENER_TESTM = (ADDRESS = (PROTOCOL = TCP)(HOST = 188.188.1.176)(PORT = 1521)) TESTS = #备库的链接字符串 (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 188.188.3.20)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = TESTM) ) ) oracle@Sol_ORA:/oracle/12.1/network/admin$ cat listener.ora # listener.ora Network Configuration File: /oracle/12.1/network/admin/listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER =(SID_LIST=(SID_DESC=(SID_NAME=TESTM)(ORACLE_HOME=/oracle/12.1))) #主库的静态注册LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 188.188.1.176)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) ) 更多详情见请继续阅读下一页的精彩内容: 推荐阅读: 使用RMAN的Duplicate功能创建物理DataGuard Oracle基础教程之通过RMAN复制数据库 RMAN备份策略制定参考内容 RMAN备份学习笔记 Oracle数据库备份加密 RMAN加密 通过RMAN备份duplicate创建DataGuard , |
今日新闻 |
推荐新闻 |
CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3 |