Hello all,
so i tried to setup physical standby database in my local vm.
I have apparently completed the configuration but i'm facing some issue which i'm unable to understand.
Os :- Linux 6.4
Oracle version :12.1.0.2.0
primary database: ORA12C
standby database : ORASTD
Primary database:-
SYS@ORA12C> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/app/oracle/fast_recovery_area
Oldest online log sequence 14
Next log sequence to archive 16
Current log sequence 16
SYS@ORA12C> select name, database_role, controlfile_type from v$database;
NAME DATABASE_ROLE CONTROL
--------- ---------------- -------
ORA12C PRIMARY CURRENT
SYS@ORA12C> select sequence#, first_time, next_time, applied from v$archived_log;
SEQUENCE# FIRST_TIM NEXT_TIME APPLIED
---------- --------- --------- ---------
4 15-APR-15 16-APR-15 NO
4 15-APR-15 16-APR-15 YES
5 16-APR-15 16-APR-15 NO
5 16-APR-15 16-APR-15 YES
6 16-APR-15 16-APR-15 NO
6 16-APR-15 16-APR-15 YES
7 16-APR-15 16-APR-15 NO
7 16-APR-15 16-APR-15 YES
8 16-APR-15 16-APR-15 NO
8 16-APR-15 16-APR-15 YES
9 16-APR-15 16-APR-15 NO
SEQUENCE# FIRST_TIM NEXT_TIME APPLIED
---------- --------- --------- ---------
9 16-APR-15 16-APR-15 YES
10 16-APR-15 16-APR-15 NO
10 16-APR-15 16-APR-15 YES
11 16-APR-15 16-APR-15 NO
12 16-APR-15 16-APR-15 NO
13 16-APR-15 16-APR-15 NO
11 16-APR-15 16-APR-15 YES
12 16-APR-15 16-APR-15 YES
13 16-APR-15 16-APR-15 YES
14 16-APR-15 16-APR-15 NO
15 16-APR-15 16-APR-15 NO
SEQUENCE# FIRST_TIM NEXT_TIME APPLIED
---------- --------- --------- ---------
15 16-APR-15 16-APR-15 NO
14 16-APR-15 16-APR-15 YES
In standby database:-
select sequence#, first_time, next_time, applied from v$archived_log;
SEQUENCE# FIRST_TIM NEXT_TIME APPLIED
---------- --------- --------- ---------
4 15-APR-15 16-APR-15 YES
5 16-APR-15 16-APR-15 YES
6 16-APR-15 16-APR-15 YES
7 16-APR-15 16-APR-15 YES
8 16-APR-15 16-APR-15 YES
9 16-APR-15 16-APR-15 YES
10 16-APR-15 16-APR-15 YES
11 16-APR-15 16-APR-15 YES
12 16-APR-15 16-APR-15 YES
13 16-APR-15 16-APR-15 YES
15 16-APR-15 16-APR-15 IN-MEMORY
SEQUENCE# FIRST_TIM NEXT_TIME APPLIED
---------- --------- --------- ---------
14 16-APR-15 16-APR-15 YES
SQL> select name, database_role, controlfile_type from v$database;
NAME DATABASE_ROLE CONTROL
--------- ---------------- -------
ORA12C PHYSICAL STANDBY STANDBY
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/app/oracle/fast_recovery_area
Oldest online log sequence 0
Next log sequence to archive 0
Current log sequence 0
Now here my question is why is the current log sequence is showing 0. I tested datas from
primary database to standby getting replicated.I'm totally out of clue.
I did try to find it on google but nothing could have helped me so far.
Any kind of help would be highly appreciated.
Thanks
Soumya