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
ABC
ABC – OK
DB_FILE_NAMECONVERT – is for duplicate
in CREATE DATABASE statement we cant specify file for CDB and PDB
ABC
ABC
A,B,C are th ecorrect choices.
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.
BCE,I agree with you
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.
sorry,from the test, A is correct.ABC are correct.B and E are conflicting.
I’ll pick BCE
ABC
BCE
ABE
ABC is correct.
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?
ABC are correct
I tested all options. The correct response is really ABC.
B,C,E are correct
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.
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.
2. Create database
SQL> CREATE DATABASE CDB1 ENABLE PLUGGABLE DATABASE
SEED FILE_NAME_CONVERT(‘/oracle/dbs,’/oracle/seed’);
if FILE_NAME_CONVERT is ommtitted you should use PDB_FILE_NAME_CONVERT
which means BCE
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
Meant sql not sale
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)
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.
I don´t understand