mysql如何查看dbid_如何获得数据库的DBID

SQL> alter database mount

2 ;

数据库已更改。

只有mount后才能获取

SQL> select dbid from v$database;

DBID

1779551310

SQL> col name format a20

SQL> select name,dbid from v$containers;

NAME DBID

CDB$ROOT 1779551310

PDB$SEED 603865257

PDBTEST 3394996704

CLONEPDB_PLUG 50957894

SQL> select name,dbid from v$pdbs;

NAME DBID

PDB$SEED 603865257

PDBTEST 3394996704

CLONEPDB_PLUG 50957894

或

C:\app\Administrator\virtual\product\12.2.0\dbhome_2\bin>rman target / nocatalog

恢复管理器: Release 12.2.0.1.0 - Production on 星期五 1月 5 09:20:17 2018

Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.

已连接到目标数据库: NEWTEST (DBID=1779551310, 未打开)

使用目标数据库控制文件替代恢复目录

nomount状态

SQL> startup nomount;

ORACLE 例程已经启动。

Total System Global Area 2768240640 bytes

Fixed Size 8922760 bytes

Variable Size 704645496 bytes

Database Buffers 2046820352 bytes

Redo Buffers 7852032 bytes

SQL> alter system dump datafile 'C:\app\Administrator\virtual\oradata\newtest\sy

saux01.dbf' block 1;

系统已更改。

SQL> oradebug setmypid;

已处理的语句

SQL> oradebug tracefile_name;

C:\APP\ADMINISTRATOR\VIRTUAL\diag\rdbms\newtest\newtest\trace\newtest_ora_26588.trc