select thread#, max(sequence#) “Last Primary Seq Generated” from v$archived_log val, v$database vdb where val.resetlogs_change# = vdb.resetlogs_change# group by thread# order by 1;<\/p>\n\n
select thread#, max(sequence#) “Last Standby Seq Received” from v$archived_log val, v$database vdb where val.resetlogs_change# = vdb.resetlogs_change# group by thread# order by 1;
select thread#, max(sequence#) “Last Standby Seq Applied” from v$archived_log val, v$database vdb where val.resetlogs_change# = vdb.resetlogs_change# and val.applied in (‘YES’,’IN-MEMORY’) group by thread# order by 1;<\/p>\n\n
alter database recover managed standby database disconnect from session;<\/p>\n\n
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;<\/p>\n\n
alter system set local_listener ='(ADDRESS=(PROTOCOL=TCP)(HOST=10.172.20.23)(PORT=1521))’;<\/p>\n\n
ALTER SYSTEM SET LOG_ARCHIVE_DEST_2=’SERVICE=stb1 ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=stb1′;<\/p>\n\n
alter database add standby logfile thread 2 GROUP 15 (‘+RECO’,’+DATA’) size 100M;<\/p>\n\n
alter database create datafile ‘\/u01\/app\/oracle\/product\/19.0.0\/dbhome_1\/dbs\/UNNAMED00013’ as ‘ \/data\/database\/pri\/STB1\/datafile\/users02.dbf’;<\/p>\n\n
rman target \/<\/p>\n\n
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;<\/p>\n\n
select protection_mode,SWITCHOVER_STATUS,DATABASE_ROLE from v$database;<\/p>\n\n
SELECT Error, DESTINATION, STATUS, ARCHIVED_THREAD#, ARCHIVED_SEQ# FROM gV$ARCHIVE_DEST_STATUS WHERE STATUS <> ‘DEFERRED’ AND STATUS <> ‘INACTIVE’;<\/p>\n\n
Alter database open read only;<\/p>\n\n
select name, floor(space_limit \/ 1024 \/ 1024\/1024) “Size GB”, ceil(space_used \/ 1024 \/ 1024\/1024) “Used GB” from v$recovery_file_dest order by name;<\/p>\n\n
select status,process from v$managed_standby;<\/p>\n\n\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":44,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"pagelayer_contact_templates":[],"_pagelayer_content":"","footnotes":""},"categories":[3],"tags":[20,18,19],"class_list":["post-335","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-check-sync-oracle-standby","tag-oracle-standby-commands","tag-standby-commands"],"_links":{"self":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts\/335","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/comments?post=335"}],"version-history":[{"count":3,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts\/335\/revisions"}],"predecessor-version":[{"id":338,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts\/335\/revisions\/338"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/media\/44"}],"wp:attachment":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/media?parent=335"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/categories?post=335"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/tags?post=335"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}