ORA-19625:ORA-27037处理过程执行输出

2025-3-14

ORA-19625: error identifying file
问题描述：rman进行备份的时候，出现报错ORA-19625，无效的文件

[oracle@mml1 dbs]$ rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Fri Mar 14 19:44:47 2025
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.

connected to target database: EISOO (DBID=4037090721)

RMAN> run{
allocate channel c1 type disk;
allocate channel c2 type disk;
backup database format '/u01/backdg/%U' plus archivelog;
backup format '/u01/backdg/%U' current controlfile ;
release channel c1;
release channel c2;
}
2> 3> 4> 5> 6> 7> 8>
using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=508 instance=eisoo1 device type=DISK

allocated channel: c2
channel c2: SID=632 instance=eisoo1 device type=DISK

Starting backup at 2025-03-14 19:44:57
current log archived
released channel: c1
released channel: c2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 03/14/2025 19:45:02
RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
ORA-19625: error identifying file /u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_3626_1186140644.dbf
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7

RMAN> change archivelog all crosscheck;

[oracle@mml1 dbs]$ cat initeisoo1.ora | grep spfile
[oracle@mml1 dbs]$ srvctl config database -d eisoo -a
Database unique name: eisoo
Database name: eisoo
Oracle home: /u01/app/oracle/product/19.3.0/dbhome_1
Oracle user: oracle
Spfile: /home/oracle/initeisoo1.ora
Password file: +DATA/EISOO/PASSWORD/pwdeisoo.258.1186140477
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DATA
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
Database is enabled
Database is individually enabled on nodes:
Database is individually disabled on nodes:
OSDBA group: dba
OSOPER group: oper
Database instances: eisoo1,eisoo2
Configured nodes: mml1,mml2
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed
[oracle@mml1 dbs]$ srvctl config database -d eisoo -p +DATA/EISOO/PARAMETERFILE/spfieeisoo.ora
PRKO-2002 : Invalid command line option: -p
[oracle@mml1 dbs]$ srvctl config database -d eisoo -p '+DATA/EISOO/PARAMETERFILE/spfieeisoo.ora'
PRKO-2002 : Invalid command line option: -p
[oracle@mml1 dbs]$ srvctl modify database -d eisoo -p '+DATA/EISOO/PARAMETERFILE/spfieeisoo.ora'
[oracle@mml1 dbs]$ srvctl modify database -d eisoo -p '+DATA/EISOO/PARAMETERFILE/spfieeisoo.ora'
[oracle@mml1 dbs]$ srvctl config database -d eisoo -a
Database unique name: eisoo
Database name: eisoo
Oracle home: /u01/app/oracle/product/19.3.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/EISOO/PARAMETERFILE/spfieeisoo.ora
Password file: +DATA/EISOO/PASSWORD/pwdeisoo.258.1186140477
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DATA
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
Database is enabled
Database is individually enabled on nodes:
Database is individually disabled on nodes:
OSDBA group: dba
OSOPER group: oper
Database instances: eisoo1,eisoo2
Configured nodes: mml1,mml2
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed
[oracle@mml1 dbs]$ exit
logout
[root@mml1 u01]# su - grid
Last login: Fri Mar 14 19:14:13 CST 2025
[grid@mml1 ~]$ srvctl stop database -d eisoo
[grid@mml1 ~]$ srvctl start database -d eisoo
[grid@mml1 ~]$
RMAN> crosscheck archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=508 instance=eisoo1 device type=DISK
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_12/thread_1_seq_3578.421.1190236909 RECID=6608 STAMP=1190236909
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_13/thread_1_seq_3579.496.1190247767 RECID=6610 STAMP=1190247774
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_13/thread_1_seq_3580.422.1190247779 RECID=6611 STAMP=1190247778
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_13/thread_1_seq_3581.367.1190258265 RECID=6614 STAMP=1190258266
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_13/thread_1_seq_3582.529.1190258271 RECID=6615 STAMP=1190258271
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_13/thread_1_seq_3583.472.1190268359 RECID=6618 STAMP=1190268360
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_13/thread_1_seq_3584.311.1190268365 RECID=6619 STAMP=1190268365
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_13/thread_1_seq_3585.325.1190284603 RECID=6622 STAMP=1190284604
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_13/thread_1_seq_3586.305.1190284609 RECID=6623 STAMP=1190284609
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_13/thread_1_seq_3587.509.1190307341 RECID=6626 STAMP=1190307342
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_13/thread_1_seq_3588.279.1190307347 RECID=6627 STAMP=1190307347
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_13/thread_1_seq_3589.459.1190322821 RECID=6630 STAMP=1190322823
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_13/thread_1_seq_3590.316.1190322827 RECID=6631 STAMP=1190322827
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_14/thread_1_seq_3591.291.1190386461 RECID=6634 STAMP=1190386467
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_14/thread_1_seq_3592.297.1190412543 RECID=6635 STAMP=1190412550
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_15/thread_1_seq_3593.426.1190487605 RECID=6636 STAMP=1190487615
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_16/thread_1_seq_3594.370.1190505931 RECID=6638 STAMP=1190505938
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_17/thread_1_seq_3595.407.1190621405 RECID=6640 STAMP=1190621412
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_17/thread_1_seq_3596.481.1190671301 RECID=6642 STAMP=1190671309
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_18/thread_1_seq_3597.409.1190714473 RECID=6643 STAMP=1190714479
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_18/thread_1_seq_3598.493.1190757683 RECID=6645 STAMP=1190757688
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_19/thread_1_seq_3599.532.1190800915 RECID=6646 STAMP=1190800922
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_19/thread_1_seq_3600.497.1190844117 RECID=6648 STAMP=1190844123
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_21/thread_1_seq_3601.272.1190959249 RECID=6650 STAMP=1190959257
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_22/thread_1_seq_3602.405.1191031215 RECID=6652 STAMP=1191031230
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_05/thread_1_seq_3603.494.1194968489 RECID=6655 STAMP=1194968497
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_05/thread_1_seq_3604.416.1194968499 RECID=6656 STAMP=1194968499
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_05/thread_1_seq_3605.372.1194971379 RECID=6660 STAMP=1194971396
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_05/thread_1_seq_3606.449.1194972831 RECID=6662 STAMP=1194972849
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_05/thread_1_seq_3607.312.1194972941 RECID=6664 STAMP=1194972940
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_05/thread_1_seq_3608.425.1194973379 RECID=6665 STAMP=1194973380
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_05/thread_1_seq_3609.378.1194973603 RECID=6667 STAMP=1194973603
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_06/thread_1_seq_3610.289.1195009235 RECID=6669 STAMP=1195009240
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_06/thread_1_seq_3611.466.1195032887 RECID=6671 STAMP=1195032888
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_07/thread_1_seq_3612.433.1195120833 RECID=6673 STAMP=1195120837
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_08/thread_1_seq_3613.309.1195252131 RECID=6676 STAMP=1195252135
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_10/thread_1_seq_3614.319.1195347621 RECID=6679 STAMP=1195347626
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_11/thread_1_seq_3615.410.1195477227 RECID=6681 STAMP=1195477231
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_11/thread_1_seq_3616.440.1195512345 RECID=6682 STAMP=1195512349
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_11/thread_1_seq_3617.471.1195514375 RECID=6685 STAMP=1195514374
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_13/thread_1_seq_3618.488.1195610437 RECID=6687 STAMP=1195610443
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_14/thread_1_seq_3619.307.1195707601 RECID=6689 STAMP=1195707608
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_14/thread_1_seq_3620.505.1195724581 RECID=6694 STAMP=1195724583
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_14/thread_1_seq_3621.374.1195724881 RECID=6697 STAMP=1195724881
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_14/thread_1_seq_3622.384.1195725629 RECID=6703 STAMP=1195725629
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_14/thread_1_seq_3623.530.1195725801 RECID=6707 STAMP=1195725800
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_14/thread_1_seq_3624.395.1195725881 RECID=6710 STAMP=1195725880
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_14/thread_1_seq_3625.439.1195728563 RECID=6712 STAMP=1195728563
validation failed for archived log
archived log file name=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_3626_1186140644.dbf RECID=6715 STAMP=1195751441
validation failed for archived log
archived log file name=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_3627_1186140644.dbf RECID=6716 STAMP=1195751441
validation succeeded for archived log
archived log file name=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_3628_1186140644.dbf RECID=6717 STAMP=1195751919
validation failed for archived log
archived log file name=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_3629_1186140644.dbf RECID=6719 STAMP=1195758260
validation failed for archived log
archived log file name=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_3630_1186140644.dbf RECID=6720 STAMP=1195758261
validation succeeded for archived log
archived log file name=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_3631_1186140644.dbf RECID=6721 STAMP=1195758526
validation succeeded for archived log
archived log file name=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_3632_1186140644.dbf RECID=6722 STAMP=1195759197
validation succeeded for archived log
archived log file name=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_3633_1186140644.dbf RECID=6724 STAMP=1195760398
validation succeeded for archived log
archived log file name=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_3634_1186140644.dbf RECID=6726 STAMP=1195760698
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_12/thread_2_seq_3034.336.1190236907 RECID=6607 STAMP=1190236907
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_13/thread_2_seq_3035.281.1190247765 RECID=6609 STAMP=1190247772
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_13/thread_2_seq_3036.351.1190247781 RECID=6612 STAMP=1190247780
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_13/thread_2_seq_3037.327.1190258263 RECID=6613 STAMP=1190258263
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_13/thread_2_seq_3038.369.1190258271 RECID=6616 STAMP=1190258271
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_13/thread_2_seq_3039.474.1190268357 RECID=6617 STAMP=1190268358
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_13/thread_2_seq_3040.412.1190268365 RECID=6620 STAMP=1190268366
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_13/thread_2_seq_3041.388.1190284601 RECID=6621 STAMP=1190284603
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_13/thread_2_seq_3042.468.1190284609 RECID=6624 STAMP=1190284609
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_13/thread_2_seq_3043.399.1190307339 RECID=6625 STAMP=1190307340
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_13/thread_2_seq_3044.343.1190307347 RECID=6628 STAMP=1190307347
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_13/thread_2_seq_3045.487.1190322819 RECID=6629 STAMP=1190322821
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_13/thread_2_seq_3046.282.1190322829 RECID=6632 STAMP=1190322829
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_14/thread_2_seq_3047.482.1190365247 RECID=6633 STAMP=1190365263
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_15/thread_2_seq_3048.478.1190487609 RECID=6637 STAMP=1190487618
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_16/thread_2_seq_3049.396.1190584849 RECID=6639 STAMP=1190584862
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_17/thread_2_seq_3050.446.1190660407 RECID=6641 STAMP=1190660413
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_18/thread_2_seq_3051.464.1190750839 RECID=6644 STAMP=1190750845
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_19/thread_2_seq_3052.453.1190844029 RECID=6647 STAMP=1190844035
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_20/thread_2_seq_3053.292.1190930423 RECID=6649 STAMP=1190930438
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_21/thread_2_seq_3054.364.1190970029 RECID=6651 STAMP=1190970036
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_01_22/thread_2_seq_3055.442.1191031217 RECID=6653 STAMP=1191031232
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_05/thread_2_seq_3056.476.1194968483 RECID=6654 STAMP=1194968494
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_05/thread_2_seq_3057.397.1194968605 RECID=6657 STAMP=1194968614
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_05/thread_2_seq_3058.486.1194968737 RECID=6658 STAMP=1194968749
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_05/thread_2_seq_3059.283.1194969605 RECID=6659 STAMP=1194969630
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_05/thread_2_seq_3060.287.1194972835 RECID=6661 STAMP=1194972847
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_05/thread_2_seq_3061.415.1194972857 RECID=6663 STAMP=1194972866
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_05/thread_2_seq_3062.479.1194973383 RECID=6666 STAMP=1194973384
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_05/thread_2_seq_3063.334.1194973609 RECID=6668 STAMP=1194973609
validation failed for archived log
archived log file name=/backupsoft/AnyBackupClient/ClientService/Oracle/orascript_oracle/thread_2_seq_3064.371.1195032879 RECID=6672 STAMP=1195032953
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_06/thread_2_seq_3064.371.1195032879 RECID=6670 STAMP=1195032880
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_07/thread_2_seq_3065.290.1195164037 RECID=6674 STAMP=1195164051
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_08/thread_2_seq_3066.390.1195207375 RECID=6675 STAMP=1195207380
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_09/thread_2_seq_3067.363.1195268459 RECID=6677 STAMP=1195268465
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_09/thread_2_seq_3068.359.1195335029 RECID=6678 STAMP=1195335034
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_10/thread_2_seq_3069.338.1195423227 RECID=6680 STAMP=1195423237
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_11/thread_2_seq_3070.418.1195512345 RECID=6683 STAMP=1195512352
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_11/thread_2_seq_3071.318.1195514373 RECID=6684 STAMP=1195514374
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_12/thread_2_seq_3072.462.1195596033 RECID=6686 STAMP=1195596044
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_13/thread_2_seq_3073.413.1195668019 RECID=6688 STAMP=1195668027
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_14/thread_2_seq_3074.507.1195724565 RECID=6690 STAMP=1195724572
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_14/thread_2_seq_3075.365.1195724585 RECID=6696 STAMP=1195724584
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_14/thread_2_seq_3076.521.1195725629 RECID=6702 STAMP=1195725629
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_14/thread_2_seq_3077.517.1195725801 RECID=6706 STAMP=1195725800
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_14/thread_2_seq_3078.329.1195725881 RECID=6711 STAMP=1195725881
validation succeeded for archived log
archived log file name=+DATA/EISOO/ARCHIVELOG/2025_03_14/thread_2_seq_3079.461.1195728563 RECID=6713 STAMP=1195728563
validation failed for archived log
archived log file name=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch2_3080_1186140644.dbf RECID=6714 STAMP=1195751440
validation failed for archived log
archived log file name=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch2_3081_1186140644.dbf RECID=6718 STAMP=1195758232
validation failed for archived log
archived log file name=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch2_3082_1186140644.dbf RECID=6723 STAMP=1195759200
validation succeeded for archived log
archived log file name=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch2_3083_1186140644.dbf RECID=6725 STAMP=1195760399
validation succeeded for archived log
archived log file name=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch2_3084_1186140644.dbf RECID=6727 STAMP=1195760700
Crosschecked 109 objects

