Standby queries

select thread#,sequence#,applied from v$archived_log;

select max(sequence#) from v$archived;


SELECT THREAD#, MAX(SEQUENCE#) AS "LAST_APPLIED_LOG"
FROM V$LOG_HISTORY
GROUP BY THREAD#;

select process,status,sequence# from v$managed_standby;



SELECT ARCH.THREAD# "Thread", ARCH.SEQUENCE# "Last Sequence Received", APPL.SEQUENCE# "Last Sequence Applied", (ARCH.SEQUENCE# - APPL.SEQUENCE#) "Difference"
FROM
(SELECT THREAD# ,SEQUENCE# FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#)) ARCH,
(SELECT THREAD# ,SEQUENCE# FROM V$LOG_HISTORY WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$LOG_HISTORY GROUP BY THREAD#)) APPL
WHERE
ARCH.THREAD# = APPL.THREAD#
ORDER BY 1;

Changing Archives location and permission-

SQL> alter system set log_archive_dest_1='location=/u101/archivelogs';

System altered.

SQL>  show parameter archive

[oracle@at001 archivelogs]$

[oracle@at001 archivelogs]$ id

uid=1000(oracle) gid=1001(oinstall) groups=1000(dba),1001(oinstall),1002(asmoper),1003(asmadmin),1004(asmdba)

[oracle@at001 archivelogs]$

[oracle@as001 archivelogs]$

[oracle@a001 archivelogs]$

[oracle@ashoramgmt001 archivelogs]$ exit

logout

[bprasad@ast001 ~]$ sudo su -

[root@at001 ~]#

[root@at001 ~]#

[root@at001 ~]# mkdir -p   /u101/archivelogs/

[root@at001 ~]# chmod -R 775 /u101/archivelogs/

[root@at001 ~]# chown -R oracle:oinstall /u101/archivelogs/

[root@at001 ~]# chmod -R 755 /u101/archivelogs/

[root@at001 ~]# ls -ld /u102/archivelogs/

drwxr-xr-x 2 oracle oinstall 49152 Jan  8 04:12 /u102/archivelogs/

[root@ashoramgmt001 ~]# ls -ld /u101/archivelogs/

drwxr-xr-x 2 oracle oinstall 4096 Jan  8 04:13 /u101/archivelogs/

[root@ashoramgmt001 ~]# exit

logout