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

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: 241 – (Topic 6)

Which command will result in a trace file being created with the create controlfile command contained in it?

  1. alter database backup controlfile;

  2. alter database backup controlfile to trace;

  3. alter database controlfile backup;

  4. alter database controlfile backup to #39;/ora01/oracle/ctrl_backup.ctl#39;;

  5. alter database begin controlfile backup;

    Answer: B Explanation:

    ALTER DATABASE BACKUP CONTROLFILE TO TRACE

    Specify TO TRACE if you want Oracle Database to write SQL statements to a trace file rather than making a physical backup of the control file. You can use SQL statements written to the trace file to start up the database, re-create the control file, and recover and open the database appropriately, based on the created control file. If you issue an ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement while block change tracking is enabled, then the resulting trace file will contain a command to reenable block change tracking.

    The trace file will also include ALTER DATABASE REGISTER LOGFILE statements for existing logfiles that reside in the current archivelog destinations. This will implicitly create database incarnation records for the branches of redo to which the logfiles apply.

    You can copy the statements from the trace file into a script file, edit the statements as

    necessary, and use the script if all copies of the control file are lost (or to change the size of the control file).

    Question No: 242 – (Topic 6)

    You want to migrate your database to ASM, so you have done a clean shutdown, made a closed backup of the entire database. You noted the location of your control files and online redo log files, and changed your spfile to use OMF. The last step is to run an RMAN script to do the conversion. Using the following steps, what is the correct order in which the following RMAN commands should be executed?

    1. STARTUP NOMOUNT

    2. ALTER DATABASE OPEN RESETLOGS

    3. SQL quot;ALTER DATABASE RENAME #39;logfile1#39; path TO #39; dgrp4#39;quot; # plus all other logfiles

    4. SWITCH DATABASE TO COPY

    5. BACKUP AS COPY DATABASE FORMAT #39; dgrp4#39;

    6. ALTER DATABASE MOUNT

    7. RESTORE CONTROLFILE FROM #39;controlfile_location#39;

      A. 2, 5, 3, 1, 7, 6, 4

      B. 1, 7, 6, 5, 4, 3, 2

      C. 5, 1, 2, 7, 4, 6, 3

      D. 7, 3, 1, 5, 6, 2, 4

      Answer: B

      Question No: 243 – (Topic 6)

      A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following

      Error message:

      Ensurepass 2018 PDF and VCE

      Which is the recommended sequence of operations you need to perform for the query successfully?

      1. Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace.

      2. Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online.

      3. Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.

      4. Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode.

Answer: B

Question No: 244 – (Topic 6)

Your ARCHIVELOG mode database has lost three datafiles and shut down. One is assigned to the SYSTEM tablespace and two are assigned to the USERS tablespace. You can choose from the following steps to recover your database:

a: Restore the three database datafiles that were lost.

b: Issue the Startup Mount command to mount the database. c: Issue the alter database open command.

d: Issue the alter database open resetlogs command.

e: Recover the database using the recover database command. f: Recover the datafiles with the recover datafile command.

g: Take the datafiles offline.

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

  1. a, b, e, c

  2. b, e, d

  3. a, b, d, c

  4. b, g, c, f

  5. a, b, d, f

    Answer: A Explanation:

    Because the system critical data files is damaged, so that the RESETLOGS option is not applied. four steps to recover the system critical data (SYSTEM tablespace or the tablespace with UNDO):

    1. SHUTDOWN ABORT, if the instance is started.

    2. MOUNT the instance

    3. restore and recover the damaged data files;

    4. OPEN the database

      Question No: 245 – (Topic 6)

      If you lost your entire database, including the database spfile, control files, online redo logs, and database datafiles, what kind of recovery would be required with RMAN?

      1. Complete database recovery.

      2. Incomplete database recovery.

      3. Approximate database recovery.

      4. Archived database recovery.

      5. The database could not be recovered with RMAN.

Answer: B

Question No: 246 – (Topic 6)

