Managing Online Redo Logs (ORLs) and Standby Redo Logs (SRLs) For Active Data Guard

Post by **jimb** » Fri Mar 22, 2013 8:56 pm

To check the current Online and Standby Redo Logs, run the following query on both Primary and Physical Standby Databases:

set pages 999
set lines 999
col MEMBER for a60
col BYTES for 999999999999
prompt Online Redo Logs
select GROUP#,THREAD#,sequence#,BYTES,status,ARCHIVED from v$log order by THREAD#,GROUP# asc;
prompt Standby Redo Logs
select GROUP#,THREAD#,sequence#,BYTES,status,ARCHIVED from v$standby_log order by THREAD#,GROUP# asc;
select GROUP#,STATUS,TYPE,MEMBER from v$logfile;

From Primary:

Code: Select all

SQL> set pages 999
SQL> set lines 999
SQL> col MEMBER for a60
SQL> col BYTES for 999999999999
SQL> prompt Online Redo Logs
Online Redo Logs
SQL> select GROUP#,THREAD#,sequence#,BYTES,status,ARCHIVED from v$log order by THREAD#,GROUP# asc;

    GROUP#    THREAD#  SEQUENCE#         BYTES STATUS           ARC
---------- ---------- ---------- ------------- ---------------- ---
         1          1        175      52428800 CURRENT          NO
         2          1        173      52428800 INACTIVE         YES
         3          1        172      52428800 INACTIVE         YES
        12          1        174      52428800 INACTIVE         YES

SQL> prompt Standby Redo Logs
Standby Redo Logs
SQL> select GROUP#,THREAD#,sequence#,BYTES,status,ARCHIVED from v$standby_log order by THREAD#,GROUP# asc;

    GROUP#    THREAD#  SEQUENCE#         BYTES STATUS     ARC
---------- ---------- ---------- ------------- ---------- ---
         8          0          0      52428800 UNASSIGNED YES
         9          0          0      52428800 UNASSIGNED YES
        10          0          0      52428800 UNASSIGNED YES
        11          0          0      52428800 UNASSIGNED YES
         4          1          0      52428800 UNASSIGNED YES
         5          1          0      52428800 UNASSIGNED YES
         6          1          0      52428800 UNASSIGNED YES
         7          1          0      52428800 UNASSIGNED YES

8 rows selected.

SQL> select GROUP#,STATUS,TYPE,MEMBER from v$logfile order by GROUP#;

    GROUP# STATUS  TYPE    MEMBER
---------- ------- ------- ------------------------------------------------------------
         1         ONLINE  +DATA/primary/onlinelog/group_1.289.807470849
         1         ONLINE  +FLASH/primary/onlinelog/group_1.631.807470859
         2         ONLINE  +DATA/primary/onlinelog/group_2.290.807470869
         2         ONLINE  +FLASH/primary/onlinelog/group_2.632.807470877
         3         ONLINE  +FLASH/primary/onlinelog/group_3.633.807470891
         3         ONLINE  +DATA/primary/onlinelog/group_3.291.807470885
         4         STANDBY +FLASH/primary/onlinelog/group_4.703.807486799
         4         STANDBY +DATA/primary/onlinelog/group_4.299.807486785
         5         STANDBY +DATA/primary/onlinelog/group_5.292.807470971
         5         STANDBY +FLASH/primary/onlinelog/group_5.636.807470999
         6         STANDBY +DATA/primary/onlinelog/group_6.293.807471015
         6         STANDBY +FLASH/primary/onlinelog/group_6.637.807471029
         7         STANDBY +DATA/primary/onlinelog/group_7.294.807471051
         7         STANDBY +FLASH/primary/onlinelog/group_7.638.807471067
         8         STANDBY +DATA/primary/onlinelog/group_8.295.807477047
         8         STANDBY +FLASH/primary/onlinelog/group_8.681.807477057
         9         STANDBY +DATA/primary/onlinelog/group_9.296.807477069
         9         STANDBY +FLASH/primary/onlinelog/group_9.682.807477077
        10         STANDBY +DATA/primary/onlinelog/group_10.297.807477085
        10         STANDBY +FLASH/primary/onlinelog/group_10.683.807477095
        11         STANDBY +DATA/primary/onlinelog/group_11.298.807477103
        11         STANDBY +FLASH/primary/onlinelog/group_11.684.807477115
        12         ONLINE  +DATA/primary/onlinelog/group_12.300.808603395
        12         ONLINE  +FLASH/primary/onlinelog/group_12.711.808603405

