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

In the morning, the database of a certain system was alarmed. The database version was 12c and the operating system was RHEL7.2.

2018-08-23T06:43:17.297341+08:00

PDB$SEED (2): Opatch validation is skipped for PDB PDB$SEED (con_id=0)

PDB$SEED (2):

PDB$SEED (2): WARNING: Pluggable Database PDB$SEED with pdb id-2 is

PDB$SEED (2): altered with errors or warnings. Please look into

PDB$SEED (2): PDB_PLUG_IN_VIOLATIONS view for more details.

PDB$SEED (2):

2018-08-23T06:43:25.423893+08:00

PDB$SEED (2): Opening pdb with no Resource Manager plan active

2018-08-23T06:44:17.773603+08:00

DCDB (3): Autotune of undo retention is turned off.

2018-08-23T06:44:17.870219+08:00

DCDB (3): attach called for domid 3 (domuid: 0x786a7683, options: 0x4, pid: 191312)

DCDB (3): queued attach broadcast request 0x12372e9f68

2018-08-23T06:44:18.028918+08:00

DWDBPDB (4): Autotune of undo retention is turned off.

2018-08-23T06:44:18.103157+08:00

DWDBPDB (4): attach called for domid 4 (domuid: 0xd95b03fa, options: 0x4, pid: 191314)

DWDBPDB (4): queued attach broadcast request 0x12372e9f10

2018-08-23T06:44:18.394250+08:00

DCDB (3): Endian type of dictionary set to little

2018-08-23T06:44:18.623678+08:00

DWDBPDB (4): Endian type of dictionary set to little

2018-08-23T06:44:19.122431+08:00

DCDB (3): Undo initialization errored: err:30013 serial:0 start:858517331 end:858517597 diff:266 ms (0.3 seconds)

Pdb DCDB hit error 30013 during open read write (1) and will be closed.

Some attempts have been made, but the library cannot be started, and as we all know, the normal situation for RAC systems is that DB1 uses untbs1,DB2 and untbs2. Log in to the system and check it out.

16:56:09 > show parameter undo

NAME TYPE VALUE

_ undo_autotune boolean FALSE

Temp_undo_enabled boolean FALSE

Undo_management string AUTO

Undo_retention integer 7200

Undo_tablespace string UNDOTBS1

16:56:09 > show parameter undo

NAME TYPE VALUE

_ undo_autotune boolean FALSE

Temp_undo_enabled boolean FALSE

Undo_management string AUTO

Undo_retention integer 7200

Undo_tablespace string UNDOTBS2

Have no choice but to submit SR for backline support, and Oracle engineer feedback query:

Select a.Sid _ name _

From

Sys.pdb_spfile$ a,cdb_pdbs b

Where a.PDB_UID=b.CON_UID

15:21:33 > col PDB_NAME for A20

15:21:42 > /

SID NAME VALUE$ PDB_NAME

Db_securefile 'PREFERRED' PDB$SEEDparallel_force_local TRUE DWDBPDBdb_securefile' PREFERRED' DWDBPDBundo_tablespace 'UNDOTBS1' DWDBPDB

DWDB1 undo_tablespace 'UNDOTBS1' DWDBPDB

DWDB2 undo_tablespace 'UNDOTBS2' DWDBPDB

Dwdb1 undo_tablespace 'UNDOTBS1' DWDBPDB

Dwdb2 undo_tablespace 'UNDOTBS2' DWDBPDBundo_tablespace' UNDOTBS2' DCDBdb_securefile 'PREFERRED' DCDB

10 rows selected.

SR continues to give feedback to Please use following commands:

ALTER SESSION SET CONTAINER = DCDB

ALTER SYSTEM SET undo_tablespace=UNDOTBS1 scope=spfile sid='dwdb1'

ALTER SYSTEM SET undo_tablespace=UNDOTBS2 scope=spfile sid='dwdb2'

Alter pluggable database DCDB open

Alert log:

2018-08-23T16:18:39.584321+08:00

LOGMINER: End mining logfile for session 1 thread 1 sequence 212717, + DATA/DWDB/ONLINELOG/redo12a.log

2018-08-23T16:18:39.659829+08:00

LOGMINER: Begin mining logfile for session 1 thread 1 sequence 212718, + DATA/DWDB/ONLINELOG/redo13a.log

2018-08-23T16:18:46.032160+08:00

DCDB (3): ALTER SYSTEM SET undo_tablespace='UNDOTBS1' SCOPE=SPFILE SID='dwdb1' PDB='DCDB'

2018-08-23T16:18:52.234874+08:00

DCDB (3): ALTER SYSTEM SET undo_tablespace='UNDOTBS2' SCOPE=SPFILE SID='dwdb2' PDB='DCDB'

2018-08-23T16:19:11.306657+08:00

DCDB (3): alter pluggable database DCDB open

We're looking into it:

16:56:08 > select a.SID _

16:56:09 2 from

16:56:09 3 sys.pdb_spfile$ a,cdb_pdbs b

16:56:09 4 where a.PDB_UID=b.CON_UID

SID NAME VALUE$ PDB_NAME

Db_securefile 'PREFERRED' PDB$SEEDparallel_force_local TRUE DWDBPDBdb_securefile' PREFERRED' DWDBPDBundo_tablespace 'UNDOTBS1' DWDBPDB

DWDB1 undo_tablespace 'UNDOTBS1' DWDBPDB

DWDB2 undo_tablespace 'UNDOTBS2' DWDBPDB

Dwdb1 undo_tablespace 'UNDOTBS1' DWDBPDB

Dwdb2 undo_tablespace 'UNDOTBS2' DWDBPDBundo_tablespace' UNDOTBS2' DCDB

Dcdb1 undo_tablespace 'UNDOTBS1' DCDBdb_securefile' PREFERRED' DCDB

Dcdb2 undo_tablespace 'UNDOTBS2' DCDB

Dwdb1 undo_tablespace 'UNDOTBS1' DCDB

Dwdb2 undo_tablespace 'UNDOTBS2' DCDB

14 rows selected.

Here is a pit, we need to specify the correct PDB for SID, and here is an own one, and the Oracle SR backend engineer asked us to have some wrong suggestions before:

ALTER SESSION SET CONTAINER = DCDB

ALTER SYSTEM SET undo_tablespace=UNDOTBS1 scope=spfile sid='dcdb1'

ALTER SYSTEM SET undo_tablespace=UNDOTBS2 scope=spfile sid='dcdb2'

Alter pluggable database DCDB open

The difference is that:

2018-08-23T15:53:13.142757+08:00

DCDB (3): ALTER SYSTEM SET undo_tablespace='UNDOTBS1' SCOPE=SPFILE SID='dcdb1' PDB='DCDB';-error

"= = DCDB (3): this command is executed in pdb DCDB

2018-08-23T11:07:37.996006+08:00

ALTER SYSTEM SET undo_tablespace='UNDOTBS1' SCOPE=BOTH SID='dwdb1';-correct

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.