[Free] 2018(Jan) Latesttests Testking Oracle 1z0-053 Dumps with VCE and PDF Download 271-280

Latesttests 2018 Jan Oracle Official New Released 1z0-053
100% Free Download! 100% Pass Guaranteed!
http://www.Latesttests.com/1z0-053.html

Oracle Database 11g: Administration II

Question No: 271 – (Topic 7)

You executed the following commands in an RMAN session for your database instance that has failures:

RMANgt; LIST FAILURE;

After some time, you executed the following command in the same session: RMANgt; ADVISE FAILURE;

But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command.

Which statement is true for the above ADVISE FAILURE command in this scenario?

  1. It produces a warning for new failures before advising for CRITICAL and HIGH failures.

  2. It ignores new failures and considers the failures listed in the last LIST FAILURE command only.

  3. It produces an error with recommendation to run the LIST FAILURE command before the ADVISE FAILURE command.

  4. It produces advice only for new failures and the failures listed in the last LIST FAILURE command are ignored.

Answer: A

Question No: 272 – (Topic 7)

You are performing incomplete recovery using RMAN. You execute the following RUN block:

RUN

{

SET UNTIL SCN 1107600; RESTORE DATABASE; RECOVER DATABASE;

}

Which statement is true about the result?

  1. RMAN restores all datafiles from the most recent backup available since the failure and applies the redo logs necessary to recover the database to SCN 1107600

  2. RMAN restores all datafiles needed to restore the database through SCN 1107599 and applies the redo logs necessary to recover the database through SCN 1107599.

  3. RMAN restores all datafiles and control files from the most recent backup

  4. The RUN block fails because you did not specify an UNTIL clause in your RECOVER DATABASE command

Answer: B

Question No: 273 – (Topic 7)

You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations.

While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?

  1. Open the database in NORMAL mode

  2. Open the database in read-only mode

  3. Open the database in RESTRICTED mode

  4. Open the database with the RESETLOGS option

    Answer: D Explanation:

    Recovering the Database After a Disaster

    The procedure for disaster recovery is similar to the procedure for recovering the database with a backup control file in NOCATALOG mode. If you are restoring the database to a new host, then you should also review the considerations described in quot;Restoring a Database on a New Hostquot;.

    This scenario assumes that the Linux server on which your database was running has been damaged beyond repair. Fortunately, you backed up the database to Oracle Secure Backup and have the tapes available. The scenario assumes the following:

    ->Oracle Database is already installed on the new host.

    ->You are restoring the database to a new Linux host with the same directory structure as the old host.

    ->You have one tape drive containing backups of all the data files and archived redo logs through log 1124, and autobackups of the control file and server parameter file.

    ->You do not use a recovery catalog with the database.

    To recover the database on the new host:

    1. If possible, restore or re-create all relevant network files such as tnsnames.ora and listener.ora and a password file.

    2. Start RMAN and connect to the target database instance.

      At this stage, no initialization parameter file exists. If you have set ORACLE_SID and ORACLE_HOME, then you can use operating system authentication to connect as SYSDBA. For example, start RMAN as follows:

      % rman

      RMANgt; CONNECT TARGET

      /

    3. Specify the DBID for the target database with the SET DBID command, as described in quot;Restoring the Server Parameter Filequot;.

      For example, enter the following command: SET DBID 676549873;

    4. Run the STARTUP NOMOUNT command.

      When the server parameter file is not available, RMAN attempts to start the instance with a dummy server parameter file.

    5. Allocate a channel to the media manager and then restore the server parameter file from autobackup. For example, enter the following command to restore the server parameter file from Oracle Secure Backup:

      RUN

      {

      ALLOCATE CHANNEL c1 DEVICE TYPE sbt; RESTORE SPFILE FROM AUTOBACKUP;

      }

    6. Restart the instance with the restored server parameter file. STARTUP FORCE NOMOUNT;

    7. Write a command file to perform the restore and recovery operation, and then execute the command file.

      The command file should do the following:

      1. Allocate a channel to the media manager.

      2. Restore a control file autobackup (see quot;Performing Recovery with a Backup Control File and No Recovery Catalogquot;).

      3. Mount the restored control file.

      4. Catalog any backups not recorded in the repository with the CATALOG command.

      5. Restore the data files to their original locations. If volume names have changed, then run SET

        NEWNAME commands before the restore operation and perform a switch after the restore operation to update the control file with the new locations for the data files, as shown in the following example.

      6. Recover the data files. RMAN stops recovery when it reaches the log sequence number specified.

        RMANgt; RUN

        {

        # Manually allocate a channel to the media manager ALLOCATE CHANNEL t1 DEVICE TYPE sbt;

        # Restore autobackup of the control file. This example assumes that you have

        # accepted the default format for the autobackup name. RESTORE CONTROLFILE FROM AUTOBACKUP;

        # The set until command is used in case the database

        # structure has changed in the most recent backups, and you want to

        # recover to that point in time. In this way RMAN restores the database

        # to the same structure that the database had at the specified time. ALTER DATABASE MOUNT;

        SET UNTIL SEQUENCE 1124 THREAD 1; RESTORE DATABASE;

        RECOVER DATABASE;

        }

        The following example of the RUN command shows the same scenario except with new file

        names for the restored data files:

        RMANgt; RUN

        {

        # If you must restore the files to new locations,

        # use SET NEWNAME commands:

        SET NEWNAME FOR DATAFILE 1 TO #39;/dev/vgd_1_0/rlvt5_500M_1#39;; SET NEWNAME FOR DATAFILE 2 TO #39;/dev/vgd_1_0/rlvt5_500M_2#39;; SET NEWNAME FOR DATAFILE 3 TO #39;/dev/vgd_1_0/rlvt5_500M_3#39;; ALLOCATE CHANNEL t1 DEVICE TYPE sbt;

        RESTORE CONTROLFILE FROM AUTOBACKUP; ALTER DATABASE MOUNT;

        SET UNTIL SEQUENCE 124 THREAD 1; RESTORE DATABASE;

        SWITCH DATAFILE ALL; # Update control file with new location of data files. RECOVER DATABASE;

        }

    8. If recovery was successful, then open the database and reset the online logs: ALTER DATABASE OPEN RESETLOGS;

