Bo's Oracle Station

查看: 2104|回复: 0

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

[复制链接]

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2020-11-24 21:48:32 | 显示全部楼层 |阅读模式
  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. SQL*Plus: Release 12.1.0.2.0 Production on 星期二 11月 24 21:42:07 2020

  3. Copyright (c) 1982, 2014, Oracle.  All rights reserved.

  4. SQL> conn / as sysdba
  5. Connected.
  6. SQL> shutdown abort
  7. ORACLE instance shut down.
  8. SQL> startup mount
  9. ORACLE instance started.

  10. Total System Global Area 2147483648 bytes
  11. Fixed Size                    2926472 bytes
  12. Variable Size                 1191184504 bytes
  13. Database Buffers          939524096 bytes
  14. Redo Buffers                   13848576 bytes
  15. Database mounted.
  16. SQL> flashback database to timestamp to_timestamp('2020-11-24:21:40:26','YYYY-MM-DD:HH24:MI:SS') ;

  17. Flashback complete.

  18. SQL> alter database open ;
  19. alter database open
  20. *
  21. ERROR at line 1:
  22. ORA-01589: 要打开数据库则必须使用 RESETLOGS 或 NORESETLOGS 选项


  23. SQL> alter database open resetlogs;

  24. Database altered.

  25. SQL> select name from v$datafile;

  26. NAME
  27. --------------------------------------------------------------------------------
  28. +DATA/ORCL/DATAFILE/system.263.1054329825
  29. +DATA/ORCL/DATAFILE/sysaux.282.1054329823
  30. +DATA/ORCL/DATAFILE/undotbs1.286.1054329823
  31. /u01/app/oracle/product/12.1.0/dbhome_2/dbs/UNNAMED00004
  32. +DATA/ORCL/DATAFILE/example.279.1054329825
  33. +DATA/ORCL/DATAFILE/tbs1.287.1050417229
  34. +DATA/ORCL/DATAFILE/tbs2.288.1050417617
  35. +DATA/ORCL/DATAFILE/tbs3.289.1050418001
  36. +DATA/ORCL/DATAFILE/tbsocp05_test.284.1054152837
  37. +DATA/ORCL/DATAFILE/tbsuniform.278.1054763341
  38. +DATA/ORCL/DATAFILE/tbsbig.280.1054764585

  39. NAME
  40. --------------------------------------------------------------------------------
  41. +DATA/ORCL/DATAFILE/tbsuniform.277.1054764627
  42. +DATA/ORCL/DATAFILE/tbs32k.259.1054931811
  43. +DATA/ORCL/DATAFILE/tbs_nocompression.291.1054936255
  44. +DATA/ORCL/DATAFILE/tbs_basic.292.1054936269
  45. +DATA/ORCL/DATAFILE/tbs_oltp.293.1054936567

  46. 16 rows selected.
复制代码




回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-11-21 23:52 , Processed in 0.039507 second(s), 24 queries .

快速回复 返回顶部 返回列表