What command would you use to set a persistent setting in RMAN so that backups are all
written to a tape device?
A.
CONFIGURE DEFAULT DEVICE TYPE TO TAPE MEDIA
B.
CONFIGURE DEFAULT DEVICE TYPE TO TAPE
C.
CONFIGURE DEFAULT DEVICE TYPE TO SBT
D.
CONFIGURE DEFAULT DEVICE TYPE TO SBT_TAPE
Explanation:
SBT_TAPE is incorrect, it should be SBT TAPE, without underline strike.
D is also correct.
http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta010.htm#i1019177
Note:
The sbt and sbt_tape device types are synonymous, but RMAN output always displays sbt_tape whether the input is sbt or sbt_tape.
I performed a testing as follows:
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ORA11G are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
……
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO SBT_TAPE;
new RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO ‘SBT_TAPE’;
new RMAN configuration parameters are successfully stored
RMAN> show all;
RMAN configuration parameters for database with db_unique_name ORA11G are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO ‘SBT_TAPE’;
……
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO SBT;
old RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO ‘SBT_TAPE’;
new RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO ‘SBT_TAPE’;
new RMAN configuration parameters are successfully stored
RMAN> show all;
RMAN configuration parameters for database with db_unique_name ORA11G are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO ‘SBT_TAPE’;
……
You are right.
Yes Lei is correct.
This explanation is not worth the space it occupies. I appears that these explanations are on the same level as “my granny says … ”
@to_whom_ever_posted_this_explanation, please provide an (official) source.
D is correct too