1.

[root@sf01 ~]# cat /etc/sysconfig/network

NETWORKING=yes

HOSTNAME=sf01

[root@sf01 ~]# cat /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.0.130  sf01



2.安装依赖包

yum install oracle-rdbms-server-11gR2-preinstall -y


3.环境变量


export TMP=/tmp

export TMPDIR=$TMP     

export ORACLE_BASE=/u01/oracle

export ORACLE_HOME=/u01/oracle/product/11.2.0/db_1

export ORACLE_SID=FIXFL

export ORACLE_TERM=xterm 

export PATH=/usr/sbin:$PATH 

export PATH=$ORACLE_HOME/bin:$PATH   

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

export CLASSPATH=$ORACLE_HOME/jre:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib 

export EDITOR=vi    

export NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'   



[root@sf01 yum.repos.d]# mkdir -p /u01/oracle/product/11.2.0/db_1

[root@sf01 yum.repos.d]# chown -R oracle:oinstall /u01/oracle

[root@sf01 yum.repos.d]# chmod -R 775 /u01/oracle



[oracle@sf01 ~]$ cd /u01/oracle/soft/

[oracle@sf01 soft]$ ls



打包oracle 家目录


tar -czvf /u01/oracle/soft/oracle_home.tar.gz /u01/oracle/product/11.2.0/db_1/


tar zxvf /u01/oracle/soft/oracle_home.tar.gz -C /u01/oracle/product/11.2.0/


perl clone.pl ORACLE_BASE=/u01/oracle ORACLE_HOME=/u01/oracle/product/11.2.0/db_1 ORACLE_HOME_NAME=OraDb11g_home1 



[oracle@sf02 bin]$ perl clone.pl ORACLE_BASE=/u01/oracle ORACLE_HOME=/u01/oracle/product/11.2.0/db_1 ORACLE_HOME_NAME=OraDb11g_home1 

./runInstaller -clone -waitForCompletion  "ORACLE_BASE=/u01/oracle" "ORACLE_HOME=/u01/oracle/product/11.2.0/db_1" "ORACLE_HOME_NAME=OraDb11g_home1" -silent -noConfig -nowait 

Starting Oracle Universal Installer...


Checking swap space: must be greater than 500 MB.   Actual 4095 MB    Passed

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2016-04-10_08-31-36AM. Please wait ...Oracle Universal Installer, Version 11.2.0.4.0 Production

Copyright (C) 1999, 2013, Oracle. All rights reserved.


You can find the log of this install session at:

 /home/oracle/oraInventory/logs/cloneActions2016-04-10_08-31-36AM.log

.................................................................................................... 100% Done.




Installation in progress (Sunday, April 10, 2016 8:32:04 AM CST)

..............................................................................                                                  78% Done.

Install successful


Linking in progress (Sunday, April 10, 2016 8:32:45 AM CST)

Link successful


Setup in progress (Sunday, April 10, 2016 8:34:50 AM CST)

Setup successful


End of install phases.(Sunday, April 10, 2016 8:35:23 AM CST)

WARNING:A new inventory has been created in this session. However, it has not yet been registered as the central inventory of this system.

To register the new inventory please run the script '/home/oracle/oraInventory/orainstRoot.sh' with root privileges. 

If you do not register the inventory, you may not be able to update or patch the products you installed.

The following configuration scripts need to be executed as the "root" user.

/home/oracle/oraInventory/orainstRoot.sh

/u01/oracle/product/11.2.0/db_1/root.sh

To execute the configuration scripts:

    1. Open a terminal window

    2. Log in as "root"

    3. Run the scripts

    

The cloning of OraDb11g_home1 was successful.

Please check '/home/oracle/oraInventory/logs/cloneActions2016-04-10_08-31-36AM.log' for more details.





rman target /<<eof

run

{

allocate channel C1 device type disk;

allocate channel C2 device type disk;

sql 'alter system switch logfile';

crosscheck archivelog all;

delete noprompt expired archivelog all;

backup incremental level=0 tag='DB0'as compressed backupset database format '/u01/oracle/soft/backup/data_%U.bak';

backup current controlfile for standby format '/u01/oracle/soft/backup/ctl_%U.bak';

crosscheck backup;

delete noprompt obsolete;

delete noprompt expired backup;

delete noprompt force archivelog until time 'sysdate-16';

sql 'alter system archive log current';

backup archivelog all format '/u01/oracle/soft/backup/arc_%n_%T_%U';

release channel C1;

release channel C2;}

