RMAN enables you to open the target database when it is alre

题目
单选题
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

参考答案和解析
正确答案: B
解析: 暂无解析
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

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?()

  • A、A backup of the target database when it is mounted
  • B、A backup of online redo log files when the database is open
  • C、A backup of only used data blocks in the file beingbeingbackup up
  • D、A backup of online, read/write data files when the database is open
  • E、A backup of only those data blocks that have changed since a previous backup
  • F、A backup of online, read/write data files when the database is in the NOMOUNT state.

正确答案:A,C,D,E

第2题:

How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog?()  

  • A、 Issue the grant command from the SYS user (or equivalent) of the target database.
  • B、 Issue the grant command from the SYS user (or equivalent) of the recovery-catalog database.
  • C、 Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.
  • D、 Issue the grant command from RMAN when connected to the recovery catalog-owning schema.
  • E、 Issue the grant command from RMAN when connected to the target database.

正确答案:D

第3题:

You are managing the APPPROD database as a DBA. You plan to duplicate this database in the same system with the name DUPDB.You issued the following RMAN commands to create a duplicate database:Which three are the prerequisites for the successful execution of the above command?()

A. The source database should be open

B. The target database should be in ARCHIVELOG mode if it is open

C. RMAN should be connected to both the instances as SYSDBA

D. The target database backups should be copied to the source database backup directories

E. The password file must exist for the source database and have the same SYS user password as the target


参考答案:B, C, E

第4题:

You executed the following command in Recovery Manager (RMAN): RMAN> RESTORE CONTROLFILE; Which operation must you perform before this command is executed?()

  • A、back up the control file to trace
  • B、bring database to the MOUNT state
  • C、open a connection to the RMAN recovery catalog, which contains the RMAN metadata for the target database
  • D、set the database ID (DBID), but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

正确答案:C

第5题:

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.

正确答案:A,F

第6题:

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

正确答案:C

第7题:

Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt:   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;   After executing this command, in which of the following cases will RMAN make an auto-backup of the control file? ()

  • A、 when you change the name of a datafile
  • B、 when you drop a table from the database
  • C、 when you take an export of the database
  • D、 when you back up the database using OS utilities
  • E、 when you issue an ALTER SYSTEM SWITCH LOGFILE statement
  • F、 when you issue a BACKUP command from inside the RMAN run block

正确答案:A,E,F

第8题:

Which is the correct way to connect to both the target database and the recovery catalog from the RMAN command line?() Assume that the target database is called ORCL and that the recovery catalog database is called RCAT. Also assume that the recovery-catalog owner is called RCAT_OWN. Assume the environment is configured for the ORCL database. 

  • A、 rman target=/ catalog=/@rcat
  • B、 rman target=/ catalog=rcat_own/rcat_own
  • C、 rman target=/ catalog=rcat_own/rcat_own@RCAT
  • D、 rman target=sys/robert@orcl catalog=rcat_own/rcat_own@RCAT
  • E、 You cannot connect to the target database and the recovery catalog at the same time.

正确答案:C,D

第9题:

If you back up a database without connecting to the recovery catalog, which operations will cause the recovery catalog to be updated?()

  • A、 The next time you back up the database when you are also connected to the recovery catalog and the target database
  • B、 The next time you are connected to the target database and the recovery catalog database and issue the resync command
  • C、 The next time you connect RMAN to just the recovery catalog
  • D、 The next time you connect to the recovery catalog and the target database with RMAN
  • E、 Connecting to the recovery catalog and issuing the resync all databases command

正确答案:A,B

第10题:

When performing a full database disaster recovery with RMAN, in what order would you execute these steps?()   a. Restore the control file from autobackups.  b. Run the RMAN restore and recover command.  c.Restore the database spfile from autobackups.  d. Make the RMAN backup set pieces available.  e. Open the database with the alter database open resetlogs command.  f.Open the database with the alter database open command. 

  • A、 a, b, c, d, e, f
  • B、 c, d, a, b, f
  • C、 d, c, a, b, f
  • D、  d, b, d, c, e
  • E、  d, c, a, b, e

正确答案:E

更多相关问题