Solved

Create copy of database from coldback up when oracle uses ASM

Posted on 2008-06-24
11
1,220 Views
Last Modified: 2013-12-18
Guys

I am in a pickle I need to copy a RAC ASM oracle 10g database from a linux box to a different linux server.

I have been advised that the simpliest method is to shutdown the database then copy the files. I have no problem doing this as I have done this many time before with a single NON RAC database in the past.

I found this to be a problem firstly because ASM makes the files invisible so I have found out how to sort this by using FTP and setting up a port.
Secondly when I shutdown the database and the instances I loose my FTP connection

Any Ideas how I can achieve this

Darren
0
Comment
Question by:DarrenJackson
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
  • 2
  • +2
11 Comments
 
LVL 35

Assisted Solution

by:Mark Geerlings
Mark Geerlings earned 143 total points
ID: 21858472
I think RMAN can do that for you, but I'm hardly a master of RMAN, and I've never used ASM, so I don't know the exact steps.  I think if you browse the RMAN documentation you should find the instructions for cloning a database via RMAN (whether it uses ASM or not).
0
 
LVL 29

Assisted Solution

by:MikeOM_DBA
MikeOM_DBA earned 143 total points
ID: 21858965
0
 
LVL 22

Assisted Solution

by:DrSQL
DrSQL earned 143 total points
ID: 21858974
Darren,
    not sure why you'd lose the FTP connection, that seems odd.  Unfortunately, for all the benfits ASM brings, it does add some complexity.  In order to clone a database using ASM you also have to clone the ASM repository.  The device names stored in there are not likely to be the same on your new box, so ASM won't be able to find anything.   Use RMAN to clone the database - it handles the transfer for you.  here's a doc: http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/ostspitr003.htm#sthref1982

Good luck!

0
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 21859007

Also with RMAN you can clone the db to non-ASM file system.

0
 

Author Comment

by:DarrenJackson
ID: 21859039
Guys thank you for the posts

I would like to use the clone feature but not sure how to create the clone then transport it to the new server
0
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 21859226
It should be possible to create the clone directly on the new server, you shouldn't need to create it first, then move/copy it.
0
 

Author Comment

by:DarrenJackson
ID: 21859254
any ideas how I would do this as at the moment I have drawn a blank
0
 
LVL 22

Expert Comment

by:DrSQL
ID: 21859346
The link I gave you:  http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/ostspitr003.htm#sthref1982

has step by step instructions (if you have RMAN).
0
 

Author Comment

by:DarrenJackson
ID: 21859376
ok will look in to this in more detail

Thank you
0
 
LVL 48

Assisted Solution

by:schwertner
schwertner earned 71 total points
ID: 21863763
Alternativelly you can do full Data Pump export and after that Import the file.

If you would like to do physical backup this will put some light over the problem

http://www.oracle.com/technology/products/database/asm/pdf/netapp_asm3329.pdf
0
 

Accepted Solution

by:
DarrenJackson earned 0 total points
ID: 21916117
I managed to find this doc on metalink that explains exactly how to do this

doc id 415579.1 How to Restore RMAN Disk  Backups of RAC database to single instance on Another Node

I am gratefull for all the help on this so I will prorata the points based upon posts

Thank you
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
constraint check 2 57
pivot rows to columns 1 46
Row_number in SQL 6 45
Excess Redo 3 32
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

696 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