Database Backup and Recovery (MOSC)

MOSC Banner

How to restore a backup from another site into my Oracle Server

edited Jun 8, 2012 4:45AM in Database Backup and Recovery (MOSC) 4 comments
Hello All,

I requested an export dumpfile of a schema from a customer and they sent me what looks like a database backup file,i.e., it has all the database related files (Datafiles, Archived Redo Logs, SPFILEs, & Control Files).  Normally, I request and receive a dumpfile created via datapump, create a tablespace with proper user, grants, etc and import the dumpfile to into my Oracle server.  I have no experience in restoring a backup file in Oracle.  What do I use, Enterprise Manager or RMAN?  Also, their database is on RAC, so not sure if that has any impact to restoring on my Oracle server (non-RAC).  Can someone point me to the proper documentation for using OEM or RMAN in this scenario?    How does that affect my current instance?  Does the restore create a new

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