Re: Oracle Backup and Restore when just have *.dbf files

Edwinah63 wrote:
> i am using the backup utility in the OEM GUI (which i presume is RMAN)
> but i would prefer to stick to the scenario outlined above.
>
> i want to be able to cover all bases, if all i have is *.dbf files and
> i need to make them visible in a brand new database instance.
>
> thank you for asking :)

RMAN was used and you should use RMAN to restore.

I find it horrifying that you have a backup that you have never tested to see if you can restore. Horrifying that you don't have documented procedures, and a check-list, to take you step-by-proven-step through this.

I wish you success but you have all of the makings of a poster on "how not to manage an Oracle database."

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)