Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to solve Oracle RMAN restore test error ORA-19571", the content of the article is simple and clear, easy to learn and understand, now please follow the editor's train of thought slowly in depth, together to study and learn "how to solve Oracle RMAN restore test error ORA-19571" bar!

When verifying the validity of the database backup, in the middle of the test, there was an error that made me feel a little inexplicable.

RMAN-00571: =

RMAN-00569: = ERROR MESSAGE STACK FOLLOWS =

RMAN-00571: =

RMAN-03002: failure of restore command at 07/09/2019 10:55:02

ORA-19571: μ? Datafile copy RECID 261 STAMP 1013152438

ORA-19600: tafile-copy 261 ()

ORA-19601:? 3a datafile-copy 0 (/ db_backup/data_D-TESTDB_TS-SYSTEM_FNO-1)

Script executed:

Recovery Manager: Release 12.1.0.2.0-Production on Tuesday July 9 10:57:04 2019

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

Connected to target database: TESTDB (DBID=*, not open)

Connected to recovery catalog database

Recovery catalog schema release 18.03.00.00. Is newer than RMAN release

RMAN > run {

2 > allocate channel C1 type disk

3 > allocate channel c2 type disk

4 > allocate channel c3 type disk

5 > allocate channel c4 type disk

6 > set newname for database to'/ db_backup/%U'

7 > restore database

8 > switch datafile all

9 > recover database

10 > release channel C1

11 > release channel c2

12 > release channel c3

13 > release channel c4

14 >}

15 >

In the database tested, catalog database is used to manage backup metadata. When testing, because there has been a problem with the backup before, when restoring the test, execute the rm command at the operating system level for physical deletion. Restore again after deletion, and the above error occurs.

Solution:

RMAN > set backup files for device type disk to accessible;RMAN > crosscheck copy of database device type disk;RMAN > delete expired copy of database device type disk

After cleaning up the datafile copy of expired, the restore can proceed normally.

Of course, you need to connect to the catalog database to do the above.

Thank you for your reading, the above is the content of "how to solve Oracle RMAN restore test error ORA-19571", after the study of this article, I believe you have a deeper understanding of how to solve the problem of Oracle RMAN restore test error ORA-19571, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.