Use the command PURGE BINARY LOGS and specify a binary log file name or a date and time to remove unused files
Execute the PURGE BINARY LOGE NOT USED command
Remove all of the binary log files that have a modification date earlier than today
Edit the .index file to remove the files you want to delete
Ensure that none of the attached slaves are using any of the binary logs you want to delete
第1题:
Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt: RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF; RMAN> BACKUP DATABASE; Which files from the database will be backed up as a result of this BACKUP command?()
第2题:
You are using Oracle Database 10g. The LOG_ARCHIVE_FORMAT parameter is set to ’LOG%t_%s_%r.dbf’. Why is %r used in the file name format?()
第3题:
A.Use the command PURGE BINARY LOGS and specify a binary log file name or a date and time to remove unused files
B.Execute the PURGE BINARY LOGE NOT USED command
C.Remove all of the binary log files that have a modification date earlier than today
D.Edit the .index file to remove the files you want to delete
E.Ensure that none of the attached slaves are using any of the binary logs you want to delete
第4题:
You are maintaining your database in Oracle10g. On Tuesday at 8:00 A.M., while starting the database, you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6:00 P.M. Which type of recovery will you perform?()
第5题:
A user executes the statement; PURGE BINARY LOGS TO 'mysql-bin.010'; What is the result?()
第6题:
You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement: SQL>ALTER DATABASE OPEN RESETLOGS; Which of the following options is true about using the RESETLOGS option?()
第7题:
If you create your database using Oracle Managed Files (OMF), what is true?()
第8题:
You work as a database administrator for Supportcenter.cn. You are using Recovery Manager (RMAN) to perform backups in your databases. Which four backup operations can be performed using RMAN?()
第9题:
You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state?()
第10题:
You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option? ()