alter database create block change tracking file
alter database enable block change file
alter database enable block change tracking using file ,/ora01/opt/ block_change_tracking.fil
alter system enable block change tracking using file ’/ora01/opt/block_ change_tracking.fil’
alter system block change tracking on
第1题:
What is the purpose of the catalog command?()
第2题:
You have enabled backup optimization in RMAN. You issue the following RMAN command to configure a redundancy-based retention policy: CONFIGURE RETENTION POLICY TO REDUNDANCY 3; Which statement is true?()
第3题:
It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager (RMAN). How would you make use of this consistent backup in RMAN?()
第4题:
You perform a backup using the following BACKUP command: RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE; Which statement is true of this command?()
第5题:
The command fails because you cannot configure a redundancy-based retention policy when backup optimization is enabled
Backup optimization is performed, but RMAN considers the redundancy-based retention policy when it determines which datafiles should be backed up
Backup optimization is permanently disabled
Backup optimization is temporarily disabled because a redundancy-based retention policy is specified
第6题:
The copy of the datafile created is stored in the RMAN repository.
The copy of the datafile created can be viewed using the LIST BACKUP command.
The copy of the datafile created using this COPY command can be placed only on the disk.
The copy of the datafile created is similar to the backup of the file created using the BACKUP command.
The copy of the datafile created can be used for recovering the database using the user-managed recovery method.
第7题:
BACKUP AS BACKUPSET
BACKUP AS COPY
BACKUP AS COMPRESSED BACKUPSET
BACKUP INCREMENTAL LEVEL n CUMULATIVE
第8题:
MAXSETSIZE TO 2
DEVICE TYPE DISK PARALLELISM 2
RETENTION POLICY TO REDUNDANCY 2
DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2
第9题:
LIST EXPIRED
DELETE EXPIRED
DELETE OBSOLETE
CHANGE UNCATALOG
第10题:
CHANGE
RESYNC
CATALOG
CROSSCHECK
第11题:
alter database create block change tracking file
alter database enable block change file
alter database enable block change tracking using file ,/ora01/opt/ block_change_tracking.fil
alter system enable block change tracking using file ’/ora01/opt/block_ change_tracking.fil’
alter system block change tracking on
第12题:
The command generates an error.
The command backs up the tablespace and creates a backup set of size 200 MB
The command backs up the tablespace and creates two backup sets of size 100 MB each.
The command backs up the tablespace and creates a backup set with backup pieces of size 100 MB each.
第13题:
Which RMAN backup command is used to create the block-change tracking file?()
第14题:
You executed the following command in the Recovery Manager (RMAN): RMAN> REPORT NEED BACKUP days 3; What is the output of this command?()
第15题:
You configured the default backup device type as disk for RMAN backups. In your database,because of business requirements,you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command is used. What must you set using the RMAN CONFIGURE command to achieve this?()
第16题:
You are migrating your production database from non-ASM to ASM storage. You used the RMAN utility to migrate the database from non-ASM to ASM storage. Which type of backup command script will you use for migrating the database from non-ASM to ASM storage?()
第17题:
The block change tracking data will be used only from the next incremental 0 backup.
The incremental backup will use change tracking data for accomplishing the backup.
The incremental backup will not use change tracking data for accomplishing the backup.
The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.
第18题:
To review RMAN control file and recovery catalog metadata and ensure that its correct
To delete RMAN backup-related metadata from the recovery catalog
To create metadata in the control file and the recovery catalog related to backup set pieces
To create a report that lists database backups
To rebuild the recovery catalog
第19题:
data files
backup sets
control files
archived redo log files
第20题:
The script is stored only in the control file.
The script is stored only in the recover catalog.
The script can be executed only by using the RMAN RUN command.
The commands of the script can be displayed with the LIST command.
The commands of the script can be displayed with the PRINT command.
The commands of the script can be displayed with the REPORT command.
第21题:
A different procedure is required to restore a database from compressed backups
The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.
Using this command to create backups minimizes the bandwidth consumed
Using this command to create backups improves the performance of the backup process
第22题:
CHANGE
RESYNC
CATALOG
CROSSCHECK
第23题:
cannot be used in RMAN
by starting up the database again
by using the CATALOG command of RMAN
by using the RECOVER CATALOG command in RMAN
by re-creating the target control file to rebuild the RMAN repository
第24题:
BACKUP AS COMPRESSED BACKUPSET DATABASE
BACKUP AS COMPRESSED COPY OF DATABASE
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET
CONFIGURE DEVICE TYPE DISK BACKUP TYPE COMPRESS
BACKUP DATABASE COMPRESS