数据库迁移--RMAN copy文件系统到ASM

evan_china

1.思路

a.备份控制文件

b.修改控制文件位置参数

c.恢复控制文件

d.RMAN copy数据库到ASM

e.恢复数据库

f.重置temp表空间

g.重设redo log

h.检查

 

2.过程

a.备份控制文件

SQL> alter database backup controlfile to '/u01/rman/c_ldjfaoidjfal.ctl';

Database altered.

b.修改控制文件位置参数

SQL> show parameter control_files

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_files                        string      /u01/oradata/dblife/control01.
                                                 ctl, /u01/oradata/dblife/contr
                                                 ol02.ctl
SQL> alter system set control_files='+DATA/dblife/controlfile/control01.ctl' scope=spfile;

System altered.

c.恢复控制文件

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount
ORACLE instance started.

Total System Global Area  419430400 bytes
Fixed Size                  1219736 bytes
Variable Size             138412904 bytes
Database Buffers          272629760 bytes
Redo Buffers                7168000 bytes

 

RMAN> restore controlfile to '+DATA/dblife/controlfile/control01.ctl' from '/u01/rman/c_ldjfaoidjfal.ctl';

Starting restore at 04-JUN-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=45 devtype=DISK

channel ORA_DISK_1: copied control file copy
Finished restore at 04-JUN-11

d.RMAN copy数据库到ASM

RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

RMAN> backup as copy database format '+DATA';

Starting backup at 04-JUN-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=45 devtype=DISK
channel ORA_DISK_1: starting datafile copy
input datafile fno=00001 name=/u01/oradata/dblife/system01.dbf
output filename=+DATA/dblife/datafile/system.259.752971523 tag=TAG20110604T224522 recid=5 stamp=752971543
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile fno=00003 name=/u01/oradata/dblife/sysaux01.dbf
output filename=+DATA/dblife/datafile/sysaux.257.752971547 tag=TAG20110604T224522 recid=6 stamp=752971565
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile fno=00002 name=/u01/oradata/dblife/undotbs01.dbf
output filename=+DATA/dblife/datafile/undotbs.256.752971573 tag=TAG20110604T224522 recid=7 stamp=752971578
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile fno=00004 name=/u01/oradata/dblife/users01.dbf
output filename=+DATA/dblife/datafile/users.265.752971581 tag=TAG20110604T224522 recid=8 stamp=752971587
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
Finished backup at 04-JUN-11

RMAN-06497: WARNING: control file is not current, control file autobackup skipped

RMAN> switch database to copy;

datafile 1 switched to datafile copy "+DATA/dblife/datafile/system.259.752971523"
datafile 2 switched to datafile copy "+DATA/dblife/datafile/undotbs.256.752971573"
datafile 3 switched to datafile copy "+DATA/dblife/datafile/sysaux.257.752971547"
datafile 4 switched to datafile copy "+DATA/dblife/datafile/users.265.752971581"

 

e.恢复数据库

RMAN> recover database;

Starting recover at 04-JUN-11
using channel ORA_DISK_1

starting media recovery

archive log thread 1 sequence 1 is already on disk as file /u01/oradata/dblife/redo1_1.rdo
archive log filename=/u01/oradata/dblife/redo1_1.rdo thread=1 sequence=1
media recovery complete, elapsed time: 00:00:01
Finished recover at 04-JUN-11

RMAN> alter database open resetlogs;

database opened

 

f.重置temp表空间

SQL> select name from v$tempfile;

NAME
--------------------------------------------------------------------------------
/u01/oradata/dblife/temp01.dbf
SQL> alter tablespace temp add tempfile '+DATA';

Tablespace altered.

SQL> alter tablespace temp drop tempfile '/u01/oradata/dblife/temp01.dbf';

Tablespace altered.

SQL> select name from v$tempfile;

NAME
--------------------------------------------------------------------------------
+DATA/dblife/tempfile/temp.264.752972535

 

g.重设redo log

SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
/u01/oradata/dblife/redo1_1.rdo
/u01/oradata/dblife/redo1_2.rdo
/u01/oradata/dblife/redo2_1.rdo
/u01/oradata/dblife/redo2_2.rdo
/u01/oradata/dblife/redo3_1.rdo
/u01/oradata/dblife/redo3_2.rdo

6 rows selected.

SQL> set linesize 100
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 1 20971520 2 NO CURRENT 228140 04-JUN-11
2 1 0 20971520 2 YES UNUSED 0
3 1 0 20971520 2 YES UNUSED 0

SQL> alter database drop logfile group 2;

Database altered.

SQL> alter database add logfile group 2 '+data' size 50m;

Database altered.

SQL> alter database drop logfile group 3;

Database altered.

SQL> alter database add logfile group 3 '+data' size 50m;

Database altered.

SQL> alter system switch logfile;

System altered.

SQL> /

System altered.

SQL> alter system checkpoint;

System altered.

SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 7 20971520 2 YES INACTIVE 229878 04-JUN-11
2 1 8 52428800 1 YES INACTIVE 229891 04-JUN-11
3 1 9 52428800 1 NO CURRENT 229910 04-JUN-11

SQL> alter database drop logfile group 1;

Database altered.

SQL> alter database add logfile group 1 '+data' size 50m;

Database altered.

SQL> select member from v$logfile;

MEMBER
----------------------------------------------------------------------------------------------------
+DATA/dblife/onlinelog/group_1.260.752973041
+DATA/dblife/onlinelog/group_2.263.752972943
+DATA/dblife/onlinelog/group_3.262.752972959

h.检查数据库

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
+DATA/dblife/datafile/system.259.752971523
+DATA/dblife/datafile/undotbs.256.752971573
+DATA/dblife/datafile/sysaux.257.752971547
+DATA/dblife/datafile/users.265.752971581

SQL> select name from v$controlfile;

NAME
--------------------------------------------------------------------------------
+DATA/dblife/controlfile/control01.ctl

SQL> select name from v$tempfile;

NAME
--------------------------------------------------------------------------------
+DATA/dblife/tempfile/temp.264.752972535