|
|
---------------------------------------------- LAB 1d ----------------------------------------------
1d_users琛ㄧ┖闂寸儹澶�
---------------------------------------------- LAB 1d ----------------------------------------------
******************
浣犵殑涓绘満淇℃伅濡備笅锛�
******************
192.168.0.4
station4.example.com
Linux station4.example.com 2.6.18-238.el5PAE #1 SMP Sun Dec 19 14:42:44 EST 2010 i686 i686 i386 GNU/Linux
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE station4
ora.FRA.dg ora....up.type ONLINE ONLINE station4
ora....ER.lsnr ora....er.type ONLINE ONLINE station4
ora.asm ora.asm.type ONLINE ONLINE station4
ora.cssd ora.cssd.type ONLINE ONLINE station4
ora.diskmon ora....on.type ONLINE ONLINE station4
ora.orcl.db ora....se.type ONLINE ONLINE station4
SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 30 23:51:23 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> Connected.
SQL> SQL> SQL> select * from sys.tname
*
ERROR at line 1:
ORA-00942: table or view does not exist
****************************
The database open mode here:
****************************
D
-
X
OPEN_MODE
--------------------
READ WRITE
**********************************
The database archivelog mode here:
**********************************
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 111
Next log sequence to archive 113
Current log sequence 113
***************************
The database datafile here:
***************************
TABLESPACE_NAME STATUS
------------------------------ ---------------
SYSTEM ONLINE
SYSAUX ONLINE
UNDOTBS1 ONLINE
TEMP ONLINE
USERS ONLINE
EXAMPLE ONLINE
NAME STATUS
----------------------------------------------------------------- ---------------
+DATA/orcl/datafile/system.256.832197063 SYSTEM
+DATA/orcl/datafile/sysaux.257.832197065 ONLINE
+DATA/orcl/datafile/undotbs1.258.832197065 ONLINE
+DATA/orcl/datafile/users.259.867485943 ONLINE
+DATA/orcl/datafile/example.265.832197353 ONLINE
******************************
The database controlfile here:
******************************
NAME
-----------------------------------------------------------------
+DATA/orcl/controlfile/current.260.832197281
+FRA/orcl/controlfile/current.256.832197283
**************************
The database logfile here:
**************************
MEMBER
--------------------------------------------------------------------------------
+DATA/orcl/onlinelog/group_3.263.832197301
+FRA/orcl/onlinelog/group_3.259.832197305
+DATA/orcl/onlinelog/group_2.262.832197293
+FRA/orcl/onlinelog/group_2.258.832197299
+DATA/orcl/onlinelog/group_1.261.832197287
+FRA/orcl/onlinelog/group_1.257.832197291
**************************
The database tempfile here:
**************************
NAME
--------------------------------------------------------------------------------
+DATA/orcl/tempfile/temp.264.832197335
*****************
The values found:
*****************
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
THE END
--------------------
上面是实验结果，破环完，数据库可以直接open，随机表可以查到，但是没有记录，查select * from v$backup，所有文件状态都是NOT ACTIVE |
|
发表于 2016-12-29 20:24:16
发表于 2016-12-29 22:46:54
