How to Move a Datafile From File System To ASM Disk Group?

RMAN > sql "alter tablespace scott66 offline";

RMAN > copy datafile '/u01/app/oracle/oradata/ecdb3/scott1.dbf' to '+ORADATA';

RMAN > switch datafile 192 to copy;
OR
RMAN > alter database rename file '/u01/app/oracle/oradata/ecdb3/scott1.dbf' to '+ORADATA/ECDB/DATAFILE/eliteaaa66.592.860514885';

RMAN > sql "alter tablespace scott66 online";

🙂

http://taliphakanozturken.wordpress.com/2012/03/21/how-to-move-a-datafile-from-file-system-to-asm-disk-group/

http://www.sivakumardba.com/2012/10/convert-datafile-from-filesystem-into.html

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.