eof


sqlplus / as sysdba<<eoh

set lines 200 pagesize 1000;

col file_name for a100;

select file_id,file_name from dba_data_files order by 1;

create pfile='/u01/oracle/soft/backup/pfile.ora' from spfile;

exit;

eoh


主库,

*.LOG_ARCHIVE_DEST_2='SERVICE=FIXFL_DG LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)'

*.fal_server='FIXFL_PRI'

*.fal_client='FIXL_DG'

*.standby_file_management='AUTO'


备库

*.fal_server='FIXFL_PRI'

*.fal_client='FIXL_DG'

*.standby_file_management='AUTO'




startup nomount pfile='/u01/oracle/soft/backup/pfile.ora';



restore standby controlfile from '/u01/oracle/soft/backup/ctl_05r2m052_1_1.bak';




alter database recover managed standby database disconnect from session;



--fixfldh


rman target /<<eof

run

{

allocate channel C1 device type disk;

allocate channel C2 device type disk;

sql 'alter system switch logfile';

backup current controlfile for standby format '/u01/oracle/soft/backup/fixfldh/ctl_%U.bak';

backup incremental level=0 tag='DB0'as compressed backupset database format '/u01/oracle/soft/backup/fixfldh/data_%U.bak';

sql 'alter system archive log current';

backup archivelog all format '/u01/oracle/soft/backup/fixfldh/arc_%n_%T_%U';

release channel C1;

release channel C2;}

eof


sqlplus / as sysdba<<eoh

set lines 200 pagesize 1000;

col file_name for a100;

select file_id,file_name from dba_data_files order by 1;

create pfile='/u01/oracle/soft/backup/fixfldh/pfile.ora' from spfile;

exit;

eoh



restore standby controlfile from '/u01/oracle/soft/backup/fixfldh/ctl_0fr2ndd1_1_1.bak';



restore standby controlfile from '/u01/oracle/soft/backup/fixfldh/ctl_0rr2nfht_1_1.bak';

startup pfile='/u01/oracle/soft/backup/fixfldh/pfile.ora;





#!/bin/bash

echo "Now run on Server DB:"

echo "--------------------------------------------------------------------------------------------------------------------------"

ps -ef|grep pmon|grep -v grep  |grep -v ASM|awk -F _ '{printf" %s | ",$3}'

echo " "

echo "--------------------------------------------------------------------------------------------------------------------------"

echo "In info file DB: "

echo "--------------------------------------------------------------------------------------------------------------------------"

awk -F: '{printf" %s |",$1}' /etc/sf/shell/db_info.txt

echo " "

echo "--------------------------------------------------------------------------------------------------------------------------"

echo -n "Please Enter database sid:"

read SID;

if [ "$SID" = "" ]; then

    echo "you havn't Enter your db name!";

    unset ORACLE_SID

else if awk -F: '{print $1}' /etc/sf/shell/db_info.txt|grep -w $SID

then

export ORACLE_SID=$SID;

export ORACLE_HOME=`awk -F: '{if ($1 == "'$ORACLE_SID'") {print $2; exit}}' /etc/sf/shell/db_info.txt`

export NLS_LANG=`awk -F: '{if ($1 == "'$ORACLE_SID'") {print $3; exit}}' /etc/sf/shell/db_info.txt`

else

  echo "The database name not exist in /etc/sf/shell/db_info.txt";

  unset ORACLE_SID;

fi

fi

umask 022

export TERM=vt100

export EDITOR=vi

export ORACLE_BASE=/u01/oracle

export PATH=$ORACLE_HOME/bin:.:$HOME/sh:/dba/app/product/11.2.0/grid/bin:/sbin:/usr/sbin:/opt/VRTS/bin:/opt/VRTSvcs/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin

export NLS_DATE_FORMAT="yyyy-mm-dd hh24:mi:ss"

export PS1="`hostname`:$ORACLE_SID > "

#export ORACLE_DOC=$ORACLE_BASE/doc

export LD_LIBRARY_PATH=$ORACLE_HOME/lib

export TMP=/tmp

export ORA_ENCRYPT_LOGIN=true

