srvctl status database -d db1prd
Platform: Red Hat Enterprise Linux Server release 5.6 (Tikanga)Instance db1prd1 is running on node hostprim1
Instance db1prd2 is running on node hostprim2
Instance db1prd3 is running on node hostprim3
Physical Standby Database Cluster Config:
srvctl status database -d db1stan
Platform: Red Hat Enterprise Linux Server release 5.6 (Tikanga)Instance db1stan1 is running on node hoststan1
Instance db1stan2 is running on node hoststan2
PART 1: PRE-CHECK
1. A.) On Primary, temporarily DEFER the shipping of logs to the Physical Standby nodes(log_archive_dest_state_2).
SQL> show parameter log_archive_dest_state_2
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=DEFER scope=memory sid='*';
B.) From Primary, verify that log shipping to Standby is set up:
SYS@db1prd SQL>show parameter log_archive_dest_2
Code: Select all
NAME TYPE VALUE
--------------------- ----------- ----------------------------------------------------------------------------
log_archive_dest_2 string service=db1stan valid_for=(online_logfiles,primary_role) db_unique_name=db1stanSQL> alter system set log_archive_dest_2='service=db1stan valid_for=(online_logfiles,primary_role) db_unique_name=db1stan' scope=both sid='*';
2. Determine if FORCE LOGGING is enabled on Primary. (Since this is a rebuild, FORCE LOGGING is assumed to be already enabled.)
FORCE LOGGING on database level is used to force logging of changes to the redo and is required for Data Guard sites.
SQL> SELECT force_logging FROM v$database;
If it is not enabled, enable FORCE LOGGING mode.
SQL> ALTER DATABASE FORCE LOGGING;
SYS@db1prd1 SQL>SELECT force_logging FROM v$database;
Code: Select all
FOR
---
YESSYS@db1prd SQL>show parameter log_archive_dest_state_
Code: Select all
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_1 string enable
log_archive_dest_state_2 string deferFrom hoststan1 (Physical Standby Node1):
sqlplus "sys@db1prd as sysdba"
sqlplus "sys@db1stan as sysdba"
From hostprim1 (Prim Node1):
sqlplus "sys@db1prd as sysdba"
sqlplus "sys@db1stan as sysdba"
5. Backup current Physical Standby SPFILE. See example output in Appendix B of this document.
SYS@db1stan1 SQL>create pfile='/tmp/initdb1stan1_03182013.ora' from spfile;
6. Validate current Physical Standby files.
A.) DO NOT touch spfile (+DATA/spfiledb1stan.ora) and password files (/appl/oracle/product/11.2.0/dbs/orapwdb1stan1/2).
Note: Since this is rebuild, NO need to create a new parameter file. We will reuse the spfile and orapwd files to rebuild Physical Standby DB.
B.) From Physical Standby DB, query the datafiles, logfiles, controlfiles and archivelogs to be deleted:
You can query the exact location by:
Code: Select all
set pages 0
select name from v$datafile;
select member from V$LOGFILE;
select NAME from V$CONTROLFILE;
select NAME from v$archived_log;Code: Select all
spool files_to_remove.txt
set pages 0
select 'rm '|| name ||'' from v$datafile;
select 'rm '|| member ||'' from V$LOGFILE;
select 'rm '|| NAME ||'' from V$CONTROLFILE;
select 'rm '|| NAME ||'' from v$archived_log;
spool offFrom hoststan1:
srvctl stop database -d db1stan
8. On Physical Standby DB, clean up old files.
A.) Logon to Standby Database as grid user and set ASM environment variables:
sudo su - grid
. oraenv
ORACLE_SID = [+ASM] ? +ASM
B.) Verify the correct environment:
echo $ORACLE_SID
+ASM
echo $ORACLE_HOME
/appl/grid/11.2.0
C.) Using ASMCMD utility, you're now ready to delete the above files in Step 6-B.
BE CAREFUL NOT TO DELETE Other ASM Files. DELETE ONLY FILES belonging to database your working on.
[grid@hoststan1 ~]$ asmcmd
ASMCMD> rm [files_to_delete]
ASMCMD> ls -ls
Tips:
Monitor ASM alert log.
RMAN will not overwrite database files on the Standby, they must be removed first.
ASM will not allow the deletion of files if the database is open (files are accessed).
e.g. ORA-15028: ASM file '+FLASH/db1stan/archivelog/2013_03_18/thread_5_seq_301.7291.810094303' not dropped;
currently being accessed (DBD ERROR: OCIStmtExecute)
ASM will implicitly remove empty sub-directories, so you only need to delete the files.
9a. From Primary, query the Total DB size.
Code: Select all
select 'Database Size (Mb): '||To_Char(Round((nb_ctl.nb * ctl_size.the_size)
+ (rlf_size.the_size/1024)
+ (dtf_size.the_size/1024)
+ (nvl(dtft_size.the_size,0)/1024))) as "Database Size"
From (select count(1) nb from v$controlfile) nb_ctl
, (select round(sum(record_size)/1024) the_size from V$CONTROLFILE_RECORD_SECTION) ctl_size
, (select round(sum(bytes)/1024) the_size from v$log) rlf_size
, (select round(sum(bytes)/1024) the_size from dba_data_files) dtf_size
, (select round(sum(bytes)/1024) the_size from dba_temp_files) dtft_size
/ASMCMD> lsdg
Code: Select all
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 4096 1048576 3660090 3659898 0 3659898 0 N DATA/
MOUNTED EXTERN N 512 4096 1048576 4182960 4155907 0 4155907 0 N FLASH/SQL> select name, state, type, total_mb, free_mb from v$asm_diskgroup;
Code: Select all
NAME STATE TYPE TOTAL_MB FREE_MB
------------------------------ ----------- ------ ---------- ----------
DATA MOUNTED EXTERN 6274440 6274233
FLASH MOUNTED EXTERN 4182960 4155923>> WARNING! DO NOT proceed if space is insufficient. Fix it first.
---------------------------------------------------------------------
10. Disable currently running RMAN backups on standby.
11. Disable currently running RMAN backups on PRIMARY, if any.
Note: Ensure that PRE-CHECK is successful before proceeding to Actual Rebuild.
**** END of PRE-CHECK ****
PART 2: REBUILD
1. From node1 (hoststan1), startup db1stan1 instance in NOMOUNT mode. DO NOT startup other node/s.
We only need the first node at this moment.
[oracle@hoststan1 ~]$ export ORACLE_SID=db1stan1
SQL> startup nomount;
2. On the same host (hoststan1), execute the Active Database Duplication.
WE WILL USE RESOURCES ON Physical Standby NODE1 (hoststan1) TO PREVENT PERFORMANCE IMPACT ON PRIMARY, utilizing the 10 gigabit Ethernet.
A.) Create a file that contains below:
vi rebuild.rman
Note: connect TARGET = Primary DBconnect TARGET sys/[sys_password_here]@db1prd
connect AUXILIARY sys/[sys_password_here]@db1stan
RUN {
allocate channel tgt1 type disk;
allocate channel tgt2 type disk;
allocate channel tgt3 type disk;
allocate channel tgt4 type disk;
allocate channel tgt5 type disk;
allocate auxiliary channel dup1 type disk;
allocate auxiliary channel dup2 type disk;
allocate auxiliary channel dup3 type disk;
DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE NOFILENAMECHECK;
}
connect AUXILIARY = Standby DB
B.) Run the RMAN script from the background.
nohup rman @rebuild.rman log=db1stanrebuild.log &
C.) Monitor db1stanrebuild.log and alert log. See example output in Appendix A of this document.
tail -500f db1stanrebuild.log
tail -500f [background_dump_dest]/alert_db1stan1.log
Note: Replication will take a while, depending on the database size. If successful, it will automatically startup the node1 instance.
Then proceed to step 3.
3. Restart Physical Standby DB.
A.) Shutdown Physical Standby node1.
export ORACLE_SID=db1stan1
sqlplus '/as sysdba'
SQL> shutdown
SQL> exit
B.)Then startup Standby Database cluster using srvctl utility:
srvctl start database -d db1stan
srvctl status database -d db1stan
4. From Primary, re-enable log shipping.
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=enable scope=both sid='*';
5. Verify the thread# on Primary.
[hostprim1]:db1prd1 >srvctl status database -d db1prd
A.) SYS@db1prd1 SQL>show parameter thread;Instance db1prd1 is running on node hostprim1
Instance db1prd2 is running on node hostprim2
Instance db1prd3 is running on node hostprim3
Code: Select all
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
thread integer 1Code: Select all
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
thread integer 3Code: Select all
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
thread integer 5This is ESSENTIAL for real-time apply.
Note: The number of Physical Standby standby redo logfile (SRLs) groups for each thread must be equal to [{number of Primary ORLs} + 1].
The size should also match the Primary ORLs.
SYS@db1stan1 SQL>prompt Standby Redo Logs
SYS@db1stan1 SQL>select GROUP#,THREAD#,sequence#,BYTES,status,ARCHIVED from v$standby_log order by THREAD#,GROUP# asc;
Code: Select all
GROUP# THREAD# SEQUENCE# BYTES STATUS ARC
---------- ---------- ---------- ------------- ---------- ---
10 1 0 2147483648 UNASSIGNED NO
11 1 2017 2147483648 ACTIVE YES
12 1 0 2147483648 UNASSIGNED NO
13 1 0 2147483648 UNASSIGNED YES
5 3 0 2147483648 UNASSIGNED NO
6 3 1531 2147483648 ACTIVE YES
9 3 0 2147483648 UNASSIGNED YES
18 3 0 2147483648 UNASSIGNED YES
19 5 0 2147483648 UNASSIGNED NO
20 5 314 2147483648 ACTIVE YES
21 5 0 2147483648 UNASSIGNED NO
31 5 0 2147483648 UNASSIGNED YES
12 rows selected.SQL> alter database add standby logfile thread [n] ('+DISKGROUP1','+DISKGROUP2') size [n]; --where size = Primary ORL size
e.g.
SQL> alter database add standby logfile thread 5 ('+DATA','+FLASH') size 2147483648;
The alert "RFS[5]: No standby redo logfiles created for thread n" states that there are missing Physical Standby SRLs so you must create them.
7. From Physical Standby node1 (db1stan1@hoststan1), start MRP in Real Time Redo Apply mode.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;
8. Wait until Physical Standby completes the archivelogs gap resolution.
9. When you are sure that Primary and Physical Standby are now synched, re-enable all backup jobs.
A.) Revert backup job changes (See PART 1 steps 10-11).
10. Verify that all services are running and that you can connect remotely on all Physical Standby nodes.
----------------------------
**** END of REBUILD ******************************************************
**************************************************************************
**************************************************************************
**************************************************************************
--------------------------------------------------------------------------
APPENDIX A: SUCCESSFUL COMPLETION OF RMAN ACTIVE DUPLICATE DATABASE SCRIPT
--------------------------------------------------------------------------
--------------------------------------------------------------------------[oracle@hoststan1 oracle]$ cat db1stanrebuild.log
Recovery Manager: Release 11.2.0.2.0 - Production on Fri Mar 15 00:58:52 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN> connect target *
2> connect AUXILIARY *
3> RUN {
4> allocate channel tgt1 type disk;
5> allocate channel tgt2 type disk;
6> allocate channel tgt3 type disk;
7> allocate channel tgt4 type disk;
8> allocate channel tgt5 type disk;
9> allocate auxiliary channel dup1 type disk;
10> allocate auxiliary channel dup2 type disk;
11> allocate auxiliary channel dup3 type disk;
12> DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE NOFILENAMECHECK;
13> }
14>
15>
connected to target database: db1prd (DBID=433293731)
connected to auxiliary database: db1prd (not mounted)
using target database control file instead of recovery catalog
allocated channel: tgt1
channel tgt1: SID=2395 instance=db1prd1 device type=DISK
allocated channel: tgt2
channel tgt2: SID=2433 instance=db1prd1 device type=DISK
allocated channel: tgt3
channel tgt3: SID=2547 instance=db1prd1 device type=DISK
allocated channel: tgt4
channel tgt4: SID=2661 instance=db1prd1 device type=DISK
allocated channel: tgt5
channel tgt5: SID=2737 instance=db1prd1 device type=DISK
allocated channel: dup1
channel dup1: SID=2113 instance=db1stan1 device type=DISK
allocated channel: dup2
channel dup2: SID=2161 instance=db1stan1 device type=DISK
allocated channel: dup3
channel dup3: SID=2209 instance=db1stan1 device type=DISK
Starting Duplicate Db at 15-MAR-13
contents of Memory Script:
{
backup as copy reuse
targetfile '/appl/oracle/product/11.2.0/dbs/orapwdb1prd1' auxiliary format
'/appl/oracle/product/11.2.0/dbs/orapwdb1stan1' ;
}
executing Memory Script
Starting backup at 15-MAR-13
Finished backup at 15-MAR-13
contents of Memory Script:
{
sql clone "alter system set control_files =
''+DATA/db1stan/controlfile/current.1411.794571783'', ''+FLASH/db1stan/controlfile/current.2054.794571783'' comment=
''Set by RMAN'' scope=spfile";
backup as copy current controlfile for standby auxiliary format '+DATA/db1stan/controlfile/current.1411.794571783';
restore clone controlfile to '+FLASH/db1stan/controlfile/current.2054.794571783' from
'+DATA/db1stan/controlfile/current.1411.794571783';
sql clone "alter system set control_files =
''+DATA/db1stan/controlfile/current.1411.794571783'', ''+FLASH/db1stan/controlfile/current.2054.794571783'' comment=
''Set by RMAN'' scope=spfile";
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
sql statement: alter system set control_files = ''+DATA/db1stan/controlfile/current.1411.794571783'',
''+FLASH/db1stan/controlfile/current.2054.794571783'' comment= ''Set by RMAN'' scope=spfile
Starting backup at 15-MAR-13
channel tgt1: starting datafile copy
copying standby control file
output file name=+FLASH/db1prd/controlfile/snapcf_db1prdp1.f tag=TAG20130315T005902 RECID=4 STAMP=810089942
channel tgt1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 15-MAR-13
Starting restore at 15-MAR-13
channel dup2: skipped, AUTOBACKUP already found
channel dup3: skipped, AUTOBACKUP already found
channel dup1: copied control file copy
Finished restore at 15-MAR-13
sql statement: alter system set control_files = ''+DATA/db1stan/controlfile/current.1411.794571783'',
''+FLASH/db1stan/controlfile/current.2054.794571783'' comment= ''Set by RMAN'' scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 2137886720 bytes
Fixed Size 2228200 bytes
Variable Size 973078552 bytes
Database Buffers 1124073472 bytes
Redo Buffers 38506496 bytes
allocated channel: dup1
channel dup1: SID=2113 instance=db1stan1 device type=DISK
allocated channel: dup2
channel dup2: SID=2161 instance=db1stan1 device type=DISK
allocated channel: dup3
channel dup3: SID=2209 instance=db1stan1 device type=DISK
contents of Memory Script:
{
sql clone 'alter database mount standby database';
}
executing Memory Script
sql statement: alter database mount standby database
RMAN-05529: WARNING: DB_FILE_NAME_CONVERT resulted in invalid ASM names; names changed to disk group only.
contents of Memory Script:
{
set newname for tempfile 1 to
"+data";
set newname for tempfile 2 to
"+data";
set newname for tempfile 3 to
"+data";
switch clone tempfile all;
set newname for datafile 1 to
"+data";
set newname for datafile 2 to
"+data";
set newname for datafile 3 to
"+data";
set newname for datafile 4 to
"+data";
set newname for datafile 5 to
"+data";
set newname for datafile 6 to
"+data";
set newname for datafile 7 to
"+data";
set newname for datafile 8 to
"+data";
set newname for datafile 9 to
"+data";
set newname for datafile 10 to
"+data";
set newname for datafile 11 to
"+data";
set newname for datafile 12 to
"+data";
set newname for datafile 13 to
"+data";
set newname for datafile 14 to
"+data";
set newname for datafile 15 to
"+data";
set newname for datafile 16 to
"+data";
set newname for datafile 17 to
"+data";
set newname for datafile 18 to
"+data";
set newname for datafile 19 to
"+data";
set newname for datafile 20 to
"+data";
set newname for datafile 21 to
"+data";
set newname for datafile 22 to
"+data";
set newname for datafile 23 to
"+data";
set newname for datafile 24 to
"+data";
set newname for datafile 25 to
"+data";
set newname for datafile 26 to
"+data";
set newname for datafile 27 to
"+data";
set newname for datafile 28 to
"+data";
set newname for datafile 29 to
"+data";
set newname for datafile 30 to
"+data";
set newname for datafile 31 to
"+data";
set newname for datafile 32 to
"+data";
set newname for datafile 33 to
"+data";
set newname for datafile 34 to
"+data";
set newname for datafile 35 to
"+data";
set newname for datafile 36 to
"+data";
set newname for datafile 37 to
"+data";
set newname for datafile 38 to
"+data";
set newname for datafile 39 to
"+data";
set newname for datafile 40 to
"+DATA/db1stan/datafile/datafile40.dbf";
backup as copy reuse
datafile 1 auxiliary format
"+data" datafile
2 auxiliary format
"+data" datafile
3 auxiliary format
"+data" datafile
4 auxiliary format
"+data" datafile
5 auxiliary format
"+data" datafile
6 auxiliary format
"+data" datafile
7 auxiliary format
"+data" datafile
8 auxiliary format
"+data" datafile
9 auxiliary format
"+data" datafile
10 auxiliary format
"+data" datafile
11 auxiliary format
"+data" datafile
12 auxiliary format
"+data" datafile
13 auxiliary format
"+data" datafile
14 auxiliary format
"+data" datafile
15 auxiliary format
"+data" datafile
16 auxiliary format
"+data" datafile
17 auxiliary format
"+data" datafile
18 auxiliary format
"+data" datafile
19 auxiliary format
"+data" datafile
20 auxiliary format
"+data" datafile
21 auxiliary format
"+data" datafile
22 auxiliary format
"+data" datafile
23 auxiliary format
"+data" datafile
24 auxiliary format
"+data" datafile
25 auxiliary format
"+data" datafile
26 auxiliary format
"+data" datafile
27 auxiliary format
"+data" datafile
28 auxiliary format
"+data" datafile
29 auxiliary format
"+data" datafile
30 auxiliary format
"+data" datafile
31 auxiliary format
"+data" datafile
32 auxiliary format
"+data" datafile
33 auxiliary format
"+data" datafile
34 auxiliary format
"+data" datafile
35 auxiliary format
"+data" datafile
36 auxiliary format
"+data" datafile
37 auxiliary format
"+data" datafile
38 auxiliary format
"+data" datafile
39 auxiliary format
"+data" datafile
40 auxiliary format
"+DATA/db1stan/datafile/datafile40.dbf" ;
sql 'alter system archive log current';
}
executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
renamed tempfile 1 to +data in control file
renamed tempfile 2 to +data in control file
renamed tempfile 3 to +data in control file
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting backup at 15-MAR-13
channel tgt1: starting datafile copy
input datafile file number=00032 name=+DATA/db1prd/datafile/datafile32.1055.792024745
channel tgt2: starting datafile copy
input datafile file number=00033 name=+DATA/db1prd/datafile/datafile33_index.1056.792024751
channel tgt3: starting datafile copy
input datafile file number=00008 name=+DATA/db1prd/datafile/datafile8.1030.792024535
channel tgt4: starting datafile copy
input datafile file number=00009 name=+DATA/db1prd/datafile/datafile9.1031.792024547
channel tgt5: starting datafile copy
input datafile file number=00003 name=+DATA/db1prd/datafile/undotbs1.873.785776559
output file name=+DATA/db1stan/datafile/undotbs1.1434.810089987 tag=TAG20130315T005944
channel tgt5: datafile copy complete, elapsed time: 00:02:45
channel tgt5: starting datafile copy
input datafile file number=00035 name=+DATA/db1prd/datafile/undotbs3.1117.798683125
output file name=+DATA/db1stan/datafile/undotbs3.1433.810090153 tag=TAG20130315T005944
channel tgt5: datafile copy complete, elapsed time: 00:02:26
channel tgt5: starting datafile copy
input datafile file number=00039 name=+DATA/db1prd/datafile/undotbs5.1121.798683465
output file name=+DATA/db1stan/datafile/datafile9.1435.810089987 tag=TAG20130315T005944
channel tgt4: datafile copy complete, elapsed time: 00:06:26
channel tgt4: starting datafile copy
input datafile file number=00005 name=+DATA/db1prd/datafile/undotbs2_1.876.797127533
output file name=+DATA/db1stan/datafile/undotbs5.1449.810090297 tag=TAG20130315T005944
channel tgt5: datafile copy complete, elapsed time: 00:01:40
channel tgt5: starting datafile copy
input datafile file number=00007 name=+DATA/db1prd/datafile/datafile7.898.785784437
output file name=+DATA/db1stan/datafile/datafile7.1387.810090397 tag=TAG20130315T005944
channel tgt5: datafile copy complete, elapsed time: 00:00:45
channel tgt5: starting datafile copy
input datafile file number=00002 name=+DATA/db1prd/datafile/sysaux.872.785776557
output file name=+DATA/db1stan/datafile/undotbs2_1.1427.810090373 tag=TAG20130315T005944
channel tgt4: datafile copy complete, elapsed time: 00:01:18
channel tgt4: starting datafile copy
input datafile file number=00010 name=+DATA/db1prd/datafile/datafile.1032.792024553
output file name=+DATA/db1stan/datafile/sysaux.1380.810090443 tag=TAG20130315T005944
channel tgt5: datafile copy complete, elapsed time: 00:00:14
channel tgt5: starting datafile copy
input datafile file number=00011 name=+DATA/db1prd/datafile/datafile_index.1033.792024567
output file name=+DATA/db1stan/datafile/datafile.1381.810090451 tag=TAG20130315T005944
channel tgt4: datafile copy complete, elapsed time: 00:00:14
channel tgt4: starting datafile copy
input datafile file number=00012 name=+DATA/db1prd/datafile/datafile.1034.792024579
output file name=+DATA/db1stan/datafile/datafile_index.1382.810090457 tag=TAG20130315T005944
channel tgt5: datafile copy complete, elapsed time: 00:00:14
channel tgt5: starting datafile copy
input datafile file number=00013 name=+DATA/db1prd/datafile/datafile_index.1035.792024587
output file name=+DATA/db1stan/datafile/datafile.1385.810090465 tag=TAG20130315T005944
channel tgt4: datafile copy complete, elapsed time: 00:00:14
channel tgt4: starting datafile copy
input datafile file number=00014 name=+DATA/db1prd/datafile/datafile.1036.792024591
output file name=+DATA/db1stan/datafile/datafile_index.1383.810090471 tag=TAG20130315T005944
channel tgt5: datafile copy complete, elapsed time: 00:00:14
channel tgt5: starting datafile copy
input datafile file number=00015 name=+DATA/db1prd/datafile/datafile_index.1037.792024597
output file name=+DATA/db1stan/datafile/datafile.1378.810090479 tag=TAG20130315T005944
channel tgt4: datafile copy complete, elapsed time: 00:00:15
channel tgt4: starting datafile copy
input datafile file number=00016 name=+DATA/db1prd/datafile/reference.1038.792024611
output file name=+DATA/db1stan/datafile/datafile_index.1413.810090487 tag=TAG20130315T005944
channel tgt5: datafile copy complete, elapsed time: 00:00:14
channel tgt5: starting datafile copy
input datafile file number=00017 name=+DATA/db1prd/datafile/datafile17.1039.792024615
output file name=+DATA/db1stan/datafile/reference.1386.810090493 tag=TAG20130315T005944
channel tgt4: datafile copy complete, elapsed time: 00:00:14
channel tgt4: starting datafile copy
input datafile file number=00018 name=+DATA/db1prd/datafile/datafile.1040.792024619
output file name=+DATA/db1stan/datafile/datafile.1393.810090507 tag=TAG20130315T005944
channel tgt4: datafile copy complete, elapsed time: 00:00:15
channel tgt4: starting datafile copy
input datafile file number=00019 name=+DATA/db1prd/datafile/datafile_index.1041.792024623
output file name=+DATA/db1stan/datafile/datafile17.1392.810090501 tag=TAG20130315T005944
channel tgt5: datafile copy complete, elapsed time: 00:00:22
channel tgt5: starting datafile copy
input datafile file number=00020 name=+DATA/db1prd/datafile/datafile.1042.792024627
output file name=+DATA/db1stan/datafile/datafile_index.1394.810090523 tag=TAG20130315T005944
channel tgt4: datafile copy complete, elapsed time: 00:00:25
channel tgt4: starting datafile copy
input datafile file number=00021 name=+DATA/db1prd/datafile/datafile_index.1043.792024631
output file name=+DATA/db1stan/datafile/datafile.1395.810090523 tag=TAG20130315T005944
channel tgt5: datafile copy complete, elapsed time: 00:00:26
channel tgt5: starting datafile copy
input datafile file number=00022 name=+DATA/db1prd/datafile/datafile.1044.792024635
output file name=+DATA/db1stan/datafile/datafile_index.1397.810090549 tag=TAG20130315T005944
channel tgt4: datafile copy complete, elapsed time: 00:00:25
channel tgt4: starting datafile copy
input datafile file number=00023 name=+DATA/db1prd/datafile/datafile_index.1045.792024639
output file name=+DATA/db1stan/datafile/datafile.1396.810090549 tag=TAG20130315T005944
channel tgt5: datafile copy complete, elapsed time: 00:00:25
channel tgt5: starting datafile copy
input datafile file number=00024 name=+DATA/db1prd/datafile/store.1046.792024679
output file name=+DATA/db1stan/datafile/datafile_index.1398.810090573 tag=TAG20130315T005944
channel tgt4: datafile copy complete, elapsed time: 00:00:25
channel tgt4: starting datafile copy
input datafile file number=00026 name=+DATA/db1prd/datafile/datafile.1048.792024685
output file name=+DATA/db1stan/datafile/store.1399.810090573 tag=TAG20130315T005944
channel tgt5: datafile copy complete, elapsed time: 00:00:25
channel tgt5: starting datafile copy
input datafile file number=00028 name=+DATA/db1prd/datafile/datafile.1050.792024693
output file name=+DATA/db1stan/datafile/datafile.1400.810090599 tag=TAG20130315T005944
channel tgt4: datafile copy complete, elapsed time: 00:00:26
channel tgt4: starting datafile copy
input datafile file number=00030 name=+DATA/db1prd/datafile/posmessage.1053.792024721
output file name=+DATA/db1stan/datafile/datafile.1401.810090599 tag=TAG20130315T005944
channel tgt5: datafile copy complete, elapsed time: 00:00:25
channel tgt5: starting datafile copy
input datafile file number=00031 name=+DATA/db1prd/datafile/posmessage_index.1054.792024725
output file name=+DATA/db1stan/datafile/posmessage.1402.810090625 tag=TAG20130315T005944
channel tgt4: datafile copy complete, elapsed time: 00:00:25
channel tgt4: starting datafile copy
input datafile file number=00036 name=+DATA/db1prd/datafile/store_index.1102.795533911
output file name=+DATA/db1stan/datafile/posmessage_index.1403.810090625 tag=TAG20130315T005944
channel tgt5: datafile copy complete, elapsed time: 00:00:25
channel tgt5: starting datafile copy
input datafile file number=00037 name=+DATA/db1prd/datafile/sysaux.1103.795534033
output file name=+DATA/db1stan/datafile/store_index.1404.810090649 tag=TAG20130315T005944
channel tgt4: datafile copy complete, elapsed time: 00:00:35
channel tgt4: starting datafile copy
input datafile file number=00038 name=+DATA/db1prd/datafile/datafile17.1104.795534929
output file name=+DATA/db1stan/datafile/sysaux.1405.810090649 tag=TAG20130315T005944
channel tgt5: datafile copy complete, elapsed time: 00:00:35
channel tgt5: starting datafile copy
input datafile file number=00001 name=+DATA/db1prd/datafile/system.871.785776553
output file name=+DATA/db1stan/datafile/datafile17.1406.810090685 tag=TAG20130315T005944
channel tgt4: datafile copy complete, elapsed time: 00:00:26
channel tgt4: starting datafile copy
input datafile file number=00025 name=+DATA/db1prd/datafile/store_index.1047.792024683
output file name=+DATA/db1stan/datafile/system.1407.810090685 tag=TAG20130315T005944
channel tgt5: datafile copy complete, elapsed time: 00:00:25
channel tgt5: starting datafile copy
input datafile file number=00027 name=+DATA/db1prd/datafile/datafile_index.1049.792024691
output file name=+DATA/db1stan/datafile/store_index.1408.810090711 tag=TAG20130315T005944
channel tgt4: datafile copy complete, elapsed time: 00:00:15
channel tgt4: starting datafile copy
input datafile file number=00029 name=+DATA/db1prd/datafile/datafile_index.1051.792024697
output file name=+DATA/db1stan/datafile/datafile_index.1409.810090711 tag=TAG20130315T005944
channel tgt5: datafile copy complete, elapsed time: 00:00:15
channel tgt5: starting datafile copy
input datafile file number=00040 name=+DATA/db1prd/datafile/datafile40.dbf
output file name=+DATA/db1stan/datafile/datafile_index.1374.810090725 tag=TAG20130315T005944
channel tgt4: datafile copy complete, elapsed time: 00:00:15
channel tgt4: starting datafile copy
input datafile file number=00004 name=+DATA/db1prd/datafile/undotbs2.875.785776565
output file name=+DATA/db1stan/datafile/datafile40.dbf tag=TAG20130315T005944
channel tgt5: datafile copy complete, elapsed time: 00:00:15
channel tgt5: starting datafile copy
input datafile file number=00034 name=+DATA/db1prd/datafile/undotbs4.1092.795197567
output file name=+DATA/db1stan/datafile/undotbs2.1376.810090741 tag=TAG20130315T005944
channel tgt4: datafile copy complete, elapsed time: 00:00:08
channel tgt4: starting datafile copy
input datafile file number=00006 name=+DATA/db1prd/datafile/users.877.785776567
output file name=+DATA/db1stan/datafile/undotbs4.1377.810090741 tag=TAG20130315T005944
channel tgt5: datafile copy complete, elapsed time: 00:00:07
output file name=+DATA/db1stan/datafile/users.1410.810090749 tag=TAG20130315T005944
channel tgt4: datafile copy complete, elapsed time: 00:00:01
output file name=+DATA/db1stan/datafile/datafile8.1450.810089987 tag=TAG20130315T005944
channel tgt3: datafile copy complete, elapsed time: 00:48:28
output file name=+DATA/db1stan/datafile/datafile.1511.810089987 tag=TAG20130315T005944
channel tgt1: datafile copy complete, elapsed time: 00:57:28
output file name=+DATA/db1stan/datafile/datafile_index.1493.810089987 tag=TAG20130315T005944
channel tgt2: datafile copy complete, elapsed time: 00:57:28
Finished backup at 15-MAR-13
sql statement: alter system archive log current
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy RECID=4 STAMP=810093442 file name=+DATA/db1stan/datafile/system.1407.810090685
datafile 2 switched to datafile copy
input datafile copy RECID=5 STAMP=810093442 file name=+DATA/db1stan/datafile/sysaux.1380.810090443
datafile 3 switched to datafile copy
input datafile copy RECID=6 STAMP=810093442 file name=+DATA/db1stan/datafile/undotbs1.1434.810089987
datafile 4 switched to datafile copy
input datafile copy RECID=7 STAMP=810093442 file name=+DATA/db1stan/datafile/undotbs2.1376.810090741
datafile 5 switched to datafile copy
input datafile copy RECID=8 STAMP=810093442 file name=+DATA/db1stan/datafile/undotbs2_1.1427.810090373
datafile 6 switched to datafile copy
input datafile copy RECID=9 STAMP=810093442 file name=+DATA/db1stan/datafile/users.1410.810090749
datafile 7 switched to datafile copy
input datafile copy RECID=10 STAMP=810093442 file name=+DATA/db1stan/datafile/datafile7.1387.810090397
datafile 8 switched to datafile copy
input datafile copy RECID=11 STAMP=810093442 file name=+DATA/db1stan/datafile/datafile8.1450.810089987
datafile 9 switched to datafile copy
input datafile copy RECID=12 STAMP=810093442 file name=+DATA/db1stan/datafile/datafile9.1435.810089987
datafile 10 switched to datafile copy
input datafile copy RECID=13 STAMP=810093442 file name=+DATA/db1stan/datafile/datafile.1381.810090451
datafile 11 switched to datafile copy
input datafile copy RECID=14 STAMP=810093443 file name=+DATA/db1stan/datafile/datafile_index.1382.810090457
datafile 12 switched to datafile copy
input datafile copy RECID=15 STAMP=810093443 file name=+DATA/db1stan/datafile/datafile.1385.810090465
datafile 13 switched to datafile copy
input datafile copy RECID=16 STAMP=810093443 file name=+DATA/db1stan/datafile/datafile_index.1383.810090471
datafile 14 switched to datafile copy
input datafile copy RECID=17 STAMP=810093443 file name=+DATA/db1stan/datafile/datafile.1378.810090479
datafile 15 switched to datafile copy
input datafile copy RECID=18 STAMP=810093443 file name=+DATA/db1stan/datafile/datafile_index.1413.810090487
datafile 16 switched to datafile copy
input datafile copy RECID=19 STAMP=810093443 file name=+DATA/db1stan/datafile/reference.1386.810090493
datafile 17 switched to datafile copy
input datafile copy RECID=20 STAMP=810093443 file name=+DATA/db1stan/datafile/datafile17.1392.810090501
datafile 18 switched to datafile copy
input datafile copy RECID=21 STAMP=810093443 file name=+DATA/db1stan/datafile/datafile.1393.810090507
datafile 19 switched to datafile copy
input datafile copy RECID=22 STAMP=810093443 file name=+DATA/db1stan/datafile/datafile_index.1394.810090523
datafile 20 switched to datafile copy
input datafile copy RECID=23 STAMP=810093443 file name=+DATA/db1stan/datafile/datafile.1395.810090523
datafile 21 switched to datafile copy
input datafile copy RECID=24 STAMP=810093443 file name=+DATA/db1stan/datafile/datafile_index.1397.810090549
datafile 22 switched to datafile copy
input datafile copy RECID=25 STAMP=810093443 file name=+DATA/db1stan/datafile/datafile.1396.810090549
datafile 23 switched to datafile copy
input datafile copy RECID=26 STAMP=810093443 file name=+DATA/db1stan/datafile/datafile_index.1398.810090573
datafile 24 switched to datafile copy
input datafile copy RECID=27 STAMP=810093443 file name=+DATA/db1stan/datafile/store.1399.810090573
datafile 25 switched to datafile copy
input datafile copy RECID=28 STAMP=810093443 file name=+DATA/db1stan/datafile/store_index.1408.810090711
datafile 26 switched to datafile copy
input datafile copy RECID=29 STAMP=810093443 file name=+DATA/db1stan/datafile/datafile.1400.810090599
datafile 27 switched to datafile copy
input datafile copy RECID=30 STAMP=810093444 file name=+DATA/db1stan/datafile/datafile_index.1409.810090711
datafile 28 switched to datafile copy
input datafile copy RECID=31 STAMP=810093444 file name=+DATA/db1stan/datafile/datafile.1401.810090599
datafile 29 switched to datafile copy
input datafile copy RECID=32 STAMP=810093444 file name=+DATA/db1stan/datafile/datafile_index.1374.810090725
datafile 30 switched to datafile copy
input datafile copy RECID=33 STAMP=810093444 file name=+DATA/db1stan/datafile/posmessage.1402.810090625
datafile 31 switched to datafile copy
input datafile copy RECID=34 STAMP=810093444 file name=+DATA/db1stan/datafile/posmessage_index.1403.810090625
datafile 32 switched to datafile copy
input datafile copy RECID=35 STAMP=810093444 file name=+DATA/db1stan/datafile/datafile.1511.810089987
datafile 33 switched to datafile copy
input datafile copy RECID=36 STAMP=810093444 file name=+DATA/db1stan/datafile/datafile_index.1493.810089987
datafile 34 switched to datafile copy
input datafile copy RECID=37 STAMP=810093444 file name=+DATA/db1stan/datafile/undotbs4.1377.810090741
datafile 35 switched to datafile copy
input datafile copy RECID=38 STAMP=810093444 file name=+DATA/db1stan/datafile/undotbs3.1433.810090153
datafile 36 switched to datafile copy
input datafile copy RECID=39 STAMP=810093444 file name=+DATA/db1stan/datafile/store_index.1404.810090649
datafile 37 switched to datafile copy
input datafile copy RECID=40 STAMP=810093444 file name=+DATA/db1stan/datafile/sysaux.1405.810090649
datafile 38 switched to datafile copy
input datafile copy RECID=41 STAMP=810093444 file name=+DATA/db1stan/datafile/datafile17.1406.810090685
datafile 39 switched to datafile copy
input datafile copy RECID=42 STAMP=810093444 file name=+DATA/db1stan/datafile/undotbs5.1449.810090297
datafile 40 switched to datafile copy
input datafile copy RECID=43 STAMP=810093444 file name=+DATA/db1stan/datafile/datafile40.dbf
Finished Duplicate Db at 15-MAR-13
released channel: tgt1
released channel: tgt2
released channel: tgt3
released channel: tgt4
released channel: tgt5
released channel: dup1
released channel: dup2
released channel: dup3
Recovery Manager complete.
APPENDIX B: STANDBY DATABASE INITIALIZATION PARAMETER FILE
--------------------------------------------------------------------------
*.__db_cache_size=768M
db1stan2.__db_cache_size=1140850688
db1stan1.__db_cache_size=1124073472
*.__java_pool_size=16M
db1stan2.__java_pool_size=16777216
db1stan1.__java_pool_size=16777216
*.__large_pool_size=16M
db1stan2.__large_pool_size=16777216
db1stan1.__large_pool_size=16777216
*.__oracle_base='/appl/oracle'# ORACLE_BASE set from environment
db1stan1.__oracle_base='/appl/oracle'#ORACLE_BASE set from environment
*.__pga_aggregate_target=3076M
db1stan2.__pga_aggregate_target=3238002688
db1stan1.__pga_aggregate_target=3238002688
*.__sga_target=2G
db1stan2.__sga_target=2147483648
db1stan1.__sga_target=2147483648
*.__shared_io_pool_size=0
db1stan2.__shared_io_pool_size=0
db1stan1.__shared_io_pool_size=0
*.__shared_pool_size=1200M
db1stan2.__shared_pool_size=905969664
db1stan1.__shared_pool_size=922746880
*.__streams_pool_size=0
db1stan2.__streams_pool_size=0
db1stan1.__streams_pool_size=0
*._aggregation_optimization_settings=0
*._always_anti_join='CHOOSE'
*._always_semi_join='CHOOSE'
*._and_pruning_enabled=TRUE
*._b_tree_bitmap_plans=TRUE
*._bloom_filter_enabled=TRUE
*._bloom_folding_enabled=TRUE
*._bloom_pruning_enabled=TRUE
*._complex_view_merging=TRUE
*._compression_compatibility='11.2.0.0.0'
*._connect_by_use_union_all='TRUE'
*._convert_set_to_join=FALSE
*._cost_equality_semi_join=TRUE
*._cpu_to_io=0
*._dimension_skip_null=TRUE
*._eliminate_common_subexpr=TRUE
*._enable_type_dep_selectivity=TRUE
*._fast_full_scan_enabled=TRUE
*._first_k_rows_dynamic_proration=TRUE
*._gby_hash_aggregation_enabled=TRUE
*._generalized_pruning_enabled=TRUE
*._globalindex_pnum_filter_enabled=TRUE
*._gs_anti_semi_join_allowed=TRUE
*._improved_outerjoin_card=TRUE
*._improved_row_length_enabled=TRUE
*._index_join_enabled=TRUE
*._ksb_restart_policy_times='0','60','120','240'# internal update to set default
*._left_nested_loops_random=TRUE
*._local_communication_costing_enabled=TRUE
*._minimal_stats_aggregation=TRUE
*._mmv_query_rewrite_enabled=TRUE
*._new_initial_join_orders=TRUE
*._new_sort_cost_estimate=TRUE
*._nlj_datafileing_enabled=1
*._optim_adjust_for_part_skews=TRUE
*._optim_enhance_nnull_detection=TRUE
*._optim_new_default_join_sel=TRUE
*._optim_peek_user_binds=TRUE
*._optimizer_adaptive_cursor_sharing=TRUE
*._optimizer_better_inlist_costing='ALL'
*._optimizer_cbqt_no_size_restriction=TRUE
*._optimizer_coalesce_subqueries=TRUE
*._optimizer_complex_pred_selectivity=TRUE
*._optimizer_compute_index_stats=TRUE
*._optimizer_connect_by_combine_sw=TRUE
*._optimizer_connect_by_cost_based=TRUE
*._optimizer_connect_by_elim_dups=TRUE
*._optimizer_correct_sq_selectivity=TRUE
*._optimizer_cost_based_transformation='LINEAR'
*._optimizer_cost_hjsmj_multimatch=TRUE
*._optimizer_cost_model='CHOOSE'
*._optimizer_dim_subq_join_sel=TRUE
*._optimizer_distinct_agg_transform=TRUE
*._optimizer_distinct_elimination=TRUE
*._optimizer_distinct_placement=TRUE
*._optimizer_eliminate_filtering_join=TRUE
*._optimizer_enable_density_improvements=TRUE
*._optimizer_enable_extended_stats=TRUE
*._optimizer_enable_table_lookup_by_nl=TRUE
*._optimizer_enhanced_filter_push=TRUE
*._optimizer_extend_jppd_view_types=TRUE
*._optimizer_extended_cursor_sharing='UDO'
*._optimizer_extended_cursor_sharing_rel='SIMPLE'
*._optimizer_extended_stats_usage_control=192
*._optimizer_false_filter_pred_pullup=TRUE
*._optimizer_fast_access_pred_analysis=TRUE
*._optimizer_fast_pred_transitivity=TRUE
*._optimizer_filter_pred_pullup=TRUE
*._optimizer_fkr_index_cost_bias=10
*._optimizer_group_by_placement=TRUE
*._optimizer_improve_selectivity=TRUE
*._optimizer_interleave_jppd=TRUE
*._optimizer_join_elimination_enabled=TRUE
*._optimizer_join_factorization=TRUE
*._optimizer_join_order_control=3
*._optimizer_join_sel_sanity_check=TRUE
*._optimizer_max_permutations=2000
*._optimizer_mode_force=TRUE
*._optimizer_multi_level_push_pred=TRUE
*._optimizer_native_full_outer_join='FORCE'
*._optimizer_new_join_card_computation=TRUE
*._optimizer_null_aware_antijoin=TRUE
*._optimizer_or_expansion='DEPTH'
*._optimizer_order_by_elimination_enabled=TRUE
*._optimizer_outer_to_anti_enabled=TRUE
*._optimizer_push_down_distinct=0
*._optimizer_push_pred_cost_based=TRUE
*._optimizer_rownum_bind_default=10
*._optimizer_rownum_pred_based_fkr=TRUE
*._optimizer_skip_scan_enabled=TRUE
*._optimizer_sortmerge_join_inequality=TRUE
*._optimizer_squ_bottomup=TRUE
*._optimizer_star_tran_in_with_clause=TRUE
*._optimizer_system_stats_usage=TRUE
*._optimizer_table_expansion=TRUE
*._optimizer_transitivity_retain=TRUE
*._optimizer_try_st_before_jppd=TRUE
*._optimizer_undo_cost_change='11.2.0.2'
*._optimizer_unnest_corr_set_subq=TRUE
*._optimizer_unnest_disjunctive_subq=TRUE
*._optimizer_use_cbqt_star_transformation=TRUE
*._optimizer_use_feedback=TRUE
*._or_expand_nvl_predicate=TRUE
*._ordered_nested_loop=TRUE
*._parallel_broadcast_enabled=TRUE
*._partition_view_enabled=TRUE
*._pivot_implementation_method='CHOOSE'
*._pre_rewrite_push_pred=TRUE
*._pred_move_around=TRUE
*._push_join_predicate=TRUE
*._push_join_union_view=TRUE
*._push_join_union_view2=TRUE
*._px_minus_intersect=TRUE
*._px_partition_scan_enabled=TRUE
*._px_pwg_enabled=TRUE
*._px_ual_serial_input=TRUE
*._query_rewrite_setopgrw_enable=TRUE
*._remove_aggr_subquery=TRUE
*._replace_virtual_columns=TRUE
*._right_outer_hash_enable=TRUE
*._selfjoin_mv_duplicates=TRUE
*._sql_model_unfold_forloops='RUN_TIME'
*._subquery_pruning_enabled=TRUE
*._subquery_pruning_mv_enabled=FALSE
*._table_scan_cost_plus_one=TRUE
*._union_rewrite_for_gs='YES_GSET_MVS'
*._unnest_subquery=TRUE
*._use_column_stats_for_function=TRUE
*.audit_file_dest='/appl/oracle/admin/db1stan/adump'
*.audit_trail='DB'
*.background_dump_dest='/appl/oracle/diag/rdbms/db1prd/db1stan1/trace'#Deprecate parameter
*.cluster_database=TRUE
*.compatible='11.2.0.0.0'
*.control_files='+DATA/db1stan/controlfile/current.1411.794571783','+FLASH/db1stan/controlfile/current.2054.794571783'#Set by RMAN
*.core_dump_dest='/appl/oracle/diag/rdbms/db1prd/db1stan1/cdump'
*.db_block_checksum='FULL'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_create_online_log_dest_1='+DATA'
*.db_create_online_log_dest_2='+FLASH'
*.db_domain=''
*.db_file_name_convert='+DATA/db1prd','+DATA/db1stan','+FLASH/db1prd','+FLASH/db1stan'
*.db_lost_write_protect='FULL'
*.db_name='db1prd'
*.db_recovery_file_dest='+FLASH'
*.db_recovery_file_dest_size=500000M
*.db_unique_name='db1stan'
*.dg_broker_config_file1='+DATA/dr1db1prd.dat'
*.dg_broker_config_file2='+DATA/dr2db1prd.dat'
*.dg_broker_start=TRUE
*.diagnostic_dest='/appl/oracle'
*.fal_server='db1prd'
db1stan2.instance_number=2
db1stan1.instance_number=1
db1stan1.local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.124)(PORT=1521))))'
db1stan2.local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.123)(PORT=1521))))'
*.log_archive_config='DG_CONFIG=(db1prd,db1stan,drdb1prd)'
*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=db1stan'
*.log_archive_dest_2='service=db1prd valid_for=(online_logfiles,primary_role) db_unique_name=db1prd'
*.log_archive_dest_3='service=drdb1prd valid_for=(STANDBY_LOGFILES,STANDBY_ROLE) DB_UNIQUE_NAME=drdb1prd'
*.log_archive_dest_4='LOCATION=/archivelogs4/db1stan VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=db1stan'
*.log_archive_dest_state_3='DEFER'
*.log_archive_dest_state_4='ENABLE'
*.log_archive_format='%t_%s_%r.arc'
*.log_buffer=37224448# log buffer update
*.log_file_name_convert='/db1prd/','/db1stan/'
*.open_cursors=300
*.optimizer_dynamic_sampling=2
*.optimizer_mode='ALL_ROWS'
*.pga_aggregate_target=3076M
*.plsql_warnings='DISABLE:ALL'# PL/SQL warnings at init.ora
*.processes=2000
*.query_rewrite_enabled='TRUE'
*.remote_listener='rac-scan:1521'
*.remote_login_passwordfile='EXCLUSIVE'
*.result_cache_max_size=10496K
db1stan1.service_names='db1prd_ETL,db1stan'
db1stan2.service_names='db1stan,db1prd_app'
*.sessions=3072
*.sga_target=2G
*.skip_unusable_indexes=TRUE
*.standby_file_management='AUTO'
db1stan2.thread=2
db1stan1.thread=1
db1stan1.undo_tablespace='UNDOTBS1'
db1stan2.undo_tablespace='UNDOTBS2'
*.user_dump_dest='/appl/oracle/diag/rdbms/db1prd/db1stan1/trace'#Deprecate parameter