[oracle@gtser1 ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.5.0 - Production on MonFeb 25 16:41:04 2013

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release10.2.0.5.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and RealApplication Testing options

SQL> archive log list;

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            +FRA

Oldest online log sequence     13

Next log sequence to archive   15

Current log sequence           15

--检查参数文件、控制文件位置

SQL> show parameter spfile;

NAME                                 TYPE        VALUE

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

spfile                               string      +DATA01/gt10g/parameterfile/sp

                                                file.268.808331735

SQL> show parameter control_files;

NAME                                 TYPE        VALUE

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

control_files                        string      +DATA01/gt10g/controlfile/curr

                                                ent.270.808328193

--备份参数文件                                       

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

File created.

--查看现有数据文件位置

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

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

+DATA01/gt10g/datafile/system.271.808328265

+DATA01/gt10g/datafile/undotbs1.273.808328327

+DATA01/gt10g/datafile/sysaux.272.808328281

+DATA01/gt10g/datafile/users.269.808328331

+DATA01/gt10g/datafile/gtlions.281.808328327