查看system.dbf信息

最新推荐文章于 2023-08-15 22:01:08 发布

congjuyan5037

最新推荐文章于 2023-08-15 22:01:08 发布

阅读量216

点赞数

文章标签：数据库

SQL> select file_name from dba_data_files;

FILE_NAME
--------------------------------------------------------------------------------
+DATA/orcl/datafile/users.267.854191187
+DATA/orcl/datafile/undotbs1.263.854191187
+DATA/orcl/datafile/sysaux.268.854191187
+DATA/orcl/datafile/system.260.854191187
+DATA/orcl/datafile/example.259.854191305
+DATA/orcl/datafile/undotbs2.258.854191485

6 rows selected.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
[oracle@hp580-4 trace]$ cd
[oracle@hp580-4 ~]$ pwd
/home/oracle
[oracle@hp580-4 ~]$ su - grid
Password:
[grid@hp580-4 ~]$ asmcmd
ASMCMD> cp +DATA/orcl/datafile/system.260.854191187   /home/grid/system.dbf
copying +DATA/orcl/datafile/system.260.854191187 -> /home/grid/system.dbf
ASMCMD> exit
[grid@hp580-4 ~]$ ll
total 768024
drwxr-xr-x 3 grid oinstall      4096 Jul 28 2014 oradiag_grid
-rw-r--r-- 1 grid oinstall       167 Mar 10 13:26 pfile.ora
-rw-r----- 1 grid oinstall 786440192 May 6 15:55 system.dbf
drwxr-xr-x 3 grid oinstall      4096 Oct 30 2014 workspace
[grid@hp580-4 ~]$ chmod a+r system.dbf
[grid@hp580-4 ~]$ ll
total 768024
drwxr-xr-x 3 grid oinstall      4096 Jul 28 2014 oradiag_grid
-rw-r--r-- 1 grid oinstall       167 Mar 10 13:26 pfile.ora
-rw-r--r-- 1 grid oinstall 786440192 May 6 15:55 system.dbf
drwxr-xr-x 3 grid oinstall      4096 Oct 30 2014 workspace
[grid@hp580-4 ~]$ exit
logout
[oracle@hp580-4 ~]$ dd if=/home/grid/system.dbf of=/home/oracle/aa.log bs=8192 skip=801 count=1
1+0 records in
1+0 records out
8192 bytes (8.2 kB) copied, 0.000358243 s, 22.9 MB/s
[oracle@hp580-4 ~]$ strings /home/oracle/aa.log
GLOBAL_DB_NAME
ORCL
Global database name,
DBTIMEZONE
00:00
DB time zone,
NO_USERID_VERIFIER_SALT 75282D7EC73B5C40AFF387B2BF5692A0,
WORKLOAD_REPLAY_MODE
bPREPARE implies external replay clients can connect; REPLAY implies workload replay is in progress,
WORKLOAD_CAPTURE_MODE
/CAPTURE implies workload capture is in progress,
EXPORT_VIEWS_VERSION
Export views revision #,
DEFAULT_PERMANENT_TABLESPACE
USERS$Name of default permanent tablespace,
GLOBAL_DB_NAME
SEEDDATA
Global database name,
NLS_RDBMS_VERSION
11.2.0.3.0 RDBMS version for NLS parameters,
NLS_NCHAR_CHARACTERSET AL16UTF16
NCHAR Character set,
NLS_NCHAR_CONV_EXCP
FALSE
NLS conversion exception,
NLS_LENGTH_SEMANTICS
BYTE
NLS length semantics,
NLS_COMP
BINARY
NLS comparison,
NLS_DUAL_CURRENCY
Dual currency symbol,
NLS_TIMESTAMP_TZ_FORMAT
DD-MON-RR HH.MI.SSXFF AM TZR
Timestamp with timezone format,
NLS_TIME_TZ_FORMAT
HH.MI.SSXFF AM TZR
Time with timezone format,
NLS_TIMESTAMP_FORMAT
DD-MON-RR HH.MI.SSXFF AM
Time stamp format,
NLS_TIME_FORMAT
HH.MI.SSXFF AM
Time format,
NLS_SORT
BINARY
Linguistic definition,
NLS_DATE_LANGUAGE
AMERICAN
Date language,
NLS_DATE_FORMAT DD-MON-RR
Date format,
NLS_CALENDAR    GREGORIAN
Calendar system,
NLS_CHARACTERSET
ZHS16GBK
Character set,
NLS_NUMERIC_CHARACTERS
Numeric characters,
NLS_ISO_CURRENCY
AMERICA
ISO currency,
NLS_CURRENCY
Local currency,
NLS_TERRITORY
AMERICA Territory,
NLS_LANGUAGE
AMERICAN
Language,
DEFAULT_TBS_TYPE        SMALLFILE
Default tablespace type,
DST_SECONDARY_TT_VERSION
0'Version of secondary timezone data file,
DST_PRIMARY_TT_VERSION
14%Version of primary timezone data file,
DST_UPGRADE_STATE
NONE&State of Day Light Saving Time Upgrade<
DBTIMEZONE
-07:00
DB time zone,
TDE_MASTER_KEY_ID,
Flashback Timestamp TimeZone
GMT"Flashback timestamp created in GMT,
DEFAULT_TEMP_TABLESPACE
TEMP$Name of default temporary tablespace,
DEFAULT_EDITION
ORA$BASE$Name of the database default edition,
DEFAULT_PERMANENT_TABLESPACE
SYSTEM$Name of default permanent tablespace,
DEFAULT_TEMP_TABLESPACE
SYSTEM$Name of default temporary tablespace,
        DICT.BASE
2 dictionary base tables version #
[oracle@hp580-4