Archive files are deleted mistakenly form my Database and RMAN show ORA-19625 error identifying file string
====================================================================================================
Suddenly one of my DBA member deleted some Archive log files mistakenly. and he don't told me.but when he run RMAN backup script. he found ORA-19625 error. then he told me that.
Solution of this problem:-
==========================
Run in RMAN command line,
RMAN> CROSSCHECK ARCHIVELOG ALL;
RMAN> DELETE EXPIRED ARCHIVELOG ALL;
The first command verifies the list of archivelogs in the
controlfile with those actually present on disk. Files that
are not found on disk (those that were deleted
by mistake) will be marked as "EXPIRED".
The second command then identifies all the "EXPIRED" files,
presents the list to you and asks you to confirm if they
should be deleted -- meaning that they will be deleted from
the controlfile. RMAN, at the next backup run (or a backup that
you initiate immediately thereafter) will not look for
these files and will not error.
Halim, a Georgia Tech graduate Senior Database Engineer/Data Architect based in Atlanta, USA, is an Oracle OCP DBA and Developer, Certified Cloud Architect Professional, and OCI Autonomous Database Specialist. With extensive expertise in database design, configuration, tuning, capacity planning, RAC, DG, scripting, Python, APEX, and PL/SQL, he combines technical mastery with a passion for innovation. Notably, Halim secured 16th place worldwide in PL/SQL Challenge Cup Playoff on the year 2010.
Saturday, January 15, 2011
Archive files are deleted mistakenly form my Database and RMAN show ORA-19625 error identifying file string
Labels:
rman
Subscribe to:
Post Comments (Atom)
My Blog List
-
-
-
ASSM states3 weeks ago
-
UKOUG Discover 20241 month ago
-
-
-
-
-
-
-
-
Moving Sideways8 years ago
-
-
Upcoming Events...11 years ago
-
No comments:
Post a Comment