|
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition>
PL/SQL> CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
DG63 READ WRITE
SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
+DATA/dg63/onlinelog/group_1.257.766190357
+FRA/dg63/onlinelog/group_1.257.766190365
+DATA/dg63/onlinelog/group_2.258.766190367
+FRA/dg63/onlinelog/group_2.258.766190373
+DATA/dg63/onlinelog/group_3.259.766190375
+FRA/dg63/onlinelog/group_3.259.766190383
6 rows selected.
SQL> select file_name from dba_data_files;
FILE_NAME
--------------------------------------------------------------------------------
+DATA/dg63/datafile/system.260.766190391
+DATA/dg63/datafile/sysaux.261.766190445
+DATA/dg63/datafile/undotbs1.262.766190487
+DATA/dg63/datafile/users.264.766190515
SQL> show parameter control;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
control_files string +DATA/dg63/controlfile/current
.256.766190349, +FRA/dg63/cont
rolfile/current.256.766190353
control_management_pack_access string DIAGNOSTIC+TUNING
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
DG63 READ WRITE
SQL> show parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/dg63/spfiledg63.ora
SQL> show parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/dg63/spfiledg63.ora
SQL> show parameter instance;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
active_instance_count integer
cluster_database_instances integer 1
instance_groups string
instance_name string dg63
instance_number integer 0
instance_type string RDBMS
open_links_per_instance integer 4
parallel_instance_group string
parallel_server_instances integer 1
|
|
|
|
|
|
|