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 mount
oracle 例程已经启动。
total system global area 2538741760 bytes
fixed size 2757504 bytes
variable size 738200704 bytes
database buffers 1778384896 bytes
redo 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/admin
oracle@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
,