export SHELL_PATH=/etc/paic/shell

LD_LIBRARY_PATH=$LD_LIBRARY_PATH

export LD_LIBRARY_PATH

PATH=$PATH

export PATH





FIXFL:/u01/oracle/product/11.2.0/db_1:american_america.AL32UTF8

FIXFLDH:/u01/oracle/product/11.2.0/db_1:american_america.AL32UTF8






sf02:FIXFLDH > sqlplus / as sysdba


SQL*Plus: Release 11.2.0.4.0 Production on Sun Apr 10 22:40:37 2016


Copyright (c) 1982, 2013, Oracle.  All rights reserved.



Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options


SQL> catalog start with '/u01/oracle/soft/backup/';

SP2-0734: unknown command beginning "catalog st..." - rest of line ignored.

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

sf02:FIXFLDH > rman target /


Recovery Manager: Release 11.2.0.4.0 - Production on Sun Apr 10 22:41:22 2016


Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.


connected to target database: FIXFLDH (DBID=2104607304, not open)


RMAN> catalog start with '/u01/oracle/soft/backup/';


using target database control file instead of recovery catalog

searching for all files that match the pattern /u01/oracle/soft/backup/


List of Files Unknown to the Database

=====================================

File Name: /u01/oracle/soft/backup/pfile.ora

File Name: /u01/oracle/soft/backup/arc_FIXFLxxx_20160410_06r2m057_1_1

File Name: /u01/oracle/soft/backup/fixfldh/pfile.ora

File Name: /u01/oracle/soft/backup/fixfldh/ctl_0rr2nfht_1_1.bak

File Name: /u01/oracle/soft/backup/fixfldh/data_0tr2nfhv_1_1.bak

File Name: /u01/oracle/soft/backup/fixfldh/arc_FIXFLDHx_20160410_10r2nfl9_1_1

File Name: /u01/oracle/soft/backup/fixfldh/data_0ur2nfkl_1_1.bak

File Name: /u01/oracle/soft/backup/fixfldh/arc_FIXFLDHx_20160410_12r2nflb_1_1

File Name: /u01/oracle/soft/backup/fixfldh/arc_FIXFLDHx_20160410_11r2nfla_1_1

File Name: /u01/oracle/soft/backup/fixfldh/data_0sr2nfhv_1_1.bak

File Name: /u01/oracle/soft/backup/fixfldh/data_0vr2nfkn_1_1.bak

File Name: /u01/oracle/soft/backup/ctl_05r2m052_1_1.bak

File Name: /u01/oracle/soft/backup/arc_FIXFLxxx_20160410_07r2m057_1_1

File Name: /u01/oracle/soft/backup/data_02r2m02d_1_1.bak

File Name: /u01/oracle/soft/backup/data_01r2m02d_1_1.bak

File Name: /u01/oracle/soft/backup/data_04r2m047_1_1.bak


Do you really want to catalog the above files (enter YES or NO)? yes

cataloging files...

cataloging done


List of Cataloged Files

=======================

File Name: /u01/oracle/soft/backup/fixfldh/ctl_0rr2nfht_1_1.bak

File Name: /u01/oracle/soft/backup/fixfldh/data_0tr2nfhv_1_1.bak

File Name: /u01/oracle/soft/backup/fixfldh/arc_FIXFLDHx_20160410_10r2nfl9_1_1

File Name: /u01/oracle/soft/backup/fixfldh/data_0ur2nfkl_1_1.bak

File Name: /u01/oracle/soft/backup/fixfldh/arc_FIXFLDHx_20160410_12r2nflb_1_1

File Name: /u01/oracle/soft/backup/fixfldh/arc_FIXFLDHx_20160410_11r2nfla_1_1

File Name: /u01/oracle/soft/backup/fixfldh/data_0sr2nfhv_1_1.bak

File Name: /u01/oracle/soft/backup/fixfldh/data_0vr2nfkn_1_1.bak


List of Files Which Where Not Cataloged

=======================================

File Name: /u01/oracle/soft/backup/pfile.ora

  RMAN-07517: Reason: The file header is corrupted

File Name: /u01/oracle/soft/backup/arc_FIXFLxxx_20160410_06r2m057_1_1

  RMAN-07518: Reason: Foreign database file DBID: 1093062288  Database Name: FIXFL

