一、概述
由dg备库备份的数据库因为恢复过程中未处理控制文件，恢复后依然为standby库，现在需要修改为读写状态.alter database open read write时报错
ora-00313
ora-00312
ora-17503
ora-15001
ora-15018
提示redo路径不存在
二、查看控制文件
sql> alter database backup controlfile to trace as '/tmp/ctl';
database altered.
sql> exit
disconnected from oracle database 19c enterprise edition release 19.0.0.0.0 - production
version 19.9.0.0.0
oracle@pod5-b1-test:/home/oracle$ vi /tmp/ctl
-- the following are current system-scope redo log archival related
-- parameters and can be included in the database initialization file.
--
-- log_archive_dest=''
-- log_archive_duplex_dest=''
--
-- log_archive_format=%t_%s_%r.dbf
--
-- db_unique_name="tbcs5"
--
-- log_archive_config='send, receive, nodg_config'
-- log_archive_max_processes=4
-- standby_file_management=manual
-- fal_client=''
-- fal_server=''
--
-- log_archive_dest_1='location= logcustdg/archbackupdir'
-- log_archive_dest_1='optional reopen=300 nodelay'
-- log_archive_dest_1='arch noaffirm noverify sync'
-- log_archive_dest_1='register'
-- log_archive_dest_1='noalternate'
-- log_archive_dest_1='nodependency'
-- log_archive_dest_1='nomax_failure noquota_size noquota_used nodb_unique_name'
-- log_archive_dest_1='valid_for=(primary_role,online_logfiles)'
-- log_archive_dest_state_1=enable
--
-- below are two sets of sql statements, each of which creates a new
-- control file and uses it to open the database. the first set opens
-- the database with the noresetlogs option and should be used only if
-- the current versions of all online logs are available. the second
-- set opens the database with the resetlogs option and should be used
-- if online logs are unavailable.
-- the appropriate set of statements can be copied from the trace into
-- a script file, edited as necessary, and executed when there is a
-- need to re-create the control file.
--
-- set #1. noresetlogs case
--
-- the following commands will create a new control file and use it
-- to open the database.
-- data used by recovery manager will be lost.
-- additional logs may be required for media recovery of offline
-- use this only if the current versions of all online logs are
-- available.
-- warning! the current control file needs to be checked against
-- the datafiles to insure it contains the correct files. the
-- commands printed here may be missing log and/or data files.
-- another report should be made after the database has been
-- successfully opened.
-- after mounting the created controlfile, the following sql
-- statement will place the database in the appropriate
-- protection mode:
-- alter database set standby database to maximize availability
startup nomount
create controlfile reuse database "tbcs" noresetlogs force logging archivelog
maxlogfiles 192
maxlogmembers 3
maxdatafiles 1024
maxinstances 32
maxloghistory 18688
logfile
group 1 (
' bakcustdg/fullbackupdir/redo03.log',
' bakcustdg/fullbackupdir/redo04.log'
) size 2048m blocksize 512,
group 2 (
' bakcustdg/fullbackupdir/redo01.log',
' bakcustdg/fullbackupdir/redo02.log'
) size 2048m blocksize 512,
group 3 (
' bakcustdg/fullbackupdir/redo05.log',
' bakcustdg/fullbackupdir/redo06.log'
) size 2048m blocksize 512,
group 4 (
' bakcustdg/fullbackupdir/redo07.log',
' bakcustdg/fullbackupdir/redo08.log'
) size 2048m blocksize 512,
group 5 (
' bakcustdg/fullbackupdir/redo09.log',
' bakcustdg/fullbackupdir/redo10.log'
) size 2048m blocksize 512,
group 6 (
' bakcustdg/fullbackupdir/redo11.log',
' bakcustdg/fullbackupdir/redo12.log'
) size 2048m blocksize 512,
group 7 (
' bakcustdg/fullbackupdir/redo13.log',
' bakcustdg/fullbackupdir/redo14.log'
) size 2048m blocksize 512,
group 8 (
' bakcustdg/fullbackupdir/redo15.log',
' bakcustdg/fullbackupdir/redo16.log'
) size 2048m blocksize 512,
group 9 (
' bakcustdg/fullbackupdir/redo17.log',
' bakcustdg/fullbackupdir/redo18.log'
) size 2048m blocksize 512,
group 10 (
' bakcustdg/fullbackupdir/redo19.log',
' bakcustdg/fullbackupdir/redo20.log'
) size 2048m blocksize 512,
group 11 (
' bakcustdg/fullbackupdir/redo21.log',
' bakcustdg/fullbackupdir/redo22.log'
) size 2048m blocksize 512,
group 12 (
' bakcustdg/fullbackupdir/redo23.log',
' bakcustdg/fullbackupdir/redo24.log'
) size 2048m blocksize 512
-- standby logfile
-- group 13 ' datadg/tbcs/onlinelog/group_13.1165.1084529243' size 2048m blocksize 512,
-- group 14 ' datadg/tbcs/onlinelog/group_14.1164.1084529249' size 2048m blocksize 512,
-- group 15 ' datadg/tbcs/onlinelog/group_15.1163.1084529255' size 2048m blocksize 512,
-- group 16 ' datadg/tbcs/onlinelog/group_16.1162.1084529261' size 2048m blocksize 512,
-- group 17 ' datadg/tbcs/onlinelog/group_17.1161.1084529265' size 2048m blocksize 512,
-- group 18 ' datadg/tbcs/onlinelog/group_18.1160.1084529269' size 2048m blocksize 512,
-- group 19 ' datadg/tbcs/onlinelog/group_19.1159.1084529275' size 2048m blocksize 512,
-- group 20 ' datadg/tbcs/onlinelog/group_20.1158.1084529279' size 2048m blocksize 512,
-- group 21 ' datadg/tbcs/onlinelog/group_21.1157.1084529283' size 2048m blocksize 512,
-- group 22 ' datadg/tbcs/onlinelog/group_22.1156.1084529289' size 2048m blocksize 512,
-- group 23 ' datadg/tbcs/onlinelog/group_23.1155.1084529293' size 2048m blocksize 512,
-- group 24 ' datadg/tbcs/onlinelog/group_24.1154.1084529297' size 2048m blocksize 512,
-- group 25 ' datadg/tbcs/onlinelog/group_25.1153.1084529303' size 2048m blocksize 512,
-- group 26 ' datadg/tbcs/onlinelog/group_26.1152.1084529307' size 2048m blocksize 512
datafile
' bakcustdg/fullbackupdir/tbcs_1097401860_6s0mi1g4.dbf',
' bakcustdg/fullbackupdir/tbcs_1097389598_vm0mhlgu.dbf',
' bakcustdg/fullbackupdir/tbcs_1097401853_6r0mi1ft.dbf',
' bakcustdg/fullbackupdir/tbcs_1097401867_6t0mi1gb.dbf',
' bakcustdg/fullbackupdir/tbcs_1097401874_6v0mi1gi.dbf',
' bakcustdg/fullbackupdir/tbcs_1097366318_j50mgupe.dbf',
' bakcustdg/fullbackupdir/tbcs_1097401642_6f0mi19a.dbf',
' bakcustdg/fullbackupdir/tbcs_1097389653_vn0mhlil.dbf',
' bakcustdg/fullbackupdir/tbcs_1097401606_6e0mi186.dbf',
' bakcustdg/fullbackupdir/tbcs_1097366373_j60mgur5.dbf',
' bakcustdg/fullbackupdir/tbcs_1097366428_j70mguss.dbf',
' bakcustdg/fullbackupdir/tbcs_1097366483_j80mguuj.dbf',
' bakcustdg/fullbackupdir/tbcs_1097366538_j90mgv0a.dbf',
' bakcustdg/fullbackupdir/tbcs_1097366594_ja0mgv22.dbf',
' bakcustdg/fullbackupdir/tbcs_1097389708_vo0mhlkc.dbf',
' bakcustdg/fullbackupdir/tbcs_1097389763_vp0mhlm3.dbf',
' bakcustdg/fullbackupdir/tbcs_1097389818_vq0mhlnq.dbf',
' bakcustdg/fullbackupdir/tbcs_1097389873_vr0mhlph.dbf',
' bakcustdg/fullbackupdir/tbcs_1097389928_vs0mhlr8.dbf',
' bakcustdg/fullbackupdir/tbcs_1097389984_vt0mhlt0.dbf',
' bakcustdg/fullbackupdir/tbcs_1097390039_vu0mhlun.dbf',
' bakcustdg/fullbackupdir/tbcs_1097390094_vv0mhm0e.dbf',
' bakcustdg/fullbackupdir/tbcs_1097390149_000mhm25.dbf',
' bakcustdg/fullbackupdir/tbcs_1097390204_010mhm3s.dbf',
' bakcustdg/fullbackupdir/tbcs_1097390259_020mhm5j.dbf',
' bakcustdg/fullbackupdir/tbcs_1097390314_030mhm7a.dbf',
' bakcustdg/fullbackupdir/tbcs_1097390369_040mhm91.dbf',
' bakcustdg/fullbackupdir/tbcs_1097390425_050mhmap.dbf',
' bakcustdg/fullbackupdir/tbcs_1097390480_060mhmcg.dbf',
' bakcustdg/fullbackupdir/tbcs_1097390535_070mhme7.dbf',
' bakcustdg/fullbackupdir/tbcs_1097390590_080mhmfu.dbf',
' bakcustdg/fullbackupdir/tbcs_1097390645_090mhmhl.dbf',
' bakcustdg/fullbackupdir/tbcs_1097390700_0a0mhmjc.dbf',
' bakcustdg/fullbackupdir/tbcs_1097390756_0b0mhml4.dbf',
' bakcustdg/fullbackupdir/tbcs_1097390811_0c0mhmmr.dbf',
' bakcustdg/fullbackupdir/tbcs_1097390866_0d0mhmoi.dbf',
' bakcustdg/fullbackupdir/tbcs_1097390921_0e0mhmq9.dbf',
' bakcustdg/fullbackupdir/tbcs_1097390976_0f0mhms0.dbf',
' bakcustdg/fullbackupdir/tbcs_1097391031_0g0mhmtn.dbf',
' bakcustdg/fullbackupdir/tbcs_1097391086_0h0mhmve.dbf',
' bakcustdg/fullbackupdir/tbcs_1097391141_0i0mhn15.dbf',
' bakcustdg/fullbackupdir/tbcs_1097391197_0j0mhn2t.dbf',
' bakcustdg/fullbackupdir/tbcs_1097391252_0k0mhn4k.dbf',
' bakcustdg/fullbackupdir/tbcs_1097391307_0l0mhn6b.dbf',
' bakcustdg/fullbackupdir/tbcs_1097391362_0m0mhn82.dbf',
' bakcustdg/fullbackupdir/tbcs_1097391417_0n0mhn9p.dbf',
' bakcustdg/fullbackupdir/tbcs_1097391472_0o0mhnbg.dbf',
' bakcustdg/fullbackupdir/tbcs_1097391527_0p0mhnd7.dbf',
' bakcustdg/fullbackupdir/tbcs_1097391582_0q0mhneu.dbf',
' bakcustdg/fullbackupdir/tbcs_1097391638_0r0mhngm.dbf',
' bakcustdg/fullbackupdir/tbcs_1097391693_0s0mhnid.dbf',
' bakcustdg/fullbackupdir/tbcs_1097391748_0t0mhnk4.dbf',
' bakcustdg/fullbackupdir/tbcs_1097391803_0u0mhnlr.dbf',
' bakcustdg/fullbackupdir/tbcs_1097391858_0v0mhnni.dbf',
' bakcustdg/fullbackupdir/tbcs_1097391913_100mhnp9.dbf',
' bakcustdg/fullbackupdir/tbcs_1097391968_110mhnr0.dbf',
' bakcustdg/fullbackupdir/tbcs_1097392024_120mhnso.dbf',
' bakcustdg/fullbackupdir/tbcs_1097392079_130mhnuf.dbf',
' bakcustdg/fullbackupdir/tbcs_1097392134_140mho06.dbf',
' bakcustdg/fullbackupdir/tbcs_1097392189_150mho1t.dbf',
' bakcustdg/fullbackupdir/tbcs_1097392244_160mho3k.dbf',
' bakcustdg/fullbackupdir/tbcs_1097392299_170mho5b.dbf',
' bakcustdg/fullbackupdir/tbcs_1097392354_180mho72.dbf',
' bakcustdg/fullbackupdir/tbcs_1097392410_190mho8q.dbf',
' bakcustdg/fullbackupdir/tbcs_1097392465_1a0mhoah.dbf',
' bakcustdg/fullbackupdir/tbcs_1097392520_1b0mhoc8.dbf',
' bakcustdg/fullbackupdir/tbcs_1097392585_1c0mhoe9.dbf',
' bakcustdg/fullbackupdir/tbcs_1097392650_1d0mhoga.dbf',
' bakcustdg/fullbackupdir/tbcs_1097392715_1e0mhoib.dbf',
' bakcustdg/fullbackupdir/tbcs_1097366649_jb0mgv3p.dbf',
' bakcustdg/fullbackupdir/tbcs_1097392780_1f0mhokc.dbf',
' bakcustdg/fullbackupdir/tbcs_1097366704_jc0mgv5g.dbf',
' bakcustdg/fullbackupdir/tbcs_1097366759_jd0mgv77.dbf',
' bakcustdg/fullbackupdir/tbcs_1097366814_je0mgv8u.dbf',
' bakcustdg/fullbackupdir/tbcs_1097366869_jf0mgval.dbf',
' bakcustdg/fullbackupdir/tbcs_1097366924_jg0mgvcc.dbf',
' bakcustdg/fullbackupdir/tbcs_1097366979_jh0mgve3.dbf',
' bakcustdg/fullbackupdir/tbcs_1097367035_ji0mgvfr.dbf',
' bakcustdg/fullbackupdir/tbcs_1097367090_jj0mgvhi.dbf',
' bakcustdg/fullbackupdir/tbcs_1097367145_jk0mgvj9.dbf',
' bakcustdg/fullbackupdir/tbcs_1097367200_jl0mgvl0.dbf',
' bakcustdg/fullbackupdir/tbcs_1097367255_jm0mgvmn.dbf',
' bakcustdg/fullbackupdir/tbcs_1097367310_jn0mgvoe.dbf',
' bakcustdg/fullbackupdir/tbcs_1097367365_jo0mgvq5.dbf',
' bakcustdg/fullbackupdir/tbcs_1097367421_jp0mgvrt.dbf',
' bakcustdg/fullbackupdir/tbcs_1097367476_jq0mgvtk.dbf',
' bakcustdg/fullbackupdir/tbcs_1097367531_jr0mgvvb.dbf',
' bakcustdg/fullbackupdir/tbcs_1097367586_js0mh012.dbf',
' bakcustdg/fullbackupdir/tbcs_1097367641_jt0mh02p.dbf',
' bakcustdg/fullbackupdir/tbcs_1097392845_1g0mhomd.dbf',
' bakcustdg/fullbackupdir/tbcs_1097392911_1h0mhoof.dbf',
' bakcustdg/fullbackupdir/tbcs_1097392976_1i0mhoqg.dbf',
' bakcustdg/fullbackupdir/tbcs_1097393041_1j0mhosh.dbf',
' bakcustdg/fullbackupdir/tbcs_1097393106_1k0mhoui.dbf',
' bakcustdg/fullbackupdir/tbcs_1097393171_1l0mhp0j.dbf',
' bakcustdg/fullbackupdir/tbcs_1097393236_1m0mhp2k.dbf',
' bakcustdg/fullbackupdir/tbcs_1097393291_1n0mhp4b.dbf',
' bakcustdg/fullbackupdir/tbcs_1097393346_1o0mhp62.dbf',
' bakcustdg/fullbackupdir/tbcs_1097393402_1p0mhp7q.dbf',
' bakcustdg/fullbackupdir/tbcs_1097393457_1q0mhp9h.dbf',
' bakcustdg/fullbackupdir/tbcs_1097393512_1r0mhpb8.dbf',
' bakcustdg/fullbackupdir/tbcs_1097393567_1s0mhpcv.dbf',
' bakcustdg/fullbackupdir/tbcs_1097393622_1t0mhpem.dbf',
' bakcustdg/fullbackupdir/tbcs_1097393677_1u0mhpgd.dbf',
' bakcustdg/fullbackupdir/tbcs_1097393732_1v0mhpi4.dbf',
' bakcustdg/fullbackupdir/tbcs_1097393788_200mhpjs.dbf',
' bakcustdg/fullbackupdir/tbcs_1097393843_210mhplj.dbf',
' bakcustdg/fullbackupdir/tbcs_1097393898_220mhpna.dbf',
' bakcustdg/fullbackupdir/tbcs_1097393953_230mhpp1.dbf',
' bakcustdg/fullbackupdir/tbcs_1097367696_ju0mh04g.dbf',
' bakcustdg/fullbackupdir/tbcs_1097367752_jv0mh068.dbf',
' bakcustdg/fullbackupdir/tbcs_1097367807_k00mh07v.dbf',
' bakcustdg/fullbackupdir/tbcs_1097367862_k10mh09m.dbf',
' bakcustdg/fullbackupdir/tbcs_1097367917_k20mh0bd.dbf',
' bakcustdg/fullbackupdir/tbcs_1097367972_k30mh0d4.dbf',
' bakcustdg/fullbackupdir/tbcs_1097394008_240mhpqo.dbf',
' bakcustdg/fullbackupdir/tbcs_1097388430_v30mhkce.dbf',
' bakcustdg/fullbackupdir/tbcs_1097388485_v40mhke5.dbf',
' bakcustdg/fullbackupdir/tbcs_1097388540_v50mhkfs.dbf',
' bakcustdg/fullbackupdir/tbcs_1097388605_v60mhkht.dbf',
' bakcustdg/fullbackupdir/tbcs_1097388661_v70mhkjl.dbf',
' bakcustdg/fullbackupdir/tbcs_1097388726_v80mhklm.dbf',
' bakcustdg/fullbackupdir/tbcs_1097388781_v90mhknd.dbf',
' bakcustdg/fullbackupdir/tbcs_1097388836_va0mhkp4.dbf',
' bakcustdg/fullbackupdir/tbcs_1097388891_vb0mhkqr.dbf',
' bakcustdg/fullbackupdir/tbcs_1097388946_vc0mhksi.dbf',
' bakcustdg/fullbackupdir/tbcs_1097389011_vd0mhkuj.dbf',
' bakcustdg/fullbackupdir/tbcs_1097389077_ve0mhl0l.dbf',
' bakcustdg/fullbackupdir/tbcs_1097389142_vf0mhl2m.dbf',
' bakcustdg/fullbackupdir/tbcs_1097389207_vg0mhl4n.dbf',
' bakcustdg/fullbackupdir/tbcs_1097389272_vh0mhl6o.dbf',
' bakcustdg/fullbackupdir/tbcs_1097389337_vi0mhl8p.dbf',
' bakcustdg/fullbackupdir/tbcs_1097389402_vj0mhlaq.dbf',
' bakcustdg/fullbackupdir/tbcs_1097394063_250mhpsf.dbf',
' bakcustdg/fullbackupdir/tbcs_1097394118_260mhpu6.dbf',
' bakcustdg/fullbackupdir/tbcs_1097394173_270mhpvt.dbf',
' bakcustdg/fullbackupdir/tbcs_1097394229_280mhq1l.dbf',
' bakcustdg/fullbackupdir/tbcs_1097394284_290mhq3c.dbf',
' bakcustdg/fullbackupdir/tbcs_1097394339_2a0mhq53.dbf',
' bakcustdg/fullbackupdir/tbcs_1097394394_2b0mhq6q.dbf',
' bakcustdg/fullbackupdir/tbcs_1097394449_2c0mhq8h.dbf',
' bakcustdg/fullbackupdir/tbcs_1097368027_k40mh0er.dbf',
' bakcustdg/fullbackupdir/tbcs_1097368082_k50mh0gi.dbf',
' bakcustdg/fullbackupdir/tbcs_1097368138_k60mh0ia.dbf',
' bakcustdg/fullbackupdir/tbcs_1097368193_k70mh0k1.dbf',
' bakcustdg/fullbackupdir/tbcs_1097368258_k80mh0m2.dbf',
' bakcustdg/fullbackupdir/tbcs_1097368313_k90mh0np.dbf',
' bakcustdg/fullbackupdir/tbcs_1097368378_ka0mh0pq.dbf',
' bakcustdg/fullbackupdir/tbcs_1097368443_kb0mh0rr.dbf',
' bakcustdg/fullbackupdir/tbcs_1097368498_kc0mh0ti.dbf',
' bakcustdg/fullbackupdir/tbcs_1097368554_kd0mh0va.dbf',
' bakcustdg/fullbackupdir/tbcs_1097368609_ke0mh111.dbf',
' bakcustdg/fullbackupdir/tbcs_1097368664_kf0mh12o.dbf',
' bakcustdg/fullbackupdir/tbcs_1097368719_kg0mh14f.dbf',
' bakcustdg/fullbackupdir/tbcs_1097368774_kh0mh166.dbf',
' bakcustdg/fullbackupdir/tbcs_1097368829_ki0mh17t.dbf',
' bakcustdg/fullbackupdir/tbcs_1097368894_kj0mh19u.dbf',
' bakcustdg/fullbackupdir/tbcs_1097368949_kk0mh1bl.dbf',
' bakcustdg/fullbackupdir/tbcs_1097369005_kl0mh1dd.dbf',
' bakcustdg/fullbackupdir/tbcs_1097369060_km0mh1f4.dbf',
' bakcustdg/fullbackupdir/tbcs_1097369115_kn0mh1gr.dbf',
' bakcustdg/fullbackupdir/tbcs_1097369180_ko0mh1is.dbf',
' bakcustdg/fullbackupdir/tbcs_1097369235_kp0mh1kj.dbf',
' bakcustdg/fullbackupdir/tbcs_1097369300_kq0mh1mk.dbf',
' bakcustdg/fullbackupdir/tbcs_1097369355_kr0mh1ob.dbf',
' bakcustdg/fullbackupdir/tbcs_1097369411_ks0mh1q3.dbf',
' bakcustdg/fullbackupdir/tbcs_1097394504_2d0mhqa8.dbf',
' bakcustdg/fullbackupdir/tbcs_1097394559_2e0mhqbv.dbf',
' bakcustdg/fullbackupdir/tbcs_1097394614_2f0mhqdm.dbf',
' bakcustdg/fullbackupdir/tbcs_1097369466_kt0mh1rq.dbf',
' bakcustdg/fullbackupdir/tbcs_1097394670_2g0mhqfe.dbf',
' bakcustdg/fullbackupdir/tbcs_1097394725_2h0mhqh5.dbf',
' bakcustdg/fullbackupdir/tbcs_1097394780_2i0mhqis.dbf',
' bakcustdg/fullbackupdir/tbcs_1097394835_2j0mhqkj.dbf',
' bakcustdg/fullbackupdir/tbcs_1097394890_2k0mhqma.dbf',
' bakcustdg/fullbackupdir/tbcs_1097394945_2l0mhqo1.dbf',
' bakcustdg/fullbackupdir/tbcs_1097395001_2m0mhqpp.dbf',
' bakcustdg/fullbackupdir/tbcs_1097395056_2n0mhqrg.dbf',
' bakcustdg/fullbackupdir/tbcs_1097369521_ku0mh1th.dbf',
' bakcustdg/fullbackupdir/tbcs_1097369576_kv0mh1v8.dbf',
' bakcustdg/fullbackupdir/tbcs_1097369631_l00mh20v.dbf',
' bakcustdg/fullbackupdir/tbcs_1097369686_l10mh22m.dbf',
' bakcustdg/fullbackupdir/tbcs_1097369742_l20mh24e.dbf',
' bakcustdg/fullbackupdir/tbcs_1097369797_l30mh265.dbf',
' bakcustdg/fullbackupdir/tbcs_1097369852_l40mh27s.dbf',
' bakcustdg/fullbackupdir/tbcs_1097369907_l50mh29j.dbf',
' bakcustdg/fullbackupdir/tbcs_1097369962_l60mh2ba.dbf',
' bakcustdg/fullbackupdir/tbcs_1097370017_l70mh2d1.dbf',
' bakcustdg/fullbackupdir/tbcs_1097370072_l80mh2eo.dbf',
' bakcustdg/fullbackupdir/tbcs_1097370128_l90mh2gg.dbf',
' bakcustdg/fullbackupdir/tbcs_1097370183_la0mh2i7.dbf',
' bakcustdg/fullbackupdir/tbcs_1097370238_lb0mh2ju.dbf',
' bakcustdg/fullbackupdir/tbcs_1097370293_lc0mh2ll.dbf',
' bakcustdg/fullbackupdir/tbcs_1097370358_ld0mh2nm.dbf',
' bakcustdg/fullbackupdir/tbcs_1097370423_le0mh2pn.dbf',
' bakcustdg/fullbackupdir/tbcs_1097370478_lf0mh2re.dbf',
' bakcustdg/fullbackupdir/tbcs_1097370543_lg0mh2tf.dbf',
' bakcustdg/fullbackupdir/tbcs_1097370599_lh0mh2v7.dbf',
' bakcustdg/fullbackupdir/tbcs_1097370654_li0mh30u.dbf',
' bakcustdg/fullbackupdir/tbcs_1097370719_lj0mh32v.dbf',
' bakcustdg/fullbackupdir/tbcs_1097370774_lk0mh34m.dbf',
' bakcustdg/fullbackupdir/tbcs_1097370839_ll0mh36n.dbf',
' bakcustdg/fullbackupdir/tbcs_1097370904_lm0mh38o.dbf',
' bakcustdg/fullbackupdir/tbcs_1097370969_ln0mh3ap.dbf',
' bakcustdg/fullbackupdir/tbcs_1097371035_lo0mh3cr.dbf',
' bakcustdg/fullbackupdir/tbcs_1097371100_lp0mh3es.dbf',
' bakcustdg/fullbackupdir/tbcs_1097395111_2o0mhqt7.dbf',
' bakcustdg/fullbackupdir/tbcs_1097371165_lq0mh3gt.dbf',
' bakcustdg/fullbackupdir/tbcs_1097371230_lr0mh3iu.dbf',
' bakcustdg/fullbackupdir/tbcs_1097371295_ls0mh3kv.dbf',
' bakcustdg/fullbackupdir/tbcs_1097371360_lt0mh3n0.dbf',
' bakcustdg/fullbackupdir/tbcs_1097371425_lu0mh3p1.dbf',
' bakcustdg/fullbackupdir/tbcs_1097371490_lv0mh3r2.dbf',
' bakcustdg/fullbackupdir/tbcs_1097371556_m00mh3t4.dbf',
' bakcustdg/fullbackupdir/tbcs_1097371621_m10mh3v5.dbf',
' bakcustdg/fullbackupdir/tbcs_1097371686_m20mh416.dbf',
' bakcustdg/fullbackupdir/tbcs_1097371751_m30mh437.dbf',
' bakcustdg/fullbackupdir/tbcs_1097371816_m40mh458.dbf',
' bakcustdg/fullbackupdir/tbcs_1097371881_m50mh479.dbf',
' bakcustdg/fullbackupdir/tbcs_1097371946_m60mh49a.dbf',
' bakcustdg/fullbackupdir/tbcs_1097372012_m70mh4bc.dbf',
' bakcustdg/fullbackupdir/tbcs_1097372077_m80mh4dd.dbf',
' bakcustdg/fullbackupdir/tbcs_1097372142_m90mh4fe.dbf',
' bakcustdg/fullbackupdir/tbcs_1097372207_ma0mh4hf.dbf',
' bakcustdg/fullbackupdir/tbcs_1097372262_mb0mh4j6.dbf',
' bakcustdg/fullbackupdir/tbcs_1097372317_mc0mh4kt.dbf',
' bakcustdg/fullbackupdir/tbcs_1097372372_md0mh4mk.dbf',
' bakcustdg/fullbackupdir/tbcs_1097372437_me0mh4ol.dbf',
' bakcustdg/fullbackupdir/tbcs_1097372503_mf0mh4qn.dbf',
' bakcustdg/fullbackupdir/tbcs_1097372568_mg0mh4so.dbf',
' bakcustdg/fullbackupdir/tbcs_1097372633_mh0mh4up.dbf',
' bakcustdg/fullbackupdir/tbcs_1097372688_mi0mh50g.dbf',
' bakcustdg/fullbackupdir/tbcs_1097372743_mj0mh527.dbf',
' bakcustdg/fullbackupdir/tbcs_1097372798_mk0mh53u.dbf',
' bakcustdg/fullbackupdir/tbcs_1097372853_ml0mh55l.dbf',
' bakcustdg/fullbackupdir/tbcs_1097372908_mm0mh57c.dbf',
' bakcustdg/fullbackupdir/tbcs_1097372964_mn0mh594.dbf',
' bakcustdg/fullbackupdir/tbcs_1097373019_mo0mh5ar.dbf',
' bakcustdg/fullbackupdir/tbcs_1097373074_mp0mh5ci.dbf',
' bakcustdg/fullbackupdir/tbcs_1097373129_mq0mh5e9.dbf',
' bakcustdg/fullbackupdir/tbcs_1097373184_mr0mh5g0.dbf',
' bakcustdg/fullbackupdir/tbcs_1097373239_ms0mh5hn.dbf',
' bakcustdg/fullbackupdir/tbcs_1097373304_mt0mh5jo.dbf',
' bakcustdg/fullbackupdir/tbcs_1097389467_vk0mhlcr.dbf',
' bakcustdg/fullbackupdir/tbcs_1097373370_mu0mh5lq.dbf',
' bakcustdg/fullbackupdir/tbcs_1097389533_vl0mhlet.dbf',
' bakcustdg/fullbackupdir/tbcs_1097395166_2p0mhquu.dbf',
' bakcustdg/fullbackupdir/tbcs_1097395221_2q0mhr0l.dbf',
' bakcustdg/fullbackupdir/tbcs_1097395276_2r0mhr2c.dbf',
' bakcustdg/fullbackupdir/tbcs_1097395331_2s0mhr43.dbf',
' bakcustdg/fullbackupdir/tbcs_1097395386_2t0mhr5q.dbf',
' bakcustdg/fullbackupdir/tbcs_1097395442_2u0mhr7i.dbf',
' bakcustdg/fullbackupdir/tbcs_1097395497_2v0mhr99.dbf',
' bakcustdg/fullbackupdir/tbcs_1097395552_300mhrb0.dbf',
' bakcustdg/fullbackupdir/tbcs_1097395607_310mhrcn.dbf',
' bakcustdg/fullbackupdir/tbcs_1097395662_320mhree.dbf',
' bakcustdg/fullbackupdir/tbcs_1097395717_330mhrg5.dbf',
' bakcustdg/fullbackupdir/tbcs_1097395772_340mhrhs.dbf',
' bakcustdg/fullbackupdir/tbcs_1097395827_350mhrjj.dbf',
' bakcustdg/fullbackupdir/tbcs_1097395883_360mhrlb.dbf',
' bakcustdg/fullbackupdir/tbcs_1097395938_370mhrn2.dbf',
' bakcustdg/fullbackupdir/tbcs_1097395993_380mhrop.dbf',
' bakcustdg/fullbackupdir/tbcs_1097396048_390mhrqg.dbf',
' bakcustdg/fullbackupdir/tbcs_1097396103_3a0mhrs7.dbf',
' bakcustdg/fullbackupdir/tbcs_1097396158_3b0mhrtu.dbf',
' bakcustdg/fullbackupdir/tbcs_1097396213_3c0mhrvl.dbf',
' bakcustdg/fullbackupdir/tbcs_1097373425_mv0mh5nh.dbf',
' bakcustdg/fullbackupdir/tbcs_1097373480_n00mh5p8.dbf',
' bakcustdg/fullbackupdir/tbcs_1097373535_n10mh5qv.dbf',
' bakcustdg/fullbackupdir/tbcs_1097373590_n20mh5sm.dbf',
' bakcustdg/fullbackupdir/tbcs_1097373645_n30mh5ud.dbf',
' bakcustdg/fullbackupdir/tbcs_1097373700_n40mh604.dbf',
' bakcustdg/fullbackupdir/tbcs_1097373756_n50mh61s.dbf',
' bakcustdg/fullbackupdir/tbcs_1097373811_n60mh63j.dbf',
' bakcustdg/fullbackupdir/tbcs_1097373866_n70mh65a.dbf',
' bakcustdg/fullbackupdir/tbcs_1097373921_n80mh671.dbf',
' bakcustdg/fullbackupdir/tbcs_1097373976_n90mh68o.dbf',
' bakcustdg/fullbackupdir/tbcs_1097401871_6u0mi1gf.dbf',
' bakcustdg/fullbackupdir/tbcs_1097396268_3d0mhs1c.dbf',
' bakcustdg/fullbackupdir/tbcs_1097396324_3e0mhs34.dbf',
' bakcustdg/fullbackupdir/tbcs_1097396379_3f0mhs4r.dbf',
' bakcustdg/fullbackupdir/tbcs_1097396434_3g0mhs6i.dbf',
' bakcustdg/fullbackupdir/tbcs_1097396489_3h0mhs89.dbf',
' bakcustdg/fullbackupdir/tbcs_1097374031_na0mh6af.dbf',
' bakcustdg/fullbackupdir/tbcs_1097374086_nb0mh6c6.dbf',
' bakcustdg/fullbackupdir/tbcs_1097374142_nc0mh6du.dbf',
' bakcustdg/fullbackupdir/tbcs_1097374197_nd0mh6fl.dbf',
' bakcustdg/fullbackupdir/tbcs_1097374252_ne0mh6hc.dbf',
' bakcustdg/fullbackupdir/tbcs_1097374307_nf0mh6j3.dbf',
' bakcustdg/fullbackupdir/tbcs_1097374362_ng0mh6kq.dbf',
' bakcustdg/fullbackupdir/tbcs_1097374417_nh0mh6mh.dbf',
' bakcustdg/fullbackupdir/tbcs_1097374472_ni0mh6o8.dbf',
' bakcustdg/fullbackupdir/tbcs_1097374528_nj0mh6q0.dbf',
' bakcustdg/fullbackupdir/tbcs_1097374593_nk0mh6s1.dbf',
' bakcustdg/fullbackupdir/tbcs_1097374648_nl0mh6to.dbf',
' bakcustdg/fullbackupdir/tbcs_1097374703_nm0mh6vf.dbf',
' bakcustdg/fullbackupdir/tbcs_1097374758_nn0mh716.dbf',
' bakcustdg/fullbackupdir/tbcs_1097374813_no0mh72t.dbf',
' bakcustdg/fullbackupdir/tbcs_1097374868_np0mh74k.dbf',
' bakcustdg/fullbackupdir/tbcs_1097374923_nq0mh76b.dbf',
' bakcustdg/fullbackupdir/tbcs_1097374979_nr0mh783.dbf',
' bakcustdg/fullbackupdir/tbcs_1097375034_ns0mh79q.dbf',
' bakcustdg/fullbackupdir/tbcs_1097375089_nt0mh7bh.dbf',
' bakcustdg/fullbackupdir/tbcs_1097375154_nu0mh7di.dbf',
' bakcustdg/fullbackupdir/tbcs_1097375209_nv0mh7f9.dbf',
' bakcustdg/fullbackupdir/tbcs_1097375274_o00mh7ha.dbf',
' bakcustdg/fullbackupdir/tbcs_1097375329_o10mh7j1.dbf',
' bakcustdg/fullbackupdir/tbcs_1097375385_o20mh7kp.dbf',
' bakcustdg/fullbackupdir/tbcs_1097375440_o30mh7mg.dbf',
' bakcustdg/fullbackupdir/tbcs_1097375495_o40mh7o7.dbf',
' bakcustdg/fullbackupdir/tbcs_1097375560_o50mh7q8.dbf',
' bakcustdg/fullbackupdir/tbcs_1097375625_o60mh7s9.dbf',
' bakcustdg/fullbackupdir/tbcs_1097375680_o70mh7u0.dbf',
' bakcustdg/fullbackupdir/tbcs_1097375735_o80mh7vn.dbf',
' bakcustdg/fullbackupdir/tbcs_1097375790_o90mh81e.dbf',
' bakcustdg/fullbackupdir/tbcs_1097375846_oa0mh836.dbf',
' bakcustdg/fullbackupdir/tbcs_1097375901_ob0mh84t.dbf',
' bakcustdg/fullbackupdir/tbcs_1097375966_oc0mh86u.dbf',
' bakcustdg/fullbackupdir/tbcs_1097376021_od0mh88l.dbf',
' bakcustdg/fullbackupdir/tbcs_1097376076_oe0mh8ac.dbf',
' bakcustdg/fullbackupdir/tbcs_1097376131_of0mh8c3.dbf',
' bakcustdg/fullbackupdir/tbcs_1097376186_og0mh8dq.dbf',
' bakcustdg/fullbackupdir/tbcs_1097376241_oh0mh8fh.dbf',
' bakcustdg/fullbackupdir/tbcs_1097376297_oi0mh8h9.dbf',
' bakcustdg/fullbackupdir/tbcs_1097376352_oj0mh8j0.dbf',
' bakcustdg/fullbackupdir/tbcs_1097376407_ok0mh8kn.dbf',
' bakcustdg/fullbackupdir/tbcs_1097376462_ol0mh8me.dbf',
' bakcustdg/fullbackupdir/tbcs_1097376527_om0mh8of.dbf',
' bakcustdg/fullbackupdir/tbcs_1097376582_on0mh8q6.dbf',
' bakcustdg/fullbackupdir/tbcs_1097376647_oo0mh8s7.dbf',
' bakcustdg/fullbackupdir/tbcs_1097376713_op0mh8u9.dbf',
' bakcustdg/fullbackupdir/tbcs_1097376768_oq0mh900.dbf',
' bakcustdg/fullbackupdir/tbcs_1097376823_or0mh91n.dbf',
' bakcustdg/fullbackupdir/tbcs_1097376878_os0mh93e.dbf',
' bakcustdg/fullbackupdir/tbcs_1097376933_ot0mh955.dbf',
' bakcustdg/fullbackupdir/tbcs_1097376988_ou0mh96s.dbf',
' bakcustdg/fullbackupdir/tbcs_1097377043_ov0mh98j.dbf',
' bakcustdg/fullbackupdir/tbcs_1097377098_p00mh9aa.dbf',
' bakcustdg/fullbackupdir/tbcs_1097377154_p10mh9c2.dbf',
' bakcustdg/fullbackupdir/tbcs_1097377209_p20mh9dp.dbf',
' bakcustdg/fullbackupdir/tbcs_1097377264_p30mh9fg.dbf',
' bakcustdg/fullbackupdir/tbcs_1097377319_p40mh9h7.dbf',
' bakcustdg/fullbackupdir/tbcs_1097377374_p50mh9iu.dbf',
' bakcustdg/fullbackupdir/tbcs_1097377439_p60mh9kv.dbf',
' bakcustdg/fullbackupdir/tbcs_1097377504_p70mh9n0.dbf',
' bakcustdg/fullbackupdir/tbcs_1097377569_p80mh9p1.dbf',
' bakcustdg/fullbackupdir/tbcs_1097377625_p90mh9qp.dbf',
' bakcustdg/fullbackupdir/tbcs_1097377680_pa0mh9sg.dbf',
' bakcustdg/fullbackupdir/tbcs_1097377735_pb0mh9u7.dbf',
' bakcustdg/fullbackupdir/tbcs_1097396544_3i0mhsa0.dbf',
' bakcustdg/fullbackupdir/tbcs_1097396599_3j0mhsbn.dbf',
' bakcustdg/fullbackupdir/tbcs_1097396654_3k0mhsde.dbf',
' bakcustdg/fullbackupdir/tbcs_1097377790_pc0mh9vu.dbf',
' bakcustdg/fullbackupdir/tbcs_1097377845_pd0mha1l.dbf',
' bakcustdg/fullbackupdir/tbcs_1097377900_pe0mha3c.dbf',
' bakcustdg/fullbackupdir/tbcs_1097377956_pf0mha54.dbf',
' bakcustdg/fullbackupdir/tbcs_1097378011_pg0mha6r.dbf',
' bakcustdg/fullbackupdir/tbcs_1097396710_3l0mhsf6.dbf',
' bakcustdg/fullbackupdir/tbcs_1097396765_3m0mhsgt.dbf',
' bakcustdg/fullbackupdir/tbcs_1097378066_ph0mha8i.dbf',
' bakcustdg/fullbackupdir/tbcs_1097378121_pi0mhaa9.dbf',
' bakcustdg/fullbackupdir/tbcs_1097378176_pj0mhac0.dbf',
' bakcustdg/fullbackupdir/tbcs_1097378231_pk0mhadn.dbf',
' bakcustdg/fullbackupdir/tbcs_1097378286_pl0mhafe.dbf',
' bakcustdg/fullbackupdir/tbcs_1097378342_pm0mhah6.dbf',
' bakcustdg/fullbackupdir/tbcs_1097378397_pn0mhait.dbf',
' bakcustdg/fullbackupdir/tbcs_1097378452_po0mhakk.dbf',
' bakcustdg/fullbackupdir/tbcs_1097378507_pp0mhamb.dbf',
' bakcustdg/fullbackupdir/tbcs_1097378562_pq0mhao2.dbf',
' bakcustdg/fullbackupdir/tbcs_1097378617_pr0mhapp.dbf',
' bakcustdg/fullbackupdir/tbcs_1097378672_ps0mharg.dbf',
' bakcustdg/fullbackupdir/tbcs_1097378727_pt0mhat7.dbf',
' bakcustdg/fullbackupdir/tbcs_1097378783_pu0mhauv.dbf',
' bakcustdg/fullbackupdir/tbcs_1097378838_pv0mhb0m.dbf',
' bakcustdg/fullbackupdir/tbcs_1097378893_q00mhb2d.dbf',
' bakcustdg/fullbackupdir/tbcs_1097396820_3n0mhsik.dbf',
' bakcustdg/fullbackupdir/tbcs_1097396875_3o0mhskb.dbf',
' bakcustdg/fullbackupdir/tbcs_1097396930_3p0mhsm2.dbf',
' bakcustdg/fullbackupdir/tbcs_1097396985_3q0mhsnp.dbf',
' bakcustdg/fullbackupdir/tbcs_1097397040_3r0mhspg.dbf',
' bakcustdg/fullbackupdir/tbcs_1097397095_3s0mhsr7.dbf',
' bakcustdg/fullbackupdir/tbcs_1097397151_3t0mhssv.dbf',
' bakcustdg/fullbackupdir/tbcs_1097378948_q10mhb44.dbf',
' bakcustdg/fullbackupdir/tbcs_1097379003_q20mhb5r.dbf',
' bakcustdg/fullbackupdir/tbcs_1097379058_q30mhb7i.dbf',
' bakcustdg/fullbackupdir/tbcs_1097379113_q40mhb99.dbf',
' bakcustdg/fullbackupdir/tbcs_1097379168_q50mhbb0.dbf',
' bakcustdg/fullbackupdir/tbcs_1097379224_q60mhbco.dbf',
' bakcustdg/fullbackupdir/tbcs_1097379279_q70mhbef.dbf',
' bakcustdg/fullbackupdir/tbcs_1097379344_q80mhbgg.dbf',
' bakcustdg/fullbackupdir/tbcs_1097379399_q90mhbi7.dbf',
' bakcustdg/fullbackupdir/tbcs_1097379454_qa0mhbju.dbf',
' bakcustdg/fullbackupdir/tbcs_1097379509_qb0mhbll.dbf',
' bakcustdg/fullbackupdir/tbcs_1097379564_qc0mhbnc.dbf',
' bakcustdg/fullbackupdir/tbcs_1097379620_qd0mhbp4.dbf',
' bakcustdg/fullbackupdir/tbcs_1097379675_qe0mhbqr.dbf',
' bakcustdg/fullbackupdir/tbcs_1097379730_qf0mhbsi.dbf',
' bakcustdg/fullbackupdir/tbcs_1097379785_qg0mhbu9.dbf',
' bakcustdg/fullbackupdir/tbcs_1097379840_qh0mhc00.dbf',
' bakcustdg/fullbackupdir/tbcs_1097379895_qi0mhc1n.dbf',
' bakcustdg/fullbackupdir/tbcs_1097379951_qj0mhc3f.dbf',
' bakcustdg/fullbackupdir/tbcs_1097380006_qk0mhc56.dbf',
' bakcustdg/fullbackupdir/tbcs_1097380061_ql0mhc6t.dbf',
' bakcustdg/fullbackupdir/tbcs_1097380116_qm0mhc8k.dbf',
' bakcustdg/fullbackupdir/tbcs_1097380171_qn0mhcab.dbf',
' bakcustdg/fullbackupdir/tbcs_1097380226_qo0mhcc2.dbf',
' bakcustdg/fullbackupdir/tbcs_1097380281_qp0mhcdp.dbf',
' bakcustdg/fullbackupdir/tbcs_1097380337_qq0mhcfh.dbf',
' bakcustdg/fullbackupdir/tbcs_1097380392_qr0mhch8.dbf',
' bakcustdg/fullbackupdir/tbcs_1097380447_qs0mhciv.dbf',
' bakcustdg/fullbackupdir/tbcs_1097380502_qt0mhckm.dbf',
' bakcustdg/fullbackupdir/tbcs_1097380557_qu0mhcmd.dbf',
' bakcustdg/fullbackupdir/tbcs_1097380612_qv0mhco4.dbf',
' bakcustdg/fullbackupdir/tbcs_1097380667_r00mhcpr.dbf',
' bakcustdg/fullbackupdir/tbcs_1097380722_r10mhcri.dbf',
' bakcustdg/fullbackupdir/tbcs_1097380778_r20mhcta.dbf',
' bakcustdg/fullbackupdir/tbcs_1097380833_r30mhcv1.dbf',
' bakcustdg/fullbackupdir/tbcs_1097380898_r40mhd12.dbf',
' bakcustdg/fullbackupdir/tbcs_1097380953_r50mhd2p.dbf',
' bakcustdg/fullbackupdir/tbcs_1097381008_r60mhd4g.dbf',
' bakcustdg/fullbackupdir/tbcs_1097381063_r70mhd67.dbf',
' bakcustdg/fullbackupdir/tbcs_1097381118_r80mhd7u.dbf',
' bakcustdg/fullbackupdir/tbcs_1097381184_r90mhda0.dbf',
' bakcustdg/fullbackupdir/tbcs_1097381239_ra0mhdbn.dbf',
' bakcustdg/fullbackupdir/tbcs_1097381294_rb0mhdde.dbf',
' bakcustdg/fullbackupdir/tbcs_1097381349_rc0mhdf5.dbf',
' bakcustdg/fullbackupdir/tbcs_1097381404_rd0mhdgs.dbf',
' bakcustdg/fullbackupdir/tbcs_1097381459_re0mhdij.dbf',
' bakcustdg/fullbackupdir/tbcs_1097381524_rf0mhdkk.dbf',
' bakcustdg/fullbackupdir/tbcs_1097381579_rg0mhdmb.dbf',
' bakcustdg/fullbackupdir/tbcs_1097381635_rh0mhdo3.dbf',
' bakcustdg/fullbackupdir/tbcs_1097381690_ri0mhdpq.dbf',
' bakcustdg/fullbackupdir/tbcs_1097381745_rj0mhdrh.dbf',
' bakcustdg/fullbackupdir/tbcs_1097381800_rk0mhdt8.dbf',
' bakcustdg/fullbackupdir/tbcs_1097381855_rl0mhduv.dbf',
' bakcustdg/fullbackupdir/tbcs_1097381910_rm0mhe0m.dbf',
' bakcustdg/fullbackupdir/tbcs_1097381975_rn0mhe2n.dbf',
' bakcustdg/fullbackupdir/tbcs_1097382040_ro0mhe4o.dbf',
' bakcustdg/fullbackupdir/tbcs_1097382106_rp0mhe6q.dbf',
' bakcustdg/fullbackupdir/tbcs_1097382171_rq0mhe8r.dbf',
' bakcustdg/fullbackupdir/tbcs_1097382236_rr0mheas.dbf',
' bakcustdg/fullbackupdir/tbcs_1097382301_rs0mhect.dbf',
' bakcustdg/fullbackupdir/tbcs_1097382366_rt0mheeu.dbf',
' bakcustdg/fullbackupdir/tbcs_1097382431_ru0mhegv.dbf',
' bakcustdg/fullbackupdir/tbcs_1097382496_rv0mhej0.dbf',
' bakcustdg/fullbackupdir/tbcs_1097382562_s00mhel2.dbf',
' bakcustdg/fullbackupdir/tbcs_1097382627_s10mhen3.dbf',
sql> select * from v$logfile;
group# status type member is_ con_id
---------- ------- ------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --- ----------
2 online bakcustdg/fullbackupdir/redo01.log no 0
2 online bakcustdg/fullbackupdir/redo02.log no 0
1 online bakcustdg/fullbackupdir/redo03.log no 0
1 online bakcustdg/fullbackupdir/redo04.log no 0
3 online bakcustdg/fullbackupdir/redo05.log no 0
3 online bakcustdg/fullbackupdir/redo06.log no 0
4 online bakcustdg/fullbackupdir/redo07.log no 0
4 online bakcustdg/fullbackupdir/redo08.log no 0
5 online bakcustdg/fullbackupdir/redo09.log no 0
5 online bakcustdg/fullbackupdir/redo10.log no 0
6 online bakcustdg/fullbackupdir/redo11.log no 0
6 online bakcustdg/fullbackupdir/redo12.log no 0
7 online bakcustdg/fullbackupdir/redo13.log no 0
7 online bakcustdg/fullbackupdir/redo14.log no 0
8 online bakcustdg/fullbackupdir/redo15.log no 0
8 online bakcustdg/fullbackupdir/redo16.log no 0
9 online bakcustdg/fullbackupdir/redo17.log no 0
9 online bakcustdg/fullbackupdir/redo18.log no 0
10 online bakcustdg/fullbackupdir/redo19.log no 0
10 online bakcustdg/fullbackupdir/redo20.log no 0
11 online bakcustdg/fullbackupdir/redo21.log no 0
11 online bakcustdg/fullbackupdir/redo22.log no 0
12 online bakcustdg/fullbackupdir/redo23.log no 0
12 online bakcustdg/fullbackupdir/redo24.log no 0
13 standby datadg/tbcs/onlinelog/group_13.1165.1084529243 no 0
14 standby datadg/tbcs/onlinelog/group_14.1164.1084529249 no 0
15 standby datadg/tbcs/onlinelog/group_15.1163.1084529255 no 0
16 standby datadg/tbcs/onlinelog/group_16.1162.1084529261 no 0
17 standby datadg/tbcs/onlinelog/group_17.1161.1084529265 no 0
18 standby datadg/tbcs/onlinelog/group_18.1160.1084529269 no 0
19 standby datadg/tbcs/onlinelog/group_19.1159.1084529275 no 0
20 standby datadg/tbcs/onlinelog/group_20.1158.1084529279 no 0
21 standby datadg/tbcs/onlinelog/group_21.1157.1084529283 no 0
22 standby datadg/tbcs/onlinelog/group_22.1156.1084529289 no 0
23 standby datadg/tbcs/onlinelog/group_23.1155.1084529293 no 0
24 standby datadg/tbcs/onlinelog/group_24.1154.1084529297 no 0
25 standby datadg/tbcs/onlinelog/group_25.1153.1084529303 no 0
26 standby datadg/tbcs/onlinelog/group_26.1152.1084529307 no 0
三、清理standby redo
sql> alter database clear logfile group 13;
alter database clear logfile group 14;
alter database clear logfile group 15;
alter database clear logfile group 16;
alter database clear logfile group 13
*
error at line 1:
ora-00349: failure obtaining block size for ' datadg'
ora-15001: diskgroup "datadg" does not exist or is not mounted
ora-15001: diskgroup "datadg" does not exist or is not mounted
ora-15001: diskgroup "datadg" does not exist or is not mounted
sql> alter database clear logfile group 17;
alter database clear logfile group 18;
alter database clear logfile group 19;
alter database clear logfile group 14
*
error at line 1:
ora-00349: failure obtaining block size for ' datadg'
ora-15001: diskgroup "datadg" does not exist or is not mounted
ora-15001: diskgroup "datadg" does not exist or is not mounted
ora-15001: diskgroup "datadg" does not exist or is not mounted
sql> alter database clear logfile group 20;
alter database clear logfile group 21;
alter database clear logfile group 15
*
error at line 1:
ora-00349: failure obtaining block size for ' datadg'
ora-15001: diskgroup "datadg" does not exist or is not mounted
ora-15001: diskgroup "datadg" does not exist or is not mounted
ora-15001: diskgroup "datadg" does not exist or is not mounted
sql> alter database clear logfile group 22;
alter database clear logfile group 23;
alter database clear logfile group 24;
alter database clear logfile group 16
*
error at line 1:
ora-00349: failure obtaining block size for ' datadg'
ora-15001: diskgroup "datadg" does not exist or is not mounted
ora-15001: diskgroup "datadg" does not exist or is not mounted
ora-15001: diskgroup "datadg" does not exist or is not mounted
sql> alter database clear logfile group 25;
alter database clear logfile group 26;
alter database clear logfile group 17
*
error at line 1:
ora-00349: failure obtaining block size for ' datadg'
ora-15001: diskgroup "datadg" does not exist or is not mounted
ora-15001: diskgroup "datadg" does not exist or is not mounted
ora-15001: diskgroup "datadg" does not exist or is not mounted
sql> alter database clear logfile group 18
*
error at line 1:
ora-00349: failure obtaining block size for ' datadg'
ora-15001: diskgroup "datadg" does not exist or is not mounted
ora-15001: diskgroup "datadg" does not exist or is not mounted
ora-15001: diskgroup "datadg" does not exist or is not mounted
sql> alter database clear logfile group 19
*
error at line 1:
ora-00349: failure obtaining block size for ' datadg'
ora-15001: diskgroup "datadg" does not exist or is not mounted
ora-15001: diskgroup "datadg" does not exist or is not mounted
ora-15001: diskgroup "datadg" does not exist or is not mounted
sql> alter database clear logfile group 20
*
error at line 1:
ora-00349: failure obtaining block size for ' datadg'
ora-15001: diskgroup "datadg" does not exist or is not mounted
ora-15001: diskgroup "datadg" does not exist or is not mounted
ora-15001: diskgroup "datadg" does not exist or is not mounted
sql> alter database clear logfile group 21
*
error at line 1:
ora-00349: failure obtaining block size for ' datadg'
ora-15001: diskgroup "datadg" does not exist or is not mounted
ora-15001: diskgroup "datadg" does not exist or is not mounted
ora-15001: diskgroup "datadg" does not exist or is not mounted
sql> alter database clear logfile group 22
*
error at line 1:
ora-00349: failure obtaining block size for ' datadg'
ora-15001: diskgroup "datadg" does not exist or is not mounted
ora-15001: diskgroup "datadg" does not exist or is not mounted
ora-15001: diskgroup "datadg" does not exist or is not mounted
sql> alter database clear logfile group 23
*
error at line 1:
ora-00349: failure obtaining block size for ' datadg'
ora-15001: diskgroup "datadg" does not exist or is not mounted
ora-15001: diskgroup "datadg" does not exist or is not mounted
ora-15001: diskgroup "datadg" does not exist or is not mounted
sql> alter database clear logfile group 24
*
error at line 1:
ora-00349: failure obtaining block size for ' datadg'
ora-15001: diskgroup "datadg" does not exist or is not mounted
ora-15001: diskgroup "datadg" does not exist or is not mounted
ora-15001: diskgroup "datadg" does not exist or is not mounted
sql> alter database clear logfile group 25
*
error at line 1:
ora-00349: failure obtaining block size for ' datadg'
ora-15001: diskgroup "datadg" does not exist or is not mounted
ora-15001: diskgroup "datadg" does not exist or is not mounted
ora-15001: diskgroup "datadg" does not exist or is not mounted
sql> alter database clear logfile group 26
*
error at line 1:
ora-00349: failure obtaining block size for ' datadg'
ora-15001: diskgroup "datadg" does not exist or is not mounted
ora-15001: diskgroup "datadg" does not exist or is not mounted
ora-15001: diskgroup "datadg" does not exist or is not mounted
sql> alter database drop standby logfile group 13;
alter database drop standby logfile group 14;
alter database drop standby logfile group 15;
alter database drop standby logfile group 16;
database altered.
sql> alter database drop standby logfile group 17;
alter database drop standby logfile group 18;
database altered.
sql>
database altered.
sql> alter database drop standby logfile group 19;
database altered.
sql> alter database drop standby logfile group 20;
database altered.
sql> alter database drop standby logfile group 21;
database altered.
sql> alter database drop standby logfile group 22;
database altered.
sql> alter database drop standby logfile group 23;
database altered.
sql> alter database drop standby logfile group 24;
alter database drop standby logfile group 25;
database altered.
sql> alter database drop standby logfile group 26;
database altered.
sql>
database altered.
sql>
database altered.
sql>
database altered.
sql>
database altered.
三、再次activate
sql> alter database activate standby database;
database altered.
sql> sql> select status from gv$instance;
status
------------
mounted
sql> alter datbase open;
alter datbase open
*
error at line 1:
ora-00940: invalid alter command
sql> alter database open;
alter database open
*
error at line 1:
ora-19751: could not create the change tracking file
ora-19750: change tracking file: ' datadg/tbcs/changetracking/ctf.1096.1094344779'
ora-17502: ksfdcre:1 failed to create file datadg/tbcs/changetracking/ctf.1096.1094344779
ora-17501: logical block size 4294967295 is invalid
ora-15001: diskgroup "datadg" does not exist or is not mounted
ora-17503: ksfdopn:2 failed to open file datadg/tbcs/changetracking/ctf.1096.1094344779
ora-15001: diskgroup "datadg" does not exist or is not mounted
ora-15018: diskgroup cannot be created
ora-15001: diskgroup "datadg" does not exist or is not mounted
提示没有块跟踪文件，路径也不存在
四、关闭块跟踪
sql> alter database disable block change tracking;
database altered.
sql> alter database open;
error:
ora-03114: not connected to oracle
alter database open
*
error at line 1:
ora-03113: end-of-file on communication channel
process id: 36422
session id: 2915 serial number: 29685
这个错无语，检查alert
ora-16072: a minimum of one standby database destination is required
保护模式不对
五、修改保护模式
oracle@pod5-b1-test:/home/oracle$ ss
sql*plus: release 19.0.0.0.0 - production on sat may 7 17:15:27 2022
version 19.9.0.0.0
米乐app官网下载 copyright (c) 1982, 2020, oracle. all rights reserved.
connected to an idle instance.
sql> startup mount
oracle instance started.
total system global area 1778384520 bytes
fixed size 8912520 bytes
variable size 943718400 bytes
database buffers 805306368 bytes
redo buffers 20447232 bytes
database mounted.
sql> alter database set standby to maximize performance;
database altered.
sql> alter database open;
database altered.
sql> select status from v$instance;
select status from v$instance
*
error at line 1:
ora-04031: unable to allocate 40 bytes of shared memory ("shared pool","unknown
object","kglh0^56416d0c","kglheapinitialize:temp")
ora-4031 醉了
六、检查内存参数
sql> exit
disconnected
oracle@pod5-b1-test:/home/oracle$ free -g
total used free shared buffers cached
mem: 376 151 224 25 1 116
-/ buffers/cache: 33 342
swap: 31 0 31
oracle@pod5-b1-test:/home/oracle$ ss
oracle@pod5-b1-test:/home/oracle$ ss
sql*plus: release 19.0.0.0.0 - production on sat may 7 17:18:34 2022
version 19.9.0.0.0
米乐app官网下载 copyright (c) 1982, 2020, oracle. all rights reserved.
connected.
sql> exit
disconnected
oracle@pod5-b1-test:/home/oracle$ ps -ef|grep pmon
oracle 8086 1 0 17:15 ? 00:00:00 ora_pmon_tbcs5
oracle 32338 15333 0 17:18 pts/5 00:00:00 grep --color=auto pmon
oracle 35387 1 0 apr28 ? 00:01:28 ora_pmon_order
grid 38062 1 0 jan13 ? 00:06:15 asm_pmon_ asm
oracle 48911 1 0 mar07 ? 00:12:08 ora_pmon_zwdbbr1
oracle@pod5-b1-test:/home/oracle$ kill -9 8086
oracle@pod5-b1-test:/home/oracle$ ss
sql*plus: release 19.0.0.0.0 - production on sat may 7 17:19:10 2022
version 19.9.0.0.0
米乐app官网下载 copyright (c) 1982, 2020, oracle. all rights reserved.
connected.
sql> exit
disconnected
oracle@pod5-b1-test:/home/oracle$ ps -ef|grep pmon
oracle 35387 1 0 apr28 ? 00:01:28 ora_pmon_order
grid 38062 1 0 jan13 ? 00:06:15 asm_pmon_ asm
oracle 47348 15333 0 17:19 pts/5 00:00:00 grep --color=auto pmon
oracle 48911 1 0 mar07 ? 00:12:08 ora_pmon_zwdbbr1
oracle@pod5-b1-test:/home/oracle$ ss
sql*plus: release 19.0.0.0.0 - production on sat may 7 17:19:21 2022
version 19.9.0.0.0
米乐app官网下载 copyright (c) 1982, 2020, oracle. all rights reserved.
connected to an idle instance.
sql> startup nomount
oracle instance started.
total system global area 1778384520 bytes
fixed size 8912520 bytes
variable size 943718400 bytes
database buffers 805306368 bytes
redo buffers 20447232 bytes
sql> show parameter sga
name type
------------------------------------ ----------------------
value
------------------------------
allow_group_access_to_sga boolean
false
lock_sga boolean
false
pre_page_sga boolean
true
sga_max_size big integer
1696m
sga_min_size big integer
name type
------------------------------------ ----------------------
value
------------------------------
0
sga_target big integer
0
unified_audit_sga_queue_size integer
1048576
sql> show parameter shared
name type
------------------------------------ ----------------------
value
------------------------------
hi_shared_memory_address integer
0
max_shared_servers integer
shared_memory_address integer
0
shared_pool_reserved_size big integer
45m
shared_pool_size big integer
name type
------------------------------------ ----------------------
value
------------------------------
900m
shared_server_sessions integer
shared_servers integer
0
sql> set linesize 1000 pagesize 1000
sql> col name for a80
sql> col owner for a20
sql> set hist on
sql> set serveroutput on
sql> /
sp2-0103: nothing in sql buffer to run.
sql> show parameter shared
name type value
------------------------------------ ---------------------- ------------------------------
hi_shared_memory_address integer 0
max_shared_servers integer
shared_memory_address integer 0
shared_pool_reserved_size big integer 45m
shared_pool_size big integer 900m
shared_server_sessions integer
shared_servers integer 0
sql> alter system set shared_pool_size=20g scope=spfile;
system altered.
sql> show parameter cache
name type value
------------------------------------ ---------------------- ------------------------------
client_result_cache_lag big integer 3000
client_result_cache_size big integer 0
data_transfer_cache_size big integer 0
db_16k_cache_size big integer 0
db_2k_cache_size big integer 0
db_32k_cache_size big integer 0
db_4k_cache_size big integer 0
db_8k_cache_size big integer 0
db_big_table_cache_percent_target string 0
db_cache_advice string on
db_cache_size big integer 768m
db_flash_cache_file string
db_flash_cache_size big integer 0
db_keep_cache_size big integer 0
db_recycle_cache_size big integer 0
object_cache_max_size_percent integer 10
object_cache_optimal_size integer 10240000
result_cache_max_result integer 5
result_cache_max_size big integer 0
result_cache_mode string manual
result_cache_remote_expiration integer 0
session_cached_cursors integer 50
sql> shutdown immediate
ora-01507: database not mounted
oracle instance shut down.
sql> sql> sql> sql> sql> startup
oracle instance started.
total system global area 2.2347e 10 bytes
fixed size 30142096 bytes
variable size 2.1475e 10 bytes
database buffers 805306368 bytes
redo buffers 36966400 bytes
database mounted.
database opened.
sql> select status from v$instance;
status
------------
open
sql> select open_mode from v$database;
open_mode
--------------------
read write
最后修改时间：2023-02-21 17:41:56
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【米乐app官网下载的版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。