- 论坛徽章:
- 0
|
在做完dataguard后,主数据库和辅数据库上执行select name,database_role from v$database;都可以看见一个为primary状态,一个为standby状态,看似好像起来了
然后在主数据库上做相关操作:
SQL> create table dgtest(id int,name char(10));
SQL> insert into dgtest values(1,'boobooke1');
1 row created.
SQL>commit;
SQL> alter system switch logfile;
System altered.
SQL> /
System altered.
SQL> /
在辅数据库上执行:
SQL> alter database recover managed standby database disconnect from session;
Database altered.
SQL> select sequence#,first_time,next_time from v$archived_log order by sequence#;
no rows selected
SQL> select sequence#,first_time,next_time from v$archived_log order by sequence#;
no rows selected
死活接受不到来自primary的数据,接着执行
SQL> alter database recover managed standby database cancel;
Database altered.
SQL> alter database open read only;
alter database open read only
*
ERROR at line 1:
ORA-16004: backup database requires recovery
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/ora/oradata/fzhndb/system01.dbf' |
|