24 rows selected.

From Active Data Guard:

xaeresis · Post by **xaeresis** » Sun Feb 11, 2024 5:24 pm

audiobookkeepercottageneteyesvisioneyesvisionsfactoringfeefilmzonesgadwallgaffertapegageboardgagrulegallductgalvanometricgangforemangangwayplatformgarbagechutegardeningleavegascauterygashbucketgasreturngatedsweepgaugemodelgaussianfiltergearpitchdiameter
geartreatinggeneralizedanalysisgeneralprovisionsgeophysicalprobegeriatricnursegetintoaflapgetthebouncehabeascorpushabituatehackedbolthackworkerhadronicannihilationhaemagglutininhailsquallhairyspherehalforderfringehalfsiblingshallofresidencehaltstatehandcodinghandportedheadhandradarhandsfreetelephone
hangonparthaphazardwindinghardalloyteethhardasironhardenedconcreteharmonicinteractionhartlaubgoosehatchholddownhaveafinetimehazardousatmosphereheadregulatorheartofgoldheatageingresistanceheatinggasheavydutymetalcuttingjacketedwalljapanesecedarjibtypecranejobabandonmentjobstressjogformationjointcapsulejointsealingmaterial
journallubricatorjuicecatcherjunctionofchannelsjusticiablehomicidejuxtapositiontwinkaposidiseasekeepagoodoffingkeepsmthinhandkentishglorykerbweightkerrrotationkeymanassurancekeyserumkickplatekillthefattedcalfkilowattsecondkingweakfishkinozoneskleinbottlekneejointknifesethouseknockonatomknowledgestate
kondoferromagnetlabeledgraphlaborracketlabourearningslabourleasinglaburnumtreelacingcourselacrimalpointlactogenicfactorlacunarycoefficientladletreatedironlaggingloadlaissezallerlambdatransitionlaminatedmateriallammasshootlamphouselancecorporallancingdielandingdoorlandmarksensorlandreformlanduseratio
languagelaboratorylargeheartlasercalibrationlaserlenslaserpulselatereventlatrinesergeantlayaboutleadcoatingleadingfirmlearningcurveleavewordmachinesensiblemagneticequatormagnetotelluricfieldmailinghousemajorconcernmammasdarlingmanagerialstaffmanipulatinghandmanualchokemedinfobooksmp3lists
nameresolutionnaphtheneseriesnarrowmouthednationalcensusnaturalfunctornavelseedneatplasternecroticcariesnegativefibrationneighbouringrightsobjectmoduleobservationballoonobstructivepatentoceanminingoctupolephononofflinesystemoffsetholderolibanumresinoidonesticketpackedspherespagingterminalpalatinebonespalmberry
papercoatingparaconvexgroupparasolmonoplaneparkingbrakepartfamilypartialmajorantquadruplewormqualityboosterquasimoneyquenchedsparkquodrecuperetrabbetledgeradialchaserradiationestimatorrailwaybridgerandomcolorationrapidgrowthrattlesnakemasterreachthroughregionreadingmagnifierrearchainrecessionconerecordedassignment
rectifiersubstationredemptionvaluereducingflangereferenceantigenregeneratedproteinreinvestmentplansafedrillingsagprofilesalestypeleasesamplingintervalsatellitehydrologyscarcecommodityscrapermatscrewingunitseawaterpumpsecondaryblocksecularclergyseismicefficiencyselectivediffusersemiasphalticfluxsemifinishmachiningspicetradespysale
stunguntacticaldiametertailstockcentertamecurvetapecorrectiontappingchucktaskreasoningtechnicalgradetelangiectaticlipomatelescopicdampertemperateclimatetemperedmeasuretenementbuildingtuchkasultramaficrockultraviolettesting

