Which three techniques can you use to achieve this?

You are planning the creation of a new multitenant container database (CDB) and want to store
the ROOT and SEED container data files in separate directories.

——–You plan to create the database using SQL statements.
Which three techniques can you use to achieve this?

You are planning the creation of a new multitenant container database (CDB) and want to store
the ROOT and SEED container data files in separate directories.

——–You plan to create the database using SQL statements.
Which three techniques can you use to achieve this?

A.
Use Oracle Managed Files (OMF).

B.
Specify the SEED FILE_NAME_CONVERT clause.

C.
Specify the PDB_FILE_NAME_CONVERT initialization parameter.

D.
Specify the DB_FILE_NAMECONVERT initialization parameter.

E.
Specify all files in the CREATE DATABASE statement without using Oracle managed Files
(OMF).

Explanation:
You must specify the names and locations of the seed’s files in one of the following
ways:
* (A) Oracle Managed Files
* (B) The SEED FILE_NAME_CONVERT Clause
* (C) The PDB_FILE_NAME_CONVERT Initialization Parameter



Leave a Reply 27

Your email address will not be published. Required fields are marked *


JanK

JanK

ABC – OK

DB_FILE_NAMECONVERT – is for duplicate
in CREATE DATABASE statement we cant specify file for CDB and PDB

rsv1999

rsv1999

A,B,C are th ecorrect choices.

test

test

B C E
A cannot put into different directory.
https://thedatabaseguide.wordpress.com/2013/08/04/creating-a-cdb-using-create-database-statement/
Here is how the E works.

Zhenyu

Zhenyu

BCE,I agree with you

Zhenyu

Zhenyu

A is incorrect. BCE are correct.

–enable OMF
SQL> show parameter db_create_file_dest

NAME TYPE VALUE
———————————— ———– ——————————
db_create_file_dest string /arch/ma

–create database using OMF
CREATE DATABASE ma
USER SYS IDENTIFIED BY oracle
USER SYSTEM IDENTIFIED BY oracle
EXTENT MANAGEMENT LOCAL
DEFAULT TABLESPACE users
DEFAULT TEMPORARY TABLESPACE temp
UNDO TABLESPACE undotbs1
ENABLE PLUGGABLE DATABASE
SEED
SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
SYSAUX DATAFILES SIZE 100M;

–view the location when enable OMF
SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
———- —————————— ———- ———-
2 PDB$SEED READ ONLY NO

SQL> select con_id,name from v$datafile order by con_id;

CON_ID NAME
———- ——————————————————————————–
1 /arch/ma/MA/datafile/o1_mf_users_c4okowyz_.dbf
1 /arch/ma/MA/datafile/o1_mf_undotbs1_c4okovrh_.dbf
1 /arch/ma/MA/datafile/o1_mf_sysaux_c4okoo6t_.dbf
1 /arch/ma/MA/datafile/o1_mf_system_c4okobm4_.dbf
2 /arch/ma/MA/24B77DE793996C55E053C55AFB82D4F9/datafile/o1_mf_users_c4okoylx_.dbf
2 /arch/ma/MA/24B77DE793996C55E053C55AFB82D4F9/datafile/o1_mf_system_c4okodm9_.dbf
2 /arch/ma/MA/24B77DE793996C55E053C55AFB82D4F9/datafile/o1_mf_sysaux_c4okops9_.dbf

–root and seed are in the same location.

Zhenyu

Zhenyu

sorry,from the test, A is correct.ABC are correct.B and E are conflicting.

nohup

nohup

I’ll pick BCE

invisible

invisible

ABC is correct.

wls-guy

wls-guy

I chose OMF and files went to:

C:\app\oracle\oradata\orcl12c [ ROOT ]
C:\app\oracle\oradata\orcl12c\pdbseed [ SEED ]

So to me, A,B,C looks good. I haven’t tried “E” yet. So can’t comment on that. Did anyone tried it?

Peter

Peter

ABC are correct

Eduardo

Eduardo

I tested all options. The correct response is really ABC.

Umaruddin Ansari

Umaruddin Ansari

B,C,E are correct

dziri

dziri

B, D, E

Oracle Database 12c: New Features for Administrators 4 – 7, Student Guide, Volume I
Creating a Container Database: Using SQL-*Plus
1- Instance startup:
a- Set ORACLE_SID=CDB1
b- Set in initCDB1.ora
* Set CONTROL_FILES to CDB control file names.
* Set DB_NAME to CBD name.
* Set ENABLE_PLUGGABLE_DATABASE to TRUE.

2. Create the database:
– CDB$ROOT container
– PDB$SEED pluggable database

3. Run catcdb.sql script.

C is wrong: Omit the SEED FILE_NAME_CONVERT clause if you use the new init.ora parameter PDB_FILE_NAME_CONVERT, mapping names of the root data files to the seed data files.

dziri

dziri

Oracle Database 12c: New Features for Administrators B – 4, Student Guide, Volume II

There are different ways to specify the target locations of the files of the cloned PDB, either FILE_NAME_CONVERT clause in the CREATE PLUGGABLE DATABASE statement, or omit this clause and use either DB_CREATE_FILE_DEST or PDB_FILE_NAME_CONVERT inistialization parameter.

dziri

dziri

2. Create database
SQL> CREATE DATABASE CDB1 ENABLE PLUGGABLE DATABASE
SEED FILE_NAME_CONVERT(‘/oracle/dbs,’/oracle/seed’);

dziri

dziri

if FILE_NAME_CONVERT is ommtitted you should use PDB_FILE_NAME_CONVERT
which means BCE

pedja

pedja

The question states will be using sale statements to create . I was leaning toward A but because will only use sale to create can’t use omf. So answer is then BCE

pedja

pedja

Meant sql not sale

broqui

broqui

As per Alapati book : these three options in this order of precedent in case more than one is setup
1. (B) SEED FILE_NAME_CONVERT (Clause in the CREATE DATABASE statement)
2. (A) OMF (set with initialization parameters DB_CREATE_FILE_DEST)
3. (C) PDB_FILE_NAME_CONVERT (Initialization parameter)

E is false. if you do not use OMF you have to use SEED FILE_NAME_CONVERT in the create clause or PDB_FILE_NAME_CONVERT (Initialization parameter)

ks

ks

Should be : B,C,D

Even OMF create files under different directory. I think question “separate directory” should have been “separate mount point or file system”.

https://blogs.oracle.com/In-Memory/entry/getting_started_with_oracle_database

When both clauses are used in the same CREATE PLUGGABLE DATABASE statement, and both initialization parameters are set, the precedence order is:
1. The FILE_NAME_CONVERT clause of Pluggable Database
2. The CREATE_FILE_DEST clause of Pluggable Database
3. The DB_CREATE_FILE_DEST initialization parameter set in the root
4. The PDB_FILE_NAME_CONVERT initialization parameter

If FILE_NAME_CONVERT and CREATE_FILE_DEST are both specified, then the FILE_NAME_CONVERT setting is used for the files being placed during PDB creation, and the CREATE_FILE_DEST setting is used to set the DB_CREATE_FILE_DEST initialization parameter in the PDB. In this case, Oracle Managed Files controls the location of the files for the PDB after PDB creation.

Alexis

Alexis

I don´t understand