主从,我按照人家的方法搞的,也没提示错误。
但是 主机的
idle> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /home/oracle/oracle/arclog_orcl
Oldest online log sequence 36
Next log sequence to archive 38
Current log sequence 38从机器的
idle> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /home/oracle/oracle/arclog_orcl
Oldest online log sequence 0
Next log sequence to archive 0
Current log sequence 0在从机查询 idle> Select sequence#,applied from v$archived_log
2 ;no rows selected
啥也没有的。 这是怎么回事儿呢。
但是 主机的
idle> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /home/oracle/oracle/arclog_orcl
Oldest online log sequence 36
Next log sequence to archive 38
Current log sequence 38从机器的
idle> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /home/oracle/oracle/arclog_orcl
Oldest online log sequence 0
Next log sequence to archive 0
Current log sequence 0在从机查询 idle> Select sequence#,applied from v$archived_log
2 ;no rows selected
啥也没有的。 这是怎么回事儿呢。
解决方案 »
- 求达人推荐--分布式数据同步原理的书籍
- 菜鸟请教oracle数据恢复
- 什么时候调用vipca
- oracle中的索引和索引表有什么区别和联系吗
- 多主体复制:帮助中说可以用Replication Management API在不静默主题站点的情况下来实现增加主体站点,请问如何实现?
- 这2句SQL怎么写?
- 怎么样建索引更合理?(回答有分)
- oracle9i里,我无法insert进去中文
- oracle安装问题
- 有没有人使用ORACLE8i + Jbuilder7 + weblogic7 开发EJB。
- win 7 配置iis啦怎么asp网页还是运行不了
- ORA-00903: invalid table name
*.db_unique_name='orcl'
*.log_archive_config='dg_config=(orcl,orcl129)'
*.log_archive_dest_1='LOCATION=/home/oracle/oracle/arclog_orcl VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=orcl'
*.log_archive_dest_2='SERVICE=orcl129 LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=orcl129'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
fal_server=orcl129
fal_client=orcl
db_file_name_convert='/home/oracle/oracle/product/10.2.0/oradata/orcl
','/home/oracle/oracle/product/10.2.0/oradata/orcl'
log_file_name_convert='/home/oracle/oracle/product/10.2.0/oradata/orcl','/home/oracle/oracle/product/10.2.0/
oradata/orcl'
STANDBY_FILE_MANAGEMENT=AUTO从机参数文件。 *.db_unique_name='orcl129'
*.log_archive_config='dg_config=(orcl129,orcl)'
*.log_archive_dest_1='LOCATION=/home/oracle/oracle/arclog_orcl VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=orcl129'
*.log_archive_dest_2='SERVICE=orcl LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orcl'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
fal_server=orcl
fal_client=orcl129
db_file_name_convert='/home/oracle/oracle/product/10.2.0/oradata/orcl','/home/oracle/oracle/product/10.2.0/oradata/orcl'
log_file_name_convert='/home/oracle/oracle/product/10.2.0/oradata/orcl','/home/oracle/oracle/product/10.2.0/oradata/orcl'
我从主机用sqlplus登录从机 就不行。后来修改了 tns (不是监听)那个文件 后可以了。、