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

1 1 0 52428800 2 YESUNUSED 0

3 1 0 52428800 2 YES UNUSED 0

2 1 1 52428800 2 NO CURRENT 86338629-MAY-14

SQL> select * from v$logfile; --查找到第2日志组中的日志成员

GROUP# STATUS TYPE MEMBER IS_

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

3 ONLINE /u01/app/oracle/oradata/metro/redo03.log NO

2 ONLINE /u01/app/oracle/oradata/metro/redo02.log NO

1 ONLINE /u01/app/oracle/oradata/metro/redo01.log NO

1 ONLINE /disk1/metro/redofile/redo01a.log NO

2 ONLINE /disk1/metro/redofile/redo02a.log NO

3 ONLINE /disk1/metro/redofile/redo03a.log NO

--把查找到的对应日志sequence #为1的日志组成员填写至此，即为redo02.log

Specify log: {=suggested | filename | AUTO | CANCEL}

/u01/app/oracle/oradata/metro/redo02.log

Log applied.

Media recovery complete.

SQL> select status fromv$instance;

STATUS

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

MOUNTED

SQL> alter database open;

alter database open

*

ERROR at line 1:

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> alter database open resetlogs;

SQL> select status fromv$instance;

STATUS

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

OPEN

SQL> select NAME from v$datafile;

NAME

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

+DATA/METRO/DATAFILE/SYSTEM.264.848860609

+DATA/METRO/DATAFILE/UNDOTBS1.266.848860809

+DATA/METRO/DATAFILE/SYSAUX.263.848860607

+DATA/METRO/DATAFILE/USERS.267.848860815

+DATA/METRO/DATAFILE/EXAMPLE.265.848860723

--至此，数据文件转储到ASM

*****************************************************************************************

后期目标：迁移临时表空间、日志文件至ASM

*****************************************************************************************

SQL> select NAME fromv$tempfile; --查看临时表空间位置

NAME

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

/u01/app/oracle/oradata/metro/temp01.dbf

SQL> selectname,status,enabled from v$tempfile; --查看临时表空间状态

NAME STATUS ENABLED

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

/u01/app/oracle/oradata/metro/temp01.dbf ONLINE READ WRITE

SQL> alter tablespace tempadd tempfile '+DATA'; --添加ASM临时表空间

SQL> alter tablespace temp drop tempfile'/u01/app/oracle/oradata/metro/temp01.dbf';--删除原临时表空间

--下面来对日志文件进行迁移

SQL> set linesize 120

SQL> select * from v$log； --查看当前日志组状态

GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM

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

1 1 0 52428800 2 YESUNUSED 0

2 1 1 52428800 2 NO CURRENT 863885 29-MAY-14

3 1 0 52428800 2 YES UNUSED 0

--添加3组日志

SQL> alter database addlogfile '+DATA' SIZE 50m;

SQL> alter database addlogfile '+DATA' SIZE 50m;

SQL> alter database addlogfile '+DATA' SIZE 50m;

SQL> selectl.group#,l.sequence#,f.member as name,l.status,l.archived from v$logl,v$logfile f

2 where f.group#=l.group#

3 order by 1;--查看当日日志使用状态

GROUP# SEQUENCE# NAME STATUS ARC

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

1 0 /disk1/metro/redofile/redo01a.log UNUSED YES

1 0/u01/app/oracle/oradata/metro/redo01.log UNUSED YES

2 1/disk1/metro/redofile/redo02a.log CURRENT NO

2 1 /u01/app/oracle/oradata/metro/redo02.log CURRENT NO