Which of the following are prerequisite steps to transport a database? (Choose all that
apply.)
A.
Query the V$TRANSPORTABLE_PLATFORMS view in the source database to determine
if the intended destination is listed.
B.
Verify that there are no restrictions or limitations that the source or destination database
may encounter.
C.
Verify that the source and destination have the same Oracle version, critical updates,
patch-set version, and patch- set exceptions.
D.
Determine if you will perform the conversion on the source or destination platform.
E.
None of the above.
BCD
@DD, why do you say answer C is correct? Any documentation links???
I think that the correct answer is B and D.
Answer A is “arguable” not correct and here is why ….
Notice the question says “transport a database” and not “transport a tablespace”, there are subtle differences here.
In http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmxplat.htm#BRADV05432 you can see at the top of the document this sentence…
You can use RMAN to transport tablespaces across platforms with different endian formats. You can also use RMAN to transport an entire database to a different platform so long as the two platforms have the same endian format.
You can also see several references to the table V$TRANSPORTABLE_PLATFORMS in this document, hwever if you read them there are all to do simple with getting the correct name of the source and destination platforms, and NOTHING to do with seeing whether you can in fact “transport a database”.
You should in fact be querying the table
Don’t believe me? take a look at ….
http://docs.oracle.com/cd/E11882_01/server.112/e40402/dynviews_1109.htm#REFRN30376
See the text ….
V$DB_TRANSPORTABLE_PLATFORM displays all platforms to which the database can be transported using the RMAN CONVERT DATABASE command. The transportable database feature only supports transports of the same endian platform. Therefore, V$DB_TRANSPORTABLE_PLATFORM displays fewer rows than V$TRANSPORTABLE_PLATFORM.
Please note “CONVERT DATABASE” means you are using “transport a database”
Latter in
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmxplat.htm
you can see the following …
You must use the RMAN CONVERT command in a transportable tablespace operation when the source platform is different from the destination platform and the endian formats are different.
Regardless of my opinion, this is the type of question that can in fact appear on the exam. Usually the answers given in this test are those that are actually looked for on the exam so during the exam use the answers given above i.e. A,B and C, however in real life problems use my advise.
I think that the correct answers are B and D.
Answer A is “arguable” not correct and here is why ….
Notice the question says “transport a database” and not “transport a tablespace”, there are subtle differences here.
In http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmxplat.htm#BRADV05432 you can see at the top of the document this sentence…
You can use RMAN to transport tablespaces across platforms with different endian formats. You can also use RMAN to transport an entire database to a different platform so long as the two platforms have the same endian format.
You can also see several references to the table V$TRANSPORTABLE_PLATFORM (there is no V$TRANSPORTABLE_PLATFORMS) in this document, however this table is only used to get the correct name of the source and destination platforms, but has NOTHING to do with seeing whether you can in fact “transport a database”.
You should in fact be querying the table V$DB_TRANSPORTABLE_PLATFORM
Take a look at …
http://docs.oracle.com/cd/E11882_01/server.112/e40402/dynviews_1109.htm#REFRN30376
See the text …
V$DB_TRANSPORTABLE_PLATFORM displays all platforms to which the database can be transported using the RMAN CONVERT DATABASE command. The transportable database feature only supports transports of the same endian platform. Therefore, V$DB_TRANSPORTABLE_PLATFORM displays fewer rows than V$TRANSPORTABLE_PLATFORM.
Note: “CONVERT DATABASE” means you are “transporting a database”
B is correct because you should in theory do various checks beforehand like
DBMS_TDB.CHECK_DB checks for
– incorrect compatibility settings
– in-doubt or active transactions
– incompatible endian formats
Also DBMS_TDB.CHECK_EXTERNAL;
checks for external tables, directories, and BFILEs
Both of these are also run when transporting the database but the DBA should also run them beforehand so he can be pre-warned of any issues.
D is also correct.
B, C and D.
Source: http://www.oracle.com/technetwork/database/availability/maa-wp-10gr2-platformmigrationtdb-131164.pdf
PERFORMING A PLATFORM MIGRATION WITH TRANSPORTABLE DATABASE
1/ Verify TDB Support for Target Platform
select platform_name from v$db_transportable_platform;
2/ Check Documentation for TDB Restrictions
3/ Target System Software Version
The target system must have the same Oracle software version and patches
installed as the source system. This includes the same patch set version, critical
patch updates, and patch set exceptions
4/ Choose Source or Target System Conversion