- 论坛徽章:
- 0
|
本帖最后由 mfkwwgi 于 2010-08-20 15:58 编辑
主从库监听正常.用oracle的tnsping工具可以互相ping通.
主库执行:
select recid,name,applied from v$archived_log;
16 rows selected.
从库执行
select recid,name,applied from v$archived_log;
0 rows selected.
在从库执行startup报错,无法打开数据库.
SQL> startup
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 79694068 bytes
Database Buffers 83886080 bytes
Redo Buffers 2973696 bytes
Database mounted.
ORA-16004: backup database requires recovery
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/home/oracle/oracle/oradata/orcl/system01.dbf'
在主库新建表a.
commit后
执行:alter system archive log current;
在从库也无法查看表. |
|