- 论坛徽章:
- 0
|
主从库监听正常.用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'
从库的控制文件是在主库建立的
主库执行:alter database create standby controlfile as '/home/risetek/oracle/product/10.2.0/redo/standby.ctl';
然后复制在从库的/home/risetek/oracle/oradata/bill目录(存放数据的文件,主从库是一致的)里面在.并且复制standby.ctl为control01.ctl,control02.ctl,control03.ctl.
数据文件是主库rman建的,从库恢复没有报错.
在主库新建表a.
commit后
执行:alter system archive log current;
在从库也无法查看表a信息. |
|