SOLVED

ORA-19625 : error identifying file

Asked by OracleDba••12 views•oracle
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
ORA-19625 : error identifying file

RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;

Starting backup at 29-NOV-23

current log archived

using channel ORA_DISK_1

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of backup plus archivelog command at 29/11/2023 00:16:23

RMAN-06059: expected archived log not found, loss of archived log compromises recoverability

ORA-19625: error identifying file /u01/app/oracle/oradata/archive/1_241_850299214.arc

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3
#oracle#error

Solutions(1)

Accepted Solution
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
You can check your expire archive log list and

delete expired

archive log files from RMAN, If you really lost your archive log file and you are not able to collect this file.

RMAN> crosscheck archivelog all;

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=98 device type=DISK

validation failed for archived log

archived log file name=/u01/app/oracle/oradata/archive/1_241_850299214.arc RECID=351 STAMP=860457193

validation failed for archived log

archived log file name=/u01/app/oracle/oradata/archive/1_242_850299214.arc RECID=351 STAMP=860457670

validation succeeded for archived log

archived log file name=/u01/app/oracle/oradata/archive/1_243_850299214.arc RECID=352 STAMP=860458582

Crosschecked 3 objects

RMAN> DELETE EXPIRED ARCHIVELOG ALL;

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=98 device type=DISK

List of Archived Log Copies for database with db_unique_name ORA11GS

=====================================================================

Key     Thrd Seq     S Low Time

------- ---- ------- - ---------

2730    1    241     X 29-NOV-23

        Name: /u01/app/oracle/oradata/archive/1_241_850299214.arc

3002    1    242     X 29-NOV-23

        Name: /u01/app/oracle/oradata/archive/1_242_850299214.arc

Do you really want to delete the above objects (enter YES or NO)? yes

deleted archived log

archived log file name=/u01/app/oracle/oradata/archive/1_241_850299214.arc RECID=351 STAMP=860457193

deleted archived log

archived log file name=/u01/app/oracle/oradata/archive/1_242_850299214.arc RECID=351 STAMP=860457670

Deleted 2 EXPIRED objects

RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;

Starting backup at 29-NOV-23

current log archived

using channel ORA_DISK_1

channel ORA_DISK_1: starting archived log backup set

channel ORA_DISK_1: specifying archived log(s) in backup set

input archived log thread=1 sequence=243 RECID=352 STAMP=860458582

input archived log thread=1 sequence=244 RECID=353 STAMP=860459023

channel ORA_DISK_1: starting piece 1 at 29-NOV-23

channel ORA_DISK_1: finished piece 1 at 29-NOV-23

piece handle=/u01/rman_backup/ora11gs_bkp_1gpkj40g tag=TAG20141009T002344 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

channel ORA_DISK_1: deleting archived log(s)

archived log file name=/u01/app/oracle/oradata/archive/1_243_850299214.arc RECID=352 STAMP=860458582

archived log file name=/u01/app/oracle/oradata/archive/1_244_850299214.arc RECID=353 STAMP=860459023

Finished backup at 29-NOV-23

Starting backup at 29-NOV-23

using channel ORA_DISK_1

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00001 name=/u01/app/oracle/oradata/ora11gp/system01.dbf

input datafile file number=00002 name=/u01/app/oracle/oradata/ora11gp/sysaux01.dbf

input datafile file number=00003 name=/u01/app/oracle/oradata/ora11gp/undotbs01.dbf

input datafile file number=00004 name=/u01/app/oracle/oradata/ora11gp/users01.dbf

channel ORA_DISK_1: starting piece 1 at 29-NOV-23

channel ORA_DISK_1: finished piece 1 at 29-NOV-23

piece handle=/u01/rman_backup/ora11gs_bkp_1hpkj40h tag=TAG20141009T002345 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:01:25

Finished backup at 29-NOV-23

Starting backup at 29-NOV-23

current log archived

using channel ORA_DISK_1

channel ORA_DISK_1: starting archived log backup set

channel ORA_DISK_1: specifying archived log(s) in backup set

input archived log thread=1 sequence=245 RECID=354 STAMP=860459111

channel ORA_DISK_1: starting piece 1 at 29-NOV-23

channel ORA_DISK_1: finished piece 1 at 29-NOV-23

piece handle=/u01/rman_backup/ora11gs_bkp_1ipkj437 tag=TAG20141009T002511 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

channel ORA_DISK_1: deleting archived log(s)

archived log file name=/u01/app/oracle/oradata/archive/1_245_850299214.arc RECID=354 STAMP=860459111

Finished backup at 29-NOV-23

Starting Control File and SPFILE Autobackup at 29-NOV-23

piece handle=/u01/rman_backup/bkp_cf_c-3519562480-20141009-01 comment=NONE

Finished Control File and SPFILE Autobackup at 29-NOV-23

RMAN>

Hope it Helps!
OracleDba•

Post Your Solution