File Name: /u01/oracle/soft/backup/fixfldh/pfile.ora

  RMAN-07517: Reason: The file header is corrupted

File Name: /u01/oracle/soft/backup/ctl_05r2m052_1_1.bak

  RMAN-07518: Reason: Foreign database file DBID: 1093062288  Database Name: FIXFL

File Name: /u01/oracle/soft/backup/arc_FIXFLxxx_20160410_07r2m057_1_1

  RMAN-07518: Reason: Foreign database file DBID: 1093062288  Database Name: FIXFL

File Name: /u01/oracle/soft/backup/data_02r2m02d_1_1.bak

  RMAN-07518: Reason: Foreign database file DBID: 1093062288  Database Name: FIXFL

File Name: /u01/oracle/soft/backup/data_01r2m02d_1_1.bak

  RMAN-07518: Reason: Foreign database file DBID: 1093062288  Database Name: FIXFL

File Name: /u01/oracle/soft/backup/data_04r2m047_1_1.bak

  RMAN-07518: Reason: Foreign database file DBID: 1093062288  Database Name: FIXFL


RMAN> restore database;


Starting restore at 2016-04-10 22:41:43

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=68 device type=DISK


channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00001 to /u01/oracle/oradata/FIXFLDH/system01.dbf

channel ORA_DISK_1: restoring datafile 00003 to /u01/oracle/oradata/FIXFLDH/undotbs01.dbf

channel ORA_DISK_1: restoring datafile 00004 to /u01/oracle/oradata/FIXFLDH/users01.dbf

channel ORA_DISK_1: reading from backup piece /u01/oracle/soft/backup/fixfldh/data_0sr2nfhv_1_1.bak

channel ORA_DISK_1: piece handle=/u01/oracle/soft/backup/fixfldh/data_0sr2nfhv_1_1.bak tag=DB0

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:01:05

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00002 to /u01/oracle/oradata/FIXFLDH/sysaux01.dbf

channel ORA_DISK_1: restoring datafile 00005 to /u01/oracle/oradata/FIXFLDH/example01.dbf

channel ORA_DISK_1: reading from backup piece /u01/oracle/soft/backup/fixfldh/data_0tr2nfhv_1_1.bak

channel ORA_DISK_1: piece handle=/u01/oracle/soft/backup/fixfldh/data_0tr2nfhv_1_1.bak tag=DB0

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:46

Finished restore at 2016-04-10 22:43:35


RMAN> recover database;


Starting recover at 2016-04-10 22:43:49

using channel ORA_DISK_1


starting media recovery


channel ORA_DISK_1: starting archived log restore to default destination

channel ORA_DISK_1: restoring archived log

archived log thread=1 sequence=24

channel ORA_DISK_1: restoring archived log

archived log thread=1 sequence=25

channel ORA_DISK_1: reading from backup piece /u01/oracle/soft/backup/fixfldh/arc_FIXFLDHx_20160410_12r2nflb_1_1

channel ORA_DISK_1: piece handle=/u01/oracle/soft/backup/fixfldh/arc_FIXFLDHx_20160410_12r2nflb_1_1 tag=TAG20160410T223521

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:02

archived log file name=/u01/oracle/fast_recovery_area/FIXFLDH/archivelog/2016_04_10/o1_mf_1_24_cjnso70g_.arc thread=1 sequence=0

channel default: deleting archived log(s)

archived log file name=/u01/oracle/fast_recovery_area/FIXFLDH/archivelog/2016_04_10/o1_mf_1_24_cjnso70g_.arc RECID=1 STAMP=908837031

archived log file name=/u01/oracle/fast_recovery_area/FIXFLDH/archivelog/2016_04_10/o1_mf_1_25_cjnso72s_.arc thread=1 sequence=25

channel default: deleting archived log(s)

archived log file name=/u01/oracle/fast_recovery_area/FIXFLDH/archivelog/2016_04_10/o1_mf_1_25_cjnso72s_.arc RECID=2 STAMP=908837031

unable to find archived log

archived log thread=1 sequence=26

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 04/10/2016 22:43:52

RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 26 and starting SCN of 1011640


RMAN> alter database open;


database opened



--添加standby log



/u01/oracle/oradata/FIXFLDH/redo03.log

