|
RMAN-04014: startup failed: ORA-03113: end-of-file on communication channel
#40043630
Ссылка:
Ссылка на сообщение:
Ссылка с названием темы:
Ссылка на профиль пользователя:
|
|
|
|
recover table 'GGTEST'.'TEST' until time "to_date('02/09/2021 04:51:10','mm/dd/yyyy hh24:mi:ss')" auxiliary destination '/tmp/oracle/recover';
Выдал ошибку
1.
2.
3.
4.
5.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/09/2021 05:00:47
RMAN-04014: startup failed: ORA-03113: end-of-file on communication channel
alert.log
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
170.
171.
172.
173.
174.
175.
176.
177.
178.
179.
180.
181.
182.
183.
184.
185.
186.
187.
188.
189.
190.
191.
192.
193.
194.
195.
196.
197.
198.
199.
200.
201.
202.
203.
204.
205.
206.
207.
208.
209.
210.
211.
212.
213.
214.
215.
216.
217.
218.
219.
220.
221.
222.
223.
224.
225.
226.
227.
228.
229.
230.
231.
232.
233.
234.
235.
236.
237.
238.
239.
240.
241.
242.
243.
244.
245.
246.
247.
248.
249.
250.
251.
252.
253.
254.
255.
256.
257.
258.
259.
260.
261.
262.
263.
264.
265.
266.
267.
268.
269.
270.
271.
272.
273.
274.
275.
276.
277.
278.
279.
280.
281.
282.
283.
284.
285.
286.
287.
288.
289.
290.
291.
292.
293.
294.
295.
296.
297.
298.
299.
300.
301.
302.
303.
304.
305.
306.
307.
308.
309.
310.
311.
312.
313.
314.
315.
316.
317.
318.
319.
320.
321.
322.
323.
324.
325.
326.
327.
328.
329.
330.
331.
332.
333.
334.
335.
336.
337.
338.
339.
340.
341.
342.
343.
344.
345.
346.
347.
348.
349.
350.
351.
352.
353.
354.
355.
356.
357.
358.
359.
360.
361.
362.
363.
364.
365.
366.
367.
368.
369.
370.
371.
372.
373.
374.
375.
376.
377.
378.
379.
380.
381.
382.
383.
384.
385.
386.
387.
388.
389.
390.
391.
392.
393.
394.
395.
396.
397.
398.
399.
400.
401.
402.
403.
404.
405.
406.
407.
408.
409.
410.
411.
412.
413.
414.
415.
416.
417.
418.
419.
420.
421.
422.
423.
424.
425.
426.
427.
428.
429.
430.
431.
432.
433.
434.
435.
436.
437.
438.
439.
440.
441.
442.
443.
444.
445.
446.
447.
448.
449.
450.
451.
452.
453.
454.
455.
456.
457.
458.
459.
460.
461.
462.
463.
464.
465.
466.
467.
468.
469.
470.
471.
472.
473.
474.
475.
476.
477.
478.
479.
480.
481.
482.
483.
484.
485.
486.
487.
488.
489.
490.
491.
492.
493.
494.
495.
496.
497.
498.
499.
500.
501.
502.
503.
504.
505.
506.
507.
508.
509.
510.
511.
512.
513.
514.
515.
516.
517.
518.
519.
520.
521.
522.
523.
524.
525.
526.
527.
528.
529.
530.
531.
532.
533.
534.
535.
536.
537.
538.
539.
540.
541.
542.
543.
544.
545.
546.
547.
548.
549.
550.
551.
552.
553.
554.
555.
556.
557.
558.
559.
560.
561.
562.
563.
564.
565.
566.
567.
568.
569.
570.
571.
572.
573.
574.
575.
576.
577.
578.
579.
580.
581.
582.
583.
584.
585.
586.
587.
588.
589.
590.
591.
592.
593.
594.
595.
596.
597.
598.
599.
600.
601.
602.
603.
604.
605.
606.
607.
608.
609.
610.
611.
612.
613.
614.
615.
616.
617.
618.
619.
620.
621.
622.
623.
624.
625.
626.
627.
628.
629.
630.
631.
632.
633.
634.
635.
636.
637.
638.
639.
640.
641.
642.
643.
644.
645.
646.
647.
648.
649.
650.
651.
652.
653.
654.
655.
656.
657.
658.
659.
660.
661.
662.
663.
664.
665.
666.
667.
668.
669.
670.
671.
672.
673.
674.
675.
676.
677.
678.
679.
680.
681.
682.
683.
684.
685.
686.
687.
688.
689.
690.
691.
692.
693.
694.
695.
696.
697.
698.
699.
700.
701.
702.
703.
704.
705.
706.
707.
708.
709.
710.
711.
712.
713.
714.
715.
716.
717.
718.
719.
720.
721.
722.
723.
724.
725.
726.
727.
728.
729.
730.
731.
732.
733.
734.
735.
736.
737.
738.
739.
740.
741.
742.
743.
744.
745.
746.
747.
748.
749.
750.
751.
752.
753.
754.
755.
756.
757.
758.
759.
760.
761.
762.
763.
764.
765.
766.
767.
768.
769.
770.
771.
772.
773.
774.
775.
776.
777.
778.
779.
780.
781.
782.
783.
784.
785.
786.
787.
788.
789.
790.
791.
792.
793.
794.
795.
796.
797.
798.
799.
800.
801.
802.
803.
804.
805.
806.
807.
808.
809.
810.
811.
812.
813.
814.
815.
816.
817.
818.
819.
820.
821.
822.
823.
824.
825.
826.
827.
828.
829.
830.
831.
832.
833.
834.
835.
836.
837.
838.
839.
840.
841.
842.
843.
844.
845.
846.
847.
848.
849.
850.
851.
852.
853.
854.
855.
856.
857.
858.
859.
860.
861.
862.
863.
864.
865.
866.
867.
868.
869.
870.
871.
872.
873.
874.
875.
876.
877.
878.
879.
880.
881.
882.
883.
884.
885.
886.
887.
888.
889.
890.
891.
892.
893.
894.
895.
896.
897.
898.
899.
900.
901.
902.
903.
904.
905.
906.
907.
908.
909.
910.
911.
912.
913.
914.
915.
916.
917.
918.
919.
920.
921.
922.
923.
924.
925.
926.
927.
928.
929.
930.
931.
932.
933.
934.
935.
936.
937.
938.
939.
940.
941.
942.
943.
944.
945.
946.
947.
948.
949.
950.
951.
952.
<msg time='2021-02-09T05:00:01.955-05:00' org_id='oracle' comp_id='VOS'
msg_id='opistr_real:1285:1197768316' type='NOTIFICATION' group='VOS'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989' version='2' attn_msg_id='35782658'
id_suffix='DB STARTUP/SHUTDOWN' oper_id='startup' flags='15'>
<txt>Starting ORACLE instance (normal) (OS id: 13989)
</txt>
<cause>A command to startup the instance was executed
</cause>
<action>Check alert log for progress and completion of command
</action>
</msg>
<msg time='2021-02-09T05:00:02.295-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>****************************************************
</txt>
</msg>
<msg time='2021-02-09T05:00:02.295-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt> Sys-V shared memory will be used for creating SGA
</txt>
</msg>
<msg time='2021-02-09T05:00:02.295-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt> ****************************************************
</txt>
</msg>
<msg time='2021-02-09T05:00:02.295-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>**********************************************************************
</txt>
</msg>
<msg time='2021-02-09T05:00:02.295-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>Dump of system resources acquired for SHARED GLOBAL AREA (SGA)
</txt>
</msg>
<msg time='2021-02-09T05:00:02.295-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt> Per process system memlock (soft) limit = 128G
</txt>
</msg>
<msg time='2021-02-09T05:00:02.295-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt> Expected per process system memlock (soft) limit to lock
</txt>
</msg>
<msg time='2021-02-09T05:00:02.296-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt> instance MAX SHARED GLOBAL AREA (SGA) into memory: 2274M
</txt>
</msg>
<msg time='2021-02-09T05:00:02.296-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt> Available system pagesizes:
</txt>
</msg>
<msg time='2021-02-09T05:00:02.296-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt> 4K, 2048K
</txt>
</msg>
<msg time='2021-02-09T05:00:02.296-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt> Supported system pagesize(s):
</txt>
</msg>
<msg time='2021-02-09T05:00:02.296-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt> PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s)
</txt>
</msg>
<msg time='2021-02-09T05:00:02.296-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt> 4K Configured 4 581636 NONE
</txt>
</msg>
<msg time='2021-02-09T05:00:02.296-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt> 2048K 0 1137 0 NONE
</txt>
</msg>
<msg time='2021-02-09T05:00:02.296-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>RECOMMENDATION:
</txt>
</msg>
<msg time='2021-02-09T05:00:02.296-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt> 1. For optimal performance, configure system with expected number
</txt>
</msg>
<msg time='2021-02-09T05:00:02.296-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt> of pages for every supported system pagesize prior to the next
</txt>
</msg>
<msg time='2021-02-09T05:00:02.296-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt> instance restart operation.
</txt>
</msg>
<msg time='2021-02-09T05:00:02.301-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>**********************************************************************
</txt>
</msg>
<msg time='2021-02-09T05:00:05.416-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksunfy:22948:2937430291' type='NOTIFICATION' group='startup'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>LICENSE_MAX_SESSION = 0
</txt>
</msg>
<msg time='2021-02-09T05:00:05.417-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksunfy:22949:4207019197' type='NOTIFICATION' group='startup'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>LICENSE_SESSIONS_WARNING = 0
</txt>
</msg>
<msg time='2021-02-09T05:00:05.441-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>Initial number of CPU is 2
</txt>
</msg>
<msg time='2021-02-09T05:00:05.441-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>Number of processor cores in the system is 2
</txt>
</msg>
<msg time='2021-02-09T05:00:05.441-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>Number of processor sockets in the system is 1
</txt>
</msg>
<msg time='2021-02-09T05:00:05.447-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>KSXRTEST ISGA: RM Channel count = 1
</txt>
</msg>
<msg time='2021-02-09T05:00:05.447-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>KSXRTEST ISGA: rcnt= 70 rmrcnt = 1
</txt>
</msg>
<msg time='2021-02-09T05:00:05.454-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>Shared memory segment for instance monitoring created
</txt>
</msg>
<msg time='2021-02-09T05:00:05.464-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>Capability Type : Network
</txt>
</msg>
<msg time='2021-02-09T05:00:05.464-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>capabilities requested : 7 detected : 0 Simulated : 0
</txt>
</msg>
<msg time='2021-02-09T05:00:05.464-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>Capability Type : Runtime Environment
</txt>
</msg>
<msg time='2021-02-09T05:00:05.464-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>capabilities requested : 400000FF detected : 40000000 Simulated : 0
</txt>
</msg>
<msg time='2021-02-09T05:00:05.464-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>Capability Type : Engineered Systems
</txt>
</msg>
<msg time='2021-02-09T05:00:05.464-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>capabilities requested : 7 detected : 0 Simulated : 0
</txt>
</msg>
<msg time='2021-02-09T05:00:05.464-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>Capability Type : Database Test
</txt>
</msg>
<msg time='2021-02-09T05:00:05.464-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>capabilities requested : 3 detected : 0 Simulated : 0
</txt>
</msg>
<msg time='2021-02-09T05:00:05.534-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>kjidomenacan initialized to 0
</txt>
</msg>
<msg time='2021-02-09T05:00:05.547-05:00' org_id='oracle' comp_id='rdbms'
msg_id='krsd_init_sdips:3004:3669501345' type='NOTIFICATION' group='startup'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>Using LOG_ARCHIVE_DEST_1 parameter default value as /home/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch
</txt>
</msg>
<msg time='2021-02-09T05:00:05.566-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ktunfy:4088:3053135360' type='NOTIFICATION' group='startup'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>Autotune of undo retention is turned on.
</txt>
</msg>
<msg time='2021-02-09T05:00:05.567-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ktinfy:1698:1526000287' type='NOTIFICATION' group='startup'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>IMODE=BR
</txt>
</msg>
<msg time='2021-02-09T05:00:05.567-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ktinfy:1706:3929296192' type='NOTIFICATION' group='startup'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>ILAT =35
</txt>
</msg>
<msg time='2021-02-09T05:00:05.597-05:00' org_id='oracle' comp_id='rdbms'
msg_id='kzunfy:7802:2892522327' type='NOTIFICATION' group='startup'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>LICENSE_MAX_USERS = 0
</txt>
</msg>
<msg time='2021-02-09T05:00:05.597-05:00' org_id='oracle' comp_id='rdbms'
msg_id='kzanfy:1715:2350609795' type='NOTIFICATION' group='startup'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>SYS auditing is enabled
</txt>
</msg>
<msg time='2021-02-09T05:00:05.709-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>NOTE: remote asm mode is remote (mode 0x2; from cluster type)
</txt>
</msg>
<msg time='2021-02-09T05:00:06.380-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>NOTE: remote asm mode is remote (mode 0x2; from cluster type)
</txt>
</msg>
<msg time='2021-02-09T05:00:06.380-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>NOTE: Cluster configuration type = CLUSTER [4]
</txt>
</msg>
<msg time='2021-02-09T05:00:06.393-05:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:24003:3284844642' type='NOTIFICATION' group='startup'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0.
</txt>
</msg>
<msg time='2021-02-09T05:00:06.393-05:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:24016:4222364190' type='NOTIFICATION' group='startup'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>ORACLE_HOME: /home/u01/app/oracle/product/19.3.0/dbhome_1
</txt>
</msg>
<msg time='2021-02-09T05:00:06.393-05:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:24016:4222364190' type='NOTIFICATION' group='startup'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>System name: Linux
</txt>
</msg>
<msg time='2021-02-09T05:00:06.393-05:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:24016:4222364190' type='NOTIFICATION' group='startup'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>Node name: node2.localdomain
</txt>
</msg>
<msg time='2021-02-09T05:00:06.393-05:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:24016:4222364190' type='NOTIFICATION' group='startup'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>Release: 4.1.12-124.45.2.el7uek.x86_64
</txt>
</msg>
<msg time='2021-02-09T05:00:06.393-05:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:24016:4222364190' type='NOTIFICATION' group='startup'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>Version: #2 SMP Tue Nov 10 14:18:36 PST 2020
</txt>
</msg>
<msg time='2021-02-09T05:00:06.393-05:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:24016:4222364190' type='NOTIFICATION' group='startup'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>Machine: x86_64
</txt>
</msg>
<msg time='2021-02-09T05:00:06.393-05:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:24054:1323239670' type='NOTIFICATION' group='startup'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>Using parameter settings in client-side pfile /tmp/ora_tfilzgrnWy on machine node2.localdomain
</txt>
</msg>
<msg time='2021-02-09T05:00:06.393-05:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:24127:144004252' type='NOTIFICATION' group='startup'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>System parameters with non-default values:
</txt>
</msg>
<msg time='2021-02-09T05:00:06.393-05:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:24169:527288951' type='NOTIFICATION' group='startup'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt> processes = 200
</txt>
</msg>
<msg time='2021-02-09T05:00:06.393-05:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:24169:527288951' type='NOTIFICATION' group='startup'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt> sga_target = 2272M
</txt>
</msg>
<msg time='2021-02-09T05:00:06.393-05:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:24169:527288951' type='NOTIFICATION' group='startup'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt> db_block_size = 8192
</txt>
</msg>
<msg time='2021-02-09T05:00:06.393-05:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:24157:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt> compatible = "19.0.0"
</txt>
</msg>
<msg time='2021-02-09T05:00:06.393-05:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:24169:527288951' type='NOTIFICATION' group='startup'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt> db_files = 200
</txt>
</msg>
<msg time='2021-02-09T05:00:06.393-05:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:24169:527288951' type='NOTIFICATION' group='startup'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt> _system_trig_enabled = FALSE
</txt>
</msg>
<msg time='2021-02-09T05:00:06.393-05:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:24157:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt> db_name = "TESTDB"
</txt>
</msg>
<msg time='2021-02-09T05:00:06.393-05:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:24157:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt> db_unique_name = "yrvp_pitr_TESTDB"
</txt>
</msg>
<msg time='2021-02-09T05:00:06.393-05:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:24157:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt> diagnostic_dest = "/home/u01/app/oracle"
</txt>
</msg>
<msg time='2021-02-09T05:00:06.500-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>Cluster Communication is configured to use IPs from: GPnP
</txt>
</msg>
<msg time='2021-02-09T05:00:06.501-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>IP: 169.254.4.205 Subnet: 169.254.0.0
</txt>
</msg>
<msg time='2021-02-09T05:00:06.501-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>KSIPC Loopback IP addresses(OSD):
</txt>
</msg>
<msg time='2021-02-09T05:00:06.501-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>127.0.0.1
</txt>
</msg>
<msg time='2021-02-09T05:00:06.503-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>KSIPC Available Transports: UDP:TCP:RDSTCP
</txt>
</msg>
<msg time='2021-02-09T05:00:06.503-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>KSIPC: Client: KCL Transport: UDP
</txt>
</msg>
<msg time='2021-02-09T05:00:06.503-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>KSIPC: Client: DLM Transport: UDP
</txt>
</msg>
<msg time='2021-02-09T05:00:06.503-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>KSIPC CAPABILITIES :MGA:IPCLW:GRPAM:TOPO:DLL:STATSFW:CRTRK
</txt>
</msg>
<msg time='2021-02-09T05:00:06.616-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>KSXP: ksxpsg_ipclwtrans: 2 UDP
</txt>
</msg>
<msg time='2021-02-09T05:00:06.617-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>cluster interconnect IPC version: [IPCLW over UDP(mode 3) ]
</txt>
</msg>
<msg time='2021-02-09T05:00:06.617-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>IPC Vendor 1 proto 2
</txt>
</msg>
<msg time='2021-02-09T05:00:06.617-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>Oracle instance running with ODM: Oracle Direct NFS ODM Library Version 6.0
</txt>
</msg>
<msg time='2021-02-09T05:00:06.625-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>============================================================
</txt>
</msg>
<msg time='2021-02-09T05:00:06.625-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>NOTE: PatchLevel of this instance 0
</txt>
</msg>
<msg time='2021-02-09T05:00:06.625-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='13989'>
<txt>============================================================
</txt>
</msg>
<msg time='2021-02-09T05:00:07.761-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbs1p_int:6681:1349786505' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>Starting background process PMON
</txt>
</msg>
<msg time='2021-02-09T05:00:07.770-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:9853:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='14026'>
<txt>PMON started with pid=2, OS id=14026
</txt>
</msg>
<msg time='2021-02-09T05:00:07.771-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbs1p_int:6681:1349786505' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>Starting background process CLMN
</txt>
</msg>
<msg time='2021-02-09T05:00:07.783-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:9853:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='14028'>
<txt>CLMN started with pid=3, OS id=14028
</txt>
</msg>
<msg time='2021-02-09T05:00:07.784-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbs1p_int:6681:1349786505' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>Starting background process PSP0
</txt>
</msg>
<msg time='2021-02-09T05:00:07.795-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:9853:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='14030'>
<txt>PSP0 started with pid=4, OS id=14030
</txt>
</msg>
<msg time='2021-02-09T05:00:07.795-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbs1p_int:6681:1349786505' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>Starting background process IPC0
</txt>
</msg>
<msg time='2021-02-09T05:00:08.828-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:9853:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='14101'>
<txt>IPC0 started with pid=5, OS id=14101
</txt>
</msg>
<msg time='2021-02-09T05:00:08.829-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbs1p_int:6681:1349786505' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>Starting background process VKTM
</txt>
</msg>
<msg time='2021-02-09T05:00:08.874-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:9853:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='14103'>
<txt>VKTM started with pid=6, OS id=14103 at elevated (RT) priority
</txt>
</msg>
<msg time='2021-02-09T05:00:08.875-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='14103'>
<txt>VKTM running at (1)millisec precision with DBRM quantum (100)ms
</txt>
</msg>
<msg time='2021-02-09T05:00:08.876-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbs1p_int:6681:1349786505' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>Starting background process GEN0
</txt>
</msg>
<msg time='2021-02-09T05:00:08.886-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:9853:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='14107'>
<txt>GEN0 started with pid=7, OS id=14107
</txt>
</msg>
<msg time='2021-02-09T05:00:08.899-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbs1p_int:6681:1349786505' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>Starting background process MMAN
</txt>
</msg>
<msg time='2021-02-09T05:00:08.935-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:9853:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='14112'>
<txt>MMAN started with pid=9, OS id=14112
</txt>
</msg>
<msg time='2021-02-09T05:00:08.935-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbs1p_int:6681:1349786505' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>Starting background process GEN1
</txt>
</msg>
<msg time='2021-02-09T05:00:08.964-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbs1p_int:6681:1349786505' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>Starting background process DIAG
</txt>
</msg>
<msg time='2021-02-09T05:00:08.965-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:9853:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='14114_14115' tid='14115'>
<txt>GEN1 started with pid=10, OS id=14114_14115
</txt>
</msg>
<msg time='2021-02-09T05:00:08.987-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:9853:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='14125'>
<txt>DIAG started with pid=12, OS id=14125
</txt>
</msg>
<msg time='2021-02-09T05:00:08.988-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbs1p_int:6681:1349786505' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>Starting background process OFSD
</txt>
</msg>
<msg time='2021-02-09T05:00:09.016-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:9853:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='14130_14132' tid='14132'>
<txt>OFSD started with pid=13, OS id=14130_14132
</txt>
</msg>
<msg time='2021-02-09T05:00:09.016-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbs1p_int:6681:1349786505' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>Starting background process DBRM
</txt>
</msg>
<msg time='2021-02-09T05:00:09.018-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='14130_14132' tid='14132'>
<txt>Oracle running with ofslib:'Oracle File Server Library' version=2
</txt>
</msg>
<msg time='2021-02-09T05:00:09.038-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:9853:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='14138'>
<txt>DBRM started with pid=15, OS id=14138
</txt>
</msg>
<msg time='2021-02-09T05:00:09.038-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbs1p_int:6681:1349786505' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>Starting background process VKRM
</txt>
</msg>
<msg time='2021-02-09T05:00:09.051-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:9853:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='14140'>
<txt>VKRM started with pid=16, OS id=14140
</txt>
</msg>
<msg time='2021-02-09T05:00:09.052-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbs1p_int:6681:1349786505' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>Starting background process PING
</txt>
</msg>
<msg time='2021-02-09T05:00:09.127-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:9853:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='14144'>
<txt>PING started with pid=17, OS id=14144
</txt>
</msg>
<msg time='2021-02-09T05:00:09.128-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbs1p_int:6681:1349786505' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>Starting background process SVCB
</txt>
</msg>
<msg time='2021-02-09T05:00:09.160-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:9853:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='14148'>
<txt>SVCB started with pid=18, OS id=14148
</txt>
</msg>
<msg time='2021-02-09T05:00:09.182-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbs1p_int:6681:1349786505' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>Starting background process ACMS
</txt>
</msg>
<msg time='2021-02-09T05:00:09.301-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:9853:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='14150'>
<txt>ACMS started with pid=19, OS id=14150
</txt>
</msg>
<msg time='2021-02-09T05:00:09.302-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbs1p_int:6681:1349786505' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>Starting background process PMAN
</txt>
</msg>
<msg time='2021-02-09T05:00:09.396-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:9853:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='14152'>
<txt>PMAN started with pid=20, OS id=14152
</txt>
</msg>
<msg time='2021-02-09T05:00:09.397-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbs1p_int:6681:1349786505' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>Starting background process DIA0
</txt>
</msg>
<msg time='2021-02-09T05:00:09.444-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:9853:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='14154'>
<txt>DIA0 started with pid=21, OS id=14154
</txt>
</msg>
<msg time='2021-02-09T05:00:09.444-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbs1p_int:6681:1349786505' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>Starting background process LMON
</txt>
</msg>
<msg time='2021-02-09T05:00:09.472-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbs1p_int:6681:1349786505' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>Starting background process LMD0
</txt>
</msg>
<msg time='2021-02-09T05:00:09.473-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:9853:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='14156'>
<txt>LMON started with pid=22, OS id=14156
</txt>
</msg>
<msg time='2021-02-09T05:00:09.597-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:9853:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='14158'>
<txt>LMD0 started with pid=23, OS id=14158
</txt>
</msg>
<msg time='2021-02-09T05:00:09.598-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbs1p_int:6681:1349786505' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>Starting background process RMS0
</txt>
</msg>
<msg time='2021-02-09T05:00:09.607-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='14158'>
<txt>* Load Monitor used for high load check
</txt>
</msg>
<msg time='2021-02-09T05:00:09.607-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='14158'>
<txt>* New Low - High Load Threshold Range = [1920 - 2560]
</txt>
</msg>
<msg time='2021-02-09T05:00:09.619-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:9853:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='14160'>
<txt>RMS0 started with pid=24, OS id=14160
</txt>
</msg>
<msg time='2021-02-09T05:00:09.620-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbs1p_int:6681:1349786505' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>Starting background process LMHB
</txt>
</msg>
<msg time='2021-02-09T05:00:09.630-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:9853:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='14162'>
<txt>LMHB started with pid=25, OS id=14162
</txt>
</msg>
<msg time='2021-02-09T05:00:09.631-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbs1p_int:6681:1349786505' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>Starting background process DBW0
</txt>
</msg>
<msg time='2021-02-09T05:00:09.811-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:9853:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='14164'>
<txt>DBW0 started with pid=26, OS id=14164
</txt>
</msg>
<msg time='2021-02-09T05:00:09.812-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbs1p_int:6681:1349786505' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>Starting background process LGWR
</txt>
</msg>
<msg time='2021-02-09T05:00:10.349-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:9853:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='14168'>
<txt>LGWR started with pid=27, OS id=14168
</txt>
</msg>
<msg time='2021-02-09T05:00:10.350-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbs1p_int:6681:1349786505' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='13989'>
<txt>Starting background process CKPT
</txt>
</msg>
<msg time='2021-02-09T05:00:10.663-05:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:9853:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='14179'>
<txt>CKPT started with pid=28, OS id=14179
</txt>
</msg>
<msg time='2021-02-09T05:00:46.350-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='14103'>
<txt>Warning: VKTM detected a time stall.
</txt>
</msg>
<msg time='2021-02-09T05:00:46.397-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='14103'>
<txt>Time drifts can result in unexpected behavior such as time-outs.
</txt>
</msg>
<msg time='2021-02-09T05:00:46.397-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='14103'>
<txt>Please see the VKTM trace file for more details:
</txt>
</msg>
<msg time='2021-02-09T05:00:46.397-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='14103'>
<txt>/home/u01/app/oracle/diag/rdbms/yrvp_pitr_testdb/yrvp/trace/yrvp_vktm_14103.trc
</txt>
</msg>
<msg time='2021-02-09T05:00:46.483-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='14138'>
<txt>Using default pga_aggregate_limit of 2048 MB
</txt>
</msg>
<msg time='2021-02-09T05:00:47.035-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='14168'>
<txt>LGWR slave LG00 created with pid=29, OS pid=14192
</txt>
</msg>
<msg time='2021-02-09T05:00:48.155-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='14125'>
<txt>System state dump requested by (instance=1, osid=14026 (PMON)), summary=[abnormal instance termination]. error - 'Instance is terminating.
</txt>
</msg>
<msg time='2021-02-09T05:00:48.155-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='14125'>
<txt>'
</txt>
</msg>
<msg time='2021-02-09T05:00:48.155-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='14125'>
<txt>System State dumped to trace file /home/u01/app/oracle/diag/rdbms/yrvp_pitr_testdb/yrvp/trace/yrvp_diag_14125.trc
</txt>
</msg>
<msg time='2021-02-09T05:00:48.199-05:00' org_id='oracle' comp_id='VOS'
msg_id='ksuitm_opt:1031:1983329783' type='ERROR' group='VOS'
level='2' host_id='node2.localdomain' host_addr='192.168.100.61'
pid='14026' attn_msg_id='35782660' id_suffix='DB Termination'
ora_id='2' db_id='yrvp_pitr_TESTDB' sess_id='1.62267'
callstack='dbklaWriteAttentionLogTextVaList()+556<-dbklaWriteAttentionLogText()+173<-ksuitm_opt()+2006<-ksucln_check_fatal_death()+790<-ksulhdcb()+531<-ksucln_coord_main()+1161<-ksbrdp()+1123<-opirip()+541<-opidrv()+581<-sou2o()+165<-opimai_real()+173<-ssthrdmain()+417<-main()+256<-__libc_start_main()+245' flags='15'>
<txt>PMON (ospid: ): terminating the instance due to ORA error
</txt>
<cause>The instance termination routine was called
</cause>
<action>Check alert log for more information relating to instance termination rectify the error and restart the instance
</action>
</msg>
<msg time='2021-02-09T05:00:48.207-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='14026'>
<txt>Cause - 'Instance is being terminated due to fatal process death (pid: 8, ospid: 14110, SA00)'
</txt>
</msg>
<msg time='2021-02-09T05:00:48.319-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='14125'>
<txt>Dumping diagnostic data in directory=[cdmp_20210209050048], requested by (instance=1, osid=14026 (PMON)), summary=[abnormal instance termination].
</txt>
</msg>
<msg time='2021-02-09T05:00:49.536-05:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='node2.localdomain'
host_addr='192.168.100.61' pid='14026'>
<txt>Instance terminated by PMON, pid = 14026
</txt>
</msg>
alert_yrvp.log
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
170.
171.
172.
173.
174.
175.
176.
177.
178.
179.
180.
181.
182.
183.
184.
185.
186.
187.
188.
189.
190.
191.
192.
193.
194.
195.
196.
197.
198.
199.
200.
201.
2021-02-09T05:00:01.955742-05:00
Starting ORACLE instance (normal) (OS id: 13989)
2021-02-09T05:00:02.295060-05:00
****************************************************
Sys-V shared memory will be used for creating SGA
****************************************************
2021-02-09T05:00:02.295871-05:00
**********************************************************************
2021-02-09T05:00:02.295908-05:00
Dump of system resources acquired for SHARED GLOBAL AREA (SGA)
2021-02-09T05:00:02.295978-05:00
Per process system memlock (soft) limit = 128G
2021-02-09T05:00:02.296013-05:00
Expected per process system memlock (soft) limit to lock
instance MAX SHARED GLOBAL AREA (SGA) into memory: 2274M
2021-02-09T05:00:02.296078-05:00
Available system pagesizes:
4K, 2048K
2021-02-09T05:00:02.296182-05:00
Supported system pagesize(s):
2021-02-09T05:00:02.296215-05:00
PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s)
2021-02-09T05:00:02.296250-05:00
4K Configured 4 581636 NONE
2021-02-09T05:00:02.296329-05:00
2048K 0 1137 0 NONE
2021-02-09T05:00:02.296369-05:00
RECOMMENDATION:
2021-02-09T05:00:02.296403-05:00
1. For optimal performance, configure system with expected number
of pages for every supported system pagesize prior to the next
instance restart operation.
2021-02-09T05:00:02.301692-05:00
**********************************************************************
2021-02-09T05:00:05.417001-05:00
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
2021-02-09T05:00:05.441863-05:00
Initial number of CPU is 2
Number of processor cores in the system is 2
Number of processor sockets in the system is 1
KSXRTEST ISGA: RM Channel count = 1
KSXRTEST ISGA: rcnt= 70 rmrcnt = 1
Shared memory segment for instance monitoring created
Capability Type : Network
capabilities requested : 7 detected : 0 Simulated : 0
Capability Type : Runtime Environment
capabilities requested : 400000FF detected : 40000000 Simulated : 0
Capability Type : Engineered Systems
capabilities requested : 7 detected : 0 Simulated : 0
Capability Type : Database Test
capabilities requested : 3 detected : 0 Simulated : 0
kjidomenacan initialized to 0
Using LOG_ARCHIVE_DEST_1 parameter default value as /home/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch
Autotune of undo retention is turned on.
IMODE=BR
ILAT =35
LICENSE_MAX_USERS = 0
SYS auditing is enabled
NOTE: remote asm mode is remote (mode 0x2; from cluster type)
NOTE: remote asm mode is remote (mode 0x2; from cluster type)
NOTE: Cluster configuration type = CLUSTER [4]
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0.
ORACLE_HOME: /home/u01/app/oracle/product/19.3.0/dbhome_1
System name: Linux
Node name: node2.localdomain
Release: 4.1.12-124.45.2.el7uek.x86_64
Version: #2 SMP Tue Nov 10 14:18:36 PST 2020
Machine: x86_64
Using parameter settings in client-side pfile /tmp/ora_tfilzgrnWy on machine node2.localdomain
System parameters with non-default values:
processes = 200
sga_target = 2272M
db_block_size = 8192
compatible = "19.0.0"
db_files = 200
_system_trig_enabled = FALSE
db_name = "TESTDB"
db_unique_name = "yrvp_pitr_TESTDB"
diagnostic_dest = "/home/u01/app/oracle"
2021-02-09T05:00:06.500997-05:00
Cluster Communication is configured to use IPs from: GPnP
IP: 169.254.4.205 Subnet: 169.254.0.0
KSIPC Loopback IP addresses(OSD):
127.0.0.1
KSIPC Available Transports: UDP:TCP:RDSTCP
KSIPC: Client: KCL Transport: UDP
KSIPC: Client: DLM Transport: UDP
KSIPC CAPABILITIES :MGA:IPCLW:GRPAM:TOPO:DLL:STATSFW:CRTRK
KSXP: ksxpsg_ipclwtrans: 2 UDP
cluster interconnect IPC version: [IPCLW over UDP(mode 3) ]
IPC Vendor 1 proto 2
Oracle instance running with ODM: Oracle Direct NFS ODM Library Version 6.0
============================================================
NOTE: PatchLevel of this instance 0
============================================================
2021-02-09T05:00:07.761447-05:00
Starting background process PMON
2021-02-09T05:00:07.770636-05:00
PMON started with pid=2, OS id=14026
Starting background process CLMN
2021-02-09T05:00:07.783713-05:00
CLMN started with pid=3, OS id=14028
Starting background process PSP0
2021-02-09T05:00:07.795627-05:00
PSP0 started with pid=4, OS id=14030
Starting background process IPC0
2021-02-09T05:00:08.828308-05:00
IPC0 started with pid=5, OS id=14101
2021-02-09T05:00:08.829047-05:00
Starting background process VKTM
2021-02-09T05:00:08.874849-05:00
VKTM started with pid=6, OS id=14103 at elevated (RT) priority
2021-02-09T05:00:08.875960-05:00
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Starting background process GEN0
2021-02-09T05:00:08.886256-05:00
GEN0 started with pid=7, OS id=14107
Starting background process MMAN
2021-02-09T05:00:08.935154-05:00
MMAN started with pid=9, OS id=14112
Starting background process GEN1
Starting background process DIAG
2021-02-09T05:00:08.965460-05:00
GEN1 started with pid=10, OS id=14114_14115
2021-02-09T05:00:08.987536-05:00
DIAG started with pid=12, OS id=14125
Starting background process OFSD
2021-02-09T05:00:09.016599-05:00
OFSD started with pid=13, OS id=14130_14132
Starting background process DBRM
2021-02-09T05:00:09.018242-05:00
Oracle running with ofslib:'Oracle File Server Library' version=2
Starting background process VKRM
2021-02-09T05:00:09.038884-05:00
DBRM started with pid=15, OS id=14138
2021-02-09T05:00:09.051410-05:00
VKRM started with pid=16, OS id=14140
Starting background process PING
2021-02-09T05:00:09.127400-05:00
PING started with pid=17, OS id=14144
Starting background process SVCB
2021-02-09T05:00:09.160781-05:00
SVCB started with pid=18, OS id=14148
Starting background process ACMS
2021-02-09T05:00:09.301889-05:00
ACMS started with pid=19, OS id=14150
Starting background process PMAN
2021-02-09T05:00:09.396272-05:00
PMAN started with pid=20, OS id=14152
Starting background process DIA0
Starting background process LMON
2021-02-09T05:00:09.444806-05:00
DIA0 started with pid=21, OS id=14154
Starting background process LMD0
2021-02-09T05:00:09.473723-05:00
LMON started with pid=22, OS id=14156
2021-02-09T05:00:09.597783-05:00
LMD0 started with pid=23, OS id=14158
Starting background process RMS0
2021-02-09T05:00:09.607090-05:00
* Load Monitor used for high load check
* New Low - High Load Threshold Range = [1920 - 2560]
2021-02-09T05:00:09.619657-05:00
RMS0 started with pid=24, OS id=14160
Starting background process LMHB
2021-02-09T05:00:09.630299-05:00
LMHB started with pid=25, OS id=14162
Starting background process DBW0
2021-02-09T05:00:09.811195-05:00
DBW0 started with pid=26, OS id=14164
Starting background process LGWR
2021-02-09T05:00:10.349606-05:00
LGWR started with pid=27, OS id=14168
2021-02-09T05:00:10.350304-05:00
Starting background process CKPT
2021-02-09T05:00:10.664002-05:00
CKPT started with pid=28, OS id=14179
2021-02-09T05:00:46.383531-05:00
Warning: VKTM detected a time stall.
Time drifts can result in unexpected behavior such as time-outs.
Please see the VKTM trace file for more details:
/home/u01/app/oracle/diag/rdbms/yrvp_pitr_testdb/yrvp/trace/yrvp_vktm_14103.trc
2021-02-09T05:00:46.483242-05:00
Using default pga_aggregate_limit of 2048 MB
2021-02-09T05:00:47.035493-05:00
LGWR slave LG00 created with pid=29, OS pid=14192
2021-02-09T05:00:48.155489-05:00
System state dump requested by (instance=1, osid=14026 (PMON)), summary=[abnormal instance termination]. error - 'Instance is terminating.
'
System State dumped to trace file /home/u01/app/oracle/diag/rdbms/yrvp_pitr_testdb/yrvp/trace/yrvp_diag_14125.trc
2021-02-09T05:00:48.199213-05:00
PMON (ospid: ): terminating the instance due to ORA error
2021-02-09T05:00:48.207168-05:00
Cause - 'Instance is being terminated due to fatal process death (pid: 8, ospid: 14110, SA00)'
2021-02-09T05:00:48.319570-05:00
Dumping diagnostic data in directory=[cdmp_20210209050048], requested by (instance=1, osid=14026 (PMON)), summary=[abnormal instance termination].
2021-02-09T05:00:49.536386-05:00
Instance terminated by PMON, pid = 14026
|
|
|