RMAN> delete expired archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=508 instance=eisoo1 device type=DISK
List of Archived Log Copies for database with db_unique_name EISOO
=====================================================================

Key Thrd Seq S Low Time
------- ---- ------- - -------------------
6715 1 3626 X 2025-03-14 10:49:22
Name: /u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_3626_1186140644.dbf

6716 1 3627 X 2025-03-14 16:36:20
Name: /u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_3627_1186140644.dbf

6719 1 3629 X 2025-03-14 17:18:38
Name: /u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_3629_1186140644.dbf

6720 1 3630 X 2025-03-14 19:03:49
Name: /u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_3630_1186140644.dbf

6672 2 3064 X 2025-03-05 17:06:48
Name: /backupsoft/AnyBackupClient/ClientService/Oracle/orascript_oracle/thread_2_seq_3064.371.1195032879

6714 2 3080 X 2025-03-14 10:49:23
Name: /u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch2_3080_1186140644.dbf

6718 2 3081 X 2025-03-14 17:10:38
Name: /u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch2_3081_1186140644.dbf

6723 2 3082 X 2025-03-14 19:03:51
Name: /u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch2_3082_1186140644.dbf

Do you really want to delete the above objects (enter YES or NO)? yes
deleted archived log
archived log file name=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_3626_1186140644.dbf RECID=6715 STAMP=1195751441
deleted archived log
archived log file name=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_3627_1186140644.dbf RECID=6716 STAMP=1195751441
deleted archived log
archived log file name=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_3629_1186140644.dbf RECID=6719 STAMP=1195758260
deleted archived log
archived log file name=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_3630_1186140644.dbf RECID=6720 STAMP=1195758261
deleted archived log
archived log file name=/backupsoft/AnyBackupClient/ClientService/Oracle/orascript_oracle/thread_2_seq_3064.371.1195032879 RECID=6672 STAMP=1195032953
deleted archived log
archived log file name=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch2_3080_1186140644.dbf RECID=6714 STAMP=1195751440
deleted archived log
archived log file name=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch2_3081_1186140644.dbf RECID=6718 STAMP=1195758232
deleted archived log
archived log file name=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch2_3082_1186140644.dbf RECID=6723 STAMP=1195759200
Deleted 8 EXPIRED objects

