Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Rman recovery data error case-- ORA-19573 error

2025-04-10 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Error case of rman recovery data

System environment:

Operating system: AIX 5300-08

Oracle: Oracle 10.2.0.1.0

Error phenomenon:

RMAN > restore datafile 4

Starting restore at 20-MAY-14

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: sid=139 devtype=DISK

Channel ORA_DISK_1: starting datafile backupset restore

Channel ORA_DISK_1: specifying datafile (s) to restore from backup set

Restoring datafile 00004 to / u01/app/oracle/oradata/prod/users01.dbf

Channel ORA_DISK_1: reading from backup piece / backup/inc0_PROD_2qp8omr6_1_1

RMAN-00571: =

RMAN-00569: = ERROR MESSAGE STACK FOLLOWS =

RMAN-00571: =

RMAN-03002: failure of restore command at 05/20/2014 12:19:41

ORA-19870: error reading backup piece / backup/inc0_PROD_2qp8omr6_1_1

ORA-19573: cannot obtain exclusive enqueue for datafile 4

I always thought there was something wrong with the backup, and I couldn't find the backup data file!

It turns out that DataBase forgot to datafile offline under open, causing this low-level error; after offline the data file, the problem is solved!

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report