关于/u01/app/oracle/product/12.1.0/dbhome_2/dbs/UNNAMED00004

botang

1. Beginning log switch checkpoint up to RBA [0x8.2.10], SCN: 12284027
   
2. Tue Nov 24 21:40:27 2020
   
3. Thread 1 advanced to log sequence 8 (LGWR switch)
   
4.   Current log# 2 seq# 8 mem# 0: +DATA/ORCL/ONLINELOG/group_2.261.1056558545
   
5.   Current log# 2 seq# 8 mem# 1: +FRA/ORCL/ONLINELOG/group_2.281.1056558545
   
6. Tue Nov 24 21:40:27 2020
   
7. Archived Log entry 58 added for thread 1 sequence 7 ID 0x5e7a4c14 dest 1:
   
8. Tue Nov 24 21:40:27 2020
   
9. drop tablespace users including contents and datafiles
   
10. Tue Nov 24 21:40:36 2020
    
11. Deleted Oracle managed file +DATA/ORCL/DATAFILE/users.262.1057354277
    
12. Completed:  drop tablespace users including contents and datafiles
    
13. Tue Nov 24 21:40:39 2020
    
14. Running KSFV I/O slave I601 os pid=11521
    
15. Tue Nov 24 21:40:45 2020
    
16. Running KSFV I/O slave I701 os pid=11603
    
17. Tue Nov 24 21:41:11 2020
    
18. KSFV I/O slave I601 dp=0xd66d4620 exiting
    
19. Tue Nov 24 21:41:11 2020
    
20. KSFV I/O slave I701 dp=0xd670ca40 exiting
    
21. Tue Nov 24 21:41:14 2020
    
22. ALTER SYSTEM: Flushing buffer cache inst=0 container=255 global
    
23. Tue Nov 24 21:41:15 2020
    
24. Completed checkpoint up to RBA [0x8.2.10], SCN: 12284027
    
25. Completed checkpoint up to RBA [0x7.2.10], SCN: 12284020
    
26.                                                                                          2160,2        Bot
    

复制代码

1. [oracle@classroom ~]$ sqlplus /nolog
   
2. 
   
3. SQL*Plus: Release 12.1.0.2.0 Production on 星期二 11月 24 21:42:07 2020
   
4. 
   
5. Copyright (c) 1982, 2014, Oracle.  All rights reserved.
   
6. 
   
7. SQL> conn / as sysdba
   
8. Connected.
   
9. SQL> shutdown abort
   
10. ORACLE instance shut down.
    
11. SQL> startup mount
    
12. ORACLE instance started.
    
13. 
    
14. Total System Global Area 2147483648 bytes
    
15. Fixed Size                    2926472 bytes
    
16. Variable Size                 1191184504 bytes
    
17. Database Buffers          939524096 bytes
    
18. Redo Buffers                   13848576 bytes
    
19. Database mounted.
    
20. SQL> flashback database to timestamp to_timestamp('2020-11-24:21:40:26','YYYY-MM-DD:HH24:MI:SS') ;
    
21. 
    
22. Flashback complete.
    
23. 
    
24. SQL> alter database open ;
    
25. alter database open
    
26. *
    
27. ERROR at line 1:
    
28. ORA-01589: 要打开数据库则必须使用 RESETLOGS 或 NORESETLOGS 选项
    
29. 
    
30. 
    
31. SQL> alter database open resetlogs;
    
32. 
    
33. Database altered.
    
34. 
    
35. SQL> select name from v$datafile;
    
36. 
    
37. NAME
    
38. --------------------------------------------------------------------------------
    
39. +DATA/ORCL/DATAFILE/system.263.1054329825
    
40. +DATA/ORCL/DATAFILE/sysaux.282.1054329823
    
41. +DATA/ORCL/DATAFILE/undotbs1.286.1054329823
    
42. /u01/app/oracle/product/12.1.0/dbhome_2/dbs/UNNAMED00004
    
43. +DATA/ORCL/DATAFILE/example.279.1054329825
    
44. +DATA/ORCL/DATAFILE/tbs1.287.1050417229
    
45. +DATA/ORCL/DATAFILE/tbs2.288.1050417617
    
46. +DATA/ORCL/DATAFILE/tbs3.289.1050418001
    
47. +DATA/ORCL/DATAFILE/tbsocp05_test.284.1054152837
    
48. +DATA/ORCL/DATAFILE/tbsuniform.278.1054763341
    
49. +DATA/ORCL/DATAFILE/tbsbig.280.1054764585
    
50. 
    
51. NAME
    
52. --------------------------------------------------------------------------------
    
53. +DATA/ORCL/DATAFILE/tbsuniform.277.1054764627
    
54. +DATA/ORCL/DATAFILE/tbs32k.259.1054931811
    
55. +DATA/ORCL/DATAFILE/tbs_nocompression.291.1054936255
    
56. +DATA/ORCL/DATAFILE/tbs_basic.292.1054936269
    
57. +DATA/ORCL/DATAFILE/tbs_oltp.293.1054936567
    
58. 
    
59. 16 rows selected.

复制代码