Solved

Migrate Oracle Database from ASM to Non-ASM on a Windows server.

Posted on 2016-11-29
1
11 Views
Last Modified: 2016-11-29
Hi,

  I have this database that is currently running using ASM, and i need to migrate it to local file system, how can i do that ?

  It is a Windows server.

  Any tips or documentation can share for helping me on this ?

  Regards,

    Joe Echavarría -
0
Comment
Question by:joe_echavarria
1 Comment
 
LVL 73

Accepted Solution

by:
sdstuber earned 500 total points
Comment Utility
you can create new tablespaces in your filesystems and then move objects from tablespaces with datafiles in asm to the new ones.
that will work for your user schemas, and in many cases can be done online.

you can't do that for the SYSTEM tablespace though.

or, shutdown your database, and you can simply use asmcmd  cp command to copy files while they are offline. then alter database rename to tell the database where to find them.

then restart the db.

you could use both methods.  Use the first for user schemas, use the latter for system


you can also use RMAN to copy your files instead of asmcmd
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
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 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.

763 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

8 Experts available now in Live!

Get 1:1 Help Now