Exam 1z0-063 topic 1 question 200 discussion

Actual exam question from Oracle's 1z0-063

Question #: 200
Topic #: 1

The CATDB12c database contains an Oracle Database version 12c catalog schema owned by the RC12C user.
The RCAT11 database contains an Oracle Database version 11g catalog schema owned by the RC11 user in which several databases are registered. Both databases are open.
You execute the RMAN commands:

Which two tasks are performed as part of the import?

A. All databases registered in the RC11 catalog are registered in the RC12C catalog.
B. Databases from the RC12C catalog are implicitly unregistered if the RC11 catalog has registered databases with same name.
C. Local and global stored scripts that have the same name as existing scripts in the RC12C catalog are automatically renamed.
D. Imported databases are unregistered from the RC11 catalog.
E. Recovery catalog is resynchronized with the control files of the registered databases.

Show Suggested Answer

Suggested Answer: AC 🗳️
C: Stored scripts are either global or local. It is possible for global scripts, but not local scripts, to have name conflicts during import because the destination schema contains an object with the same name. In this case, RMAN renames the global script name to COPY OF script_name.
Incorrect Answers:
B: Ensure that the same database is not registered in both the source recovery catalog schema and destination catalog schema. If a database is registered in both schemas, then UNREGISTER this database from source recovery catalog and execute the IMPORT command again.
Note: Use the IMPORT CATALOG command to import the metadata from one recovery catalog schema into a different catalog schema. If you created catalog schemas of different versions to store metadata for multiple target databases, then this command enables you to maintain a single catalog schema for all databases.
References:
https://docs.oracle.com/database/121/RCMRF/rcmsynta026.htm

by NorthKorean at April 25, 2020, 3:14 p.m.

Comments

Submit Cancel

Grace1_2239478234

3 years, 2 months ago

What was the answer to 173? the same question but the vote was that it would fail because the catalogs are different versions?

upvoted 2 times

...

hilaire

3 years, 10 months ago

AD correct

upvoted 3 times

hilaire

3 years, 10 months ago

local script cannot rename https://docs.oracle.com/database/121/RCMRF/rcmsynta026.htm#RCMRF198

upvoted 1 times

...

ErikJanssen

4 years, 3 months ago

The versions should be equal of the source and destination catalog schemas

upvoted 1 times

...

mihanik

4 years, 11 months ago

Answer is AD https://docs.oracle.com/database/121/RCMRF/rcmsynta026.htm#RCMRF198 By default, the imported database IDs are unregistered from the source recovery catalog schema after a successful import. It is possible for global scripts, but not local scripts, to have name conflicts during import because the destination schema contains an object with the same name. In this case, RMAN renames the global script name to COPY OF script_name. For example, RMAN renames bp_cmd to COPY OF bp_cmd.

upvoted 2 times

...

NorthKorean

5 years, 2 months ago

AD is answer

upvoted 1 times

Sugar

5 years ago

i agree A D are correct

upvoted 1 times

...