What RMAN command is used to execute a tablespace point-in-time recovery?()A、 recoverB、 duplicateC、 restoreD、 copyE、 None of the above

What RMAN command is used to execute a tablespace point-in-time recovery?()

  • A、 recover
  • B、 duplicate
  • C、 restore
  • D、 copy
  • E、 None of the above

相关考题:

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

View the Exhibit to examine the error during the database startup.You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:RMAN REPAIR FAILURE;Which statement describes the consequence of the command?()A. The command performs the recovery and closes the failures.B. The command only displays the advice and the RMAN script required for repair.C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.D. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).

What is the purpose of the catalog command?()  A、 To review RMAN control file and recovery catalog metadata and ensure that its correctB、 To delete RMAN backup-related metadata from the recovery catalogC、 To create metadata in the control file and the recovery catalog related to backup set pieces D、 To create a report that lists database backupsE、 To rebuild the recovery catalog

David managed to accidentally delete the datafiles for database called DSL. He called Heber and Heber tried to help but he managed to delete the control files of the database. Heber called Bill and Bill saved the day. They are using a recovery catalog for this database.  What steps did Bill perform to recover the database and in what order?()   a. Restored the control file with the RMAN restore controlfile command.  b. Mounted the DSL instance with the alter database mount command.  c. Restored the datafiles for the DSL database with the RMAN restore command. d. Opened the DSL database with the alter database open resetlogs command. e. Recovered the datafiles for the DSL database with the RMAN recover command. f. Started the DSL instance.  g. Connected to the recovery catalog with RMAN. A、 a, b, c, d, e, f, gB、 b, c, d, g, f, e, aC、 g, f, a, b, c, e, dD、 c, a, d, b, f, e, gE、 g, f, a, b, e, c, d

What RMAN command must you use before you can back up a database using the recovery catalog?()A、 create catalogB、 install databaseC、 catalog databaseD、 merge Catalog with databaseE、 register database

What information does the report schema command not provide?() A、 Size of the datafilesB、 Size of the tempfilesC、 Date of last backup for datafiles and tempfilesD、 Filenames for each datafileE、 Checkpoint SCN associated with the last RMAN backup

You issued the following RMAN command:  RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON;     What is NOT an impact of using the above command?()A、 When a successful backup is recorded in the RMAN repository, then a backup of the current control file is performed.B、 When a structural change is made to the database, then a backup of the current control file is performed.C、 When a successful backup is performed in the RMAN repository, then a backup of the spfile is performed.D、 When a structural change is made to the database, then a backup of the alert log file will be performed.

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, fB、 c, d, a, b, fC、 d, c, a, b, fD、 d, b, d, c, eE、 d, c, a, b, e

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

Consider this RMAN command:   RMAN CONFIGURE RETENTION POLICY CLEAR;   What is the effect of this command?()A、Backups will never expire.B、It removes any retention policy.C、The DELETE OBSOLETE command will fail with an error.D、It sets the retention policy to the default of REDUNDANCY 1.

You execute the following command to perform a backup by using Recovery Manager (RMAN): RMAN run  {allocate channel c1 type sbt;  backup datafile 1;  }  The command errors out. A part of the error message is as follows:  RMAN/x7f03009: failure of allocate command on c1 channel  ORA/x7f19554: error allocating device, device type: SBT_TAPE, device name:  What could explain why the statement failed?()A、sbt is not a valid device type.B、Media Management Library was not loaded.C、The sbt device cannot be used for data file backups.D、No path was defined in the ALLOCATE CHANNEL command.E、The channel is currently being used by another RMAN session.

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.

When issuing the CROSSCHECK command in RMAN, if a backup file CANNOT be found, to what status is that file set?()A、DELETEDB、OBSOLETEC、EXPIREDD、UNKNOWN

单选题Consider this RMAN command:   RMAN CONFIGURE RETENTION POLICY CLEAR;   What is the effect of this command?()ABackups will never expire.BIt removes any retention policy.CThe DELETE OBSOLETE command will fail with an error.DIt sets the retention policy to the default of REDUNDANCY 1.

单选题You issue the following RMAN command to set a retention policy on a database:   RMANCONFIGURE RETENTION POLICY TO REDUNDANCY 2;   What will be the outcome of issuing this command?()A After two days,a backup will be marked obsoleteB After two days,a backup will be deleted from the mediaC If the RMAN repository has records of two or more recent backups of a file,then older backups will be deleted from the media.D If the RMAN repository has records of two or more recent backups of a file then older backups will be marked obsolete.

