多项选择题
A. take the backup of the flash recovery area less frequently
B. increase the value of the UNDO_RETENTION initialization parameter
C. change the value of the WORKAREA_SIZE_POLICY initialization parameter to AUTO
D. change the backup retention policy to retain the backups for a smaller period of time
E. increase the value of the DB_RECOVERY_FILE_DEST_SIZE initialization parameter
F. increase the value of the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter
单项选择题 You are using an Automatic Storage Management (ASM) instance to manage the files of your production database. You have two disk groups, DG1and DG2with one device each. In the parameter file of the production database, the following parameters have been specified: DB_CREATE_ONLINE_LOG_DEST_1 = ’+dg1’ DB_CREATE_ONLINE_LOG_DEST_2 = ’+dg2’ What would be the impact of this setting?()
单项选择题 YoulostthePRODSTDtablespace,whichwasread/write.Thetablespacewasread-onlywhenthelastbackupwasperformed.Howwouldyourecoverthetablespace?()
单项选择题 Thecurrenttimeis12:00noon.YouwanttorecovertheUSERStablespacefromafailurethatoccurredat11:50a.m.Youdiscoverthattheonlymemberofanunarchivedredologgroupcontaininginformationfrom11:40a.m.onwardsiscorrupt.Withreferencetothisscenario,ifyouarenotusingRecoveryManager(RMAN),whichrecoverymethodwouldyouuse?()