Thinking Out Loud

June 7, 2014

Learning RMAN is like learning to ride a bike

Filed under: 11g,oracle,RMAN — mdinh @ 12:13 am

For almost five years, I have used RMAN very minimally.

Luckily, learning RMAN is like learning to ride a bike. One may not be able to perform wheelie, but one does not forget.

Please allow me to share the details on how to restore database to a new server, new database name, and new location using RMAN.

Summary:

At source, database is using OMF and backup is located at /oradata/backup.
At target, database is not using OMF and backup is copied from source to /oradata/bkup.

Database was renamed from SAN to DB02.

Detail’s here

About these ads

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

The Rubric Theme. Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 302 other followers

%d bloggers like this: