Your database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)? (Choose Three)
A. Redo logs
B. Control file
C. The latest backup of only the damaged data file
D. The latest backup of all the data file in the USERS tablespace
E. Temporary files of temporary tablespace
F. Archive Logs since the latest backup to point of failure
Examine the following scenario:
Database is running in ARCHIVELOG mode.
Complete consistent backup is taken every Sunday.
On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted
The disk having active online redo log files is also corrupted. The hardware is repaired and the paths for online redo log files and control files are still valid.
Which option would you use to perform the recovery of database till the point of failure?
A. Restore the latest whole backup, perform complete recovery, and open the database normally
B. Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS option.
C. Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS option.
D. Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option.
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.)
A. The database must be opened in restricted mode.
B. The database must be configured to run in ARCHIVELOG mode.
C. The tablespaces are required to be in backup mode before taking the backup.
D. The tablespaces are required to be in read-only mode before taking the backup
You realize that the control file is damaged in your production database. After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?
A. Mount the database
B. Open the database in NORMAL mode
C. Open the database in RESTRICTED mode
D. Open the database with the RESETLOGS option
You have lost datafile 4 from your database. Which is typically the fastest way to restore your database?
A. Restore and recover the datafile.
B. Restore and recover the tablespace.
C. Restore and recover the database.
D. Restore and recover the control file.
E. Restore and recover the parameter file.
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 '/oracle01/flash_recovery_area/ORCL/
archivelog/2008_08_17 / o1_mf_1_10_4bj6wnqm_.arc' no longer needed for this recovery Specify log:
{
ORA-00308: cannot open archived log '/oracle01/flash_recovery_area/ORCL/ archivelog/2008_08_17 /o1_mf_1_11_%u_.arc'
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.)
A. Restore the archived redo log that is missing and attempt recovery again.
B. Recovery is complete and you can open the database.
C. Recovery needs redo that is not available in any archived redo log. Attempt to apply an online redo log if available.
D. Recover the entire database and apply all archived redo logs again.
E. Recovery is not possible because an archived redo log has been lost.
What methods are available to recover lost control files? (Choose all that apply.)
A. Backup control file.
B. Emergency control file.
C. The create controlfile command.
D. The restore controlfile SQL*Plus command.
E. No backup is required. The database will re-create the control file when it is discovered to be lost.
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?
A. a, b, e, c
B. b, e, d
C. a, b, d, c
D. b, g, c, f
E. a, b, d, f
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.
SQL> 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: '/oracle01/oradata/orcl/redo02a.log' 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: '/oracle01/oradata/orcl/redo02.log' ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3
SQL> 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:
'/oracle01/oradata/orcl/redo02.log' ORA-00312: online log 2 thread 1: '/oracle01/oradata/orcl/redo02a.log'
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.
A.
b, a, f
B.
e, b, a, f
C.
e, b, a, g
D.
b, a, g
E.
c, e, b, d, f
Your database is running In ARCHIVELOG mode. One of the data files, USERDATA01.DBF, in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available.
Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)? (Choose three.)
A. redo logs
B. control file
C. temporary files of temporary tablespace
D. the latest backup of only the damaged data file
E. the latest backup of all the data files In the USERS tablespace
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Oracle exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 1Z0-053 exam preparations and Oracle certification application, do not hesitate to visit our Vcedump.com to find your solutions here.