RMAN> run{
allocate channel c1 type disk;
allocate channel c2 type disk;
backup database format '/u01/backdg/%U' plus archivelog;
backup format '/u01/backdg/%U' current controlfile ;
release channel c1;
release channel c2;
}
2> 3> 4> 5> 6> 7> 8>
released channel: ORA_DISK_1
allocated channel: c1
channel c1: SID=508 instance=eisoo1 device type=DISK

allocated channel: c2
channel c2: SID=632 instance=eisoo1 device type=DISK

Starting backup at 2025-03-14 19:48:04
current log archived
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=3578 RECID=6608 STAMP=1190236909
input archived log thread=2 sequence=3034 RECID=6607 STAMP=1190236907
input archived log thread=2 sequence=3035 RECID=6609 STAMP=1190247772
input archived log thread=1 sequence=3579 RECID=6610 STAMP=1190247774
input archived log thread=2 sequence=3036 RECID=6612 STAMP=1190247780
input archived log thread=1 sequence=3580 RECID=6611 STAMP=1190247778
input archived log thread=1 sequence=3581 RECID=6614 STAMP=1190258266
input archived log thread=2 sequence=3037 RECID=6613 STAMP=1190258263
input archived log thread=2 sequence=3038 RECID=6616 STAMP=1190258271
input archived log thread=1 sequence=3582 RECID=6615 STAMP=1190258271
input archived log thread=1 sequence=3583 RECID=6618 STAMP=1190268360
input archived log thread=2 sequence=3039 RECID=6617 STAMP=1190268358
input archived log thread=2 sequence=3040 RECID=6620 STAMP=1190268366
input archived log thread=1 sequence=3584 RECID=6619 STAMP=1190268365
input archived log thread=1 sequence=3585 RECID=6622 STAMP=1190284604
input archived log thread=2 sequence=3041 RECID=6621 STAMP=1190284603
input archived log thread=2 sequence=3042 RECID=6624 STAMP=1190284609
input archived log thread=1 sequence=3586 RECID=6623 STAMP=1190284609
input archived log thread=1 sequence=3587 RECID=6626 STAMP=1190307342
input archived log thread=2 sequence=3043 RECID=6625 STAMP=1190307340
input archived log thread=2 sequence=3044 RECID=6628 STAMP=1190307347
input archived log thread=1 sequence=3588 RECID=6627 STAMP=1190307347
input archived log thread=1 sequence=3589 RECID=6630 STAMP=1190322823
input archived log thread=2 sequence=3045 RECID=6629 STAMP=1190322821
input archived log thread=2 sequence=3046 RECID=6632 STAMP=1190322829
input archived log thread=1 sequence=3590 RECID=6631 STAMP=1190322827
input archived log thread=1 sequence=3591 RECID=6634 STAMP=1190386467
input archived log thread=2 sequence=3047 RECID=6633 STAMP=1190365263
input archived log thread=2 sequence=3048 RECID=6637 STAMP=1190487618
input archived log thread=1 sequence=3592 RECID=6635 STAMP=1190412550
input archived log thread=1 sequence=3593 RECID=6636 STAMP=1190487615
input archived log thread=1 sequence=3594 RECID=6638 STAMP=1190505938
input archived log thread=2 sequence=3049 RECID=6639 STAMP=1190584862
input archived log thread=1 sequence=3595 RECID=6640 STAMP=1190621412
input archived log thread=2 sequence=3050 RECID=6641 STAMP=1190660413
input archived log thread=1 sequence=3596 RECID=6642 STAMP=1190671309
input archived log thread=2 sequence=3051 RECID=6644 STAMP=1190750845
input archived log thread=1 sequence=3597 RECID=6643 STAMP=1190714479
input archived log thread=1 sequence=3598 RECID=6645 STAMP=1190757688
input archived log thread=2 sequence=3052 RECID=6647 STAMP=1190844035
input archived log thread=1 sequence=3599 RECID=6646 STAMP=1190800922
input archived log thread=1 sequence=3600 RECID=6648 STAMP=1190844123
input archived log thread=2 sequence=3053 RECID=6649 STAMP=1190930438
input archived log thread=1 sequence=3601 RECID=6650 STAMP=1190959257
input archived log thread=2 sequence=3054 RECID=6651 STAMP=1190970036
input archived log thread=1 sequence=3602 RECID=6652 STAMP=1191031230
input archived log thread=2 sequence=3055 RECID=6653 STAMP=1191031232
input archived log thread=1 sequence=3603 RECID=6655 STAMP=1194968497
channel c1: starting piece 1 at 2025-03-14 19:48:11
channel c2: starting archived log backup set
channel c2: specifying archived log(s) in backup set
input archived log thread=2 sequence=3056 RECID=6654 STAMP=1194968494
input archived log thread=1 sequence=3604 RECID=6656 STAMP=1194968499
input archived log thread=2 sequence=3057 RECID=6657 STAMP=1194968614
input archived log thread=2 sequence=3058 RECID=6658 STAMP=1194968749
input archived log thread=2 sequence=3059 RECID=6659 STAMP=1194969630
input archived log thread=2 sequence=3060 RECID=6661 STAMP=1194972847
input archived log thread=1 sequence=3605 RECID=6660 STAMP=1194971396
input archived log thread=1 sequence=3606 RECID=6662 STAMP=1194972849
input archived log thread=1 sequence=3607 RECID=6664 STAMP=1194972940
input archived log thread=2 sequence=3061 RECID=6663 STAMP=1194972866
input archived log thread=2 sequence=3062 RECID=6666 STAMP=1194973384
input archived log thread=1 sequence=3608 RECID=6665 STAMP=1194973380
input archived log thread=1 sequence=3609 RECID=6667 STAMP=1194973603
input archived log thread=2 sequence=3063 RECID=6668 STAMP=1194973609
input archived log thread=1 sequence=3610 RECID=6669 STAMP=1195009240
input archived log thread=2 sequence=3064 RECID=6670 STAMP=1195032880
input archived log thread=1 sequence=3611 RECID=6671 STAMP=1195032888
input archived log thread=2 sequence=3065 RECID=6674 STAMP=1195164051
input archived log thread=1 sequence=3612 RECID=6673 STAMP=1195120837
input archived log thread=1 sequence=3613 RECID=6676 STAMP=1195252135
input archived log thread=2 sequence=3066 RECID=6675 STAMP=1195207380
input archived log thread=2 sequence=3067 RECID=6677 STAMP=1195268465
input archived log thread=1 sequence=3614 RECID=6679 STAMP=1195347626
input archived log thread=2 sequence=3068 RECID=6678 STAMP=1195335034
input archived log thread=2 sequence=3069 RECID=6680 STAMP=1195423237
input archived log thread=1 sequence=3615 RECID=6681 STAMP=1195477231
input archived log thread=2 sequence=3070 RECID=6683 STAMP=1195512352
input archived log thread=1 sequence=3616 RECID=6682 STAMP=1195512349
input archived log thread=1 sequence=3617 RECID=6685 STAMP=1195514374
input archived log thread=2 sequence=3071 RECID=6684 STAMP=1195514374
input archived log thread=2 sequence=3072 RECID=6686 STAMP=1195596044
input archived log thread=1 sequence=3618 RECID=6687 STAMP=1195610443
input archived log thread=2 sequence=3073 RECID=6688 STAMP=1195668027
input archived log thread=1 sequence=3619 RECID=6689 STAMP=1195707608
input archived log thread=2 sequence=3074 RECID=6690 STAMP=1195724572
input archived log thread=1 sequence=3620 RECID=6694 STAMP=1195724583
input archived log thread=2 sequence=3075 RECID=6696 STAMP=1195724584
input archived log thread=1 sequence=3621 RECID=6697 STAMP=1195724881
input archived log thread=2 sequence=3076 RECID=6702 STAMP=1195725629
input archived log thread=1 sequence=3622 RECID=6703 STAMP=1195725629
input archived log thread=2 sequence=3077 RECID=6706 STAMP=1195725800
input archived log thread=1 sequence=3623 RECID=6707 STAMP=1195725800
input archived log thread=2 sequence=3078 RECID=6711 STAMP=1195725881
input archived log thread=1 sequence=3624 RECID=6710 STAMP=1195725880
input archived log thread=2 sequence=3079 RECID=6713 STAMP=1195728563
input archived log thread=1 sequence=3625 RECID=6712 STAMP=1195728563
input archived log thread=1 sequence=3628 RECID=6717 STAMP=1195751919
input archived log thread=1 sequence=3631 RECID=6721 STAMP=1195758526
input archived log thread=1 sequence=3632 RECID=6722 STAMP=1195759197
input archived log thread=1 sequence=3633 RECID=6724 STAMP=1195760398
input archived log thread=2 sequence=3083 RECID=6725 STAMP=1195760399
input archived log thread=1 sequence=3634 RECID=6726 STAMP=1195760698
channel c2: starting piece 1 at 2025-03-14 19:49:26
channel c1: finished piece 1 at 2025-03-14 19:53:41
piece handle=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/9m3kbn7q_1_1 tag=TAG20250314T194807 comment=NONE
channel c1: backup set complete, elapsed time: 00:05:30
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=2 sequence=3084 RECID=6727 STAMP=1195760700
input archived log thread=1 sequence=3635 RECID=6729 STAMP=1195760886
input archived log thread=2 sequence=3085 RECID=6728 STAMP=1195760886
channel c1: starting piece 1 at 2025-03-14 19:53:48
channel c1: finished piece 1 at 2025-03-14 19:54:23
piece handle=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/9o3kbni9_1_1 tag=TAG20250314T194807 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:35
channel c2: finished piece 1 at 2025-03-14 19:54:33
piece handle=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/9n3kbn7s_1_1 tag=TAG20250314T194807 comment=NONE
channel c2: backup set complete, elapsed time: 00:05:07
Finished backup at 2025-03-14 19:54:33

Starting backup at 2025-03-14 19:54:34
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00003 name=+DATA/EISOO/sysaux01.dbf
input datafile file number=00007 name=+DATA/EISOO/users01.dbf
channel c1: starting piece 1 at 2025-03-14 19:54:35
channel c2: starting full datafile backup set
channel c2: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/EISOO/system01.dbf
input datafile file number=00004 name=+DATA/EISOO/undotbs01.dbf
input datafile file number=00005 name=+DATA/EISOO/undotbs02.dbf
channel c2: starting piece 1 at 2025-03-14 19:54:35
channel c2: finished piece 1 at 2025-03-14 19:57:00
piece handle=/u01/backdg/9q3kbnjr_1_1 tag=TAG20250314T195434 comment=NONE
channel c2: backup set complete, elapsed time: 00:02:25
channel c1: finished piece 1 at 2025-03-14 19:57:10
piece handle=/u01/backdg/9p3kbnjr_1_1 tag=TAG20250314T195434 comment=NONE
channel c1: backup set complete, elapsed time: 00:02:35
Finished backup at 2025-03-14 19:57:10

Starting backup at 2025-03-14 19:57:10
current log archived
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=2 sequence=3086 RECID=6731 STAMP=1195761433
channel c1: starting piece 1 at 2025-03-14 19:57:13
channel c2: starting archived log backup set
channel c2: specifying archived log(s) in backup set
input archived log thread=1 sequence=3636 RECID=6730 STAMP=1195761431
channel c2: starting piece 1 at 2025-03-14 19:57:14
channel c1: finished piece 1 at 2025-03-14 19:57:17
piece handle=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/9r3kbnop_1_1 tag=TAG20250314T195713 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:04
channel c2: finished piece 1 at 2025-03-14 19:57:17
piece handle=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/9s3kbnoq_1_1 tag=TAG20250314T195713 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:03
Finished backup at 2025-03-14 19:57:17

