Oracle Database 11g: Administration II
Question No: 191 – (Topic 5)
You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.
Which two statements are true about this backup operation? (Choose two.)
Backup compression should be enabled
Parallelism for the channel should be set to 2
All the files must be backed up as backup sets
The backup may be stored either on disk or on media with media manager
Question No: 192 – (Topic 5)
Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backup and specify the KEEP clause.
Which components are backed up when this option is specified?
only the control file, the current SPFILE, and data files
only the current SPFILE and data files if autobackup is disabled
only the data files and the archived redo logs
the control file, current SPFILE file, data files, and archived redo logs
Question No: 193 – (Topic 5)
What is the impact of the results of the output of the following command?
RMANgt; report unrecoverable database;
Report of files that need backup due to unrecoverable operations File Type of Backup Required Name
— ———— ——————
full or incremental C:\ORACLE\ORADATA\ORCL\USERS01.DBF
There are no backup sets with any backups of the users01.dbf datafile.
The users01.dbf datafile has had unrecoverable operations occur in it. It will need to be backed up or some data loss is possible during a recovery.
The users01.dbf datafile is corrupted.
The users01.dbf datafile backup exceeds the retention criteria.
The last backup of the users01.dbf datafile failed and must be rerun.
Question No: 194 – (Topic 5)
You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?
Database Control Files
Online redo logs
Archived redo logs
The database SPFILE
None of the above, all these files are backed up.
Question No: 195 – (Topic 5)
Which of the following commands will fail?
report need backup;
report need backup days 3;
Question No: 196 – (Topic 5)
Examine the following set of RMAN commands:
RMANgt; CONFIGURE CHANNEL dc1 DEVICE TYPE DISK FORMAT #39;/u02/backup/%U#39;; RMANgt; RUN (
ALLOCATE CHANNEL Chi DEVICE TYPE DISK;
EXECUTE SCRIPT full_backup;
Which statement is true when the RMAN RUN block is executed?
The execution of the script fails because multiple channels cannot coexist.
The script is executed and both the channels are used for the script execution.
The new channel #39;CHI#39; is Ignored because a channel has been configured already.
configuration parameter dc1 is overridden because a new channel is allocated in RMAN RUN block.
Question No: 197 – (Topic 5)
True or false: RMAN offers the equivalent of the SQL command alter database backup controlfile to trace.
Question No: 198 – (Topic 5)
Given the following steps, which would be the correct order to create a backup of an Oracle database in NOARCHIVELOG mode?
shutdown immediate from RMAN
Log into RMAN
startup mount from RMAN 10.backup database
alter database open
backup database plus archivelog delete input
Answer: E Explanation:
Backing Up a Database in NOARCHIVELOG Mode
If a database runs in NOARCHIVELOG mode, then the only valid database backup is a consistent backup. For the backup to be consistent, the database must be mounted after a consistent shutdown. No recovery is required after restoring the backup.
To make a consistent database backup:
Start RMAN and connect to a target database.
Shut down the database consistently and then mount it.
For example, enter the following commands to guarantee that the database is in a consistent state for a backup:
RMANgt; SHUTDOWN IMMEDIATE; RMANgt; STARTUP FORCE DBA; RMANgt; SHUTDOWN IMMEDIATE; RMANgt; STARTUP MOUNT;
Run the BACKUP DATABASE command.
For example, enter the following command at the RMAN prompt to back up the database to the default backup device:
RMANgt; BACKUP DATABASE;
The following variation of the command creates image copy backups of all data files in the database:
RMANgt; BACKUP AS COPY DATABASE;
Open the database and resume normal operations. The following command opens the database:
RMANgt; ALTER DATABASE OPEN;
Question No: 199 – (Topic 5)
What is the impact of the following backup if it exceeds the duration allowance? backup as compressed backupset duration 2:00 partial minimize load database ;
The entire backup will fail. It will not be usable for recovery.
The entire backup will fail, but any datafile successfully backed up will be usable for recovery.
If this backup fails, subsequent backups will prioritize datafiles not backed up.
If this backup fails, an error will be raised and any other commands will not be executed.
If this backup fails, no error will be raised and any other commands will be executed.
Question No: 200 – (Topic 5)
Identify the scenarios in which the RMAN CROSSCHECR command is useful. (Choose all that apply.)
To check that the obsolete backups are deleted from the repository records and from the disk.
To update the RMAN repository if you delete archived redo logs with operating system commands.
To update outdated information about backups that disappeared from disk or tape or became corrupted and inaccessible.
To synchronize the actual files on disk or in the media management catalog with the RMAN repository for which the backup was not taken using RMAN.
Answer: B,C Explanation:
Crosscheck are useful because they can do the following: (Link)
->Update outdated information about backups that disappeared from disk or tape or became corrupted
->Update the repository if you delete archived redo logs or other files with operating system commands
Use the CROSSCHECK command to synchronize the physical reality of backups and copies with their logical records in the RMAN repository.
The CROSSCHECK command checks only objects marked AVAILABLE or EXPIRED in the repository by examining the files on disk for DISK channels or by querying the media manager for sbt channels.
Meaning of Crosscheck Status: EXPIRED
Object is not found either in file system (for DISK) or in the media manager (for sbt). A backup set is EXPIRED if any backup piece in the set is EXPIRED.
The CROSSCHECK command does not delete the repository records of the files that it does not find, but updates their repository records to EXPIRED. You can run DELETE EXPIRED to remove the repository records for expired files and any existing physical files whose status is EXPIRED.
If backups are EXPIRED, then you can re-execute the crosscheck later and determine whether expired backups are available. This precaution is especially useful when you use RMAN with a media manager. For example, if some backup pieces or copies were erroneously marked as EXPIRED because the PARMS channel settings were incorrect, then after ensuring that the files really do exist in the media manager, run the CROSSCHECK BACKUP command again to restore those files to AVAILABLE status.
Object is available for use by RMAN. For a backup set to be AVAILABLE, all backup pieces in the set must have the status AVAILABLE.
100% Free Download!
–Download Free Demo:1z0-053 Demo PDF
100% Pass Guaranteed!
–Download 2018 Latesttests 1z0-053 Full Exam PDF and VCE
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|