Question No: 274 – (Topic 7)

What is the end result of these commands if they are successful?

RMANgt; show retention policy;

RMAN configuration parameters for database with db_unique_name ORCL are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

RMANgt; backup database tag=gold_copy plus archivelog tag=gold_copy delete input; RMANgt; backup database tag=silver_copy plus archivelog tag=silver_copy delete input;

  1. Attempting to restore silver_copy will fail.

  2. Attempting to restore gold_copy will fail.

  3. Both backups will be available for restore without question.

  4. Attempting to restore gold_copy may or may not succeed.

  5. You will not be able to restore either gold_copy or silver_copy.

Answer: D

Question No: 275 – (Topic 7)

While querying the EMPLOYEES table, you receive an ORA-01578 message indicating block corruption in File# 1201 and Block# 1968. You analyze the table and the corruption is verified.

Which RMAN command do you use to perform BMR and repair the corrupt block?

  1. RECOVER FILE=1201 BLOCK=1968;

  2. RECOVER CORRUPTION LIST;

  3. RECOVER DATAFILE 1201 BLOCK 1968;

  4. RECOVER BLOCK CORRUPTION LIST;

  5. None of the above

Answer: B,C

Question No: 276 – (Topic 7)

Given the following RMAN commands, choose the option that reflects the order required to restore your currently operational ARCHIVELOG mode database.

a: restore database; b: recover database;

c: shutdown immediate d: startup

e: restore archivelog all; f: alter database open

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

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

  3. c, b, a, d, f

  4. c, a, b, d

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

Answer: C

Question No: 277 – (Topic 7)

View the Exhibit to examine the error during the database startup. You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:

RMANgt; REPAIR FAILURE;

Which statement describes the consequence of the command? Exhibit:

Latesttests 2018 PDF and VCE

  1. The command performs the recovery and closes the failures.

  2. The command only displays the advice and the RMAN script required for repair.

  3. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.

  4. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).

Answer: C

Question No: 278 – (Topic 7)

You have control-file autobackups enabled. When starting your database from SQL*Plus, you receive the following error message:

SQLgt; startup

ORA-01078: failure in processing system parameters

LRM-00109: could not open parameter file #39;C:\ORACLE\PRODUCT\11.1.0\DB_1\DATABASE

\INITORCL.ORA#39;

Using RMAN, how would you respond to this error?

  1. Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.

  2. Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.

  3. Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.

  4. Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.

  5. Issue the restore spfile from autobackup command from the RMAN prompt.

Answer: C

Question No: 279 – (Topic 7)

You are using Recovery Manager (RMAN) for backup and recovery operations with a recovery catalog. You have been taken database backups every evening. On November 15, 2007, at 11:30 AM, you were informed that the USER_DATA tablespace was accidentally dropped. On investigation, you found that the tablespace existed until 11:00 AM, and important transactions were done after that.

So you decided to perform incomplete recovery until 11:00 AM. All the archive logs needed to perform recovery are intact. In NOMOUNT state you restored the control file that has information about the USER_DATA tablespace from the latest backup. Then you mounted the database. Identify the next set of commands that are required to accomplish the task?

Latesttests 2018 PDF and VCE

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Answer: A

Question No: 280 – (Topic 7)

Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)

  1. The user has dropped an important table that needs to be recovered.

  2. The database files are corrupted when the database is open.

  3. You are not able to start up the database instance because the required database files are missing.

  4. The archived log files are missing for which backup is not available.

Answer: B,C

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

Latesttests 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

2018 Latesttests IT Certification PDF and VCE