You execute the commands on a multitenant container database CDB1 that has multiple
pluggable databases:
$ . oraenv
Oracle_SID = [oracle] ? cdb1
The oraclebasefor Oracle_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 is
/u01/app/oracle
$ rman target /
Recovery Manager : Release 12.1.0.0.2 – production on Fri Ju1 19 05:18:33: 2013
Coppyright (c) 1982, 2013, oracle and/or its affiliates. All rights reserved.
Connected to target database:CDB1 (DBID=782249327)
RMAN>SELECT name FROMv$tablespace;
Which statement is true about the execution of the last command?
A.
It succeeds and displays all the tablespaces that belong to the root database.
B.
It fails and returns an error because a connection is not made by using the sysdba
privilege.
C.
It succeeds and displays all the tablespaces that belong to the root and pluggable
databases.
D.
It fails and returns an error because SQL commands cannot be executed at the RMAN
prompt.
C
C
I am not sure.
[oracle@host01 adump]$ rman target sys/oracle_4U@pdborcl
Recovery Manager: Release 12.1.0.2.0 – Production on Tue Dec 29 18:45:04 2015
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1425085620)
RMAN> select * from v$tablespace;
using target database control file instead of recovery catalog
TS# NAME INC BIG FLA ENC CON_ID
———- —————————— — — — — ———-
2 UNDOTBS1 YES NO YES 0
0 SYSTEM YES NO YES 3
1 SYSAUX YES NO YES 3
2 TEMP NO NO YES 3
3 USERS YES NO YES 3
4 EXAMPLE YES NO YES 3
RMAN> exit
Recovery Manager complete.
[oracle@host01 adump]$ rman target /
Recovery Manager: Release 12.1.0.2.0 – Production on Tue Dec 29 18:45:26 2015
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1425085620)
RMAN> select * from v$tablespace;
using target database control file instead of recovery catalog
TS# NAME INC BIG FLA ENC CON_ID
———- —————————— — — — — ———-
1 SYSAUX YES NO YES 1
0 SYSTEM YES NO YES 1
2 UNDOTBS1 YES NO YES 1
4 USERS YES NO YES 1
3 TEMP NO NO YES 1
0 SYSTEM YES NO YES 2
1 SYSAUX YES NO YES 2
2 TEMP NO NO YES 2
0 SYSTEM YES NO YES 3
1 SYSAUX YES NO YES 3
2 TEMP NO NO YES 3
3 USERS YES NO YES 3
4 EXAMPLE YES NO YES 3
6 TEST YES YES YES 1
7 TEMP2 NO NO YES 1
15 rows selected
RMAN>
From my test show above. I confirm C.
C
Tested.
C.
It succeeds and displays all the tablespaces that belong to the root and pluggable
databases.
C
C