Thursday, September 4, 2008

Archive to db_recovery_file_dest

alter system set db_recovery_file_dest_size=400G;
alter system set db_recovery_file_dest='+ASM_ORADATA42';
alter system set LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=pd01dis1';