1.2.2. 数据库迁移-从文件系统到ASM

SQL> archive log list;

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            /u01/oracle/10g/arch

Oldest online log sequence     7

Next log sequence to archive   9

Current log sequence           9

--查看参数文件和控制文件位置

SQL> show parameter spfile;

NAME                                 TYPE        VALUE

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

spfile                               string      /u01/oracle/10g/product/10.2.0

                                                /db_1/dbs/spfilegt10g.ora

SQL> show parameter control_files;

NAME                                 TYPE        VALUE

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

control_files                        string      /u01/oracle/10g/oradata/gt10g/

                                                control1.ctl

--参数文件和控制文件备份                                         

SQL> create pfile='/tmp/pfile1' from spfile;

File created.

SQL> alter database backup controlfile to'/tmp/controfile1';

Database altered.

--查看当前数据文件位置

SQL> select name from v$datafile

  2  union all

  3  select name from v$controlfile

  4  union all

  5  select name from v$tempfile

  6  union all

  7  select member from v$logfile;

NAME

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

/u01/oracle/10g/oradata/gt10g/system01.dbf

/u01/oracle/10g/oradata/gt10g/undotbs1.dbf

/u01/oracle/10g/oradata/gt10g/sysaux01.dbf

/u01/oracle/10g/oradata/gt10g/users01.dbf

/u01/oracle/10g/oradata/gt10g/gtlions01.dbf

/u01/oracle/10g/ora