Forum Stats

  • 3,769,805 Users
  • 2,253,023 Discussions
  • 7,875,211 Comments

Discussions

restore slow

Alain
Alain Member Posts: 78 Bronze Badge

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?