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: 171 – (Topic 5)
Which backup option defines a user-defined name for a backup?
-
FORMAT
-
NAME
-
TAG
-
FORMAT U%
Answer: C
Question No: 172 – (Topic 5)
Which of the following RMAN structures can data from a datafile span?
-
RMAN backup-set pieces spanning backup sets
-
RMAN backup-set pieces within a given backup set
-
RMAN backups
-
RMAN channels
-
None of the above
Answer: B
Question No: 173 – (Topic 5)
Which is the correct command to back up the database, back up the archived redo logs, and then remove the backed-up archived redo logs?
-
backup database
-
backup database and archivelogs
-
backup database plus archivelogs
-
backup database plus archivelog delete input
-
backup database and archivelog delete input
Answer: D
Question No: 174 – (Topic 5)
Consider the following command:
backup database plus archivelog delete input;
How many backup sets would be created by this command if the following were true:
->Control-file auto backups were enabled.
->The size of backup sets was not restricted.
->One channel was allocated.
-
1
-
2
-
3
-
4
-
5
Answer: D Explanation: RMANgt; show all;
RMAN configuration parameters for database with db_unique_name TESTDB are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO
#39;%F#39;; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; #
default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default CONFIGURE ENCRYPTION ALGORITHM #39;AES128#39;; # default
CONFIGURE COMPRESSION ALGORITHM #39;BASIC#39; AS OF RELEASE #39;DEFAULT#39; OPTIMIZE FOR LOAD
TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO
#39;/u01/app/oracle/product/11.2.0/dbhome_1/ dbs/snapcf_testdb.f#39;; # default
RMANgt; Backup database plus archivelog delete input;
Starting backup at 19-DEC-13 current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=10 RECID=5 STAMP=834597174 input archived log thread=1 sequence=11 RECID=6 STAMP=834597417 channel ORA_DISK_1: starting piece 1 at 19-DEC-13
channel ORA_DISK_1: finished piece 1 at 19-DEC-13
piece handle=/u01/app/oracle/fast_recovery_area/TESTDB/backupset/2013_12_19/ o1_mf_annnn_TAG20131219T163657_9c5d1bn3_.bkp tag=TAG20131219T163657 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03 channel ORA_DISK_1: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/TESTDB/ archivelog/2013_12_19/o1_mf_1_10_9c5csl13_.arc RECID=5 STAMP=834597174 archived log file name=/u01/app/oracle/fast_recovery_area/TESTDB/ archivelog/2013_12_19/o1_mf_1_11_9c5d19cn_.arc RECID=6 STAMP=834597417 Finished backup at 19-DEC-13
Starting backup at 19-DEC-13 using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/testdb/system01.dbf input datafile file number=00002 name=/u01/app/oracle/oradata/testdb/sysaux01.dbf input datafile file number=00005 name=/u01/app/oracle/oradata/testdb/example01.dbf input datafile file number=00003 name=/u01/app/oracle/oradata/testdb/undotbs01.dbf input datafile file number=00004 name=/u01/app/oracle/oradata/testdb/users01.dbf channel ORA_DISK_1: starting piece 1 at 19-DEC-13
channel ORA_DISK_1: finished piece 1 at 19-DEC-13
piece handle=/u01/app/oracle/fast_recovery_area/TESTDB/backupset/2013_12_19/ o1_mf_nnndf_TAG20131219T163703_9c5d1j8c_.bkp tag=TAG20131219T163703 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:05 Finished backup at 19-DEC-13
Starting backup at 19-DEC-13 current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=12 RECID=7 STAMP=834597550
channel ORA_DISK_1: starting piece 1 at 19-DEC-13 channel ORA_DISK_1: finished piece 1 at 19-DEC-13
piece handle=/u01/app/oracle/fast_recovery_area/TESTDB/backupset/2013_12_19/ o1_mf_annnn_TAG20131219T163911_9c5d5hlk_.bkp tag=TAG20131219T163911 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 channel ORA_DISK_1: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/TESTDB/ archivelog/2013_12_19/o1_mf_1_12_9c5d5g7r_.arc RECID=7 STAMP=834597550
Finished backup at 19-DEC-13
Starting Control File and SPFILE Autobackup at 19-DEC-13
piece handle=/u01/app/oracle/fast_recovery_area/TESTDB/autobackup/2013_12_19/ o1_mf_s_834597553_9c5d5lz1_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 19-DEC-13 RMANgt; list backup;
C:\Users\albo\Desktop\1-1.jpg
Question No: 175 – (Topic 5)
If a backup set is expired, what can you do to correct the problem?
-
Change the retention criteria.
-
Make the lost backup set pieces available to RMAN again.
-
Run the crosscheck command to correct the location for the backup set piece contained in the metadata.
-
Nothing. The backup set piece is lost forever.
-
Call Oracle support, their assistance is required.
Answer: B
Question No: 176 – (Topic 5)
You want to convert your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task?
-
Data Pump Export and Import
-
conventional export and import
-
the CONVERT command of RMAN
-
the BACKUP AS COPY command of RMAN
Answer: D Explanation:
If you have enough disk space that you can have both your entire non-ASM database and your ASM disk group on disk at the same time, you can do the migration directly without using tapes.
-
Back up your database files as copies to the ASM disk group.
BACKUP AS COPY INCREMENTAL LEVEL 0 DATABASE FORMAT ‘ DISK’ TAG ‘ORA_ASM_MIGRATION’;
REF: Oracle(r) 10g Backup and Recovery Advance User’s Guide, 16-2
Question No: 177 – (Topic 5)
What does the output on this report indicate?
-
The my_data_01.dbf datafile is corrupted and needs to be restored.
-
The my_data_01.dbf datafile has not yet been backed up. This report does not imply that the data in the datafile can not be recovered.
-
The my_data_01.dbf datafile has not yet been backed up. This report implies that the data in the datafile can not be recovered.
-
The my_data_01.dbf datafile no longer meets the retention criteria for backups.
-
Datafile 5 is missing.
-
-
Answer: B
Question No: 178 – (Topic 5)
Which two statements are true about encrypting RMAN backup? (Choose two.)
-
The transparent encryption of backups uses the encryption wallet
-
The database uses the same encryption key for every encrypted backup
-
The password encryption of backups only uses the password while creating and restoring backup
Answer: A,C
Question No: 179 – (Topic 5)
You issue the following command on the RMAN prompt. REPORT NEED BACKUP DAYS 5;
Which statement is true about executing this command?
-
It will display a list of files that need incremental backup
-
It will display a list of files that need backup after five days
-
It will display a list of files that were backed up in the last five days
-
It will display a list of files that have not been backed up in the last five days
-
It will apply the current retention policy to determine the files that need to be backed up
Answer: D
Question No: 180 – (Topic 5)
Using the LIST command in Recovery Manager (RMAN), which two pieces of information in the RMAN repository can be listed? (Choose two.)
-
stored scripts in the recovery catalog
-
backups that can be deleted from disk
-
backup sets and image copies are obsolete
-
backups that do not have the AVAILABLE status in the RMAN repository
Answer: A,D Explanation:
About the LIST command
The primary purpose of the LIST command is to list backup and copies. For example, you can list:
->Backups and proxy copies of a database, tablespace, data file, archived redo log, or control file
->Backups that have expired
->Backups restricted by time, path name, device type, tag, or recoverability
->Archived redo log files and disk copies
Besides backups and copies, RMAN can list other types of data. For example, you can list:
->Backup sets and proxy copies
->Image copies
->Archived redo log files
->Database incarnations
->Databases in a Data Guard environment
->Backups and copies for a primary or standby database in a Data Guard environment
->Restore points
->Names of stored scripts
->Failures for use with Data Recovery Advisor
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 |
100-105 Dumps VCE PDF
200-105 Dumps VCE PDF
300-101 Dumps VCE PDF
300-115 Dumps VCE PDF
300-135 Dumps VCE PDF
300-320 Dumps VCE PDF
400-101 Dumps VCE PDF
640-911 Dumps VCE PDF
640-916 Dumps VCE PDF
70-410 Dumps VCE PDF
70-411 Dumps VCE PDF
70-412 Dumps VCE PDF
70-413 Dumps VCE PDF
70-414 Dumps VCE PDF
70-417 Dumps VCE PDF
70-461 Dumps VCE PDF
70-462 Dumps VCE PDF
70-463 Dumps VCE PDF
70-464 Dumps VCE PDF
70-465 Dumps VCE PDF
70-480 Dumps VCE PDF
70-483 Dumps VCE PDF
70-486 Dumps VCE PDF
70-487 Dumps VCE PDF
220-901 Dumps VCE PDF
220-902 Dumps VCE PDF
N10-006 Dumps VCE PDF
SY0-401 Dumps VCE PDF