oracle主备账号密码,Oracle主备库配置过程

三、通过日志检查切换结果

现在的备库(beijing)上看一下归档日志

SQL> select sequence#,first_time,next_time from v$archived_log order by 1;

SEQUENCE# FIRST_TIME          NEXT_TIME

---------- ------------------- -------------------

21 2012-01-10 08:54:06 2012-01-10 09:49:30

21 2012-01-10 08:54:06 2012-01-10 09:49:30

22 2012-01-10 09:49:30 2012-01-10 09:49:32

22 2012-01-10 09:49:30 2012-01-10 09:49:32

23 2012-01-10 09:49:32 2012-01-10 09:49:47

23 2012-01-10 09:49:32 2012-01-10 09:49:47(此时还是主库，有两个同序号的日志)

24 2012-01-10 09:49:47 2012-01-10 09:52:43

现在的主库(shanghai)切换一下日志

SQL> alter system switch logfile;

System altered.

现在的备库(beijing)上看一下归档日志，发现同样新增了一条日志，序号为25

SQL> select sequence#,first_time,next_time from v$archived_log order by 1;

SEQUENCE# FIRST_TIME          NEXT_TIME

---------- ------------------- -------------------

21 2012-01-10 08:54:06 2012-01-10 09:49:30

21 2012-01-10 08:54:06 2012-01-10 09:49:30

22 2012-01-10 09:49:30 2012-01-10 09:49:32

22 2012-01-10 09:49:30 2012-01-10 09:49:32

23 2012-01-10 09:49:32 2012-01-10 09:49:47

23 2012-01-10 09:49:32 2012-01-10 09:49:47

24 2012-01-10 09:49:47 2012-01-10 09:52:43

25 2012-01-10 09:52:43 2012-01-10 09:59:20

看一下现在的备库(beijing)的状态，SWITCHOVER_STATUS是NOT ALLOWED，因为主库正常运转中。

SQL> select db_unique_name,switchover_status,database_role from v$database;

DB_UNIQUE_NAME       SWITCHOVER_STATUS                        DATABASE_ROLE

-------------------- ---------------------------------------- --------------------------------

beijing              NOT ALLOWED                              PHYSICAL STANDBY

四、数据验证

1.在主库scott.dept表中插入些数据。

SQL> select * from scott.dept;

DEPTNO DNAME                        LOC

---------- ---------------------------- --------------------------

10 ACCOUNTING                   NEW YORK

20 RESEARCH                     DALLAS

30 SALES                        CHICAGO

40 OPERATIONS                   BOSTON

SQL> insert into scott.dept values (55,'wallimn','beijing');

1 row created.

SQL> commit;

Commit complete.

SQL> alter system switch logfile;

System altered.

2.备库查询一下

SQL> alter database recover managed standby database cancel;

Database altered.

SQL> alter database open;

Database altered.

SQL> select * from scott.dept;

DEPTNO DNAME                        LOC

---------- ---------------------------- --------------------------

10 ACCOUNTING                   NEW YORK

20 RESEARCH                     DALLAS

30 SALES                        CHICAGO

40 OPERATIONS                   BOSTON

55 wallimn                      beijing

3.备库恢复REDO应用

SQL> alter database recover managed standby database disconnect from session;

Database altered.

-END-