Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Recreating database with backups on a different server

user645399Oct 21 2011 — edited Oct 28 2011
Dear buddies,

I am backing up with RMAN

Level 0 backup on Sundays and Level 1 backup on weekdays

Now, I want to recreate this database on another server.

Is it possible? I do not want to do duplicate or cloning.

Any suggestions?

What do we call this kind of recovery?

Should I be doing something like this?
Make a full backup all of current your database files instead of using the Level 0 or Level 1 backups.
Place all database files to same directories.
Create the Windows service if removed.
C:\> oradim.exe -new -sid <ORACLE_SID> -startmode -manual

Startup instance.
C:\> net start OracleService<ORACLE_SID>
C:\> sqlplus /nolog
SQL> connect / as sysdba
Thanks!
This post has been answered by Helios-GunesEROL on Oct 21 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 25 2011
Added on Oct 21 2011
35 comments
1,675 views