Hi all
Learning data guard in 11R2 on linux env.
Once i have created standby redolog file , status is INVALID. why ?
>> My current redo log details
SYS>select b.group#, b.member, a.bytes from v$logfile b, v$log a where a.group#=b.group# order by group#;
GROUP# MEMBER BYTES
---------- ---------------------------------------------------- ----------
1 /u01/app/oracle/oradata/REDOLOG/orcl/redo1a.log 52428800
1 /u03/app/oracle/oradata/REDOLOG/orcl/redo1b.log 52428800
2 /u03/app/oracle/oradata/REDOLOG/orcl/redo2b.log 52428800
2 /u01/app/oracle/oradata/REDOLOG/orcl/redo2a.log 52428800
3 /u03/app/oracle/oradata/REDOLOG/orcl/redo3b.log 52428800
3 /u01/app/oracle/oradata/REDOLOG/orcl/redo3a.log 52428800
>> I have created standby redologs on primary database.
SYS>ALTER DATABASE ADD STANDBY LOGFILE group 4('/u01/app/oracle/oradata/REDOLOG/orcl/stby_redo1a.log') SIZE 50m REUSE;
Database altered.
SYS>ALTER DATABASE ADD STANDBY LOGFILE member '/u03/app/oracle/oradata/REDOLOG/orcl/stby_redo1b.log' REUSE to group 4;
Database altered.
SYS> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- ---------------------------------------------------- ---
3 ONLINE /u01/app/oracle/oradata/REDOLOG/orcl/redo3a.log NO
2 ONLINE /u01/app/oracle/oradata/REDOLOG/orcl/redo2a.log NO
1 ONLINE /u01/app/oracle/oradata/REDOLOG/orcl/redo1a.log NO
3 ONLINE /u03/app/oracle/oradata/REDOLOG/orcl/redo3b.log NO
1 ONLINE /u03/app/oracle/oradata/REDOLOG/orcl/redo1b.log NO
2 ONLINE /u03/app/oracle/oradata/REDOLOG/orcl/redo2b.log NO
4 STANDBY /u01/app/oracle/oradata/REDOLOG/orcl/stby_redo1a.log NO
4 INVALID STANDBY /u03/app/oracle/oradata/REDOLOG/orcl/stby_redo1b.log NO
Thanks all