/u01/oracle/oradata/FIXFLDH/redo02.log

/u01/oracle/oradata/FIXFLDH/redo01.log



alter database add standby logfile '/u01/oracle/oradata/FIXFLDH/redo01.log' thread 1('+BACK','+RECO') size 100M;









 

SELECT a.group#,

       a.thread#,

       a.bytes / 1024 / 1024 "size_mb",

       a.status,

       b.member

  FROM v$standby_log a, v$logfile b

     WHERE a.group# = b.group#

   AND b.type = 'STANDBY'

  ORDER BY a.group#;

  

  

  ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=MEMORY SID='*';

  

  

  alter database recover managed standby database cancel;

  

  

alter database add  logfile group 8 ('/u01/oracle/oradata/FIXFLDH/redo08.log') size 50M;

alter database add  logfile group 9 ('/u01/oracle/oradata/FIXFLDH/redo09.log') size 50M;

alter database add  logfile group 10 ('/u01/oracle/oradata/FIXFLDH/redo10.log') size 50M;




alter database drop standby logfile group 4;

alter database drop standby logfile group 5;

alter database drop standby logfile group 6;

alter database drop standby logfile group 7;



sf02:FIXFLDH > oerr ora 19527

19527, 00000, "physical standby redo log must be renamed"

// *Cause:  An attempt was made to clear redo log at a physical standby

//          database. Clearing an OMF redo log will not work unless

//          DB_CREATE_FILE_DEST, DB_CREATE_ONLINE_LOG_DEST_n or 

//          DB_RECOVERY_FILE_DEST parameter is specified. Clearing a non-OMF 

//          (or user-defined) redo log file will not work unless the 

//          LOG_FILE_NAME_CONVERT initialization parameter is 

//          set.

// *Action  Set DB_CREATE_FILE_DEST, DB_CREATE_ONLINE_LOG_DEST_n or 

//          DB_RECOVERY_FILE_DEST parameter for OMF redo log files and 

//          re-issue the operation that attempted to clear redo log. Set 

//          LOG_FILE_NAME_CONVERT parameter for non-OMF redo log files and

//          re-issue the operation that attempted to clear redo log.




alter system set log_file_name_convert='/u01/oracle/oradata/FIXFLDH/','/u01/oracle/oradata/FIXFLDH/' scope=spfile;


alter database clear logfile group 1;

alter database clear logfile group 2;

alter database clear logfile group 3;


alter database drop logfile group 1;

alter database drop logfile group 2;

alter database drop logfile group 3;




1)Standby库添加四组Standby redo log,用户备库的恢复

alter database add standby logfile group 4 ('/u01/oracle/oradata/FIXFLDH/standby01.log') size 50M;

alter database add standby logfile group 5 ('/u01/oracle/oradata/FIXFLDH/standby02.log') size 50M;

alter database add standby logfile group 6 ('/u01/oracle/oradata/FIXFLDH/standby03.log') size 50M;

alter database add standby logfile group 7 ('/u01/oracle/oradata/FIXFLDH/standby04.log') size 50M;

alter database add standby logfile group 8 ('/u01/oracle/oradata/FIXFLDH/standby05.log') size 50M;


redo 文件:


alter database clear logfile group 1;

alter database drop logfile group 2;

alter database drop logfile group 3;

alter database add  logfile group 1 ('/u01/oracle/oradata/FIXFLDH/redo01.log') size 50M reuse;

alter database add  logfile group 2 ('/u01/oracle/oradata/FIXFLDH/redo02.log') size 50M reuse;

alter database add  logfile group 3 ('/u01/oracle/oradata/FIXFLDH/redo03.log') size 50M;


2)Primary库添加四组Standby redo log,用于主备切换

alter database add standby logfile group 4 ('/u01/oracle/oradata/FIXFLDH/standby01.log') size 50M;

alter database add standby logfile group 5 ('/u01/oracle/oradata/FIXFLDH/standby02.log') size 50M;

alter database add standby logfile group 6 ('/u01/oracle/oradata/FIXFLDH/standby03.log') size 50M;

alter database add standby logfile group 7 ('/u01/oracle/oradata/FIXFLDH/standby04.log') size 50M;






alter database recover managed standby database using current logfile disconnect from session;



select status from v$managed_standby;