Starting backup at 2025-03-14 19:57:17
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
including current control file in backup set
channel c1: starting piece 1 at 2025-03-14 19:57:33
channel c1: finished piece 1 at 2025-03-14 19:57:40
piece handle=/u01/backdg/9t3kbnou_1_1 tag=TAG20250314T195718 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:07
Finished backup at 2025-03-14 19:57:40

Starting Control File and SPFILE Autobackup at 2025-03-14 19:57:41
piece handle=+DATA/dir/c-4037090721-20250314-01 comment=NONE
Finished Control File and SPFILE Autobackup at 2025-03-14 19:58:06

released channel: c1

released channel: c2

RMAN>

版权声明 1 本网站名称：EDUG博客
2 本站永久网址：https://www.edug.net/
3 本网站的文章部分内容可能来源于网络，仅供大家学习与参考，如有侵权，请联系站长 QQ2571176258进行删除处理。
4 本站一切资源不代表本站立场，并不代表本站赞同其观点和对其真实性负责。
5 本站一律禁止以任何方式发布或转载任何违法的相关信息，访客发现请向站长举报
6 本站资源大多存储在云盘，如发现链接失效，请联系我们我们会第一时间更新。
7 如无特别声明本文即为原创文章仅代表个人观点，版权归《EDUG博客》所有，欢迎转载，转载请保留原文链接。
THE END
ORACLE RAC中SPFILE文件路径修改
<<上一篇
相关推荐
ORA-19625:ORA-27037处理过程执行输出
MySQL数据库root密码忘记的三种解决方法
Linux操作系统恢复后启动出现dracut-initqueue[xxx]: Warning: dracut-initqueue timeout
Linux系统双网卡如何绑定
Oracle 安装包一览
Linux 系统镜像一览：
SSH连接时出现Host key verification failed的原因及解决方法以及ssh-keygen命令的用法
[Xtrabackup] failed to execute query ‘LOCK INSTANCE FOR BACKUP’ : 1227 (42000) Access denied; you need (at least one of) the BACKUP_ADMIN privilege(s) for this operation
版权声明：本站部分内容/图片收集自互联网，如果无意中侵犯了您的权益，请来信告知，请联系我们立即删除，谢谢！
邮箱：2571176258@qq.com