第13次活动：2017-08-27（星期日晚上7:00-10:00）

botang

bclresult-9a.zip (45.41 KB, 下载次数: 288)

2017-8-28 11:01 上传

点击文件名下载附件           bclresult-9c.zip (47.32 KB, 下载次数: 279)

2017-8-28 11:02 上传

点击文件名下载附件        bclresult-10a.zip (48.37 KB, 下载次数: 288)

2017-8-28 11:02 上传

点击文件名下载附件
[oracle@station90 ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Sun Aug 27 20:52:36 2017

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> conn / as sysdba
Connected.
SQL> select  name ,status from v$datafile;

NAME
--------------------------------------------------------------------------------
STATUS
-------
+DATA/orcl/datafile/system.259.953150809
SYSTEM

+DATA/orcl/datafile/sysaux.257.953150809
ONLINE

+DATA/orcl/datafile/undotbs1.258.953150809
ONLINE


NAME
--------------------------------------------------------------------------------
STATUS
-------
+DATA/orcl/datafile/users.260.953150809
ONLINE

+DATA/orcl/datafile/example.256.953150809
ONLINE

+DATA/orcl/datafile/tbsocp05_test.263.953150809
ONLINE


6 rows selected.

SQL> alter database open ;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


SQL> alter database open  RESETLOGS;

Database altered.

SQL> select  name ,status from v$datafile;

NAME
--------------------------------------------------------------------------------
STATUS
-------
+DATA/orcl/datafile/system.259.953150809
SYSTEM

+DATA/orcl/datafile/sysaux.257.953150809
ONLINE

+DATA/orcl/datafile/undotbs1.258.953150809
ONLINE


NAME
--------------------------------------------------------------------------------
STATUS
-------
+DATA/orcl/datafile/users.260.953150809
OFFLINE

+DATA/orcl/datafile/example.256.953150809
ONLINE

+DATA/orcl/datafile/tbsocp05_test.263.953150809
ONLINE


6 rows selected.

SQL>