?
Solved

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

Posted on 2008-06-19
7
Medium Priority
?
1,100 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
5 Comments
 
LVL 74

Accepted Solution

by:
sdstuber earned 1000 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 74

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 74

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

601 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