Solved

How to use RMAN to copy database from linux to windows with backupset

Posted on 2008-06-19
7
1,064 Views
Last Modified: 2013-12-18
Hello,

           I made a backupset of oracle 10g database on linux using RMAN. Now i want to duplicate this database on windows (XP) with this backupset. Is this possible? Can you tell me the detailed procedure to achive this?

Thank you very much
0
Comment
Question by:huer
  • 3
7 Comments
 
LVL 73

Accepted Solution

by:
sdstuber earned 250 total points
ID: 21821363
to change platforms you'll need to export and import,  create a new database on windows then export (standard or datapump version) from Linux and then import (standard or datapump version) to Windows
0
 

Author Comment

by:huer
ID: 21824990
So i cannot use the backupset to restore database on different platform.
0
 
LVL 73

Expert Comment

by:sdstuber
ID: 21825012
correct
0
 
LVL 27

Expert Comment

by:Tolomir
ID: 22700309
NACK.

a21821363 comment from sdstuber is right.

---> You cannot do that use instead: exp / imp


Also a knowledge base should keep  I'm sorry Dave, I'm afraid I can't do that answers.


0
 
LVL 73

Expert Comment

by:sdstuber
ID: 22701595
yes, I think my answer should be accepted even if it wasn't the answer the asker wanted.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle - Query Insert and Update multiple tables 5 57
case statement in where clause with not exist 15 46
Maintaining Oracle Managed Accounts 2 29
sql query 9 37
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now