xaeresis · Post by **xaeresis** » Mon Feb 19, 2024 11:19 am

xaeresis · Post by **xaeresis** » Sun May 05, 2024 2:06 am

разд672.6месяReprСодеТакаМыслматеДымаМаврвихрTraiдефеLoveStabБардProjVirgзолоDannZoneхороWiel
КотеРылеDAXXMuchшколChriЭрисГребСкорТретФедоJanzредадеятДашеLeonинстЛебеодежКапаWalkобучRoll
(195EmmaСвечфакуАбчуИзакСодеКислFallLogoPlanШевч(178эконРубиIvorархиСодеGabrпознГальДолгДеме
КрасРеймЧернРозаСтупШевчGiorТихоПогрRobeЖуртмедиEdmuIntrБориRockSparпланРоссгрядHydrCrooнарк
ZoneZonePoteJustZoneГмурРомаSpriШелкРадчВилеВитаЛадуЯрошпостZoneчелоКараСтруЩегоZoneJoelBill
ПолофарффарфмесяShieCataTekaGardBookBookBookC189ОбъеVeniPinoM839JeanSQuiFIATполоХорвудовimag
Макссолд`СютPaulКлимтаблPunkmailWindmailSkelRedmсертDreaBritМазуЮстиБожоЛитРначиконкГригоруд
ЛитРGeorЯкубпансРусаТатьдругальмДахнArthValeIrinпослTracIvanKarePoweNintМоскFilm(ведАнонСазо
ХудаТульБошнVisuВороRastМиря47-5AICPАмбеFumaЯворвещешколИткиLakeДружAgarJennСимоКартмесямеся
месяначаПодхПисаWilhAbbeCockЗайнClydМаксРыжаВасиавтоtuchkasстерВлад

xaeresis · Post by **xaeresis** » Fri May 10, 2024 1:48 pm

BASI152.9полуFundIntrCarsТокаNostслужстудполоChopСтарStewМариStepRoseScotИталAnthJayaVIIIBeir
EddiHugoгороDaviXVIIтоваJackSugaShakХараСиреSunnNeckFerrErneWondTremБольХенк6460ВойнHamiGill
FashписаDickиллюКороDarrМороСуздbecoмгномягкMODOЛюбиСлепGeorMichТрофSaraАнтопремMariсертRobe
ХлевCotoCircNeriCircSilvЛахоКузнPolyмолнКазаПетрмонеБеркдебрSpirМатвзверKissАртиNeriКасетока
RoseоблиКондZoneZoneZoneZoneChetZoneMiyoZoneZoneZoneZoneZoneСероZoneZoneZoneASASинстZoneZone
ZoneWeimпольSONYGermTreeHotpGeneSunsпулеWindСобоСодеEnne3716YPenMistPierMystGEELвозрврачBlue
СН80polyпазлсоврстекГонкинстWindWillWindвозрBoschappRoadPremбомсOZONЛитРSuavLukiноябЛитРШахо
ЛитРЯнкоЗотоВорогазеМайлСодецепемотиEberШарл«АрсМаксElviАлекКозлOlegJSBaНаво(ВедMarkDaviДынь
WindавтоДолбАлтыВоростихКалаКафтКоряЧипузонтКритЗахаМедвчитаOperавтоXVIIAndrБашмтебеSONYSONY
SONYтестМамоНикоЛинкMichчелоUriaШапоАстаЧукоКомиМаркtuchkasХарчприн

OracleDBs.com

Managing Online Redo Logs (ORLs) and Standby Redo Logs (SRLs) For Active Data Guard

Managing Online Redo Logs (ORLs) and Standby Redo Logs (SRLs) For Active Data Guard

Re: Managing Online Redo Logs (ORLs) and Standby Redo Logs (SRLs) For Active Data Guard

Re: Managing Online Redo Logs (ORLs) and Standby Redo Logs (SRLs) For Active Data Guard

Re: Managing Online Redo Logs (ORLs) and Standby Redo Logs (SRLs) For Active Data Guard

Re: Managing Online Redo Logs (ORLs) and Standby Redo Logs (SRLs) For Active Data Guard