RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database?()A、’SQL ALTER DATABASE OPEN’;B、SQL ALTER DATABASE ’OPEN’;C、OPEN DATABASE;D、DATABASE OPEN

RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database?()

  • A、’SQL ALTER DATABASE OPEN’;
  • B、SQL ALTER DATABASE ’OPEN’;
  • C、OPEN DATABASE;
  • D、DATABASE OPEN

相关考题:

Multiple RMAN sessions are connected to the database instance.Examine the following output when backup commands are running in server sessions:What could have helped you to correlate server sessions with channels?()A. Implement RMAN multiplexingB. Set the DEBUG ON in the RMAN scriptC. Specify the command ID in the RMAN scriptD. Use a tag with the RMAN BACKUP command

Whenrunningthetablespacepoint-in-timecommandrecovertablespaceusersuntiltime,,10/06/2008:22:42:00auxiliarydestination,,c:\oracle\auxiliary;youreceivethefollowingerror:RMAN-00571:===========================================================RMAN-00569:===============ERRORMESSAGESTACKFOLLOWS===============RMAN-00571:===========================================================RMAN-03002:failureofrecovercommandat10/08/200816:00:30RMAN-20202:TablespacenotfoundintherecoverycatalogRMAN-06019:couldnottranslatetablespacenameUSERSWhatisthelikelycauseoftheerror?()A.ThedatabaseisinARCHIVELOGmode.B.Thereisnotacurrentbackupofthedatabaseavailable.C.TheUSERStablespacehasdependentobjectsinothertablespacesandcannotbeapartofaTSPITRalone.D.TheUSERStablespaceisnoteligibleforTSPITRbecauseithasinvalidobjects.E.Therecovertablespacecommandisincorrectandgeneratestheerror.

What are three results of issuing the switchport host command? ()A、enables PortFastB、disables trunkingC、disables Cisco Discovery ProtocolD、enables port securityE、enables loopguardF、disables EtherChannel

In a Cisco SDN, every element in the network acts as a point of defense. Which two best describethe features of Cisco SDN? ()A、 enables automated threat responseB、 enables noncompliant device accessC、 enables endpoint posture enforcementD、 enables third-party client and server protocols

What does the mac packet-classify command do when applied to an interface configuration?()A、 It enables MAC ACLs to be applied to only IP packets that enter the interface.B、 It enables MAC ACLs to be applied to only non-IP packets that enter the interface.C、 It enables MAC ACLs to be applied to all packets that enter the interface.D、 It enables MAC ACLs to be used for QoS settings.

Which of the following statements is NOT true about RMAN?()A、It improves usability by enabling you to reuse the scripts to perform recovery operations.B、It detects block corruption while restoration and recovery operations.C、It enables you to perform block media recovery.D、It is capable to recover through unrecoverable operations, with only full database backups.

RMAN provides more granular catalog security through which feature?()A、Virtual private databaseB、Virtual private catalogC、RMAN virtual databaseD、RMAN secure catalogE、Oracle Database Vault

hich of the following RMAN structures can data from a datafile span?()A、RMAN backup-set pieces spanning backup sets B、RMAN backup-set pieces within a given backup sets C、RMAN backups D、RMAN channels E、None of the above

You can back up the RMAN recovery catalog with RMAN.()A、 TrueB、 False

What are the two advantages of RMAN Block Media Recovery (BMR) over file/x7flevel recovery?()A、BMR lowers the mean time to recover (MTTR).B、BMR supports point­in­time recovery of individual data blocks.C、BMR enables you to use incremental backups for block recovery.D、BMR enables recovery even when the database is not mounted or open.E、BMR enables you to use proxy backups to perform block media recovery.F、BMR enables increased availability of data during recovery because the data file that requires a recovery can remain online.

Identify four uses of the Oracle Scheduler.()A、 enables Oracle database to schedule which processes execute on which processors in a multiple CPU environmentB、 enables Oracle database to do patches according to a DBA-defined scheduleC、 enables you to schedule the execution of jobs based on timeD、 enables you to execute jobs in a clustered environmentE、 enables you to periodically execute operating systemscript files located on the same server as the databaseF、 enables you to create a job that makes use of saved programs and schedulesG、 enables you to automate the management of the jobs that are created using the DBMS_JOB package

The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use?() A、the DBNEWID utilityB、the ANALYZE commandC、the RMAN LIST commandD、the RMAN REPORT commandE、the RMAN CROSSCHECK commandF、the RMAN BLOCKRECOVER command

Which of the following RMAN structures can data from a datafile span?()A、 RMAN backup-set pieces spanning backup setsB、 RMAN backup-set pieces within a given backup setC、 RMAN backupsD、 RMAN channelsE、 None of the above

