You plan to migrate an Oracle database that supports an online transaction processing (OLTP)
workload to your Database Machine.
Following are details for the source database:
Database version: 10.2.0
Byte order: Big Endian HP-UX (64-bit)
Database size: 24 TB
Storage: ASM with 1 MB allocation unit size
Which two are supported migration methods?
A.
Physical migration using ASM online Migration
B.
Physical migration using Transportable Database
C.
Logical migration using Oracle Streams
D.
Local migration using Oracle Streams
E.
Logical migration using logical standby
Explanation:
Note:
* physical migration techniques (e.g. Data Guard Physical Standby, Transportable Database,
Transportable Tablespaces(B), Rapid Clone) vs. logical migration techniques(C)(e.g. Oracle Data
Pump).
*You can use either Data Pump export/import or original export/import for Streams instantiations.
*The Oracle Exadata Database Machine runs the standard Oracle Database. Therefore, any
application that runs with the Oracle Database today can be seamlessly migrated to the Exadata
Database Machine with no changes to the application.
*There are several techniques for migrating data to a Database Machine. Migration can be done
using Oracle Recovery Manager (RMAN) to backup from traditional storage and restore the data
onto Exadata. Oracle Data Guard can also be used to facilitate a migration. This is done by first
creating a standby database based on Exadata storage. The standby can be using Exadata
storage
and the production database can be on traditional storage. By executing a fast switchover, taking
just seconds, you can transform the standby database into the production database. This provides
a built-in safety net as you can undo the migration very gracefully if unforeseen issues arise.
Transportable Tablespaces(B)and Data Pump may also be used to migrate to Exadata. Any
technique used to move data between Oracle Databases can be used with Exadata.
Not B, Exadata is little endian where transportable database will not succeed due to convert database rman command will fail
Correct answers are : C & E
C & E
Transportable tablespace is possible from Big to little endian, check the limitation as per Oracle doc
http://docs.oracle.com/cd/E11882_01/server.112/e25494/tspaces.htm#ADMIN11396
So to correct previous comments, don’t get confued the same with “Transportable database”, which is not feasible from Big to little.
So B seems likely option.
At the same as per compatibility set of metalink doc “Data Guard Support for Heterogeneous Primary and Logical Standbys in Same Data Guard Configuration (Doc ID 1085687.1)”
RDBMS 10.2 on HP-UX doesnt seems very compatible with 11g DB on OEL hosted on exadata hardware.
To correct we checked other source as well and C, E seems logical as it is migration to OLTP
A is wrong. Endian different and AU size different
B is correct. RMAN Convert database
C is correct. Steams or Golden Gate
D is wrong. what is local migration??
E is wrong. Different platform. how to setup logical standby which is based on physical standby.
So B and C are the right answer
it has to be logical migration so C and E.for A,B we need to have source 11.2 .D is not valid .
For Physical Transportable Database, the source database must be 11.2, besides the endian format must be the same. The DB in question is 10.2 and differetn endian format, hence, B option is not valid here.
Probably there seems to typo error in answer D. If it is logical instead of local, then it is the perfect answer.
I found follwoing paper from oracle:
http://www.oracle.com/au/products/database/migration-to-exadata-whitepaper-1-129592.pdf
The mentioned database as AU 1 MB, so the migration has to be logical.
The mentioned database is 10g, so it is not possible via transportable database.
I’m sure answer C is correct, but all others are wrong. So maybe answer B is not transportable database, but transportable tablespaces…
B & C.
E is wrong because source has to be on Linux x86-64.
Touch-ups:
If B is transportable “tablespace”
I am not sure why such questions are asked in Exadata exam where its very specific and there is need to know all concepts and along with its limitation.
C and E are correct.
Answer B is wrong as per below. It says “Transportable database” is not supported for migration from HP UX to Linux. “Trasportable tablespace can be used”
you cannot transport a whole database from HP_UX to Linux for x86 using this feature. You can, however, create a new database on a destination platform manually, and transport needed tablespaces from the source database using cross-platform transportable tablespace as described in “Cross-Platform Tranportable Tablespace: CONVERT DATAFILE or TABLESPACE”.
https://docs.oracle.com/cd/E50790_01/doc/doc.121/e50471/administer.htm#SAGUG20528
C: Logical migration using Oracle Streams
E: Logical migration using logical standby
Explanation:
A. Physical migration using ASM online Migration = WRONG: source is 10.2.0. and need to be at least 11.2.0.
B. Physical migration using Transportable Database = WRONG: source is 10.2.0. and need to be at least 11.2.0. + source is big endian and need to be little endian
C. Logical migration using Oracle Streams = RIGHT: logical migration using streams support source in 10.2.0
D. Local migration using Oracle Streams = WRONG: the migration will be done to Exadata environment not “local”
E. Logical migration using logical standby = RIGHT: logical standby database migration support source in 10.2.0
Option D stated as “logical migration using golden gate” in the exam.
Just took my Oracle 1Z0-027 exam several days ago! Scored 87% for the second try! (The passing score is 60% now.)
Got 90 questions in total, questions are mainly on Exadata Database Machine, ILOM, RMAN, I/O resource, CellCLI (commands), OLTP…etc.
I used the latest version PassLeader 107q dumps (here it is: http://www.passleader.com/1z0-027.html)
Almost all questions were from it, and some wrong answers have been corrected in that PL 107q dumps, the most valid 1Z0-027 dumps!
By the way, part of that 107q PassLeader 1Z0-027 dumps are available on Google Drive for free:
https://drive.google.com/open?id=0B-ob6L_QjGLpZ05EYlhnaTd2VGs
(It seems that PL just updated that 107q files…)
Good Luck!!!