关于/u01/app/oracle/product/12.1.0/dbhome_2/dbs/UNNAMED00004
Beginning log switch checkpoint up to RBA , SCN: 12284027Tue Nov 24 21:40:27 2020
Thread 1 advanced to log sequence 8 (LGWR switch)
Current log# 2 seq# 8 mem# 0: +DATA/ORCL/ONLINELOG/group_2.261.1056558545
Current log# 2 seq# 8 mem# 1: +FRA/ORCL/ONLINELOG/group_2.281.1056558545
Tue Nov 24 21:40:27 2020
Archived Log entry 58 added for thread 1 sequence 7 ID 0x5e7a4c14 dest 1:
Tue Nov 24 21:40:27 2020
drop tablespace users including contents and datafiles
Tue Nov 24 21:40:36 2020
Deleted Oracle managed file +DATA/ORCL/DATAFILE/users.262.1057354277
Completed:drop tablespace users including contents and datafiles
Tue Nov 24 21:40:39 2020
Running KSFV I/O slave I601 os pid=11521
Tue Nov 24 21:40:45 2020
Running KSFV I/O slave I701 os pid=11603
Tue Nov 24 21:41:11 2020
KSFV I/O slave I601 dp=0xd66d4620 exiting
Tue Nov 24 21:41:11 2020
KSFV I/O slave I701 dp=0xd670ca40 exiting
Tue Nov 24 21:41:14 2020
ALTER SYSTEM: Flushing buffer cache inst=0 container=255 global
Tue Nov 24 21:41:15 2020
Completed checkpoint up to RBA , SCN: 12284027
Completed checkpoint up to RBA , SCN: 12284020
2160,2 Bot
$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on 星期二 11月 24 21:42:07 2020
Copyright (c) 1982, 2014, Oracle.All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 2926472 bytes
Variable Size 1191184504 bytes
Database Buffers 939524096 bytes
Redo Buffers 13848576 bytes
Database mounted.
SQL> flashback database to timestamp to_timestamp('2020-11-24:21:40:26','YYYY-MM-DD:HH24:MI:SS') ;
Flashback complete.
SQL> alter database open ;
alter database open
*
ERROR at line 1:
ORA-01589: 要打开数据库则必须使用 RESETLOGS 或 NORESETLOGS 选项
SQL> alter database open resetlogs;
Database altered.
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
+DATA/ORCL/DATAFILE/system.263.1054329825
+DATA/ORCL/DATAFILE/sysaux.282.1054329823
+DATA/ORCL/DATAFILE/undotbs1.286.1054329823
/u01/app/oracle/product/12.1.0/dbhome_2/dbs/UNNAMED00004
+DATA/ORCL/DATAFILE/example.279.1054329825
+DATA/ORCL/DATAFILE/tbs1.287.1050417229
+DATA/ORCL/DATAFILE/tbs2.288.1050417617
+DATA/ORCL/DATAFILE/tbs3.289.1050418001
+DATA/ORCL/DATAFILE/tbsocp05_test.284.1054152837
+DATA/ORCL/DATAFILE/tbsuniform.278.1054763341
+DATA/ORCL/DATAFILE/tbsbig.280.1054764585
NAME
--------------------------------------------------------------------------------
+DATA/ORCL/DATAFILE/tbsuniform.277.1054764627
+DATA/ORCL/DATAFILE/tbs32k.259.1054931811
+DATA/ORCL/DATAFILE/tbs_nocompression.291.1054936255
+DATA/ORCL/DATAFILE/tbs_basic.292.1054936269
+DATA/ORCL/DATAFILE/tbs_oltp.293.1054936567
16 rows selected.
页:
[1]