单选题Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）AYou need to perform the restore and recover operations manually, because the backup was made manually. BFirst you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. CFirst you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. DYou can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information.
单选题
Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）
A
You need to perform the restore and recover operations manually, because the backup was made manually.
B
First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database.
C
First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database.
D
You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information.
参考解析
解析：
暂无解析
相关考题：
You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace： RMAN BACKUP TABLESPACE DETTBS; Under which conditions would this command execute successfully？ （）A、The database is in NOMOUNT state.B、The database is in ARCHIVELOG mode and the tablespace is online.C、The database is in ARCHIVELOG mode and the tablespace is offline.D、The database is in NOARCHIVELOG mode and the tablespace is online.E、The database is in NOARCHIVELOG mode and the tablespace is offline.
What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode？（）A、 MMONB、 LGWRC、 ARCHD、 ARWRE、 COPY
You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？ （）A、Hot backupB、Online backupC、consistent backupD、incremental backupE、inconsistent backup
Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（） A、 Database datafilesB、 Control filesC、 Archived redo logsD、 Online redo logsE、 Flashback logs
Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（） A、 Put the database in hot backup mode and perform an online backup，including backing up the archived redo logs.B、 Just back up the database datafiles without shutting down the database.C、 You will have to wait until you can shut down the database to perform the backup.D、 Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up.E、 Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the course of the remaining backup
Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file？（）A、adding a new user to the databaseB、dropping a user from the databaseC、dropping a table from the databaseD、dropping a data file from a tablespaceE、adding a new tablespace to the database
Which two are characteristics of user-managed backup and recovery operations？（）A、Recovery is initiated using SQL*Plus.B、Database files are backed up using SQL commands.C、Database files are backed up with Recovery Manager.D、Database files are restored using Recovery Manager.E、Database files are backed up using operating system commands.
you can perform an active database duplication when the database is in NOARCHIVELOG mode.（）A、 TrueB、 False
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?（）A、Database Datafiles B、Database Control Files C、Online redo logsD、Archived redo logs E、The database SPFILE F、None of the above, all these files are backed up.
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?（）A、only the control file, the current SPFILE, and data filesB、only the current SPFILE and data files if autobackup is disabledC、only the data files and the archived redo logsD、the control file, current SPFILE file, data files, and archived redo logs
Which two requirements are critically important to implement for your database backup strategy if you require a 24 hours a day， 7 days a week production environment？（）A、ARCHIVELOG mode.B、NOARCHIVELOG mode.C、Open database backups.D、Consistent whole backups.
A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger，which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression？（）A、 backup database allB、 backup compressed databaseC、 backup as compressed backupset databaseD、 backup as compressed backup database plus archivelog allE、 backup as compressed backupset database plus compress archivelog all
You are peer reviewing a fellow DBAs backup plan for his NOARCHIVELOG mode database， as shown here： Put the tablespaces in backup mode. Back up the datafiles for all tablespaces. Take the tablespaces out of backup mode. Back up all archived redo logs. Your colleague asks for you to comment on his plan. Which response would be correct？（）A、 The plan will work as is.B、 The plan needs to be modified to allow for an archive-log switch after step 3.C、 The plan needs to be modified so that a backup of the archived redo logs occurs before step 1.D、 The plan needs to be adjusted to shut down the database after step 1 and to restart the database after step 2.E、 The plan cannot work as presented.
单选题Your test database is running in NOARCHIVELOG mode. What are the implications of this？ （）AYou can perform open database backups.BYou can perform closed database backups.CYou cannot perform schema-level logical backups.DYou can perform the backup of only the SYSTEM tablespace when the database is open.
单选题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?（）Aonly the control file, the current SPFILE, and data filesBonly the current SPFILE and data files if autobackup is disabledConly the data files and the archived redo logsDthe control file, current SPFILE file, data files, and archived redo logs
多选题Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file？（）Aadding a new user to the databaseBdropping a user from the databaseCdropping a table from the databaseDdropping a data file from a tablespaceEadding a new tablespace to the database
单选题Your database is in the NOARCHIVELOG mode. Since last night’s offline backup， the logs in group 1 have been written to twice. This morning， the SYSTEM data file has become corrupted. Up to what point can it be recovered？（）Auntil the last commitBcannot be recoveredCuntil the last offline backupDuntil the beginning of the last transaction
单选题A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger，which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression？（）A backup database allB backup compressed databaseC backup as compressed backupset databaseD backup as compressed backup database plus archivelog allE backup as compressed backupset database plus compress archivelog all
单选题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?（）ADatabase Datafiles BDatabase Control Files COnline redo logsDArchived redo logs EThe database SPFILE FNone of the above, all these files are backed up.
单选题you can perform an active database duplication when the database is in NOARCHIVELOG mode.（）A TrueB False
多选题Which two statements about Recovery Manager （RMAN） backups are true？ （）AOnline redo log files can be backed up.BArchived redo log files are backed up.COnly used data blocks can be backed up as backup sets.DOnly consistent database backups can be performed.ERMAN backup can be taken only if the database is configured in ARCHIVELOG mode.
多选题You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace： RMAN BACKUP TABLESPACE DETTBS； Under which conditions would this command execute successfully？ （）AThe database is in NOMOUNT state.BThe database is in ARCHIVELOG mode and the tablespace is online.CThe database is in ARCHIVELOG mode and the tablespace is offline.DThe database is in NOARCHIVELOG mode and the tablespace is online.EThe database is in NOARCHIVELOG mode and the tablespace is offline.
单选题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？（）A only the control file， the current SPFILE， and data filesB only the current SPFILE and data files if autobackup is disabledC only the data files and the archived redo logsD the control file，current SPFILE file，data files，and archived redo logs
多选题Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（）ADatabase datafilesBControl filesCArchived redo logsDOnline redo logsEFlashback logs
单选题Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）AYou need to perform the restore and recover operations manually, because the backup was made manually. BFirst you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. CFirst you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. DYou can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information.
单选题What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode？（）A MMONB LGWRC ARCHD ARWRE COPY
单选题You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？ （）AHot backupBOnline backupCconsistent backupDincremental backupEinconsistent backup
单选题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？（）A Database DatafilesB Database Control FilesC Online redo logsD Archived redo logsE The database SPFILEF None of the above，all these files are backed up