Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
restore slow

Hi,
an exadata x3/2 of a customer crashed. Problems with disks and ASM high redundancy doesn't help.
There was an 11.2 EE database on it (among others). (linux 6 x86_64)
I am trying to restore db to a new system to get data back.
using oracle 11.2.0.4 rman : errors during restore
channel d6: restoring datafile 00005 to +DATAC/cnamcs/datafile/maintbs.267.1042150803
channel d6: restoring section 217 of 217
channel d1: ORA-19870: error while restoring backup piece /backup_db/cnamcs/rman/level0/base_8puu3ql0_212_1
ORA-19563: datafile header validation failed for file +DATAC/cnamcs/datafile/maintbs.267.1042150803
=> headers corrupted. Metalink shows fixes in PSU 201906, but customer didn't pay.
So I tried the restore from a 12.2 database.
It takes hours du restore 1 pieces out of 217:
...
channel d2: piece handle=/backup_db/cnamcs/rman/level0/base_8puu3ql0_5_1 tag=BACKUP_BASE_DB
channel d2: restored backup piece 5
channel d2: restore complete, elapsed time: 09:26:14
channel d2: starting datafile backup set restore
channel d2: specifying datafile(s) to restore from backup set
channel d2: restoring datafile 00005 to +DATAC/CNAMCS/DATAFILE/maintbs.266.1042218047
channel d2: restoring section 11 of 217
channel d2: reading from backup piece /backup_db/cnamcs/rman/level0/base_8puu3ql0_11_1
channel d1: piece handle=/backup_db/cnamcs/rman/level0/base_8puu3ql0_6_1 tag=BACKUP_BASE_DB
channel d1: restored backup piece 6
channel d1: restore complete, elapsed time: 09:26:46
channel d1: starting datafile backup set restore
channel d1: specifying datafile(s) to restore from backup set
channel d1: restoring datafile 00005 to +DATAC/CNAMCS/DATAFILE/maintbs.266.1042218047
channel d1: restoring section 12 of 217
channel d1: reading from backup piece /backup_db/cnamcs/rman/level0/base_8puu3ql0_12_1
....
Any hint to speed this up?