Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1228
  • Last Modified:

Create copy of database from coldback up when oracle uses ASM

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
DarrenJackson
Asked:
DarrenJackson
  • 4
  • 2
  • 2
  • +2
5 Solutions
 
Mark GeerlingsDatabase AdministratorCommented:
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
 
DrSQLCommented:
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
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
MikeOM_DBACommented:

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

0
 
DarrenJacksonAuthor Commented:
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
 
Mark GeerlingsDatabase AdministratorCommented:
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
 
DarrenJacksonAuthor Commented:
any ideas how I would do this as at the moment I have drawn a blank
0
 
DrSQLCommented:
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
 
DarrenJacksonAuthor Commented:
ok will look in to this in more detail

Thank you
0
 
schwertnerCommented:
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
 
DarrenJacksonAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 4
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now