After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?

  1. Opening the database in RESTRICTED mode

  2. Opening the database with the RESETLOGS option

  3. Setting a new DBID for the newly restored database

  4. Restoring the server parameter file (SPFILE) to the new host

    Answer: B

    Question No: 247 – (Topic 6)

    You have discovered that one of three control files has been lost. What steps would you follow to recover that control file?

    1. Shut down the database.

    2. Restore a control-file copy from backup media.

    3. Use the create control file command to create a new control file.

    4. Copy the backup control file into place.

    5. Create a new copy of the control file from one of the surviving control files.

    6. Recover the database using the recover database using BACKUP CONTROLFILE command.

    7. Start up the database.

      1. a, b, f, g

      2. c, f, g

      3. a, d, f, g

      4. a, f, g

      5. a, e, g

Answer: E

Question No: 248 – (Topic 6)

You have lost all your online redo logs. As a result, your database has crashed. You have tried to restart the database and clear the online redo log files, but when you try to open the database you get the following error.

SQLgt; startup

ORACLE instance started.

Total System Global Area 167395328 bytes Fixed Size 1298612 bytes

Variable Size 142610252 bytes Database Buffers 20971520 bytes Redo Buffers 2514944 bytes Database mounted.

ORA-00313: open failed for members of log group 2 of thread 1

ORA-00312: online log 2 thread 1: #39;/oracle01/oradata/orcl/redo02a.log#39;

ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3

ORA-00312: online log 2 thread 1: #39;/oracle01/oradata/orcl/redo02.log#39;

ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3

SQLgt; alter database clear logfile group 2;

alter database clear logfile group 2 * ERROR at line 1:

ORA-01624: log 2 needed for crash recovery of instance orcl (thread 1) ORA-00312: online log 2 thread 1: #39;/oracle01/oradata/orcl/redo02.log#39; ORA-00312: online log 2 thread 1: #39;/oracle01/oradata/orcl/redo02a.log#39;

What steps must you take to resolve the error?

a: Issue the recover database redo logs command.

b: Issue the Startup Mount command to mount the database. c: Restore the last full database backup.

d: Perform a point-in-time recovery, applying all archived redo logs that are available.

e: Restore all archived redo logs generated during and after the last full database backup. f: Open the database using the alter database open resetlogs command.

g: Issue the alter database open command.

  1. b, a, f

  2. e, b, a, f

  3. e, b, a, g

  4. b, a, g

  5. c, e, b, d, f

Answer: E Explanation:

If the online redo log is in ACTIVE or CURRENT status, you cannot issue CLEAR LOGFILE GROUP n command, it occurs ORA-01624 error.

The option (a) is invalid, there is NO such recover database redo log command, so that the answer must be (c, e, b, d, f).

It applies an incomplete recovery, then open database with RESETLOGS option.

Question No: 249 – (Topic 6)

Which are the correct steps, in order, to deal with the loss of an online redo log if the database has not yet crashed?

a: Issue a checkpoint.

b: Shut down the database.

c: Issue an alter database open command to open the database. d: Startup mount the database.

e: Issue an alter database clear logfile command. f: Recover all database datafiles.

  1. a, b, c, d

  2. b, d, e, c

  3. a, b, d, e, c

  4. b, f, d, f, c

  5. b, d, a, c

Answer: C

Question No: 250 – (Topic 6)

Which of the following represents the correct way to perform an online recovery of datafile 4, which is assigned to a tablespace called USERS?

  1. shutdown restore datafile 4; recover datafile 4; alter database open;

  2. Sql alter database datafile 4 offline; restore datafile 4; recover datafile 4; alter database open;

  3. Sql alter database datafile 4 offline; restore datafile 4; Sql alter database datafile 4 online;

  4. Sql alter database datafile 4 offline; restore database datafile 4; recover database datafile 4; Sql alter database datafile 4 online;

  5. Sql alter database datafile 4 offline; restore datafile 4; recover datafile 4; Sql alter database datafile 4 online;

Answer: E

100% Ensurepass Free Download!
Download Free Demo:1z0-053 Demo PDF
100% Ensurepass Free Guaranteed!
1z0-053 Dumps

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 *