Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 231:

  Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform? (Choose three.)

  A. Both source and target database must be the same character set

  B. Both source and target database must have the same endian format

  C. The COMPATIBLE parameter must be the same in the source and target databases.

  D. The minimum compatibility level for both the source and target database must be 10.0.0.

  E. All read-only and offline data files that belong to the tablespace to be transported must be platform aware.

  Correct Answer: ABD

• Question 232:

  Examine the following scenario: The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows:

  RMAN> RUN { ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb; }

  Which statement is true about the duplicate database in this scenario?

  A. It contains data till the last backup

  B. It contains all data from target database until the current time

  C. It contains all data from only the committed transactions in the target database

  D. It contains all data except that which is used by the transactions in the current online redo file of target database

  Correct Answer: D

• Question 233:

  Examine the following command that is used to duplicate a database on the same host:

  RMAN> RUN { ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; }

  Which two statements describe the effect after the database is duplicated successfully? (Choose two)

  A. The data files of the read-only tablespaces in the target database are not duplicated

  B. The read-only tablespaces in the target database are still defined in new the database

  C. The read-only tablespaces in the target database are changed to online after duplication

  D. The data files of the read-only tablespaces in the target database get duplicated

  E. The read-only tablespaces in the target database are not defined in the new database

  Correct Answer: AB

• Question 234:

  Which three tasks can be performed using a duplicate database? (Choose three.)

  A. Testing the backup and recovery procedures

  B. Testing the upgrade of an Oracle database to a new release

  C. Testing the effect of an application changes on database performance

  D. Continuously updating archive log files from the target database to support failover

  Correct Answer: ABC

• Question 235:

  Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) while duplicating a running database? (Choose Two) A. Creating the control file for the duplicate database

  B. Restoring the target data files to the duplicate database

  C. Performing complete recovery using all available backups

  D. Generating a new, unique DBID for the duplicate database

  E. Copying the online redo log files from the target database to the duplicate database

  Correct Answer: CE

• Question 236:

  Which two statements are true about a duplicate database that is created by using the DUPLICATE command in RMAN? (Choose two.)

  A. It is a copy or a subset of the target database.

  B. It is opened in RESTRICT mode after a duplicating operation.

  C. It is created by using backups and archived redo log files from the target database.

  D. It is created with the same database identifier (DBID) as that of target database.

  Correct Answer: AC

  Duplicating a Database

  Overview of RMAN Database Duplication

  Database duplication is the use of the DUPLICATE command to copy all or a subset of the data in a source database. The duplicate database (the copied database) functions entirely independently from the source database (the database

  being copied).

  Purpose of Database Duplication

  If you copy a database with operating system utilities instead of the DUPLICATE command, then the DBID of the copied database remains the same as the original database. To register the copy database in the same recovery catalog with

  the original, you must change the DBID with the DBNEWID utility (see Oracle Database Utilities). In contrast, the DUPLICATE command automatically assigns the duplicate database a different DBID so that it can be registered in the same

  recovery catalog as the source database.

  Backup-Based Duplication

  In backup-based duplication, RMAN creates the duplicate database by using pre-existing RMAN backups and copies. This technique of duplication uses one of the following mutually exclusive subtechniques:

  Duplication without a target database connection, RMAN obtains metadata about backups from a recovery catalog.

  Duplication without a target database connection and without a recovery catalog. RMAN obtains metadata about where backups and copies reside from BACKUP LOCATION. Duplication with a target database connection. RMAN obtains

  metadata about backups from the target database control file or from the recovery catalog.

  How RMAN Duplicates a Database

  For backup-based duplication, the principal work of the duplication is performed by the auxiliary channels.

  These channels correspond to a server session on the auxiliary instance on the destination host. For active database duplication the primary work is performed by target channels. RMAN must perform database point-in-time recovery, even

  when no explicit point in time is provided for duplication. Point-in-time recovery is required because the online redo log files in the source database are not backed up and cannot be applied to the duplicate database. The farthest point of

  recovery of the duplicate database is the st recent redo log file archived by the source database.

  As part of the duplicating operation, RMAN automates the following steps:

  1.

  Creates a default server parameter file for the auxiliary instance if the following conditions are true:

  Duplication does not involve a standby database.

  Server parameter files are not being duplicated.

  The auxiliary instance was not started with a server parameter file.

  2.

  Restores from backup or copies from active database the latest control file that satisfies the UNTIL clause requirements.

  3.

  Mounts the restored or copied backup control file from the active database.

  4.

  Uses the RMAN repository to select the backups for restoring the data files to the auxiliary instance.

  This step applies to backup-based duplication.

  5.

  Restores and copies the duplicate data files and recovers them with incremental backups and archived redo log files to a noncurrent point in time.

  6.

  Shuts down and restarts the database instance in NOMOUNT mode.

  7.

  Creates a new control file, which then creates and stores the new DBID in the data files.

  8.

  Opens the duplicate database with the RESETLOGS option and creates the online redo log for the new database.

• Question 237:

  You are managing the APPPROD database as a DBA. You plan to duplicate this database in the same system with the name DUPDB. You issued the following RMAN commands to create a duplicate database:

  

  Which three are the prerequisites for the successful execution of the above command? (Choose three.)

  A. The source database should be open.

  B. The target database should be in ARCHIVELOG mode if it is open.

  C. RMAN should be connected to both the instances as SYSDBA.

  D. The target database backups should be copied to the source database backup directories.

  E. The password file must exist for the source database and have the same SYS user password as the target.

  Correct Answer: BCE

• Question 238:

  As part of archiving the historical data, you want to transfer data from one database to another database, which is on another server. All tablespaces in the source database are read/write and online. The source and target databases use the same compatibility level and character sets. View the Exhibit and examine the features in the source and target database.

  Which of the following steps are required to transport a tablespace from the database to the target database:

  1.

  Make the tablespace read-only at the source database.

  2.

  Export metadata from the source database.

  3.

  Convert data filed by using Recovery Manager (RMAN).

  4.

  Transfer the dump file and data filed to the target machine.

  5.

  Import metadata at the target database.

  6.

  Make the tablespace read/write at the target database.

  Exhibit: A. 2, 4, and 5

  

  B. All the steps

  C. 2, 3, 4 and 5

  D. 1, 2, 4, 5 and 6

  Correct Answer: D

  Refer to here. Generate a Transportable Tablespace Set read_only--expdp--4-import-read_wrtie

  1, 2, 4, 5, 6 (optional)

  If both platforms have the same endianness, no conversion is necessary. Otherwise you must do a conversion of the tablespace set either at the source or destination database. Transport the dump file to the directory pointed to by the DATA_PUMP_DIR directory object, or to any other directory of your choosing.

  Run the following query to determine the location of DATA_PUMP_DIR: SELECT * FROM DBA_DIRECTORIES WHERE DIRECTORY_NAME = 'DATA_PUMP_DIR';

  

  Transport the data files to the location of the existing data files of the destination database. On the UNIX and Linux platforms, this location is typically /u01/app/oracle/oradata/SID/ or +DISKGROUP/SID/ datafile/.

• Question 239:

  When you are 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.

  Correct Answer: B

• Question 240:

  Which of the following commands will perform an active database duplication of the ORCL database to the ORCL2 database?

  

  A. B. C. D. E.

  Correct Answer: E