Database Backup and Recovery (MOSC)

MOSC Banner

how to recover a datafile that was added during a backup-recovering is from ASM to file system

edited Dec 3, 2013 5:53AM in Database Backup and Recovery (MOSC) 11 commentsAnswered
I have a RAC database 11gr2 on ASM that while an rman backup was in progress, a datafile was added.
In a disaster recovery scenario we restored the database to single instance and a conventional file system.
The restore uses "set newname for database to '/p100/oradata/WFMRPRD/%b';"
When the restore encountered the new datafile, 26, an error occurred.
Is there a way to recover the database with the new datafile?

Starting restore at 25-NOV-2013 12:00:08

creating datafile file number=26 name=/p100/oradata/DSPRPRD/prod_oim_lob.287.832216777
released channel: dev_0
released channel: dev_1
released channel: dev_2
released channel: dev_3
released channel: dev1

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center