RemRem fra_setup.sqlRemRem Copyright (c) 2007, 2007, Oracle. All rights reserved.RemRem NAMERem fra_setup.sql - Flash Recovery Area SetupRemRem DESCRIPTIONRem This script provides information to setup Rem the flash recovery area in an SAP environmentRem according to SAP note 966073.Rem Rem Supported releases: 10.2.0RemRem Oracle/SAP DevelopmentRemRem NOTESRem Logon to the Oracle Database Server as ora userRem Create directory for flash recovery area before runningRem the steps belowRem $mkdir -p $ORACLE_BASE/oraflashRem Run connected AS SYSDBA to the databaseRemRem MODIFIED (MM/DD/YY)Rem abecker 12/18/07 - createdRemRem =================================================================RemRem Modify Oracle Profile parameterRemsqlplus /nologconnect / as sysdbaset pagesize 100set echo onset feedback onREMREM Save a copy of Oracle parameter fileREMspool fra_config.logcreate pfile = '?/dbs/initSID.ora.SAVE.pre_fra' from spfile;REMREM Check archivelog statusREMarchive log listREMREM Check log_archive_* parameterREMshow parameter log_archive_destshow parameter log_archive_duplex_destshow parameter log_archive_formatselect name, value, isspecified from v$spparameter where name in ('log_archive_dest', 'log_archive_duplex_dest') and isspecified = 'TRUE';REMREM Mount database instanceREMshutdown immediatestartup mountREMREM Remove log_archive_dest_* parameterREMalter system reset LOG_ARCHIVE_DEST scope = spfile sid = '*';alter system reset LOG_ARCHIVE_DUPLEX_DEST scope = spfile sid = '*';REMREM Set log_archive_dest_1 log_archive_dest_2REMalter system set log_archive_dest_1 = 'LOCATION=' scope = spfile;alter system set log_archive_dest_2 = 'LOCATION=' scope = spfile;REMREM Mount database instanceREMshutdown immediatestartup mountarchive log listREMREM Set Oracle profile parameter for flash recovery areaREMalter system set db_recovery_file_dest_size = 6G;alter system set db_recovery_file_dest = '';alter database openshow parameter db_recovery_file_destREMREM Save a copy of Oracle parameter fileREMcreate pfile = '?/dbs/initSID.ora.SAVE.fra' from spfile;REMREM Check flash recovery area settingsREMSELECT * FROM V$RECOVERY_FILE_DEST;SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE;REMREM brspace -f dbparam -a createREMspool off