- Home
- Database
- Oracle 12 C
- OCP Oracle 12C Advanced Administration(1Z0-063)
61.
True or false: RMAN supports duplication of only the entire CDB to another CDB.
- A.True
- B.False
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| RMAN supports duplication of an individual PDB, several PDBs, or the entire CDB to another CDB. |
62.
Which command is used to begin a tablespace point-in-time recovery?
- A.RESTORE TABLESPACE
- B.RECOVER TABLESPACE
- C.TABLESPACE RECOVER
- D.RECOVER TO TIME
- E.RECOVER DATAFILE
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| The RECOVER TABLESPACE command is used to start a TSPITR recovery. |
63.
When you’re performing active database duplication, a backup of what kind is required?
- A.A current RMAN backup-set backup is required.
- B.No backup is required.
- C.An RMAN image backup is required.
- D.A manual backup is required.
- E.A duplicate preparatory backup is required.
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| Active database duplication does not require any backup before the duplication is run. |
64.
Which of the following commands will perform an active database duplication of the
ORCL database to the ORCL2 database?
- A.Set oracle_sid=orcl
rman target=sys/robert auxname=sys/Robert@orcl2
create duplicate target database to neworcl from
active database nofilenamecheck
spfile set control_files 'c:\oracle\oradata\neworcl\control01.ctl',
'c:\oracle\oradata\neworcl\control02.ctl'
set db_file_name_convert
'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl'
set log_file_name_convert
'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl';
- B.Set oracle_sid=orcl
rman target=sys/robert auxname=sys/Robert@orcl2
duplicate target database nofilenamecheck
spfile set control_files 'c:\oracle\oradata\neworcl\control01.ctl',
'c:\oracle\oradata\neworcl\control02.ctl'
set db_file_name_convert
'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl'
set log_file_name_convert
'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl'; - C.Set oracle_sid=orcl
rman target=sys/robert auxname=sys/Robert@orcl2
duplicate target database to neworcl nofilenamecheck
spfile set control_files 'c:\oracle\oradata\neworcl\control01.ctl',
'c:\oracle\oradata\neworcl\control02.ctl'
set db_file_name_convert
'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl'
set log_file_name_convert
'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl'; - D.Set oracle_sid=orcl
rman target=sys/robert auxname=sys/Robert
duplicate target database to neworcl from active database
nofilenamecheck
spfile set control_files 'c:\oracle\oradata\neworcl\control01.ctl',
'c:\oracle\oradata\neworcl\control02.ctl'
set db_file_name_convert
'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl'
set log_file_name_convert
'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl'; - E.Set oracle_sid=orcl
rman target=sys/robert auxname=sys/Robert@orcl2
duplicate target database to neworcl from active database
nofilenamecheck
spfile set control_files 'c:\oracle\oradata\neworcl\control01.ctl',
'c:\oracle\oradata\neworcl\control02.ctl'
set db_file_name_convert
'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl'
set log_file_name_convert
'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl';
- Answer & Explanation
- Report
Answer : [E]
Explanation :
Explanation :
| The commands in option E are the correct commands to perform an active database duplication given the conditions listed. |
65.
How many database instances are used during a database-duplication process?
- A.one
- B.two
- C.three
- D.four
- E.five
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| You will use two databases. The first is the target database, and the second is the auxiliary database instance. |
|
|
||||||||||||||||||||||||||||
