Oracle DB Migration from File System to ASM

RMAN copy backup
RMAN> backup as copy database format ‘+DATA’;

FRA Configuration

SQL> alter system set db_recovery_file_dest_size=1800m;

System altered.

SQL> alter system set db_recovery_file_dest=’+FRA’;

System altered.

OMF Configuration

SQL> alter system set db_create_file_dest=’+DATA’;

System altered.

Spfile Configuration
SQL> create spfile=’+DATA/spfileprima.ora’ from memory;

File created.

For more info refer…
https://uhesse.com/2010/12/01/database-migration-to-asm-with-short-downtime/

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s