You want to implement the backup and recovery strategy in your database using Recovery Manager (RMAN). You have chosen the control file of the target database for the RMAN repository.  Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication?()A、 rman TARGET / NOCATALOGB、 rman TARGET sys/passwordC、 rman TARGET sys/password AS SYSDBAD、 rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat

You observe that the senior database administrator always uses the following command when connecting to Recovery Manager (RMAN), and then starts executing commands to backup the database files: % rman target / What would be the effect of this command?()A、 RMAN would use the current operating system location to place the backup.B、 RMAN would use the control file of the target database to maintain the backup.C、 RMAN would use the recovery catalog of the target database to maintain the backup.D、 RMAN would use the control file of the target database to maintain the backup metadata.E、 RMAN would use the recovery catalog of the target database to maintain the backup metadata.

What is the purpose of the RMAN recovery catalog?()A、 Make backups fasterB、 Store RMAN metadataC、 Store RMAN scriptsD、 Provide the ability to do centralized backup reportingE、 Make recovery faster

单选题You are ready to implement RMAN in the backup and recover strategy for your company. Which system privilege must the RMAN user have to be able to connect and execute RMAN commands on a target database?()ASYSDBABSYSOPERCNo system privileges are required for the RMAN user.DOnly SYS user can connect and execute RMAN commands on a target database.

单选题Which of the following statements is NOT true about RMAN?()AIt improves usability by enabling you to reuse the scripts to perform recovery operations.BIt detects block corruption while restoration and recovery operations.CIt enables you to perform block media recovery.DIt is capable to recover through unrecoverable operations, with only full database backups.

多选题What is the purpose of the RMAN recovery catalog?()AMake backups fasterBStore RMAN metadataCStore RMAN scriptsDProvide the ability to do centralized backup reportingEMake recovery faster

单选题The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use?()Athe DBNEWID utilityBthe ANALYZE commandCthe RMAN LIST commandDthe RMAN REPORT commandEthe RMAN CROSSCHECK commandFthe RMAN BLOCKRECOVER command

单选题You want to implement the backup and recovery strategy in your database using Recovery Manager (RMAN). You have chosen the control file of the target database for the RMAN repository.  Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication?()A rman TARGET / NOCATALOGB rman TARGET sys/passwordC rman TARGET sys/password AS SYSDBAD rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat

多选题What are the two advantages of RMAN Block Media Recovery (BMR) over file-level recovery?()ABMR lowers the mean time to recover (MTTR).BBMR supports point-in-time recovery of individual data blocks.CBMR enables you to use incremental backups for block recovery.DBMR enables recovery even when the database is not mounted or open.EBMR enables you to use proxy backups to perform block media recovery.FBMR enables increased availability of data during recovery because the data file requires a recovery can remain online.

单选题You observe that the senior database administrator always uses the following command when connecting to Recovery Manager (RMAN), and then starts executing commands to backup the database files: % rman target / What would be the effect of this command?()A RMAN would use the current operating system location to place the backup.B RMAN would use the control file of the target database to maintain the backup.C RMAN would use the recovery catalog of the target database to maintain the backup.D RMAN would use the control file of the target database to maintain the backup metadata.E RMAN would use the recovery catalog of the target database to maintain the backup metadata.

单选题RMAN provides more granular catalog security through which feature?()A Virtual private databaseB Virtual private catalogC RMAN virtual databaseD RMAN secure catalogE Oracle Database Vault

单选题Which of the following RMAN structures can data from a datafile span?()A RMAN backup-set pieces spanning backup setsB RMAN backup-set pieces within a given backup setC RMAN backupsD RMAN channelsE None of the above

单选题You are creating a recovery catalog for use with RMAN. You have issued these commands: SQL CREATE TABLESPACE rman_ts DATAFILE  ’/DISK1/rman_ts01.dbf’ 2 SIZE 20M 3 DEFAULT STORAGE (initial 100K next 100K pctincrease 0); SQL CREATE USER rman_db01 IDENTIFIED BY rman_db01 2 DEFAULT TABLESPACE rman_ts 3 QUOTA unlimited ON rman_ts;  Which command should you issue next?()ARESYNC CATALOG;BREGISTER DATABASE;CCREATE CATALOG TABLESPACE rman_ts;DGRANT recovery_catalog_owner TO rman_db01;

单选题What does the mac packet-classify command do when applied to an interface configuration?()A It enables MAC ACLs to be applied to only IP packets that enter the interface.B It enables MAC ACLs to be applied to only non-IP packets that enter the interface.C It enables MAC ACLs to be applied to all packets that enter the interface.D It enables MAC ACLs to be used for QoS settings.