SELECT a.group#,

       a.thread#,

       a.bytes / 1024 / 1024 "size_mb",

       a.members,

       a.status,

       b.MEMBER

  FROM v$log a, v$logfile b

 where a.group#= b.group#

 and b.TYPE='ONLINE'

 ORDER BY a.GROUP#;


 

 

 

 改成实时应用模式:

 

*.LOG_ARCHIVE_DEST_2='SERVICE=FIXFLDH_DG LGWR SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)'

修改ASYNC 为 SYNC

 

 1.拷贝主库的redo log 到备库

 

 

2.主备库都添加 standby log

alter database add standby logfile group 4 ('/u01/oracle/oradata/FIXFL/standby01.log') size 50M;

alter database add standby logfile group 5 ('/u01/oracle/oradata/FIXFL/standby02.log') size 50M;

alter database add standby logfile group 6 ('/u01/oracle/oradata/FIXFL/standby03.log') size 50M;

alter database add standby logfile group 7 ('/u01/oracle/oradata/FIXFL/standby04.log') size 50M;





SELECT a.group#,

       a.thread#,

       a.bytes / 1024 / 1024 "size_mb",

       a.members,

       a.status,

       b.MEMBER

  FROM v$log a, v$logfile b

 where a.group#= b.group#

 and b.TYPE='ONLINE'

 ORDER BY a.GROUP#;

 

 

 

 alter database recover managed standby database using current logfile disconnect from session;



select status from v$managed_standby;








IXFLDH.__db_cache_size=201326592

FIXFLDH.__java_pool_size=4194304

FIXFLDH.__large_pool_size=75497472

FIXFLDH.__oracle_base='/u01/oracle'#ORACLE_BASE set from environment

FIXFLDH.__pga_aggregate_target=272629760

FIXFLDH.__sga_target=402653184

FIXFLDH.__shared_io_pool_size=0

FIXFLDH.__shared_pool_size=109051904

FIXFLDH.__streams_pool_size=0

*.audit_file_dest='/u01/oracle/admin/FIXFLDH/adump'

*.audit_trail='db'

*.compatible='11.2.0.4.0'

*.control_files='/u01/oracle/oradata/FIXFLDH/control01.ctl','/u01/oracle/fast_recovery_area/FIXFLDH/control02.ctl'

*.db_block_size=8192

*.db_domain=''

*.db_name='FIXFLDH'

*.db_recovery_file_dest='/u01/oracle/fast_recovery_area'

*.db_recovery_file_dest_size=4385144832

*.diagnostic_dest='/u01/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=FIXFLDHXDB)'

*.memory_target=672137216

*.open_cursors=300

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.undo_tablespace='UNDOTBS1'

*.LOG_ARCHIVE_DEST_2='SERVICE=FIXFLDH_DG LGWR SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)'

*.fal_server='FIXFLDH_PRI'

*.fal_client='FIXFLDH_DG'

*.standby_file_management='AUTO'






FIXFL.__db_cache_size=138412032

FIXFL.__java_pool_size=4194304

FIXFL.__large_pool_size=12582912

FIXFL.__oracle_base='/u01/oracle'#ORACLE_BASE set from environment

FIXFL.__pga_aggregate_target=293601280

FIXFL.__sga_target=381681664

FIXFL.__shared_io_pool_size=0

FIXFL.__shared_pool_size=209715200

FIXFL.__streams_pool_size=4194304

*.audit_file_dest='/u01/oracle/admin/FIXFL/adump'

*.audit_trail='db'

*.compatible='11.2.0.4.0'

*.control_files='/u01/oracle/oradata/FIXFL/control01.ctl','/u01/oracle/fast_recovery_area/FIXFL/control02.ctl'

*.db_block_size=8192

*.db_domain=''

*.db_name='FIXFL'

*.db_recovery_file_dest='/u01/oracle/fast_recovery_area'

*.db_recovery_file_dest_size=4385144832

*.diagnostic_dest='/u01/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=FIXFLXDB)'

*.fal_client='FIXL_DG'

*.fal_server='FIXFL_PRI'

*.LOG_ARCHIVE_DEST_2='SERVICE=FIXFL_DG LGWR SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)'

*.memory_target=673185792

*.open_cursors=300

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.standby_file_management='AUTO'

*.undo_tablespace='UNDOTBS1'