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

Latesttests 2018 Jan Oracle Official New Released 1z0-053
100% Free Download! 100% Pass Guaranteed!

Oracle Database 11g: Administration II

Question No: 231 – (Topic 6)

You are trying to recover your database. During the recovery process, you receive the following error:

ORA-00279: change 5033391 generated at 08/17/2008 06:37:40 needed for thread 1 ORA-00289: suggestion: /oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 / o1_mf_1_11_%u_.arc

ORA-00280: change 5033391 for thread 1 is in sequence #11

ORA-00278: log file #39;/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 / o1_mf_1_10_4bj6wnqm_.arc#39; no longer needed for this recovery Specify log:

{lt;RETgt;=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log #39;/oracle01/flash_recovery_area/ORCL/ archivelog/2008_08_17 /o1_mf_1_11_%u_.arc#39;

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

Additional information: 3

How do you respond to this error? (Choose two.)

  1. Restore the archived redo log that is missing and attempt recovery again.

  2. Recovery is complete and you can open the database.

  3. Recovery needs redo that is not available in any archived redo log. Attempt to apply an online redo log if available.

  4. Recover the entire database and apply all archived redo logs again.

  5. Recovery is not possible because an archived redo log has been lost.

    Answer: A,C

    Question No: 232 – (Topic 6)

    You have lost all your SYSTEM tablespace datafiles (system_01.dbf and system_02.dbf) and the database has crashed.

    What would be the appropriate order of operations to correct the situation?

    1. Mount the database with the startup mount command.

    2. Take the SYSTEM data file offline with the alter database command.

    3. Restore the SYSTEM_01.dbf data file from backup media with the required archived redo logs.

    4. Restore all SYSTEM tablespace-related datafiles from backup media.

    5. Issue the recover tablespace SYSTEM command.

    6. Issue the recover data file SYSTEM_01.dbf command.

    7. Open the database with the alter database open command.

    8. Open the database with the alter database open RESETLOGS command.

      1. a, c, f, g

      2. b, d, e, h

      3. a, b, c, f, g

      4. d, a, e, g

      5. b, c, f, e, g

Answer: D Explanation:

Because there is NO controlfile damaged, and there is NO PITR recover, you don#39;t need to use RESETLOGS option.

Question No: 233 – (Topic 6)

What is the correct order of the following commands if you wanted to restore datafile 4, which was accidentally removed from the file system?

a: sql #39;alter database datafile 4 online#39;; b: restore datafile 4;

c: recover datafile 4;

d: sql #39;alter database datafile 4 offline#39;; e: startup

f: shutdown

  1. a, c, b, d

  2. d, b, c, a

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

  4. c, a, b, d, f

  5. a, b, d, e

Answer: B

Question No: 234 – (Topic 6)

You want to put a specific tablespace called MY_DATA in hot backup mode so you can back it up.

What command would you use?

  1. alter tablespace MY_DATA begin backup;

  2. alter tablespace MY_DATA start backup;

  3. alter tablespace MY_DATA backup begin;

  4. alter MY_DATA begin backup;

  5. You cannot back up individual tablespaces.

Answer: A

Question No: 235 – (Topic 6)

Which is NOT a valid way of backing up a control file?

  1. Backing up the control file to trace

  2. Copying the existing control file of the database to the backup location during a hot backup

  3. Copying the existing control file of the database to the backup location during a cold backup

  4. Creating a backup control file

  5. Using the create controlfile command

    Answer: B

    Question No: 236 – (Topic 6)

    You are peer reviewing a fellow DBAs backup plan for his NOARCHIVELOG mode database, as shown here:

    1. Put the tablespaces in backup mode.

    2. Back up the datafiles for all tablespaces.

    3. Take the tablespaces out of backup mode.

    4. Back up all archived redo logs.

      Your colleague asks for you to comment on his plan. Which response would be correct?

      1. The plan will work as is.

      2. The plan needs to be modified to allow for an archive-log switch after step 3.

      3. The plan needs to be modified so that a backup of the archived redo logs occurs before

        step 1.

      4. The plan needs to be adjusted to shut down the database after step 1 and to restart the database after step 2.

      5. The plan cannot work as presented.

        Answer: B Explanation:

        Without command ALTER SYSTEM SWITCH LOGFILE, the backup of archive redo logs will be useless.

        Question No: 237 – (Topic 6)

        Given a complete loss of your database, in what order would you need to perform the following RMAN operations to restore it?

        1. restore controlfile

        2. restore database

        3. restore spfile

        4. recover database

        5. alter database open

        6. alter database open resetlogs

  1. b, a, c, d, e

  2. a, c, b, d, f

  3. c, a, b, d, e

  4. c, a, b, d, f

  5. e, a, b, d, c

Answer: D

Question No: 238 – (Topic 6)

What is the correct order of steps to perform an online database backup?

a: alter database begin backup; b: alter database end backup;

c: Back up the database datafiles. d: Back up the archive log files.

e: alter system switch logfile;

  1. a, b, c, d, e

  2. e, d, a, b, c

  3. a, c, b, d, e

  4. d, b, c, a, e

  5. a, c, b, e, d

    Answer: E Explanation: (link)

    To back up online read/write tablespaces in an open database:

    1. Use the DBA_DATA_FILES data dictionary view to identify all of the data files in the tablespace.


    3. Back up the online data files of the online tablespace with operating system commands.


    5. ALTER SYSTEM ARCHIVE LOG CURRENT; Archive the unarchived redo logs so that the redo required to recover the tablespace backup is archived.

      Question No: 239 – (Topic 6)

      You are managing a 24*7 database. The backup strategy for the database is to perform user-managed backups.

      Identify two prerequisites to perform the backups. (Choose two.)

      1. The database must be opened in restricted mode.

      2. The database must be configured to run in ARCHIVELOG mode.

      3. The tablespaces are required to be in backup mode before taking the backup.

      4. The tablespaces are required to be in read-only mode before taking the backup

Answer: B,C

Question No: 240 – (Topic 6)

In your test database:

->You are using Recovery Manager (RMAN) to perform incremental backups of your test database

->The test database is running in NOARCHIVELOG mode

->One of the data files is corrupted

->All online redo log files are lost because of a media failure

Which option must you consider in this scenario?

  1. Configuring the database in ARCHVIELOG mode and then using incremental backup to recover the database

  2. Using incremental backup to recover the damaged data file and then manually creating the online redo log files

  3. Creating a new test database because the database is not recoverable due to the fact that the database is configured in NOARCHIVELOG mode

  4. Using incremental backups to recover the database by using the RECOVER DATABASE NOREDO command and then using the RESETLOGS option to open the database.

Answer: D Explanation:

Example 3-6 Recovering a NOARCHIVELOG Database

You can perform limited recovery of changes to a database running in NOARCHIVELOG mode by applying incremental backups. The incremental backups must be consistent, like all backups of a database run in NOARCHIVELOG mode, so you cannot back up the database when it is open.

Assume that you run database prod in NOARCHIVELOG mode with a recovery catalog. You shut down the database consistently and make a level 0 backup of database prod to tape on Sunday afternoon. You shut down the database consistently and make a level 1 differential incremental backup to tape at 3:00 a.m. on Wednesday and Friday.

On Saturday, a media failure destroys half the data files and the online redo logs. Because the online logs are lost, you must specify the NOREDO option in the RECOVER command. Otherwise, RMAN searches for the redo logs after applying the Friday incremental backup and issues an error message when it does not find them.

After connecting RMAN to prod and the catalog database, recover as follows:


RESTORE CONTROLFILE; # restore control file from consistent backup ALTER DATABASE MOUNT;

RESTORE DATABASE; # restore data files from consistent backup

RECOVER DATABASE NOREDO; # specify NOREDO because online redo logs are lost


The recovered database reflects only changes up through the time of the Friday incremental backup. Because there are no archived redo log files, there is no way to recover changes made after the incremental backup.

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
Free VCE Simulator Yes No No
Instant Download Yes No No

2018 Latesttests IT Certification PDF and VCE