You are working as a DBA in an organization. The flash recovery area files are created in ’+disk1’. You want to create new flash recovery area files in the ’+disk2’ location. The new location of the flash recovery area files should be written in the control file and the spfile.Which command will you issue to change the location of the flash recovery area files?()
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = ’+disk2’ ;
B. ALTER SYSTEM SET DB_RECOVER_FILE_DEST = ’+disk2’ SCOPE = BOTH;
C. ALTER SYSTEM SET DB_CREATE_FILE_DEST = ’+disk2’;
D. ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_n = ’+disk2’;