[Free] 2018(Jan) EnsurePass Passguide Oracle 1z0-053 Dumps with VCE and PDF 291-300

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-053
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-053.html

Oracle Database 11g: Administration II

Question No: 291 – (Topic 7)

Which two statements are true about the duplexing of the backups taken by RMAN?

(Choose two.)

  1. It#39;s only supported for the backups performed on the tape

  2. It is not supported for backup operations that produce image copies

  3. Duplex backups need a parallelism for the device to be equal to number of copies

  4. Duplex backups can be performed to either disk or tape, but cannot be performed on tape and disk simultaneously

Answer: B,D

Question No: 292 – (Topic 7)

A user sends you an email with the following error message:

create table idtable(id number)

* ERROR at line 1:

ORA-01116: error in opening database file 4

ORA-01110: data file 4: #39;/oracle01/oradata/orcl/users01.dbf#39;

ORA-27041: unable to open file Linux Error: 2: No such file or directory Additional information: 3

You can choose from the following steps:

a: Restore the missing database datafiles. b: Take the missing datafile offline.

c: Shut down the database.

d: Issue the recover tablespace USERS command.

e: Issue the Startup Mount command to mount the database. f: Bring the USERS tablespace online.

g: Issue the alter database open command.

Which is the correct order of these steps in this case?

  1. b, a, d, f

  2. c, a, e, b, d, f, g

  3. c, e, d, g

  4. b, d, f

  5. e, d, g

Answer: A Explanation: RMANgt; repair failure;

Strategy: The repair includes complete media recovery with no data loss

Repair script: /u01/app/oracle/diag/rdbms/test0924/test0924/hm/reco_172511374.hm contents of repair script:

# restore and recover datafile

sql #39;alter database datafile4 offline#39;; restore datafile 4;

recover datafile 4;

sql #39;alter database datafile 4 online#39;;

Question No: 293 – (Topic 7)

Which of the following are valid until command options when attempting point-in-time recovery in RMAN? (Choose all that apply.)

  1. until time

  2. until change

  3. until sequence

  4. until SCN

  5. until commit

    Answer: A,C,D

    Question No: 294 – (Topic 7)

    David managed to accidentally delete the datafiles for database called DSL. He called

    Heber and Heber tried to help but he managed to delete the control files of the database. Heber called Bill and Bill saved the day.

    They are using a recovery catalog for this database.

    What steps did Bill perform to recover the database and in what order?

    1. Restored the control file with the RMAN restore controlfile command.

    2. Mounted the DSL instance with the alter database mount command.

    3. Restored the datafiles for the DSL database with the RMAN restore command.

    4. Opened the DSL database with the alter database open resetlogs command.

    5. Recovered the datafiles for the DSL database with the RMAN recover command.

    6. Started the DSL instance.

    7. Connected to the recovery catalog with RMAN.

      1. a, b, c, d, e, f, g

      2. b, c, d, g, f, e, a

      3. g, f, a, b, c, e, d

      4. c, a, d, b, f, e, g

      5. g, f, a, b, e, c, d

        Answer: C Explanation:

        About Recovery with a Backup Control File

        If all copies of the current control file are lost or damaged, then you must restore and mount a backup control file. You must then run the RECOVER command, even if no data files have been restored, and open the database with the RESETLOGS option. If some copies of the current control file are usable, however, then you can follow the procedure in quot;Responding to the Loss of a Subset of the Current Control Filesquot; and avoid the recovery and RESETLOGS operation.

        When RMAN is connected to a recovery catalog, the recovery procedure with a backup control file is identical to recovery with a current control file. The RMAN metadata missing from the backup control file is available from the recovery catalog. The only exception is if the database name is not unique in the catalog, in which case you must use SET DBID command before restoring the control file.

        1. Start RMAN and connect to a target database.

        2. Start the target instance without mounting the database. RMANgt;STARTUP NOMOUNT;

        3. Restore the control file

          RMANgt; SET DBID 320066378; # (Optional) If the database name is not unique, you need to specify the DBID

          RMANgt; RUN

          {

          SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO

          #39;autobackup_format#39;;

          RESTORE CONTROLFILE FROM AUTOBACKUP;

          }

        4. Start the target instance with mounting the database. RMANgt;STARTUP MOUNT;

        5. Restore the data files; RMANgt;RESTORE DATABASE;

        6. Recover the database; RMANgt;RECOVER DATABASE;

        7. Open the database with RESETLOGS option; RMANgt; ALTER DATABASE OPEN RESETLOGS;

          Question No: 295 – (Topic 7)

          Which components are needed for successful and most efficient recovery.

          1. The backup RB3 and the current online redo log files

          2. the backup RB2 and the archived redo log files after the log sequence number 15622

          3. Backup R81 and the archived redo log hies after the log sequence number 12871

          4. The backup RB3 and the archived redo log files after the log sequence number 16721

Answer: A

Topic 8, Using RMAN to Duplicate a Database

Question No: 296 – (Topic 8)

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

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

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

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

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

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

Answer: A,B,D

Question No: 297 – (Topic 8)

When issuing the duplicate database command, you use the parameter DB_FILE_NAME_CONVERT. For what purpose do you use this parameter?

  1. To indicate the location of the auxiliary-instance online redo logs.

  2. To indicate the location of the target database datafiles.

  3. To indicate the location of the auxiliary-instance control file and online redo logs.

  4. To indicate the location of the auxiliary-instance database datafiles.

  5. This is not a valid parameter when duplicating a database.

Answer: D

Question No: 298 – (Topic 8)

Which two statements are correct about database transportation? (Choose two.)

  1. The source and target platforms must be the same

  2. Redo logs, control files and temp files are also transported

  3. The transported database must have the same database identifier (DBID) as the source database and cannot be changed

  4. The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported

  5. Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format

Answer: D,E

Question No: 299 – (Topic 8)

True or false: you can perform an active database duplication when the database is in NOARCHIVELOG mode.

  1. True

  2. False

Answer: B

Question No: 300 – (Topic 8)

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

  1. Testing the backup and recovery procedures

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

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

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

Answer: A,B,C

100% Ensurepass Free Download!
Download Free Demo:1z0-053 Demo PDF
100% Ensurepass Free Guaranteed!
Download 2018 EnsurePass 1z0-053 Full Exam PDF and VCE

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *