Dataguard

11G RMAN DUPLICATE from ACTIVE Database – Oracle Managed Files OMF

SETUP

First of all, lets go over the brief setup for our dataguard.

node1 is the primary site and node2 is the disaster recovery site.
node1 will be running the production database and its name will be ISTAN.
On the standby site we will have the ISTANDR instance running as the standby database.

We have little scripts to change oracle homes (database home and grid infrastructure home) :

[oracle@node2 ~]$ cat .grid_env
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid
export ORACLE_SID=+ASM
export PATH=$ORACLE_HOME/bin:$PATH
alias oh="cd $ORACLE_HOME"
[oracle@node2 ~]$ cat .db_env
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
export ORACLE_SID=DRISTAN
export PATH=$ORACLE_HOME/bin:$PATH
alias oh="cd $ORACLE_HOME"

We have the similar hosts file on both servers.

[oracle@node2 ~]$ cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.223.201 node1 node1.localhost
192.168.223.202 node2 node2.localhost

ON THE STANDBY

1 – First, set up the listener for the standby. ISTANDR will be added as a static entry on the listener.

[oracle@node2 ~]$ . .grid_env
[oracle@node2 ~]$ cat /u01/app/oracle/product/11.2.0/grid/network/admin/listener.ora
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = DRISTAN)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
      (SID_NAME = DRISTAN)
     )
   )
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = node2)(PORT = 1521))
    )
  )
ADR_BASE_LISTENER = /u01/app/oracle/product/11.2.0/grid

Add the listener as a resource.

[oracle@node2 ~]$ srvctl add listener -l LISTENER -o /u01/app/oracle/product/11.2.0/grid -p 1521
[oracle@node2 ~]$ srvctl start listener
[oracle@node2 ~]$ srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): node2
[oracle@node2 ~]$ srvctl config listener
Name: LISTENER
Home: /u01/app/oracle/product/11.2.0/grid
End points: TCP:1521
[oracle@node2 ~]$ lsnrctl status LISTENER
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 20-JUL-2013 08:14:59
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=node2)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 20-JUL-2013 08:07:55
Uptime 0 days 0 hr. 7 min. 3 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/11.2.0/grid/diag/tnslsnr/node2/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node2)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "DRISTAN" has 1 instance(s).
Instance "DRISTAN", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

2 – Create the pfile and password file for the Standby database. For OMF, we will utilize the db_create*dest* parameters in our pfile.

[oracle@node2 ~]$ . .db_env
[oracle@node2 dbs]$ cat $ORACLE_HOME/dbs/initDRISTAN.ora
db_name=ISTAN
db_unique_name=DRISTAN
control_files='+DATA'
db_create_file_dest='+DATA'
db_create_online_log_dest_1='+DATA'
db_create_online_log_dest_2='+DATA'
db_recovery_file_dest='+DATA'
db_recovery_file_dest_size=1800M
compatible=11.2.0.3.0
sga_target=16G
db_files=1000
[oracle@node2 dbs]$ orapwd file=$ORACLE_HOME/dbs/orapwDRISTAN password=oracle

3 – Startup Standby Database in NOMOUNT mode

[oracle@node2 ~]$ . .db_env
[oracle@node2 ~]$ echo $ORACLE_SID
DRISTAN
[oracle@node2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Sat Jul 20 08:33:24 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> STARTUP NOMOUNT;
ORACLE instance started.
Total System Global Area 238034944 bytes
Fixed Size 2227136 bytes
Variable Size 180356160 bytes
Database Buffers 50331648 bytes
Redo Buffers 5120000 bytes

ON THE PRIMARY

1 – CREATE the Standby Log Files SLR files (N+1 redo log files ) per thread. Since it is a single instance database we will have just one thread. Standby log files should be the same size as the redo log files. Standby log files on the primary site will be need in case of a switchover. Do not multiplex the standby redo logs.

SQL> col member format a60
SQL> set lines 300
SQL> select group#, type, member from v$logfile;
GROUP# TYPE MEMBER
---------- ------- ------- ------------------------------------------------------------ ---
1 ONLINE +DATA/istan/onlinelog/group_1.258.820737741
1 ONLINE +DATA/istan/onlinelog/group_1.259.820737745
2 ONLINE +DATA/istan/onlinelog/group_2.260.820737747
2 ONLINE +DATA/istan/onlinelog/group_2.261.820737751
3 ONLINE +DATA/istan/onlinelog/group_3.262.820737755
3 ONLINE +DATA/istan/onlinelog/group_3.263.820737757
SQL> col value format a20
SQL> select name, value from v$parameter where name like 'db_create_%' and value is not null;
NAME VALUE
-------------------------------------------------------------------------------- --------------------
db_create_file_dest +DATA
db_create_online_log_dest_1 +DATA
db_create_online_log_dest_2 +DATA
SQL> select group#, thread#, bytes/1024/1024 size_in_MB from v$log;
GROUP# THREAD# SIZE_IN_MB
---------- ---------- ----------
1 1 50
2 1 50
3 1 50

We will create 4 stanby log files and their size will be 50MB. We should not multiplex the standby log files. For that reason we will reset the second online create log destination;

SQL> ALTER SYSTEM SET db_create_online_log_dest_2='';
System altered.
SQL> ALTER DATABASE ADD STANDBY LOGFILE SIZE 50M;
Database altered.
SQL> ALTER DATABASE ADD STANDBY LOGFILE SIZE 50M;
Database altered.
SQL> ALTER DATABASE ADD STANDBY LOGFILE SIZE 50M;
Database altered.
SQL> ALTER DATABASE ADD STANDBY LOGFILE SIZE 50M;
Database altered.
SQL> select group#, type, member from v$logfile;
GROUP# TYPE MEMBER
---------- ------- ------- ------------------------------------------------------------ ---
1 ONLINE +DATA/istan/onlinelog/group_1.258.820737741
1 ONLINE +DATA/istan/onlinelog/group_1.259.820737745
2 ONLINE +DATA/istan/onlinelog/group_2.260.820737747
2 ONLINE +DATA/istan/onlinelog/group_2.261.820737751
3 ONLINE +DATA/istan/onlinelog/group_3.262.820737755
3 ONLINE +DATA/istan/onlinelog/group_3.263.820737757
4 STANDBY +DATA/istan/onlinelog/group_4.274.82126481
5 STANDBY +DATA/istan/onlinelog/group_5.273.82126484
6 STANDBY +DATA/istan/onlinelog/group_6.275.82126485
7 STANDBY +DATA/istan/onlinelog/group_7.276.82126485
SQL> select group#, thread#, bytes/1024/1024 size_in_MB from v$log;
GROUP# THREAD# SIZE_IN_MB
---------- ---------- ----------
1 1 50
2 1 50
3 1 50
SQL> select group#, thread#, bytes/1024/1024 size_in_MB from v$standby_log;
GROUP# THREAD# SIZE_IN_MB
---------- ---------- ----------
4 0 50
5 0 50
6 0 50
7 0 50

Revert the online create log destination back to original;

SQL> ALTER SYSTEM SET db_create_online_log_dest_2='+DATA';
System altered.

2 – Add Tns Entry for the standby & primary oracle database homes. Check sqlplus connectivity before proceed. (do not forget to disable the firewall.)

[oracle@node2 ~]$ cat /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
ISTAN =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.223.201)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ISTAN)
    )
  )

DRISTAN =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.223.202)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DRISTAN)
    )
  )

3-Now it is time to create standby using RMAN

[oracle@node1 ~]$ rman target sys/oracle@istan auxiliary sys/oracle@dristan
Recovery Manager: Release 11.2.0.3.0 - Production on Sun Jul 21 06:35:35 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ISTAN (DBID=1035650504)
connected to auxiliary database: ISTAN (not mounted)
RMAN> run {
allocate channel prmy1 type disk;
allocate channel prmy2 type disk;
allocate channel prmy3 type disk;
allocate channel prmy4 type disk;
allocate channel prmy5 type disk;
allocate channel prmy6 type disk;
allocate channel prmy7 type disk;
allocate auxiliary channel stby1 type disk;
allocate auxiliary channel stby2 type disk;
allocate auxiliary channel stby3 type disk;
allocate auxiliary channel stby4 type disk;
allocate auxiliary channel stby5 type disk;
allocate auxiliary channel stby6 type disk;
allocate auxiliary channel stby7 type disk;
duplicate target database for standby from active database nofilenamecheck;
}
using target database control file instead of recovery catalog
allocated channel: pri_channel1
channel pri_channel1: SID=52 device type=DISK
allocated channel: pri_channel2
channel pri_channel2: SID=53 device type=DISK
allocated channel: pri_channel3
channel pri_channel3: SID=54 device type=DISK
allocated channel: pri_channel4
channel pri_channel4: SID=51 device type=DISK
allocated channel: pri_channel5
channel pri_channel5: SID=46 device type=DISK
allocated channel: stby1
channel stby1: SID=25 device type=DISK
Starting Duplicate Db at 21-JUL-13
contents of Memory Script:
{
backup as copy reuse
targetfile '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwISTAN' auxiliary format
'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwDRISTAN' ;
}
executing Memory Script
Starting backup at 21-JUL-13
Finished backup at 21-JUL-13
contents of Memory Script:
{
sql clone "alter system set control_files =
''+DATA/dristan/controlfile/current.256.821340245'' comment=
''Set by RMAN'' scope=spfile";
backup as copy current controlfile for standby auxiliary format '+DATA/dristan/controlfile/current.256.821340245';
sql clone "alter system set control_files =
''+DATA/dristan/controlfile/current.256.821340245'' comment=
''Set by RMAN'' scope=spfile";
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
sql statement: alter system set control_files = ''+DATA/dristan/controlfile/current.256.821340245'' comment= ''Set by RMAN'' scope=spfile
Starting backup at 21-JUL-13
channel pri_channel1: starting datafile copy
copying standby control file
output file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_ISTAN.f tag=TAG20130721T063737 RECID=2 STAMP=821342258
channel pri_channel1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 21-JUL-13
sql statement: alter system set control_files = ''+DATA/dristan/controlfile/current.256.821340245'' comment= ''Set by RMAN'' scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 238034944 bytes
Fixed Size 2227136 bytes
Variable Size 180356160 bytes
Database Buffers 50331648 bytes
Redo Buffers 5120000 bytes
allocated channel: stby1
channel stby1: SID=23 device type=DISK
contents of Memory Script:
{
sql clone 'alter database mount standby database';
}
executing Memory Script
sql statement: alter database mount standby database
contents of Memory Script:
{
set newname for clone tempfile 1 to new;
switch clone tempfile all;
set newname for clone datafile 1 to new;
set newname for clone datafile 2 to new;
set newname for clone datafile 3 to new;
set newname for clone datafile 4 to new;
backup as copy reuse
datafile 1 auxiliary format new
datafile 2 auxiliary format new
datafile 3 auxiliary format new
datafile 4 auxiliary format new
;
sql 'alter system archive log current';
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to +DATA in control file
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting backup at 21-JUL-13
channel pri_channel1: starting datafile copy
input datafile file number=00001 name=+DATA/istan/datafile/system.264.820737761
channel pri_channel2: starting datafile copy
input datafile file number=00003 name=+DATA/istan/datafile/undotbs1.266.820737841
channel pri_channel3: starting datafile copy
input datafile file number=00002 name=+DATA/istan/datafile/sysaux.265.820737805
channel pri_channel4: starting datafile copy
input datafile file number=00004 name=+DATA/istan/datafile/users.268.820737863
output file name=+DATA/dristan/datafile/users.278.821342273 tag=TAG20130721T063751
channel pri_channel4: datafile copy complete, elapsed time: 00:00:07
output file name=+DATA/dristan/datafile/system.275.821342273 tag=TAG20130721T063751
channel pri_channel1: datafile copy complete, elapsed time: 00:02:05
output file name=+DATA/dristan/datafile/undotbs1.277.821342273 tag=TAG20130721T063751
channel pri_channel2: datafile copy complete, elapsed time: 00:02:05
output file name=+DATA/dristan/datafile/sysaux.276.821342273 tag=TAG20130721T063751
channel pri_channel3: datafile copy complete, elapsed time: 00:02:05
Finished backup at 21-JUL-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=2 STAMP=821342397 file name=+DATA/dristan/datafile/system.275.821342273
datafile 2 switched to datafile copy
input datafile copy RECID=3 STAMP=821342397 file name=+DATA/dristan/datafile/sysaux.276.821342273
datafile 3 switched to datafile copy
input datafile copy RECID=4 STAMP=821342397 file name=+DATA/dristan/datafile/undotbs1.277.821342273
datafile 4 switched to datafile copy
input datafile copy RECID=5 STAMP=821342397 file name=+DATA/dristan/datafile/users.278.821342273
Finished Duplicate Db at 21-JUL-13
released channel: pri_channel1
released channel: pri_channel2
released channel: pri_channel3
released channel: pri_channel4
released channel: pri_channel5
released channel: stby1

4 – Where are the datafiles files for standby instance created ?

DATAFILES

SQL> select name from v$datafile;
NAME
-----------------------------------------------
+DATA/dristan/datafile/system.275.821342273
+DATA/dristan/datafile/sysaux.276.821342273
+DATA/dristan/datafile/undotbs1.277.821342273
+DATA/dristan/datafile/users.278.821342273

CONTROLFILE

SQL> select name from v$controlfile;
NAME
-----------------------------------------------
+DATA/dristan/controlfile/current.256.821340245

LOG FILES

SQL> set lines 300
SQL> set pages 300
SQL> select group#, thread#, bytes/1024/1024 size_in_MB from v$log;
GROUP# THREAD# SIZE_IN_MB
---------- ---------- ----------
1 1 50
3 1 50
2 1 50
SQL> select group#, thread#, bytes/1024/1024 size_in_MB from v$standby_log;
GROUP# THREAD# SIZE_IN_MB
---------- ---------- ----------
4 0 50
5 0 50
6 0 50
7 0 50
SQL> select type, member from v$logfile
TYPE MEMBER
------- --------------------------------------------------
ONLINE +DATA/dristan/onlinelog/group_1.279.821342397
ONLINE +DATA/dristan/onlinelog/group_1.280.821342399
ONLINE +DATA/dristan/onlinelog/group_2.281.821342401
ONLINE +DATA/dristan/onlinelog/group_2.282.821342403
ONLINE +DATA/dristan/onlinelog/group_3.283.821342405
ONLINE +DATA/dristan/onlinelog/group_3.284.821342407
STANDBY +DATA/dristan/onlinelog/group_4.285.821342407
STANDBY +DATA/dristan/onlinelog/group_5.287.821342411
STANDBY +DATA/dristan/onlinelog/group_6.289.821342415
STANDBY +DATA/dristan/onlinelog/group_7.291.821342417
STANDBY +DATA/dristan/onlinelog/group_4.286.821342409
STANDBY +DATA/dristan/onlinelog/group_5.288.821342413
STANDBY +DATA/dristan/onlinelog/group_6.290.821342415
STANDBY +DATA/dristan/onlinelog/group_7.292.821342419

Standby log files are multiplexed. Our standby log files are multiplexed as well. We need to drop one member from each standby log group.

SQL> alter database drop standby logfile member '+DATA/dristan/onlinelog/group_4.285.821342407';
Database altered.
SQL> alter database drop standby logfile member '+DATA/dristan/onlinelog/group_5.287.821342411';
Database altered.
SQL> alter database drop standby logfile member '+DATA/dristan/onlinelog/group_6.289.821342415';
Database altered.
SQL> alter database drop standby logfile member '+DATA/dristan/onlinelog/group_7.291.821342417';
Database altered.
SQL> select type, member from v$logfile ;
TYPE MEMBER
------- --------------------------------------------------
ONLINE +DATA/dristan/onlinelog/group_1.279.821342397
ONLINE +DATA/dristan/onlinelog/group_1.280.821342399
ONLINE +DATA/dristan/onlinelog/group_2.281.821342401
ONLINE +DATA/dristan/onlinelog/group_2.282.821342403
ONLINE +DATA/dristan/onlinelog/group_3.283.821342405
ONLINE +DATA/dristan/onlinelog/group_3.284.821342407
STANDBY +DATA/dristan/onlinelog/group_4.286.821342409
STANDBY +DATA/dristan/onlinelog/group_5.288.821342413
STANDBY +DATA/dristan/onlinelog/group_6.290.821342415
STANDBY +DATA/dristan/onlinelog/group_7.292.821342419

4 – SET up the log shipping and other parameters.

STANDBY parameters

SQL> ALTER SYSTEM SET FAL_SERVER=ISTAN;
System altered.
SQL> ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(ISTAN,DRISTAN)';
System altered.
SQL> ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO;
System altered.
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='service=ISTAN ASYNC DB_UNIQUE_NAME=ISTAN VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) ';
System altered.
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE;
System altered.

PRIMARY parameters

SQL> ALTER SYSTEM SET FAL_SERVER=DRISTAN;
System altered.
SQL> ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO;
System altered.
SQL> ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(ISTAN,DRISTAN)';
System altered.
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='service=DRISTAN ASYNC DB_UNIQUE_NAME=DRISTAN VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) ';
System altered.
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE;
System altered.

5 – Start the apply process

Standby :

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT PARALLEL 4;

alert log (standby) :

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT PARALLEL 4
Attempt to start background Managed Standby Recovery process (DRISTAN)
Sun Jul 21 07:30:58 2013
MRP0 started with pid=31, OS id=9112
MRP0: Background Managed Standby Recovery process started (DRISTAN)
started logmerger process
Sun Jul 21 07:31:03 2013
Managed Standby Recovery starting Real Time Apply
Parallel Media Recovery started with 4 slaves
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Media Recovery Log +DATA/dristan/archivelog/2013_07_21/thread_1_seq_61.287.821345449
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT PARALLEL 4
Media Recovery Log +DATA/dristan/archivelog/2013_07_21/thread_1_seq_62.289.821345449
Media Recovery Log +DATA/dristan/archivelog/2013_07_21/thread_1_seq_63.291.821345427
Media Recovery Waiting for thread 1 sequence 64

Primary :

SQL> ALTER SYSTEM SWITCH LOGFILE;

alert log (standby) :

Sun Jul 21 07:32:14 2013
Primary database is in MAXIMUM PERFORMANCE mode
RFS[3]: Assigned to RFS process 9135
RFS[3]: Selected log 4 for thread 1 sequence 65 dbid 1035650504 branch 820737736
Sun Jul 21 07:32:14 2013
RFS[4]: Assigned to RFS process 9137
RFS[4]: Selected log 5 for thread 1 sequence 64 dbid 1035650504 branch 820737736
Sun Jul 21 07:32:15 2013
Recovery of Online Redo Log: Thread 1 Group 5 Seq 64 Reading mem 0
Mem# 0: +DATA/dristan/onlinelog/group_5.288.821342413
Sun Jul 21 07:32:15 2013
Archived Log entry 4 added for thread 1 sequence 64 ID 0x3dbadec8 dest 1:
Media Recovery Waiting for thread 1 sequence 65 (in transit)
Recovery of Online Redo Log: Thread 1 Group 4 Seq 65 Reading mem 0
Mem# 0: +DATA/dristan/onlinelog/group_4.286.821342409
Sun Jul 21 07:32:15 2013
Primary database is in MAXIMUM PERFORMANCE mode
Re-archiving standby log 4 thread 1 sequence 65
Archived Log entry 5 added for thread 1 sequence 65 ID 0x3dbadec8 dest 1:
RFS[5]: Assigned to RFS process 9139
RFS[5]: Selected log 4 for thread 1 sequence 66 dbid 1035650504 branch 820737736
Media Recovery Waiting for thread 1 sequence 66 (in transit)
Recovery of Online Redo Log: Thread 1 Group 4 Seq 66 Reading mem 0
Mem# 0: +DATA/dristan/onlinelog/group_4.286.821342409
Sun Jul 21 07:32:18 2013
Primary database is in MAXIMUM PERFORMANCE mode
Re-archiving standby log 4 thread 1 sequence 66
RFS[6]: Assigned to RFS process 9147
RFS[6]: Selected log 5 for thread 1 sequence 67 dbid 1035650504 branch 820737736
Sun Jul 21 07:32:18 2013
Archived Log entry 6 added for thread 1 sequence 66 ID 0x3dbadec8 dest 1:
Media Recovery Waiting for thread 1 sequence 67 (in transit)
Recovery of Online Redo Log: Thread 1 Group 5 Seq 67 Reading mem 0
Mem# 0: +DATA/dristan/onlinelog/group_5.288.821342413
Sun Jul 21 07:32:20 2013
Primary database is in MAXIMUM PERFORMANCE mode
Re-archiving standby log 5 thread 1 sequence 67
Media Recovery Waiting for thread 1 sequence 68
RFS[7]: Assigned to RFS process 9149
RFS[7]: Selected log 4 for thread 1 sequence 68 dbid 1035650504 branch 820737736
Sun Jul 21 07:32:21 2013
Primary database is in MAXIMUM PERFORMANCE mode
Re-archiving standby log 4 thread 1 sequence 68
RFS[8]: Assigned to RFS process 9151
RFS[8]: Selected log 6 for thread 1 sequence 69 dbid 1035650504 branch 820737736
Archived Log entry 7 added for thread 1 sequence 68 ID 0x3dbadec8 dest 1:
Archived Log entry 8 added for thread 1 sequence 67 ID 0x3dbadec8 dest 1:
Media Recovery Log +DATA/dristan/archivelog/2013_07_21/thread_1_seq_68.296.821345541
Media Recovery Waiting for thread 1 sequence 69 (in transit)
Recovery of Online Redo Log: Thread 1 Group 6 Seq 69 Reading mem 0
Mem# 0: +DATA/dristan/onlinelog/group_6.290.821342415
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s