PROD1, PROD2 and PROD3 are three instances that have multitenant container database PROD open.
PROD contains multiple PDBs.
Examine these successful commands:
$ srvctl add service –db PROD –pdb PRDPDB1 –service SRVPDB1
$ srvctl start service –db PROD –service SRVPDB1
Which statement is true about the srvctl start service command?
A.
It opens the PRDPDB1 PDB if not already opened.
B.
It can open the PRDPDB1 PDB only if it is policy managed.
C.
It can open the PRDPDB1 PDB automatically.
D.
It can open the PRDPDB1 PDB only if it is manually managed.
Explanation:
I think that correct answer is A :
You manage PDBs in an Oracle RAC-based CDB by managing services, regardless of whether the PDBs are policy managed or administrator managed. Assign one dynamic database service to each PDB to coordinate start, stop, and placement of PDBs across instances in a clustered container database.
https://docs.oracle.com/database/121/RACAD/admin.htm#RACAD8913
Regards
Hi Marc
Also agree with you
Regards
You manage PDBs in an Oracle RAC-based CDB by managing services, regardless of whether the PDBs are policy managed or administrator managed. Assign one dynamic database service to each PDB to coordinate start, stop, and placement of PDBs across instances in a clustered container database.
“A” and “C” seems to be correct, but the best choice seems to be “A”
A is correct
https://martincarstenbach.wordpress.com/2014/02/17/rac-and-pluggable-databases/
answer is C
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
———- —————————— ———- ———-
2 PDB$SEED READ ONLY NO
3 CDB_PDB1 READ WRITE NO
SQL> alter pluggable database cdb_pdb1 close immediate;
Pluggable database altered.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
[oracle@localhost ~]$ clear
[oracle@localhost ~]$ srvctl add service -d cdb3 -pdb cdb_pdb1 -s pdbservice
[oracle@localhost ~]$ srvctl start service -d cdb3 -s pdbservice
[oracle@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Tue Sep 12 23:16:06 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
———- —————————— ———- ———-
2 PDB$SEED READ ONLY NO
3 CDB_PDB1 READ WRITE NO
SQL>