How to migrate DB under File System management under ASM

Record an approximate process.

C:>sqlplus Sys/system@test as Sysdba

Sql*plus:release 10.2.0.1.0-production on Sunday October 11 19:08:22 2009

Copyright (c) 1982, +, Oracle. All rights reserved.

You are connected to an idle routine.

Sql> Startup

The ORACLE routine has started.

Total System Global area 167772160 bytes

Fixed Size 1247900 bytes

Variable Size 88081764 bytes

Database buffers 75497472 bytes

Redo buffers 2945024 bytes

Database loading complete.

The database is already open.

sql> ALTER DATABASE backup Controlfile to ' C:control01.ctl ';

The database has changed.

Sql> alter system set control_files= ' +DG ' scope=spfile;

The system has changed.

Sql> alter system set db_recovery_file_dest= ' +DG ';

The system has changed.

Sql> Show PARAMETER Db_recovery

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

Db_recovery_file_dest string +DG

Db_recovery_file_dest_size Big Integer 2G

Sql> Show PARAMETER db_name

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

Db_name string TEST

sql> shutdown Immediate

The database has been closed.

The database has been unloaded.

The ORACLE routine has been closed.

Sql> exit

From Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-production

With the partitioning, OLAP and Data Mining options disconnected

C:>rman Target Sys/system@test

Recovery manager: Release 10.2.0.1.0-production on Sunday October 11 19:11:40 2009

Copyright (c) 1982, +, Oracle. All rights reserved.

Connected to target database (not started)

Rman> Startup Nomount

Oracle instance started

System global Zone total 167772160 bytes

Fixed Size 1247900 bytes

Variable Size 88081764 bytes

Database buffers 75497472 bytes

Redo buffers 2945024 bytes

rman> restore Controlfile from ' c:control01.ctl ';

Start Restore in November-October-09

Replacing the recovery directory with the target database control file

Allocated channel: Ora_disk_1

Channel ora_disk_1:sid=156 Devtype=disk

Channel ora_disk_1: Copy of control file copied

Output filename =+dg/test/controlfile/current.271.699995579

Completed restore in November-October-09

Rman> ALTER DATABASE Mount;

The database is loaded

Channel Freed: Ora_disk_1

rman> Backup as Copy database format ' +DG ';

Start Backup in November-October-09

Start implicit crosscheck backup in November-October-09

Allocated channel: Ora_disk_1

Channel ora_disk_1:sid=152 Devtype=disk

Completed implicit crosscheck Backup in November-October-09

Start implicit crosscheck copy in November-October-09

Using channel Ora_disk_1

Completed implicit crosscheck copy in November-October-09

Search for all files in the recovery area

Compiling file directory ...

No directories are being compiled for files

Using channel Ora_disk_1

Channel Ora_disk_1: Start data file copy

Enter the data file fno=00001 name=c:oradatatestsystem01. Dbf

Output filename = +dg/test/datafile/system.272.699995623 Tag = tag20091011t191342 RE

CID = 1 time stamp = 699995675

Channel ora_disk_1: Data file copy completed, after time: 00:00:55

Channel Ora_disk_1: Start data file copy

Enter the data file fno=00002 name=c:oradatatestundotbs01. Dbf

Output filename = +dg/test/datafile/undotbs1.273.699995679 Mark = tag20091011t191342

RecId = 2 time stamp = 699995699

Channel ora_disk_1: Data file copy completed, after time: 00:00:25

Channel Ora_disk_1: Start data file copy

Enter the data file fno=00003 name=c:oradatatestsysaux01. Dbf

Output filename = +dg/test/datafile/sysaux.274.699995705 Tag = tag20091011t191342 RE

CID = 3 time stamp = 699995722

Channel ora_disk_1: Data file copy completed, after time: 00:00:25

Channel Ora_disk_1: Start data file copy

Enter the data file fno=00004 name=c:oradatatestusers01. Dbf

Output filename = +dg/test/datafile/users.275.699995729 tag = tag20091011t191342 Rec

id = 4 time stamp = 699995733

Channel ora_disk_1: Data file copy completed, after time: 00:00:07

Channel Ora_disk_1: Start data file copy

Enter the data file fno=00005 name=c:oradatatesttest. Dbf

Output filename = +dg/test/datafile/test.276.699995737 Mark = tag20091011t191342 Reci

D = 5 time stamp = 699995738

Channel ora_disk_1: Data file copy completed, after time: 00:00:03

Completed backup in November-October-09

RMAN-06497: Warning: Control file is not current version, control file automatic backup will be skipped

Rman>

rman> Recover database;

Started recover in November-October-09

Using channel Ora_disk_1

Beginning recovery of media

The archive log thread 1 sequence 22 has been c:oradatatestredo01 as a file. LOG exists on disk

Archive log filename =c:oradatatestredo01. LOG Thread =1 sequence =22

Media restore completed, when: 00:00:03

Completed recover in November-October-09

Rman> run{

2> switch Tempfile 1 to ' +DG ';

3>}

Temporary file 1 has been renamed to +DG in the control file

Rman> EXIT

Recovery manager complete.

C:>sqlplus Sys/system@test as Sysdba

Sql*plus:release 10.2.0.1.0-production on Sunday October 11 19:18:35 2009

Copyright (c) 1982, +, Oracle. All rights reserved.

Connect to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-production

With the partitioning, OLAP and Data Mining options

Sql>

Sql> Select member from V$logfile;

Member

--------------------------------------------------------------------------------

C:oradatatestredo01. LOG