Shulou(Shulou.com)06/01 Report--

SQL > alter database mount

2

The database has changed.

It can only be obtained after 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

Or

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

Recovery Manager: Release 12.2.0.1.0-Production on Friday January 5 09:20:17 2018

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

Connected to the target database: NEWTEST (DBID=1779551310, not open)

Replace the recovery directory with the target database control file

Nomount statu

SQL > startup nomount

The ORACLE routine has been started.

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

The system has changed.

SQL > oradebug setmypid

Processed statement

SQL > oradebug tracefile_name

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.