单选题You issued the following RMAN command:  RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON;     What is NOT an impact of using the above command?()A When a successful backup is recorded in the RMAN repository, then a backup of the current control file is performed.B When a structural change is made to the database, then a backup of the current control file is performed.C When a successful backup is performed in the RMAN repository, then a backup of the spfile is performed.D When a structural change is made to the database, then a backup of the alert log file will be performed.

单选题David managed to accidentally delete the datafiles for database called DSL. He called Heber and Heber tried to help but he managed to delete the control files of the database. Heber called Bill and Bill saved the day. They are using a recovery catalog for this database.  What steps did Bill perform to recover the database and in what order?()   a. Restored the control file with the RMAN restore controlfile command.  b. Mounted the DSL instance with the alter database mount command.  c. Restored the datafiles for the DSL database with the RMAN restore command. d. Opened the DSL database with the alter database open resetlogs command. e. Recovered the datafiles for the DSL database with the RMAN recover command. f. Started the DSL instance.  g. Connected to the recovery catalog with RMAN.A a, b, c, d, e, f, gB b, c, d, g, f, e, aC g, f, a, b, c, e, dD c, a, d, b, f, e, gE g, f, a, b, e, c, d

单选题You have control-file autobackups enabled. When starting your database from SQL*Plus, you receive the following error message:   SQL startup ORA-01078: failure in processing system parameters LRM-00109:  could not open parameter file ,  C:///ORACLE/PRODUCT/11.1.0/DB_1/DATABASE/INITORCL.ORA Using RMAN,   how would you respond to this error?()A Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.B Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.C Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.D Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.E Issue the restore spfile from autobackup command from the RMAN prompt.

单选题You issue the following RMAN command to set a retention policy on a database: RMANCONFIGURE RETENTION POLICY TO REDUNDANCY 2; What will be the outcome of issuing this command?()AAfter two days, a backup will be marked obsoleteBAfter two days, a backup will be deleted from the mediaCIf the RMAN repository has records of two or more recent backups of a file, then older backups will be deleted from the media.DIf the RMAN repository has records of two or more recent backups of a file, then older backups will be marked obsolete.

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

单选题When running the tablespace point-in-time command   recover tablespace users until time ,,10/06/2008:22:42:00 auxiliary destination ,,c:/oracle/auxiliary; you receive the following error:  RMAN-00571: ===========================================================  RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS  =============== RMAN-00571:  ===========================================================  RMAN-03002: failure of recover command at 10/08/2008 16:00:30  RMAN-20202: Tablespace not found in the recovery catalog  RMAN-06019: could not translate tablespace name "USERS"   What is the likely cause of the error?()A The database is in ARCHIVELOG mode.B There is not a current backup of the database available.C The USERS tablespace has dependent objects in other tablespaces and can not be a part of a TSPITR alone.D The USERS tablespace is not eligible for TSPITR because it has invalid objects.E The recover tablespace command is incorrect and generates the error.

单选题You executed the following command in the Recovery Manager (RMAN):   RMAN REPORT NEED BACKUP days 3;   What is the output of this command?()A A list of files that require a backup within 3 daysB A list of files requiring more than 3 days of archivelogs to applyC A list of files that RMAN recommends be backed up only once in every three days,based on low volatilityD A list of files for which a backup as already been performed in the last three days and which is  required to be backed up again based on the high number of transactions performed on them

单选题What RMAN command must you use before you can back up a database using the recovery catalog?()A create catalogB install databaseC catalog databaseD merge Catalog with databaseE register database

单选题You set the recovery window to seven days and the backup optimization to ON using the CONFIGURE command of Recovery Manager (RMAN). The most recent backup of the TOOLStablespace to disk was taken on January 3. The TOOLStablespace is read-only.On February 21, when you execute a command to back up all the tablespaces to disk, you find that RMAN backs up the TOOLS tablespace also, even though the contents of the tablespace have not changed after the backup on January 3. Because there are no changes made to the TOOLStablespace, you decide that the tablespace should not be backed up by RMAN. What can you do to skip backing up the TOOLStablespace without changing the current backup optimization setting?()A configure a default device for RMAN backupsB temporarily disable the retention policy for RMAN backupsC configure automatic channel allocation for RMAN backupsD use the CONFIGURE command to reconfigure the recovery window to 60 days

单选题What RMAN command is used to execute a tablespace point-in-time recovery?()A recoverB duplicateC restoreD copyE None of the above

多选题What information does the report schema command not provide?()ASize of the datafilesBSize of the tempfilesCDate of last backup for datafiles and tempfilesDFilenames for each datafileECheckpoint SCN associated with the last RMAN backup