Database Administration (MOSC)

MOSC Banner

Question about pdb$seed temp file location

edited Nov 24, 2018 4:09AM in Database Administration (MOSC) 8 commentsAnswered

Hi

12.1.0.2.0

Anyone know when I create container database with dbca, then why pdb$seed has it's TEMP file in other ASM directory..?

connected to target database: CDB1 (DBID=965202348)RMAN>RMAN> report schema;...5    270      PDB$SEED:SYSTEM      NO      +DATA/CDB1/FD9AC20F64D244D7E043B6A9E80A2F2F/DATAFILE/system.289.991484921...7    880      PDB$SEED:SYSAUX      NO      +DATA/CDB1/FD9AC20F64D244D7E043B6A9E80A2F2F/DATAFILE/sysaux.288.991484921...List of Temporary Files=======================File Size(MB) Tablespace           Maxsize(MB) Tempfile Name---- -------- -------------------- ----------- --------------------1    197      TEMP                 32767       +DATA/CDB1/TEMPFILE/temp.307.9914849172    100      PDB$SEED:TEMP        32767       +DATA/CDB1/FD9AC20F64D244D7E043B6A9E80A2F2F/DATAFILE/pdbseed_temp012018-11-06_12-29-10-pm.dbf...-- Since now, everything looks to be correct, but when checking the following location "+DATA/cdb1/FD9AC20F64D244D7E043B6A9E80A2F2F/DATAFILE" from ASM$ asmcmd ls -l +DATA/cdb1/FD9AC20F64D244D7E043B6A9E80A2F2F/DATAFILEType      Redund  Striped  Time             Sys  NameDATAFILE  UNPROT  COARSE   NOV 06 13:00:00  Y    SYSAUX.288.991484921DATAFILE  UNPROT  COARSE   NOV 06 13:00:00  Y    SYSTEM.289.991484921TEMPFILE  UNPROT  COARSE   NOV 06 12:00:00  N    pdbseed_temp012018-11-06_12-29-10-PM.dbf => +DATA/CDB1/

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center