Subhendra's blog: May 2012

Wednesday, May 23, 2012

Recreating RAC 2node after failover to single instance standby

Doing the failover from RAC to single instance

Take a backup from singleinstance primary for recreation of failed RAC primary again

$ ps -fe|grep pmon

grid 4063456 1 0 Apr 25 - 2:39 asm_pmon_+ASM

oracle 5505028 1 0 May 18 - 0:38 ora_pmon_CBELIVESBY

oracle 12845220 1 0 20:01:18 - 0:06 ora_pmon_TRAINSBY

oracle 18022502 18415664 0 10:24:58 pts/0 0:00 grep pmon

$ export ORACLE_SID=TRAINSBY

$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue May 22 10:25:40 2012

Connected to:

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

With the Partitioning, Automatic Storage Management, OLAP, Data Mining

and Real Application Testing options

SQL> select name,open_mode,database_role from v$database;

NAME OPEN_MODE DATABASE_ROLE

--------- -------------------- ----------------

TRAIN READ WRITE PRIMARY

SQL> exit

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

With the Partitioning, Automatic Storage Management, OLAP, Data Mining

and Real Application Testing options

$ id

uid=1101(oracle) gid=1000(oinstall) groups=1200(dba),1300(asmdba)

$ echo $ORACLE_SID

TRAINSBY

$ rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Tue May 22 10:36:55 2012

connected to target database: TRAIN (DBID=1173390908)

RMAN>

RMAN> report schema

2> ;

using target database control file instead of recovery catalog

Report of database schema for database with db_unique_name TRAINSBY

List of Permanent Datafiles

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

File Size(MB) Tablespace RB segs Datafile Name

---- -------- -------------------- ------- ------------------------

1 950 SYSTEM *** +DATA/trainsby/datafile/system.318.783876789

2 1020 SYSAUX *** +DATA/trainsby/datafile/sysaux.319.783876647

3 3050 UNDOTBS1 *** +DATA/trainsby/datafile/undotbs1.268.783876647

4 5 USERS *** +DATA/trainsby/datafile/users.317.783876789

5 3325 UNDOTBS2 *** +DATA/trainsby/datafile/undotbs2.310.783876647

6 18692 T24DISTDATA *** +DATA/trainsby/datafile/t24distdata.292.783876643

7 5596 T24DISTINDEX *** +DATA/trainsby/datafile/t24distindex.346.783876645

8 14596 T24DISTDATA *** +DATA/trainsby/datafile/t24distdata.349.783876645

9 4096 T24DISTDATA *** +DATA/trainsby/datafile/t24distdata.309.783876647

10 4096 T24DISTDATA *** +DATA/trainsby/datafile/t24distdata.320.783876647

List of Temporary Files

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

File Size(MB) Tablespace Maxsize(MB) Tempfile Name

---- -------- -------------------- ----------- --------------------

1 601 TEMP 32767 +DATA/trainsby/tempfile/temp.278.783884917

RMAN> run

2> {sql "alter system switch logfile";

3> allocate channel ch1 type disk format '/u02/backup/rman/Primary_bkp_for_stndby_%U';

4> backup database;

5> backup current controlfile for standby;

6> sql "alter system archive log current";

7> }

sql statement: alter system switch logfile

allocated channel: ch1

channel ch1: SID=1325 device type=DISK

Starting backup at 22-MAY-12

channel ch1: starting compressed full datafile backup set

channel ch1: specifying datafile(s) in backup set

input datafile file number=00006 name=+DATA/trainsby/datafile/t24distdata.292.783876643

input datafile file number=00008 name=+DATA/trainsby/datafile/t24distdata.349.783876645

input datafile file number=00007 name=+DATA/trainsby/datafile/t24distindex.346.783876645

input datafile file number=00009 name=+DATA/trainsby/datafile/t24distdata.309.783876647

input datafile file number=00010 name=+DATA/trainsby/datafile/t24distdata.320.783876647

input datafile file number=00005 name=+DATA/trainsby/datafile/undotbs2.310.783876647

input datafile file number=00003 name=+DATA/trainsby/datafile/undotbs1.268.783876647

input datafile file number=00002 name=+DATA/trainsby/datafile/sysaux.319.783876647

input datafile file number=00001 name=+DATA/trainsby/datafile/system.318.783876789

input datafile file number=00004 name=+DATA/trainsby/datafile/users.317.783876789

channel ch1: starting piece 1 at 22-MAY-12

channel ch1: finished piece 1 at 22-MAY-12

piece handle=/u02/backup/rman/Primary_bkp_for_stndby_0fnbk3up_1_1 tag=TAG20120522T104128 comment=NONE

channel ch1: backup set complete, elapsed time: 00:01:15

channel ch1: starting compressed full datafile backup set

channel ch1: specifying datafile(s) in backup set

including current control file in backup set

including current SPFILE in backup set

channel ch1: starting piece 1 at 22-MAY-12

channel ch1: finished piece 1 at 22-MAY-12

piece handle=/u02/backup/rman/Primary_bkp_for_stndby_0gnbk414_1_1 tag=TAG20120522T104128 comment=NONE

channel ch1: backup set complete, elapsed time: 00:00:01

Finished backup at 22-MAY-12

Starting backup at 22-MAY-12

channel ch1: starting compressed full datafile backup set

channel ch1: specifying datafile(s) in backup set

including standby control file in backup set

channel ch1: starting piece 1 at 22-MAY-12

channel ch1: finished piece 1 at 22-MAY-12

piece handle=/u02/backup/rman/Primary_bkp_for_stndby_0hnbk417_1_1 tag=TAG20120522T104247 comment=NONE

channel ch1: backup set complete, elapsed time: 00:00:01

Finished backup at 22-MAY-12

sql statement: alter system archive log current

released channel: ch1

RMAN> exit

Recovery Manager complete.

$ pwd

/u02/backup/rman

$ ls -ltr

total 774880

-rw-r----- 1 oracle asmadmin 394477568 May 22 10:42 Primary_bkp_for_stndby_0fnbk3up_1_1

-rw-r----- 1 oracle asmadmin 1130496 May 22 10:42 Primary_bkp_for_stndby_0gnbk414_1_1

-rw-r----- 1 oracle asmadmin 1130496 May 22 10:42 Primary_bkp_for_stndby_0hnbk417_1_1

$ scp Primary_bkp_for_stndby* oracle@10.1.8.15:/u02/backup/rman/

oracle@10.1.8.15's password:

Primary_bkp_for_stndby_0fnbk3up_1_1 100% 376MB 28.9MB/s 00:13

Primary_bkp_for_stndby_0gnbk414_1_1 100% 1104KB 1.1MB/s 00:00

Primary_bkp_for_stndby_0hnbk417_1_1 100% 1104KB 1.1MB/s 00:00

$ ps -fe|grep pmon

grid 4063456 1 0 Apr 25 - 2:40 asm_pmon_+ASM

oracle 5505028 1 0 May 18 - 0:39 ora_pmon_CBELIVESBY

oracle 12845220 1 0 20:01:18 - 0:06 ora_pmon_TRAINSBY

Recreation of RAC done as below.

$ ps -fe|grep pmon

grid 7208962 1 0 May 07 - 1:45 asm_pmon_+ASM1

oracle 9830492 43974732 0 10:43:59 pts/1 0:00 grep pmon

oracle 24707132 1 0 May 20 - 0:26 ora_pmon_LIVECBE1

oracle 29032610 1 0 May 13 - 2:29 ora_pmon_CBELIVE1

oracle 32768210 1 1 23:48:48 - 0:05 ora_pmon_UAT1

oracle 37748968 1 0 May 20 - 0:15 ora_pmon_femobile1

oracle 41091102 1 0 10:33:27 - 0:00 ora_pmon_TRAIN1

$ export ORACLE_SID=TRAIN1

$ pwd

/home/oracle

$ cd /tmp

$ ls -ltr|grep init

-rw-r--r-- 1 oracle asmadmin 2000 May 22 10:37 initTRAIN2205.ora

$ vi initTRAIN2205.ora

$ echo $ORACLE_HOME

/u01/app/oracle/product/11.2.0/db1

$ echo $ORACLE_SID

TRAIN1

$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue May 22 10:53:54 2012

Connected to an idle instance.

THE INSTANCE NAME IS TRAIN1

SQL>

SQL> startup nomount pfile='/tmp/initTRAIN2205.ora';

ORACLE instance started.

Total System Global Area 1.1458E+10 bytes

Fixed Size 2217120 bytes

Variable Size 9831451488 bytes

Database Buffers 1610612736 bytes

Redo Buffers 13496320 bytes

SQL> create spfile='+DATA/train/spfiletrain.ora' from pfile='/tmp/initTRAIN2205.ora';

File created.

SQL> shut immediate

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> startup nomount

ORACLE instance started.

Total System Global Area 1.1458E+10 bytes

Fixed Size 2217120 bytes

Variable Size 9831451488 bytes

Database Buffers 1610612736 bytes

Redo Buffers 13496320 bytes

SQL> exit

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

With the Partitioning, Real Application Clusters, OLAP, Data Mining

and Real Application Testing options

$ echo $ORACLE_SID

TRAIN1

$ id

uid=1101(oracle) gid=1000(oinstall) groups=1200(dba),1300(asmdba)

$ echo $ORACLE_SID

TRAIN1

$ rman target sys/oracle@TRAINSBY auxiliary /

Recovery Manager: Release 11.2.0.1.0 - Production on Tue May 22 10:59:07 2012

connected to target database: TRAIN (DBID=1173390908)

connected to auxiliary database: TRAIN (not mounted)

RMAN> duplicate target database for standby nofilenamecheck;

Starting Duplicate Db at 05/22/12 10:59:44

using target database control file instead of recovery catalog

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=3770 instance=TRAIN1 device type=DISK

contents of Memory Script:

{

sql clone "alter system set control_files =

''+DATA/train/controlfile/current.482.783946787'', ''+ARCHIVE/train/controlfile/current.5329.783946789'' comment=

''Set by RMAN'' scope=spfile";

restore clone standby controlfile;

}

executing Memory Script

sql statement: alter system set control_files = ''+DATA/train/controlfile/current.482.783946787'', ''+ARCHIVE/train/controlfile/current.5329.783946789'' comment= ''Set by RMAN'' scope=spfile

Starting restore at 05/22/12 10:59:48

using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: restoring control file

channel ORA_AUX_DISK_1: reading from backup piece /u02/backup/rman/Primary_bkp_for_stndby_0hnbk417_1_1

channel ORA_AUX_DISK_1: piece handle=/u02/backup/rman/Primary_bkp_for_stndby_0hnbk417_1_1 tag=TAG20120522T104247

channel ORA_AUX_DISK_1: restored backup piece 1

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01

output file name=+DATA/train/controlfile/current.481.783946789

output file name=+ARCHIVE/train/controlfile/current.5318.783946789

Finished restore at 05/22/12 10:59:49

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";

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";

restore

clone database

;

}

executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to +data in control file

executing command: SET NEWNAME

Starting restore at 05/22/12 10:59:58

using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore

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

channel ORA_AUX_DISK_1: restoring datafile 00001 to +data

channel ORA_AUX_DISK_1: restoring datafile 00002 to +data

channel ORA_AUX_DISK_1: restoring datafile 00003 to +data

channel ORA_AUX_DISK_1: restoring datafile 00004 to +data

channel ORA_AUX_DISK_1: restoring datafile 00005 to +data

channel ORA_AUX_DISK_1: restoring datafile 00006 to +data

channel ORA_AUX_DISK_1: restoring datafile 00007 to +data

channel ORA_AUX_DISK_1: restoring datafile 00008 to +data

channel ORA_AUX_DISK_1: restoring datafile 00009 to +data

channel ORA_AUX_DISK_1: restoring datafile 00010 to +data

channel ORA_AUX_DISK_1: reading from backup piece /u02/backup/rman/Primary_bkp_for_stndby_0fnbk3up_1_1

channel ORA_AUX_DISK_1: piece handle=/u02/backup/rman/Primary_bkp_for_stndby_0fnbk3up_1_1 tag=TAG20120522T104128

channel ORA_AUX_DISK_1: restored backup piece 1

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:06:15

Finished restore at 05/22/12 11:06:14

contents of Memory Script:

{

switch clone datafile all;

}

executing Memory Script

datafile 1 switched to datafile copy

input datafile copy RECID=31 STAMP=783947174 file name=+DATA/train/datafile/system.476.783947057

datafile 2 switched to datafile copy

input datafile copy RECID=32 STAMP=783947174 file name=+DATA/train/datafile/sysaux.448.783946917

datafile 3 switched to datafile copy

input datafile copy RECID=33 STAMP=783947174 file name=+DATA/train/datafile/undotbs1.447.783946909

datafile 4 switched to datafile copy

input datafile copy RECID=34 STAMP=783947174 file name=+DATA/train/datafile/users.475.783947059

datafile 5 switched to datafile copy

input datafile copy RECID=35 STAMP=783947174 file name=+DATA/train/datafile/undotbs2.466.783946901

datafile 6 switched to datafile copy

input datafile copy RECID=36 STAMP=783947174 file name=+DATA/train/datafile/t24distdata.480.783946799

datafile 7 switched to datafile copy

input datafile copy RECID=37 STAMP=783947174 file name=+DATA/train/datafile/t24distindex.346.783946873

datafile 8 switched to datafile copy

input datafile copy RECID=38 STAMP=783947174 file name=+DATA/train/datafile/t24distdata.479.783946841

datafile 9 switched to datafile copy

input datafile copy RECID=39 STAMP=783947174 file name=+DATA/train/datafile/t24distdata.483.783946885

datafile 10 switched to datafile copy

input datafile copy RECID=40 STAMP=783947174 file name=+DATA/train/datafile/t24distdata.295.783946893

Finished Duplicate Db at 05/22/12 11:08:16

RMAN> exit

Recovery Manager complete.

$ ps -fe|grep pmon

grid 7208962 1 0 May 07 - 1:45 asm_pmon_+ASM1

oracle 21364882 43974732 0 11:08:25 pts/1 0:00 grep pmon

oracle 24707132 1 0 May 20 - 0:26 ora_pmon_LIVECBE1

oracle 29032610 1 0 May 13 - 2:29 ora_pmon_CBELIVE1

oracle 32768210 1 0 23:48:48 - 0:05 ora_pmon_UAT1

oracle 34996306 1 0 10:55:17 - 0:00 ora_pmon_TRAIN1

oracle 37748968 1 0 May 20 - 0:15 ora_pmon_femobile1

$ echo $ORACLE_SID

TRAIN1

$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue May 22 11:08:43 2012

Connected to:

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

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

THE INSTANCE NAME IS TRAIN1

SQL>

SQL> select name,open_mode,database_role from v$database;

NAME OPEN_MODE DATABASE_ROLE

--------- -------------------- ----------------

TRAIN MOUNTED PHYSICAL STANDBY

SQL> alter database recover managed standby database disconnect from session;

Database altered.

SQL> select NAME,PROTECTION_MODE,PROTECTION_LEVEL from v$database;

NAME PROTECTION_MODE PROTECTION_LEVEL

--------- -------------------- --------------------

TRAIN MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE

SQL> alter database set standby database to maximize availability;

Database altered.

SQL> select NAME,PROTECTION_MODE,PROTECTION_LEVEL from v$database;

NAME PROTECTION_MODE PROTECTION_LEVEL

--------- -------------------- --------------------

TRAIN MAXIMUM AVAILABILITY MAXIMUM AVAILABILITY

SQL> select name,open_mode,database_role from v$database;

NAME OPEN_MODE DATABASE_ROLE

--------- -------------------- ----------------

TRAIN MOUNTED PHYSICAL STANDBY

Switchover from single instance Primary to just created RAC single node standby

$ export ORACLE_SID=TRAINSBY

$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue May 22 11:09:46 2012

Connected to:

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

With the Partitioning, Automatic Storage Management, OLAP, Data Mining

and Real Application Testing options

SQL> alter system switch logfile;

SQL> select name,open_mode,database_role from v$database;

NAME OPEN_MODE DATABASE_ROLE

--------- -------------------- ----------------

TRAIN READ WRITE PRIMARY

SQL> select switchover_status from v$database;

SWITCHOVER_STATUS

--------------------

TO STANDBY

SQL> alter database commit to switchover to standby;

Database altered.

SQL> shutdown immediate;

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.

Total System Global Area 1.0689E+10 bytes

Fixed Size 2216200 bytes

Variable Size 3959426808 bytes

Database Buffers 6710886400 bytes

Redo Buffers 16945152 bytes

Database mounted.

SQL> select name,open_mode,database_role from v$database;

NAME OPEN_MODE DATABASE_ROLE

--------- -------------------- ----------------

TRAIN MOUNTED PHYSICAL STANDBY

SQL> select NAME,PROTECTION_MODE,PROTECTION_LEVEL from v$database;

NAME PROTECTION_MODE PROTECTION_LEVEL

--------- -------------------- --------------------

TRAIN MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE

SQL> alter database recover managed standby database disconnect from session;

Database altered.

SQL> alter database set standby database to maximize availability;

Database altered.

SQL>

Switch over from standby to primary

<check switchover status>
SQL> select switchover_status from v$database;

SWITCHOVER_STATUS
--------------------
TO PRIMARY
<switchover to primary>
SQL> alter database commit to switchover to primary;

Database altered.
<shutdown immediate>
SQL> shutdown immediate;
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
<start new primary>
SQL> startup
ORACLE instance started.

Total System Global Area 1.1458E+10 bytes
Fixed Size 2217120 bytes
Variable Size 9831451488 bytes
Database Buffers 1610612736 bytes
Redo Buffers 13496320 bytes
Database mounted.
Database opened.
SQL> alter system switch logfile;

System altered.

Reopening of RAC node2 after switch over

$ ps -fe|grep pmon

grid 7208982 1 0 May 07 - 2:04 asm_pmon_+ASM2

oracle 20578400 21627052 0 11:02:49 pts/0 0:00 grep pmon

oracle 25821194 1 0 May 13 - 2:58 ora_pmon_CBELIVE2

$ export ORACLE_SID=TRAIN2

$ id

uid=1101(oracle) gid=1000(oinstall) groups=1200(dba),1300(asmdba)

$ echo $ORACLE_SID

TRAIN2

$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue May 22 11:23:46 2012

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 1.1458E+10 bytes

Fixed Size 2217120 bytes

Variable Size 8388610912 bytes

Database Buffers 3053453312 bytes

Redo Buffers 13496320 bytes

Database mounted.

Database opened.

SQL> alter system switch logfile;

System altered.

SQL>

SQL> select name,open_mode,database_role from v$database;

NAME OPEN_MODE DATABASE_ROLE

--------- -------------------- ----------------

TRAIN READ WRITE PRIMARY

SQL> exit

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

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

$ ps -fe|grep pmon

grid 7208982 1 0 May 07 - 2:05 asm_pmon_+ASM2

oracle 20119650 1 0 11:23:51 - 0:00 ora_pmon_TRAIN2

oracle 24051730 21627052 0 11:27:35 pts/0 0:00 grep pmon

oracle 25821194 1 0 May 13 - 2:59 ora_pmon_CBELIVE2

Switchover from primary.to standby

Primary Database ( TRAIN )

SQL> select name,open_mode,database_role from v$database;

NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
TRAIN READ WRITE PRIMARY
<testing switchover status>
SQL> select switchover_status from v$database;

SWITCHOVER_STATUS
--------------------
FAILED DESTINATION

SQL> alter system switch logfile;

System altered.

SQL> /
System altered.
<testing switchover status>
SQL> select switchover_status from v$database;

SWITCHOVER_STATUS
--------------------
TO STANDBY

<switchover to standby>
SQL> alter database commit to switchover to standby;

Database altered.
<shutdown immediate>
SQL> shutdown immediate;
ORA-01507: database not mounted

ORACLE instance shut down.
<startup mount>
SQL> startup mount
ORACLE instance started.

Total System Global Area 1.1458E+10 bytes
Fixed Size 2217120 bytes
Variable Size 9831451488 bytes
Database Buffers 1610612736 bytes
Redo Buffers 13496320 bytes
Database mounted.
SQL> select name,open_mode,database_role from v$database;

NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
TRAIN MOUNTED PHYSICAL STANDBY
<start managed recovery again>
SQL> alter database recover managed standby database disconnect from session;

Database altered.

======================================================================
On Standby Database ( TRAINSBY )
======================================================================

SQL> select name,open_mode,database_role from v$database;

NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
TRAIN MOUNTED PHYSICAL STANDBY

<checking switch over status>
SQL> select switchover_status from v$database;

SWITCHOVER_STATUS
--------------------
TO PRIMARY
<switchover to primary>
SQL> alter database commit to switchover to primary;

Database altered.
<shutdown immediate>
SQL> shutdown immediate
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
<startup new primary database>
SQL> startup
ORACLE instance started.

Total System Global Area 1.0689E+10 bytes
Fixed Size 2216200 bytes
Variable Size 3959426808 bytes
Database Buffers 6710886400 bytes
Redo Buffers 16945152 bytes
Database mounted.
Database opened.
SQL> select name,open_mode,database_role from v$database;

NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
TRAIN READ WRITE PRIMARY

SQL> alter system switch logfile;

System altered.

Failover to standby database:Manual method

SCENARIO : We had simulated a crash on the priamry db by shut down database and deleted a control file from ASM location. So as a result next time when i tried to start the DB it refused to come up. So we have decided to failover to standby site.

Failover test
<log in to standby DB as sysdba>
$ export ORACLE_SID=TRAINSBY
$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Mon May 21 19:59:03 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options

SQL> select name,open_mode,database_role from v$database;

NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
TRAIN READ ONLY WITH APPLY PHYSICAL STANDBY
<cancel managed recovery>
SQL> alter database recover managed standby database cancel;

Database altered.
<activate standby database>
SQL> alter database activate standby database;

Database altered.

SQL> select name,open_mode,database_role from v$database;

NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
TRAIN MOUNTED PRIMARY

<shutdown database>
SQL> shu immediate
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
<startup>
SQL> startup
ORACLE instance started.

Total System Global Area 1.0689E+10 bytes
Fixed Size 2216200 bytes
Variable Size 3959426808 bytes
Database Buffers 6710886400 bytes
Redo Buffers 16945152 bytes
Database mounted.
Database opened.
SQL> select name,open_mode,database_role from v$database;

NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
TRAIN READ WRITE PRIMARY

SQL>

Sunday, May 20, 2012

RAC cloning : 2 node to 2 node in the same host

Step1: Create a duplicate stand alone database from the RAC db follow the steps in
Step2: Follow the notes as described in Note ID: [ ID 747457.1 ]

Modify the single instance pfile for the RAC specific parameters

*.cluster_database = TRUE

*.cluster_database_instances = 2 
*.undo_management=AUTO 
prod1.undo_tablespace=UNDOTBS1
prod1.instance_name=prod1
prod1.instance_number=1 
prod1.thread=1 
<prod1.local_listener=listener_ocvmrh2103>

<prod2.local_listener=listener_ocvmrh2190>
prod1.remote_listener=<scan listener>

prod2.remote_listener=<scan listener>
prod2.instance_name=prod2
prod2.instance_number=2 
prod2.thread=2 
prod2.undo_tablespace=UNDOTBS2


create spfile from pfile

export ORACLE_SID=PROD1
sqlplus "/ as sysdba"
create spfile='+DATA/PROD/spfilePROD.ora' from pfile='/tmp/initPROD.ora';
exit


Create the password file for instance1


orapwd file=orapwORCL1 password=oracle





start the database in mount stage


export ORACLE_SID=prod1 <this is most important one instance 1>




 Open your database and run $ORACLE_HOME/rdbms/admin/catclust.sql to create cluster database specific views.
Now can start ur 2nd instance follow the same steps as earlier i.e. export  ORACLE_SID=<instance 2> create a password file for 2nd instance and start the second instance.
Add the newly created RAC database to cluster
srvctl add database -d <database name> -o <ORACLE_HOME path> -p <spfile location and name>
srvctl add instance -d <database name> -i <instance 1 name> -n <node 1 name >
srvctl add instance -d <database name> -i <instance 2 name> -n <node 2 name >

Friday, May 18, 2012

Applying patch through Opatch:SQLPLUS slowness: Bug 9593134: DNS OR NIS MIS-CONFIGURATION CAN CAUSE SLOW DATABASE CONNECTS

Hi,
We have recently hit a bug in our single instance standalone DB(11.2.0.1) on AIX 6.1(64 bits).
Description of problem:
$sqlplus t24/*****@EMR20
<takes mostly 1 or 2 minutes to connect>

Solution:

Download and apply patch 9593134

Bug 9593134: DNS OR NIS MIS-CONFIGURATION CAN CAUSE SLOW DATABASE CONNECTS

Procedure:

1) Download the correct patch from support.oracle.com

2) Transfer the zipped patch file to the server and unzip it there at required directory

$ unzip -d /home/oracle/sqlpatch/ p9593134_112010_AIX64-5L.zip

Archive: p9593134_112010_AIX64-5L.zip

creating: /home/oracle/sqlpatch/9593134/

creating: /home/oracle/sqlpatch/9593134/files/

creating: /home/oracle/sqlpatch/9593134/files/lib/

creating: /home/oracle/sqlpatch/9593134/files/lib/libntcp11.a/

inflating: /home/oracle/sqlpatch/9593134/files/lib/libntcp11.a/ntt.o

creating: /home/oracle/sqlpatch/9593134/etc/

creating: /home/oracle/sqlpatch/9593134/etc/config/

inflating: /home/oracle/sqlpatch/9593134/etc/config/inventory.xml

inflating: /home/oracle/sqlpatch/9593134/etc/config/actions.xml

inflating: /home/oracle/sqlpatch/9593134/etc/config/deploy.xml

creating: /home/oracle/sqlpatch/9593134/etc/xml/

inflating: /home/oracle/sqlpatch/9593134/etc/xml/GenericActions.xml

inflating: /home/oracle/sqlpatch/9593134/etc/xml/ShiphomeDirectoryStructure.xml

inflating: /home/oracle/sqlpatch/9593134/README.txt

$ which unzip
/u01/app/oracle/product/11.2.0/dbhome_1/bin/unzip

$ opatch
ksh: opatch: not found.
$ cd $ORACLE_HOME
$ ls -ltr|grep -i opat
drwxr-xr-x 6 oracle oinstall 4096 May 18 03:05 OPatch
$ pwd
/u01/app/oracle/product/11.2.0/dbhome_1
3) Add the opatch to PATH variable if it is not already done
$ export PATH=$PATH:$ORACLE_HOME/OPatch
$ echo $PATH
/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/oracle/bin:/usr/bin/X11:/sbin:/usr/java6/jre/bin:/usr/java6/bin:/u01/app/oracle/product/11.2.0/dbhome_1/bin:.:/u01/app/oracle/product/11.2.0/dbhome_1/OPatch
$ opatch
Invoking OPatch 11.1.0.6.6

Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation. All rights reserved.
....................
...................

4) Check for opatch lsinventory to check things all good
$ opatch lsinventory
Invoking OPatch 11.1.0.6.6

Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.1.0.6.6
OUI version : 11.2.0.1.0
OUI location : /u01/app/oracle/product/11.2.0/dbhome_1/oui
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2012-05-18_03-11-11AM.log

Patch history file: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt

Lsinventory Output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2012-05-18_03-11-11AM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Database 11g 11.2.0.1.0
There are 1 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

--------------------------------------------------------------------------------

OPatch succeeded.
5) Stop all database services running out of that $ORACLE_HOME (optionally listener service also for my case i had stopped listener service also).

6) Start the opatch apply , you have to be in the unzipped folder "/home/oracle/sqlpatch/9593134" location for that.

$ opatch apply
Invoking OPatch 11.1.0.6.6

Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.1.0.6.6
OUI version : 11.2.0.1.0
OUI location : /u01/app/oracle/product/11.2.0/dbhome_1/oui
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2012-05-18_03-20-24AM.log

Patch history file: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt

ApplySession applying interim patch '9593134' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'

Running prerequisite checks...
Patch 9593134: Optional component(s) missing : [ oracle.network.cman, 11.2.0.1.0 ]

OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/11.2.0/dbhome_1')

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '9593134' for restore. This might take a while...
Backing up files affected by the patch '9593134' for rollback. This might take a while...

Patching component oracle.network.rsf, 11.2.0.1.0...
Updating archive file "/u01/app/oracle/product/11.2.0/dbhome_1/lib/libntcp11.a" with "lib/libntcp11.a/ntt.o"

Patching component oracle.rdbms, 11.2.0.1.0...

Patching component oracle.rdbms.rsf, 11.2.0.1.0...
Running make for target client_sharedlib
Running make for target ioracle

OPatch found the word "error" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
ld: 0711-415 WARNING: Symbol ldxdts is already exported.
ld: 0711-415 WARNING: Symbol ldxsto is already exported.
ld: 0711-415 WARNING: Symbol lnxadd is already exported.
ld: 0711-415 WARNING: Symbol lnxcopy is already exported.
ld: 0711-415 WARNING: Symbol lnxmin is already exported.
ld: 0711-415 WARNING: Symbol lnxmul is already exported.
ld: 0711-415 WARNING: Symbol lnxnur is already exported.
ld: 0711-415 WARNING: Symbol lnxren is already exported.
ld: 0711-415 WARNING: Symbol lnxsca is already exported.
ld: 0711-415 WARNING: Symbol lnxshift is already exported.
ld: 0711-415 WARNING: Symbol lnxsni is already exported.
ld: 0711-415 WARNING: Symbol lxgu2t is already exported.
ld: 0711-415 WARNING: Symbol sldxgd is already exported.
ld: 0711-224 WARNING: Duplicate symbol: .aio_nwait_timeout64
ld: 0711-224 WARNING: Duplicate symbol: aio_nwait_timeout64
ld: 0711-224 WARNING: Duplicate symbol: .aio_nwait64
ld: 0711-224 WARNING: Duplicate symbol: aio_nwait64
ld: 0711-224 WARNING: Duplicate symbol: fc_softc
ld: 0711-224 WARNING: Duplicate symbol: __fe_def_env
ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information.
ld: 0711-319 WARNING: Exported symbol not defined: count__21TxsOqSourceDefinitionFP31TxsOqSourceDefinitionController
ld: 0711-319 WARNING: Exported symbol not defined: cout__3std
ld: 0711-319 WARNING: Exported symbol not defined: create11gMeasure__26TxsOqAWExpressionGeneratorFRC9xswstringPC18TxsOqAWMeasureInfoP25TxsOqSQLGenerationContext
ld: 0711-319 WARNING: Exported symbol not defined: createAWDimensionColumn__27TxsOqSQLBaseSelectStatementFP24TxsOqMdmPrimaryDimensionP24TxsOqSQLBaseSelectColumnP25TxsOqSQLGenerationContext
ld: 0711-319 WARNING: Exported symbol not defined: createAWDimensionColumn__27TxsOqSQLBaseSelectStatementFP27TxsOqMdm10gPrimaryDimensionP24TxsOqSQLBaseSelectColumnP25TxsOqSQLGenerationContext
ld: 0711-319 WARNING: Exported symbol not defined: createAWLevelHierarchyHolder__23TxsOqAWGenerationHelperFPC19TxsOqSourceSnapshotP22TxsOqGenerationContext
ld: 0711-319 WARNING: Exported symbol not defined: createAWLevelHolder__23TxsOqAWGenerationHelperFPC19TxsOqSourceSnapshotP22TxsOqGenerationContext
ld: 0711-319 WARNING: Exported symbol not defined: createAWMeasureInfo__23TxsOqAWGenerationHelperFPC19TxsOqSourceSnapshotP22TxsOqGenerationContext
ld: 0711-319 WARNING: Exported symbol not defined: createAWOffsetHolder__23TxsOqAWGenerationHelperFPC19TxsOqSourceSnapshot20ExsOqMdm10gLevelTypeiP22TxsOqGenerationContext
ld: 0711-319 WARNING: Exported symbol not defined: createAncestorsTableHolder__28TxsOqSQLAncestorsTableHolderFP33TxsOqSQLDimensionExpressionHolderP25TxsOqSQLGenerationContext
ld: 0711-319 WARNING: Exported symbol not defined: createAndMapLevel__25TxsOqLegacyMetadataReaderFPUcN61P24TxsOqMdmPrimaryDimensionP22TxsOqMdmLevelHierarchyPP17TxsOqSynBaseQueryPP25TxsOqMdmHierarchyLevelMapN31UiT15_
...........................
............................

ld: 0711-773 WARNING: Object /u01/app/oracle/product/11.2.0/dbhome_1/lib//libordsdo11.a[mdrt.o], imported symbol kcbstdbz_
Symbol was expected to be local. Extra instructions
are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /u01/app/oracle/product/11.2.0/dbhome_1/lib//libordsdo11.a[mdrcnc.o], imported symbol mdrcnccmt_
Symbol was expected to be local. Extra instructions
are being generated to reference the symbol.
ld: 0711-783 WARNING: TOC overflow. TOC size: 219440 Maximum size: 65536
Extra instructions are being generated for each reference to a TOC
symbol if the symbol is in the TOC overflow area.

--------------------------------------------------------------------------------
OPatch Session completed with warnings.

OPatch completed with warnings.
$

7) Now when checked with my db connection through sqlplus tns connection string it was as faster.

Tuesday, May 15, 2012

Manually creating Standby Database without auxillary database

Note: for details please refer to Doc ID 469493.1

1) Take backup of primary database in my case i have taken a compressed one.

$ rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Fri May 18 20:05:47 2012

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

connected to target database: ORCLLIVE (DBID=XXXXXXXX)

RMAN> report schema
2> ;

using target database control file instead of recovery catalog
Report of database schema for database with db_unique_name ORCLLIVE

List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 950 SYSTEM *** +DATA/ORCLLIVE/datafile/system.493.781
2 1030 SYSAUX *** +DATA/ORCLLIVE/datafile/sysaux.492.781
3 24800 UNDOTBS1 *** +DATA/ORCLLIVE/datafile/undotbs1.495.7
4 5 USERS *** +DATA/ORCLLIVE/datafile/users.494.7813
5 17450 UNDOTBS2 *** +DATA/ORCLLIVE/datafile/undotbs2.500.7
6 32767 T24DISTDATA *** +DATA/ORCLLIVE/datafile/t24distdata.50
7 23096 T24DISTINDEX *** +DATA/ORCLLIVE/datafile/t24distindex.5
8 32767 T24DISTDATA *** +DATA/ORCLLIVE/datafile/t24distdata.50
9 32767 T24DISTDATA *** +DATA/ORCLLIVE/datafile/t24distdata.50
10 4096 SYSAUX *** +DATA/ORCLLIVE/datafile/sysaux.302.781
11 32767 T24DISTDATA *** +DATA/ORCLLIVE/datafile/t24distdata.30
12 1024 SYSTEM *** +DATA/ORCLLIVE/datafile/system.305.781
13 32767 T24DISTDATA *** +DATA/ORCLLIVE/datafile/t24distdata.35
14 32767 T24DISTDATA *** +DATA/ORCLLIVE/datafile/t24distdata.40
15 32704 T24DISTDATA *** +DATA/ORCLLIVE/datafile/t24distdata.39
16 4096 T24DISTDATA *** +DATA/ORCLLIVE/datafile/t24distdata.27

List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 1282 TEMP 32767 +DATA/ORCLLIVE/tempfile/temp.499.7

RMAN> run {
2> allocate channel c1 type disk;
3> allocate channel c2 type disk;
4> allocate channel c3 type disk;
5> backup as compressed backupset database format '/u02/backup/rman/Primary_bkp_standby_%U';
6> backup as compressed backupset archivelog all format '/u02/backup/rman/Primary_bkp_standby_%U.arc';
7> }

allocated channel: c1
channel c1: SID=5970 instance=ORCLLIVE1 device type=DISK

allocated channel: c2
channel c2: SID=7232 instance=ORCLLIVE1 device type=DISK

allocated channel: c3
channel c3: SID=632 instance=ORCLLIVE1 device type=DISK

Starting backup at 05/18/12 20:08:18
channel c1: starting compressed full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00006 name=+DATA/ORCLLIVE/datafile/t24distdata.504.781389949
input datafile file number=00011 name=+DATA/ORCLLIVE/datafile/t24distdata.309.781739411
input datafile file number=00015 name=+DATA/ORCLLIVE/datafile/t24distdata.395.782432771
input datafile file number=00005 name=+DATA/ORCLLIVE/datafile/undotbs2.500.781389443
channel c1: starting piece 1 at 05/18/12 20:08:19
channel c2: starting compressed full datafile backup set
channel c2: specifying datafile(s) in backup set
input datafile file number=00008 name=+DATA/ORCLLIVE/datafile/t24distdata.506.781574987
input datafile file number=00013 name=+DATA/ORCLLIVE/datafile/t24distdata.355.781804141
input datafile file number=00003 name=+DATA/ORCLLIVE/datafile/undotbs1.495.781389155
input datafile file number=00016 name=+DATA/ORCLLIVE/datafile/t24distdata.273.782953715
input datafile file number=00001 name=+DATA/ORCLLIVE/datafile/system.493.781389153
input datafile file number=00004 name=+DATA/ORCLLIVE/datafile/users.494.781389155
channel c2: starting piece 1 at 05/18/12 20:08:19
channel c3: starting compressed full datafile backup set
channel c3: specifying datafile(s) in backup set
input datafile file number=00009 name=+DATA/ORCLLIVE/datafile/t24distdata.507.781648603
input datafile file number=00014 name=+DATA/ORCLLIVE/datafile/t24distdata.403.782189783
input datafile file number=00007 name=+DATA/ORCLLIVE/datafile/t24distindex.505.781390005
input datafile file number=00010 name=+DATA/ORCLLIVE/datafile/sysaux.302.781737219
input datafile file number=00002 name=+DATA/ORCLLIVE/datafile/sysaux.492.781389155
input datafile file number=00012 name=+DATA/ORCLLIVE/datafile/system.305.781781913
channel c3: starting piece 1 at 05/18/12 20:08:19
backup as compressed backupset archivelog all format '/u02/backup/rman/Primary_bkp_standby_%U.arc';channel c2: finished piece 1 at 05/18/12 20:40:15
piece handle=/u02/backup/rman/Primary_bkp_standby_4jnbajlj_1_1 tag=TAG20120518T200818 comment=NONE
channel c2: backup set complete, elapsed time: 00:31:56
channel c1: finished piece 1 at 05/18/12 20:40:55
piece handle=/u02/backup/rman/Primary_bkp_standby_4inbajli_1_1 tag=TAG20120518T200818 comment=NONE
channel c1: backup set complete, elapsed time: 00:32:36
channel c3: finished piece 1 at 05/18/12 20:48:55
piece handle=/u02/backup/rman/Primary_bkp_standby_4knbajlj_1_1 tag=TAG20120518T200818 comment=NONE
channel c3: backup set complete, elapsed time: 00:40:36
Finished backup at 05/18/12 20:48:55

Starting backup at 05/18/12 20:48:56
current log archived
channel c1: starting compressed archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=761 RECID=1370 STAMP=783595072
input archived log thread=2 sequence=610 RECID=1371 STAMP=783595494
input archived log thread=1 sequence=762 RECID=1372 STAMP=783599053
input archived log thread=2 sequence=611 RECID=1373 STAMP=783599537
input archived log thread=1 sequence=763 RECID=1374 STAMP=783601882
input archived log thread=2 sequence=612 RECID=1375 STAMP=783602044
input archived log thread=1 sequence=764 RECID=1376 STAMP=783604598
channel c1: starting piece 1 at 05/18/12 20:49:18
channel c2: starting compressed archived log backup set
channel c2: specifying archived log(s) in backup set
input archived log thread=2 sequence=613 RECID=1377 STAMP=783605887
input archived log thread=1 sequence=765 RECID=1378 STAMP=783608647
input archived log thread=2 sequence=614 RECID=1379 STAMP=783611922
input archived log thread=1 sequence=766 RECID=1380 STAMP=783612898
input archived log thread=2 sequence=615 RECID=1381 STAMP=783614063
input archived log thread=1 sequence=767 RECID=1382 STAMP=783616274
input archived log thread=2 sequence=616 RECID=1383 STAMP=783616766
channel c2: starting piece 1 at 05/18/12 20:49:18
channel c3: starting compressed archived log backup set
channel c3: specifying archived log(s) in backup set
input archived log thread=1 sequence=768 RECID=1384 STAMP=783619605
input archived log thread=2 sequence=617 RECID=1385 STAMP=783619918
input archived log thread=1 sequence=769 RECID=1386 STAMP=783623487
input archived log thread=2 sequence=618 RECID=1387 STAMP=783623742
input archived log thread=1 sequence=770 RECID=1388 STAMP=783636553
input archived log thread=2 sequence=619 RECID=1389 STAMP=783636555
channel c3: starting piece 1 at 05/18/12 20:49:18
channel c3: finished piece 1 at 05/18/12 20:57:33
piece handle=/u02/backup/rman/Primary_bkp_standby_4nnbam2e_1_1.arc tag=TAG20120518T204917 comment=NONE
channel c3: backup set complete, elapsed time: 00:08:15
channel c1: finished piece 1 at 05/18/12 20:59:03
piece handle=/u02/backup/rman/Primary_bkp_standby_4lnbam2e_1_1.arc tag=TAG20120518T204917 comment=NONE
channel c1: backup set complete, elapsed time: 00:09:45
channel c2: finished piece 1 at 05/18/12 20:59:13
piece handle=/u02/backup/rman/Primary_bkp_standby_4mnbam2e_1_1.arc tag=TAG20120518T204917 comment=NONE
channel c2: backup set complete, elapsed time: 00:09:55
Finished backup at 05/18/12 20:59:13

Starting Control File and SPFILE Autobackup at 05/18/12 20:59:13
piece handle=+ARCHIVE/ORCLLIVE/backup/c-XXXXXXXX-20120518-01 comment=NONE
Finished Control File and SPFILE Autobackup at 05/18/12 20:59:14
released channel: c1
released channel: c2
released channel: c3

RMAN> run {
2> allocate channel c1 type disk format '/u02/backup/rman/Primary_bkp_standby_%U';
3> backup current controlfile for standby;
4> }

released channel: ORA_DISK_1
allocated channel: c1
channel c1: SID=5970 instance=ORCLLIVE1 device type=DISK

Starting backup at 05/18/12 21:04:14
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
including standby control file in backup set
channel c1: starting piece 1 at 05/18/12 21:04:15
channel c1: finished piece 1 at 05/18/12 21:04:16
piece handle=/u02/backup/rman/Primary_bkp_standby_4qnbamue_1_1 tag=TAG20120518T210414 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
Finished backup at 05/18/12 21:04:16

Starting Control File and SPFILE Autobackup at 05/18/12 21:04:16
piece handle=+ARCHIVE/ORCLLIVE/backup/c-XXXXXXXX-20120518-02 comment=NONE
Finished Control File and SPFILE Autobackup at 05/18/12 21:04:17
released channel: c1

RMAN> exit

Recovery Manager complete.
$ ls -ltr
total 0
-rw-r----- 1 oracle asmadmin 7834181632 May 18 20:40 Primary_bkp_standby_4jnbajlj_1_1
-rw-r----- 1 oracle asmadmin 7977918464 May 18 20:40 Primary_bkp_standby_4inbajli_1_1
-rw-r----- 1 oracle asmadmin 10228621312 May 18 20:48 Primary_bkp_standby_4knbajlj_1_1
-rw-r----- 1 oracle asmadmin 3398466560 May 18 20:57 Primary_bkp_standby_4nnbam2e_1_1.arc
-rw-r----- 1 oracle asmadmin 4068699648 May 18 20:59 Primary_bkp_standby_4lnbam2e_1_1.arc
-rw-r----- 1 oracle asmadmin 4140691968 May 18 20:59 Primary_bkp_standby_4mnbam2e_1_1.arc
-rw-r----- 1 oracle asmadmin 18087936 May 18 21:04 Primary_bkp_standby_4qnbamue_1_1
$ hostanem
ksh: hostanem: not found.
$ hostname

2)SCP the backup files to standby server

$ scp Primary_bkp_standby_* oracle@10.3.8.15:/u02/backup/rman/
oracle@10.3.8.15's password:
Primary_bkp_standby_4inbajli_1_1 100% 7608MB 26.5MB/s 04:47
Primary_bkp_standby_4jnbajlj_1_1 100% 7471MB 26.7MB/s 04:40
Primary_bkp_standby_4knbajlj_1_1 100% 9755MB 23.7MB/s 06:51
Primary_bkp_standby_4lnbam2e_1_1.arc 100% 3880MB 24.6MB/s 02:38
Primary_bkp_standby_4mnbam2e_1_1.arc 100% 3949MB 25.6MB/s 02:34
Primary_bkp_standby_4nnbam2e_1_1.arc 100% 3241MB 24.6MB/s 02:12
Primary_bkp_standby_4qnbamue_1_1

1) Modify the standby parameter file and start standby DB in nomount state
$ ps -fe|grep pmon
grid 4063456 1 0 Apr 25 - 1:56 asm_pmon_+ASM
oracle 5242980 1 0 10:13:42 - 0:02 ora_pmon_ORCLLIVESBY
oracle 7602180 1 0 18:08:57 - 0:00 ora_pmon_LIVEORCLSBY
$ echo $ORACLE_SID
LIVEORCLSBY

$ rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Tue May 15 18:29:43 2012

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

connected to target database: LIVEORCL (not mounted)

RMAN> set dbid=2649139521

executing command: SET DBID

RMAN> restore standby controlfile from '/u02/backup/rman/Primary_bkp_standby_0hnb2gli_1_1';

Starting restore at 15-MAY-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=5671 device type=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=+DATA/LIVEORCLsby/controlfile/control01.ctl
output file name=+ARCHIVE/LIVEORCLsby/controlfile/control02.ctl
Finished restore at 15-MAY-12

RMAN> sql 'alter database mount standby database';

sql statement: alter database mount standby database
released channel: ORA_DISK_1

RMAN> restore database;

Starting restore at 15-MAY-12
Starting implicit crosscheck backup at 15-MAY-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=7183 device type=DISK
Crosschecked 16 objects
Finished implicit crosscheck backup at 15-MAY-12

Starting implicit crosscheck copy at 15-MAY-12
using channel ORA_DISK_1
Finished implicit crosscheck copy at 15-MAY-12

searching for all files in the recovery area
cataloging files...
no files cataloged

using channel ORA_DISK_1

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 +DATA/LIVEORCLsby/datafile/sysaux.306.781894957
channel ORA_DISK_1: restoring datafile 00008 to +DATA/LIVEORCLsby/datafile/t24distdata.397.782095887
channel ORA_DISK_1: restoring datafile 00009 to +DATA/LIVEORCLsby/datafile/t24distdata.400.782095905
channel ORA_DISK_1: restoring datafile 00011 to +DATA/LIVEORCLsby/datafile/t24distdata.398.782096151
channel ORA_DISK_1: reading from backup piece /u02/backup/rman/Primary_bkp_standby_0anb2f5t_1_1
channel ORA_DISK_1: piece handle=/u02/backup/rman/Primary_bkp_standby_0anb2f5t_1_1 tag=TAG20120515T180236
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:05:55
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 +DATA/LIVEORCLsby/datafile/system.312.781894955
channel ORA_DISK_1: restoring datafile 00003 to +DATA/LIVEORCLsby/datafile/undotbs1.301.781894957
channel ORA_DISK_1: restoring datafile 00007 to +DATA/LIVEORCLsby/datafile/t24distindex.446.781895581
channel ORA_DISK_1: restoring datafile 00010 to +DATA/LIVEORCLsby/datafile/t24distdata.396.782095937
channel ORA_DISK_1: reading from backup piece /u02/backup/rman/Primary_bkp_standby_0bnb2f5t_1_1
channel ORA_DISK_1: piece handle=/u02/backup/rman/Primary_bkp_standby_0bnb2f5t_1_1 tag=TAG20120515T180236
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:06: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 00004 to +DATA/LIVEORCLsby/datafile/users.300.781894957
channel ORA_DISK_1: restoring datafile 00005 to +DATA/LIVEORCLsby/datafile/undotbs2.408.781895217
channel ORA_DISK_1: restoring datafile 00006 to +DATA/LIVEORCLsby/datafile/t24distdata.406.781895523
channel ORA_DISK_1: reading from backup piece /u02/backup/rman/Primary_bkp_standby_09nb2f5t_1_1
channel ORA_DISK_1: piece handle=/u02/backup/rman/Primary_bkp_standby_09nb2f5t_1_1 tag=TAG20120515T180236
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:13:16
Finished restore at 15-MAY-12

RMAN> list backup of archivelog all;

List of Backup Sets
===================

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
6 732.31M DISK 00:02:01 15-MAY-12
BP Key: 6 Status: EXPIRED Compressed: YES Tag: TAG20120515T173105
Piece Name: /u02/backup/rman/Primary_bkp_standby_08nb2dap_1_1.arc

List of Archived Logs in backup set 6
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 78 52466833 15-MAY-12 53677900 15-MAY-12
1 79 53677900 15-MAY-12 54503144 15-MAY-12

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
7 1.27G DISK 00:03:29 15-MAY-12
BP Key: 7 Status: EXPIRED Compressed: YES Tag: TAG20120515T173105
Piece Name: /u02/backup/rman/Primary_bkp_standby_07nb2dap_1_1.arc

List of Archived Logs in backup set 7
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 75 49006110 15-MAY-12 50147864 15-MAY-12
1 76 50147864 15-MAY-12 51315589 15-MAY-12
1 77 51315589 15-MAY-12 52466833 15-MAY-12

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
8 1.28G DISK 00:03:30 15-MAY-12
BP Key: 8 Status: EXPIRED Compressed: YES Tag: TAG20120515T173105
Piece Name: /u02/backup/rman/Primary_bkp_standby_06nb2dap_1_1.arc

List of Archived Logs in backup set 8
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 72 45447595 14-MAY-12 46666639 14-MAY-12
1 73 46666639 14-MAY-12 47839944 14-MAY-12
1 74 47839944 14-MAY-12 49006110 15-MAY-12

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
14 818.80M DISK 00:02:02 15-MAY-12
BP Key: 14 Status: AVAILABLE Compressed: YES Tag: TAG20120515T181054
Piece Name: /u02/backup/rman/Primary_bkp_standby_0gnb2flf_1_1.arc

List of Archived Logs in backup set 14
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 78 52466833 15-MAY-12 53677900 15-MAY-12
1 79 53677900 15-MAY-12 54503144 15-MAY-12
1 80 54503144 15-MAY-12 54736952 15-MAY-12

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
15 1.27G DISK 00:03:15 15-MAY-12
BP Key: 15 Status: AVAILABLE Compressed: YES Tag: TAG20120515T181054
Piece Name: /u02/backup/rman/Primary_bkp_standby_0fnb2flf_1_1.arc

List of Archived Logs in backup set 15
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 75 49006110 15-MAY-12 50147864 15-MAY-12
1 76 50147864 15-MAY-12 51315589 15-MAY-12
1 77 51315589 15-MAY-12 52466833 15-MAY-12

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
16 1.28G DISK 00:03:15 15-MAY-12
BP Key: 16 Status: AVAILABLE Compressed: YES Tag: TAG20120515T181054
Piece Name: /u02/backup/rman/Primary_bkp_standby_0enb2flf_1_1.arc

List of Archived Logs in backup set 16
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 72 45447595 14-MAY-12 46666639 14-MAY-12
1 73 46666639 14-MAY-12 47839944 14-MAY-12
1 74 47839944 14-MAY-12 49006110 15-MAY-12

RMAN> recover database until sequence 81;

Starting recover at 15-MAY-12
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=80
channel ORA_DISK_1: reading from backup piece /u02/backup/rman/Primary_bkp_standby_0gnb2flf_1_1.arc
channel ORA_DISK_1: piece handle=/u02/backup/rman/Primary_bkp_standby_0gnb2flf_1_1.arc tag=TAG20120515T181054
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:55
archived log file name=+ARCHIVE/LIVEORCLsby/archivelog/2012_05_15/thread_1_seq_80.937.783370839 thread=1 sequence=80
channel default: deleting archived log(s)
archived log file name=+ARCHIVE/LIVEORCLsby/archivelog/2012_05_15/thread_1_seq_80.937.783370839 RECID=1 STAMP=783370893
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/15/2012 19:01:37
RMAN-11003: failure during parse/execution of SQL statement: alter database recover cancel
ORA-10879: error signaled in parallel recovery slave
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '+DATA/LIVEORCLsby/datafile/system.318.783369549'

RMAN> exit
<no need to worry about the above error it is usual>

****************************
I have again posting the screen shot from a second work done
****************************

$ hostname
dt24db1
$ rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Fri May 18 21:50:48 2012

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

connected to target database: ORCLLIVE (not mounted)

RMAN> set dbid=XXXXXXXX;

executing command: SET DBID

RMAN> restore standby controlfile from '/u02/backup/rman/Primary_bkp_standby_4qnbamue_1_1';

Starting restore at 18-MAY-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=5671 device type=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=+DATA/ORCLLIVEsby/controlfile/control01.ctl
output file name=+ARCHIVE/ORCLLIVEsby/controlfile/control02.ctl
Finished restore at 18-MAY-12

RMAN> sql 'alter database mount standby database';

sql statement: alter database mount standby database
released channel: ORA_DISK_1

RMAN> run {
2> allocate channel c1 type disk;
3> allocate channel c2 type disk;
4> allocate channel c3 type disk;
5> restore database;
6> }

allocated channel: c1
channel c1: SID=5671 device type=DISK

allocated channel: c2
channel c2: SID=7372 device type=DISK

allocated channel: c3
channel c3: SID=1 device type=DISK

Starting restore at 18-MAY-12
Starting implicit crosscheck backup at 18-MAY-12
Crosschecked 6 objects
Crosschecked 4 objects
Finished implicit crosscheck backup at 18-MAY-12

Starting implicit crosscheck copy at 18-MAY-12
Finished implicit crosscheck copy at 18-MAY-12

searching for all files in the recovery area
cataloging files...
no files cataloged

channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00001 to +DATA/ORCLLIVEsby/datafile/system.493.781389153
channel c1: restoring datafile 00003 to +DATA/ORCLLIVEsby/datafile/undotbs1.495.781389155
channel c1: restoring datafile 00004 to +DATA/ORCLLIVEsby/datafile/users.494.781389155
channel c1: restoring datafile 00008 to +DATA/ORCLLIVEsby/datafile/t24distdata.506.781574987
channel c1: restoring datafile 00013 to +DATA/ORCLLIVEsby/datafile/t24distdata.355.781804141
channel c1: restoring datafile 00016 to +DATA/ORCLLIVEsby/datafile/t24distdata.273.782953715
channel c1: reading from backup piece /u02/backup/rman/Primary_bkp_standby_4jnbajlj_1_1
channel c2: starting datafile backup set restore
channel c2: specifying datafile(s) to restore from backup set
channel c2: restoring datafile 00005 to +DATA/ORCLLIVEsby/datafile/undotbs2.500.781389443
channel c2: restoring datafile 00006 to +DATA/ORCLLIVEsby/datafile/t24distdata.504.781389949
channel c2: restoring datafile 00011 to +DATA/ORCLLIVEsby/datafile/t24distdata.309.781739411
channel c2: restoring datafile 00015 to +DATA/ORCLLIVEsby/datafile/t24distdata.395.782432771
channel c2: reading from backup piece /u02/backup/rman/Primary_bkp_standby_4inbajli_1_1
channel c3: starting datafile backup set restore
channel c3: specifying datafile(s) to restore from backup set
channel c3: restoring datafile 00002 to +DATA/ORCLLIVEsby/datafile/sysaux.492.781389155
channel c3: restoring datafile 00007 to +DATA/ORCLLIVEsby/datafile/t24distindex.505.781390005
channel c3: restoring datafile 00009 to +DATA/ORCLLIVEsby/datafile/t24distdata.507.781648603
channel c3: restoring datafile 00010 to +DATA/ORCLLIVEsby/datafile/sysaux.302.781737219
channel c3: restoring datafile 00012 to +DATA/ORCLLIVEsby/datafile/system.305.781781913
channel c3: restoring datafile 00014 to +DATA/ORCLLIVEsby/datafile/t24distdata.403.782189783
channel c3: reading from backup piece /u02/backup/rman/Primary_bkp_standby_4knbajlj_1_1
channel c1: piece handle=/u02/backup/rman/Primary_bkp_standby_4jnbajlj_1_1 tag=TAG20120518T200818
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:53:17
channel c2: piece handle=/u02/backup/rman/Primary_bkp_standby_4inbajli_1_1 tag=TAG20120518T200818
channel c2: restored backup piece 1
channel c2: restore complete, elapsed time: 00:56:17
channel c3: piece handle=/u02/backup/rman/Primary_bkp_standby_4knbajlj_1_1 tag=TAG20120518T200818
channel c3: restored backup piece 1
channel c3: restore complete, elapsed time: 01:02:57
Finished restore at 18-MAY-12
released channel: c1
released channel: c2
released channel: c3

RMAN> list backup of archivelog all;

List of Backup Sets
===================

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
34 27.55G SBT_TAPE 00:05:39 02-MAY-12
BP Key: 34 Status: AVAILABLE Compressed: NO Tag: TAG20120502T224856
Handle: 13na0n2o_1_1 Media: 209

List of Archived Logs in backup set 34
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 232 347453695 02-MAY-12 349840006 02-MAY-12
1 233 349840006 02-MAY-12 352147840 02-MAY-12
1 234 352147840 02-MAY-12 354522775 02-MAY-12
1 235 354522775 02-MAY-12 356649490 02-MAY-12
1 236 356649490 02-MAY-12 358982367 02-MAY-12
1 237 358982367 02-MAY-12 360619613 02-MAY-12
2 180 341007633 02-MAY-12 343699472 02-MAY-12
2 181 343699472 02-MAY-12 346154653 02-MAY-12
2 182 346154653 02-MAY-12 348277162 02-MAY-12
2 183 348277162 02-MAY-12 349868949 02-MAY-12
2 184 349868949 02-MAY-12 351608063 02-MAY-12
2 185 351608063 02-MAY-12 353305961 02-MAY-12
2 186 353305961 02-MAY-12 355212888 02-MAY-12
2 187 355212888 02-MAY-12 357174576 02-MAY-12
2 188 357174576 02-MAY-12 359484407 02-MAY-12
2 189 359484407 02-MAY-12 360619681 02-MAY-12

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
39 17.30G SBT_TAPE 00:03:42 03-MAY-12
BP Key: 39 Status: AVAILABLE Compressed: NO Tag: TAG20120503T073135
Handle: 18na1lmo_1_1 Media: 206

List of Archived Logs in backup set 39
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 248 382004487 03-MAY-12 385618656 03-MAY-12
1 249 385618656 03-MAY-12 389092866 03-MAY-12
1 250 389092866 03-MAY-12 390901773 03-MAY-12
1 251 390901773 03-MAY-12 392106567 03-MAY-12
1 252 392106567 03-MAY-12 394277116 03-MAY-12
2 200 382632521 03-MAY-12 385790796 03-MAY-12
2 201 385790796 03-MAY-12 389131231 03-MAY-12
2 202 389131231 03-MAY-12 391229549 03-MAY-12
2 203 391229549 03-MAY-12 392263438 03-MAY-12
2 204 392263438 03-MAY-12 394277204 03-MAY-12

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
48 26.48G SBT_TAPE 00:05:12 04-MAY-12
BP Key: 48 Status: AVAILABLE Compressed: NO Tag: TAG20120504T002512
Handle: 1hna3h38_1_1 Media: 211

List of Archived Logs in backup set 48
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 295 440453648 03-MAY-12 441267232 03-MAY-12
1 296 441267232 03-MAY-12 442089839 03-MAY-12
1 297 442089839 03-MAY-12 442788833 03-MAY-12
1 298 442788833 03-MAY-12 443397843 03-MAY-12
1 299 443397843 03-MAY-12 445617628 03-MAY-12
1 300 445617628 03-MAY-12 446626870 03-MAY-12
1 301 446626870 03-MAY-12 446948934 03-MAY-12
1 302 446948934 03-MAY-12 447225114 04-MAY-12
1 303 447225114 04-MAY-12 447322610 04-MAY-12
2 225 438489108 03-MAY-12 439596911 03-MAY-12
2 226 439596911 03-MAY-12 440908374 03-MAY-12
2 227 440908374 03-MAY-12 441780266 03-MAY-12
2 228 441780266 03-MAY-12 442419386 03-MAY-12
2 229 442419386 03-MAY-12 445619229 03-MAY-12
2 230 445619229 03-MAY-12 447103564 03-MAY-12
2 231 447103564 03-MAY-12 447322623 04-MAY-12

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
53 22.84G SBT_TAPE 00:04:37 04-MAY-12
BP Key: 53 Status: AVAILABLE Compressed: NO Tag: TAG20120504T072953
Handle: 1mna49vi_1_1 Media: 212

List of Archived Logs in backup set 53
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 316 463886735 04-MAY-12 464972042 04-MAY-12
1 317 464972042 04-MAY-12 465825713 04-MAY-12
1 318 465825713 04-MAY-12 466560543 04-MAY-12
1 319 466560543 04-MAY-12 467819412 04-MAY-12
1 320 467819412 04-MAY-12 468533396 04-MAY-12
1 321 468533396 04-MAY-12 469232219 04-MAY-12
1 322 469232219 04-MAY-12 470084951 04-MAY-12
1 323 470084951 04-MAY-12 470379280 04-MAY-12
2 239 459125778 04-MAY-12 461806664 04-MAY-12
2 240 461806664 04-MAY-12 463462443 04-MAY-12
2 241 463462443 04-MAY-12 464624101 04-MAY-12
2 242 464624101 04-MAY-12 466089220 04-MAY-12
2 243 466089220 04-MAY-12 468533538 04-MAY-12
2 244 468533538 04-MAY-12 470380609 04-MAY-12

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
61 20.46G SBT_TAPE 00:04:34 04-MAY-12
BP Key: 61 Status: AVAILABLE Compressed: NO Tag: TAG20120504T232133
Handle: 1una61nt_1_1 Media: 205

List of Archived Logs in backup set 61
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 351 527853272 04-MAY-12 529849000 04-MAY-12
1 352 529849000 04-MAY-12 531983208 04-MAY-12
1 353 531983208 04-MAY-12 534051392 04-MAY-12
1 354 534051392 04-MAY-12 536099513 04-MAY-12
1 355 536099513 04-MAY-12 544388703 04-MAY-12
1 356 544388703 04-MAY-12 547487452 04-MAY-12
2 267 528236442 04-MAY-12 530696797 04-MAY-12
2 268 530696797 04-MAY-12 532728435 04-MAY-12
2 269 532728435 04-MAY-12 534615657 04-MAY-12
2 270 534615657 04-MAY-12 536431221 04-MAY-12
2 271 536431221 04-MAY-12 543453851 04-MAY-12
2 272 543453851 04-MAY-12 547488572 04-MAY-12

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
66 4.12G SBT_TAPE 00:00:55 05-MAY-12
BP Key: 66 Status: AVAILABLE Compressed: NO Tag: TAG20120505T002311
Handle: 23na65bg_1_1 Media: 206

List of Archived Logs in backup set 66
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 357 547487452 04-MAY-12 550541685 05-MAY-12
1 358 550541685 05-MAY-12 551017462 05-MAY-12
2 273 547488572 04-MAY-12 550468509 05-MAY-12
2 274 550468509 05-MAY-12 551018331 05-MAY-12

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
71 32.46G SBT_TAPE 00:06:40 05-MAY-12
BP Key: 71 Status: AVAILABLE Compressed: NO Tag: TAG20120505T200527
Handle: 29na8ak7_1_1 Media: 207

List of Archived Logs in backup set 71
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 383 600928779 05-MAY-12 604024698 05-MAY-12
1 384 604024698 05-MAY-12 605967686 05-MAY-12
1 385 605967686 05-MAY-12 607585079 05-MAY-12
1 386 607585079 05-MAY-12 609187135 05-MAY-12
1 387 609187135 05-MAY-12 610689662 05-MAY-12
1 388 610689662 05-MAY-12 611956659 05-MAY-12
1 389 611956659 05-MAY-12 612800460 05-MAY-12
1 390 612800460 05-MAY-12 613506150 05-MAY-12
1 391 613506150 05-MAY-12 614093553 05-MAY-12
1 392 614093553 05-MAY-12 614512382 05-MAY-12
1 393 614512382 05-MAY-12 614637808 05-MAY-12
2 297 598428679 05-MAY-12 600425981 05-MAY-12
2 298 600425981 05-MAY-12 602488063 05-MAY-12
2 299 602488063 05-MAY-12 604544904 05-MAY-12
2 300 604544904 05-MAY-12 606854004 05-MAY-12
2 301 606854004 05-MAY-12 608877969 05-MAY-12
2 302 608877969 05-MAY-12 610976974 05-MAY-12
2 303 610976974 05-MAY-12 612925256 05-MAY-12
2 304 612925256 05-MAY-12 614094064 05-MAY-12
2 305 614094064 05-MAY-12 614638048 05-MAY-12

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
94 91.39G SBT_TAPE 00:17:11 10-MAY-12
BP Key: 94 Status: AVAILABLE Compressed: NO Tag: TAG20120510T222120
Handle: 32nalof2_1_1 Media: 205

List of Archived Logs in backup set 94
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 563 884919191 09-MAY-12 887804259 10-MAY-12
1 564 887804259 10-MAY-12 890701287 10-MAY-12
1 565 890701287 10-MAY-12 893635710 10-MAY-12
1 566 893635710 10-MAY-12 895934907 10-MAY-12
1 567 895934907 10-MAY-12 897735127 10-MAY-12
1 568 897735127 10-MAY-12 899767113 10-MAY-12
1 569 899767113 10-MAY-12 902004038 10-MAY-12
1 570 902004038 10-MAY-12 904592482 10-MAY-12
1 571 904592482 10-MAY-12 905136126 10-MAY-12
1 572 905136126 10-MAY-12 905764585 10-MAY-12
1 573 905764585 10-MAY-12 906379804 10-MAY-12
1 574 906379804 10-MAY-12 907041837 10-MAY-12
1 575 907041837 10-MAY-12 907711724 10-MAY-12
1 576 907711724 10-MAY-12 909096461 10-MAY-12
1 577 909096461 10-MAY-12 911944526 10-MAY-12
1 578 911944526 10-MAY-12 912693054 10-MAY-12
1 579 912693054 10-MAY-12 913160254 10-MAY-12
1 580 913160254 10-MAY-12 913666126 10-MAY-12
1 581 913666126 10-MAY-12 914211095 10-MAY-12
1 582 914211095 10-MAY-12 914782901 10-MAY-12
1 583 914782901 10-MAY-12 916831437 10-MAY-12
1 584 916831437 10-MAY-12 919002316 10-MAY-12
1 585 919002316 10-MAY-12 920601060 10-MAY-12
1 586 920601060 10-MAY-12 924118328 10-MAY-12
1 587 924118328 10-MAY-12 927555190 10-MAY-12
1 588 927555190 10-MAY-12 931059131 10-MAY-12
1 589 931059131 10-MAY-12 934436054 10-MAY-12
1 590 934436054 10-MAY-12 935770866 10-MAY-12
2 425 884922271 09-MAY-12 888728620 10-MAY-12
2 426 888728620 10-MAY-12 892355354 10-MAY-12
2 427 892355354 10-MAY-12 895689350 10-MAY-12
2 428 895689350 10-MAY-12 897867259 10-MAY-12
2 429 897867259 10-MAY-12 900434925 10-MAY-12
2 430 900434925 10-MAY-12 903957658 10-MAY-12
2 431 903957658 10-MAY-12 904878659 10-MAY-12
2 432 904878659 10-MAY-12 905518165 10-MAY-12
2 433 905518165 10-MAY-12 906171636 10-MAY-12
2 434 906171636 10-MAY-12 906856901 10-MAY-12
2 435 906856901 10-MAY-12 907559152 10-MAY-12
2 436 907559152 10-MAY-12 908894686 10-MAY-12
2 437 908894686 10-MAY-12 912432483 10-MAY-12
2 438 912432483 10-MAY-12 912903612 10-MAY-12
2 439 912903612 10-MAY-12 913419718 10-MAY-12
2 440 913419718 10-MAY-12 913942777 10-MAY-12
2 441 913942777 10-MAY-12 914455684 10-MAY-12
2 442 914455684 10-MAY-12 914945915 10-MAY-12
2 443 914945915 10-MAY-12 917791991 10-MAY-12
2 444 917791991 10-MAY-12 919369785 10-MAY-12
2 445 919369785 10-MAY-12 923038104 10-MAY-12
2 446 923038104 10-MAY-12 929593324 10-MAY-12
2 447 929593324 10-MAY-12 935772920 10-MAY-12

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
95 87.85G SBT_TAPE 00:16:18 10-MAY-12
BP Key: 95 Status: AVAILABLE Compressed: NO Tag: TAG20120510T222120
Handle: 33nalpgl_1_1 Media: 213

List of Archived Logs in backup set 95
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 591 935770866 10-MAY-12 938598571 10-MAY-12
1 592 938598571 10-MAY-12 942530629 10-MAY-12
1 593 942530629 10-MAY-12 946615068 10-MAY-12
1 594 946615068 10-MAY-12 951348580 10-MAY-12
1 595 951348580 10-MAY-12 955853202 10-MAY-12
1 596 955853202 10-MAY-12 960169405 10-MAY-12
1 597 960169405 10-MAY-12 964627994 10-MAY-12
1 598 964627994 10-MAY-12 969304310 10-MAY-12
1 599 969304310 10-MAY-12 974500207 10-MAY-12
1 600 974500207 10-MAY-12 979706391 10-MAY-12
1 601 979706391 10-MAY-12 983423731 10-MAY-12
1 602 983423731 10-MAY-12 987260882 10-MAY-12
1 603 987260882 10-MAY-12 991371531 10-MAY-12
1 604 991371531 10-MAY-12 996153593 10-MAY-12
1 605 996153593 10-MAY-12 1001043776 10-MAY-12
1 606 1001043776 10-MAY-12 1005915212 10-MAY-12
1 607 1005915212 10-MAY-12 1010775787 10-MAY-12
1 608 1010775787 10-MAY-12 1015585911 10-MAY-12
1 609 1015585911 10-MAY-12 1019803070 10-MAY-12
1 610 1019803070 10-MAY-12 1025755568 10-MAY-12
1 611 1025755568 10-MAY-12 1026952827 10-MAY-12
1 612 1026952827 10-MAY-12 1027254180 10-MAY-12
2 448 935772920 10-MAY-12 941320312 10-MAY-12
2 449 941320312 10-MAY-12 945546813 10-MAY-12
2 450 945546813 10-MAY-12 949345592 10-MAY-12
2 451 949345592 10-MAY-12 953028704 10-MAY-12
2 452 953028704 10-MAY-12 956764475 10-MAY-12
2 453 956764475 10-MAY-12 960471774 10-MAY-12
2 454 960471774 10-MAY-12 964192897 10-MAY-12
2 455 964192897 10-MAY-12 967635227 10-MAY-12
2 456 967635227 10-MAY-12 970648810 10-MAY-12
2 457 970648810 10-MAY-12 973713500 10-MAY-12
2 458 973713500 10-MAY-12 976733107 10-MAY-12
2 459 976733107 10-MAY-12 979848952 10-MAY-12
2 460 979848952 10-MAY-12 983354839 10-MAY-12
2 461 983354839 10-MAY-12 986777711 10-MAY-12
2 462 986777711 10-MAY-12 990325345 10-MAY-12
2 463 990325345 10-MAY-12 993843003 10-MAY-12
2 464 993843003 10-MAY-12 997341859 10-MAY-12
2 465 997341859 10-MAY-12 1000716872 10-MAY-12
2 466 1000716872 10-MAY-12 1004077232 10-MAY-12
2 467 1004077232 10-MAY-12 1007131038 10-MAY-12
2 468 1007131038 10-MAY-12 1010139598 10-MAY-12
2 469 1010139598 10-MAY-12 1013007924 10-MAY-12
2 470 1013007924 10-MAY-12 1016591483 10-MAY-12
2 471 1016591483 10-MAY-12 1018305863 10-MAY-12
2 472 1018305863 10-MAY-12 1019799100 10-MAY-12
2 473 1019799100 10-MAY-12 1021053684 10-MAY-12
2 474 1021053684 10-MAY-12 1023284490 10-MAY-12
2 475 1023284490 10-MAY-12 1025970592 10-MAY-12
2 476 1025970592 10-MAY-12 1027255004 10-MAY-12

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
113 28.59G SBT_TAPE 00:05:36 14-MAY-12
BP Key: 113 Status: AVAILABLE Compressed: NO Tag: TAG20120514T201228
Handle: 3onb02dd_1_1 Media: 210

List of Archived Logs in backup set 113
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 675 1166393473 14-MAY-12 1170425832 14-MAY-12
1 676 1170425832 14-MAY-12 1174541797 14-MAY-12
1 677 1174541797 14-MAY-12 1178736616 14-MAY-12
1 678 1178736616 14-MAY-12 1183049717 14-MAY-12
1 679 1183049717 14-MAY-12 1187323767 14-MAY-12
1 680 1187323767 14-MAY-12 1191129096 14-MAY-12
1 681 1191129096 14-MAY-12 1194605143 14-MAY-12
1 682 1194605143 14-MAY-12 1198748230 14-MAY-12
2 537 1166393515 14-MAY-12 1170363336 14-MAY-12
2 538 1170363336 14-MAY-12 1174506310 14-MAY-12
2 539 1174506310 14-MAY-12 1178108902 14-MAY-12
2 540 1178108902 14-MAY-12 1182168217 14-MAY-12
2 541 1182168217 14-MAY-12 1186382158 14-MAY-12
2 542 1186382158 14-MAY-12 1190759127 14-MAY-12
2 543 1190759127 14-MAY-12 1194659328 14-MAY-12
2 544 1194659328 14-MAY-12 1199075304 14-MAY-12

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
115 35.24G SBT_TAPE 00:03:52 14-MAY-12
BP Key: 121 Status: AVAILABLE Compressed: NO Tag: TAG20120514T221955
Handle: 3qnb09sb_1_2 Media: 209

List of Archived Logs in backup set 115
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 675 1166393473 14-MAY-12 1170425832 14-MAY-12
1 676 1170425832 14-MAY-12 1174541797 14-MAY-12
1 677 1174541797 14-MAY-12 1178736616 14-MAY-12
1 678 1178736616 14-MAY-12 1183049717 14-MAY-12
1 679 1183049717 14-MAY-12 1187323767 14-MAY-12
1 680 1187323767 14-MAY-12 1191129096 14-MAY-12
1 681 1191129096 14-MAY-12 1194605143 14-MAY-12
1 682 1194605143 14-MAY-12 1198748230 14-MAY-12
1 683 1198748230 14-MAY-12 1202071770 14-MAY-12
1 684 1202071770 14-MAY-12 1202375988 14-MAY-12
1 685 1202375988 14-MAY-12 1202779458 14-MAY-12
1 686 1202779458 14-MAY-12 1202788686 14-MAY-12
2 537 1166393515 14-MAY-12 1170363336 14-MAY-12
2 538 1170363336 14-MAY-12 1174506310 14-MAY-12
2 539 1174506310 14-MAY-12 1178108902 14-MAY-12
2 540 1178108902 14-MAY-12 1182168217 14-MAY-12
2 541 1182168217 14-MAY-12 1186382158 14-MAY-12
2 542 1186382158 14-MAY-12 1190759127 14-MAY-12
2 543 1190759127 14-MAY-12 1194659328 14-MAY-12
2 544 1194659328 14-MAY-12 1199075304 14-MAY-12
2 545 1199075304 14-MAY-12 1202779476 14-MAY-12
2 546 1202779476 14-MAY-12 1202788726 14-MAY-12

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
118 31.52G SBT_TAPE 00:03:32 15-MAY-12
BP Key: 123 Status: AVAILABLE Compressed: NO Tag: TAG20120515T064618
Handle: 3tnb17hq_1_2 Media: 211

List of Archived Logs in backup set 118
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 687 1202788686 14-MAY-12 1202825997 14-MAY-12
1 688 1202825997 14-MAY-12 1204566856 14-MAY-12
1 689 1204566856 14-MAY-12 1207670647 14-MAY-12
1 690 1207670647 14-MAY-12 1209447849 15-MAY-12
1 691 1209447849 15-MAY-12 1211087824 15-MAY-12
1 692 1211087824 15-MAY-12 1213213660 15-MAY-12
1 693 1213213660 15-MAY-12 1216624373 15-MAY-12
1 694 1216624373 15-MAY-12 1218624957 15-MAY-12
1 695 1218624957 15-MAY-12 1219808615 15-MAY-12
1 696 1219808615 15-MAY-12 1221489035 15-MAY-12
1 697 1221489035 15-MAY-12 1221571470 15-MAY-12
2 547 1202788726 14-MAY-12 1205761252 14-MAY-12
2 548 1205761252 14-MAY-12 1208297636 14-MAY-12
2 549 1208297636 14-MAY-12 1210128910 15-MAY-12
2 550 1210128910 15-MAY-12 1212164951 15-MAY-12
2 551 1212164951 15-MAY-12 1215075174 15-MAY-12
2 552 1215075174 15-MAY-12 1217805884 15-MAY-12
2 553 1217805884 15-MAY-12 1219215368 15-MAY-12
2 554 1219215368 15-MAY-12 1221528195 15-MAY-12
2 555 1221528195 15-MAY-12 1221571407 15-MAY-12

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
134 32.43G DISK 00:03:47 18-MAY-12
BP Key: 138 Status: EXPIRED Compressed: NO Tag: TAG20120518T065457
Piece Name: +ARCHIVE/ORCLLIVE/backupset/2012_05_18/annnf0_tag20120518t065457_0.2532.783586499

List of Archived Logs in backup set 134
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 750 1371204057 17-MAY-12 1371450323 17-MAY-12
1 751 1371450323 17-MAY-12 1373459484 17-MAY-12
1 752 1373459484 17-MAY-12 1376243154 18-MAY-12
1 753 1376243154 18-MAY-12 1378162990 18-MAY-12
1 754 1378162990 18-MAY-12 1379781261 18-MAY-12
1 755 1379781261 18-MAY-12 1382025374 18-MAY-12
1 756 1382025374 18-MAY-12 1385077819 18-MAY-12
1 757 1385077819 18-MAY-12 1387039353 18-MAY-12
1 758 1387039353 18-MAY-12 1388204513 18-MAY-12
1 759 1388204513 18-MAY-12 1390433218 18-MAY-12
1 760 1390433218 18-MAY-12 1390593122 18-MAY-12
2 602 1371204147 17-MAY-12 1374163876 17-MAY-12
2 603 1374163876 17-MAY-12 1376817618 18-MAY-12
2 604 1376817618 18-MAY-12 1378715667 18-MAY-12
2 605 1378715667 18-MAY-12 1380491289 18-MAY-12
2 606 1380491289 18-MAY-12 1383309562 18-MAY-12
2 607 1383309562 18-MAY-12 1386137004 18-MAY-12
2 608 1386137004 18-MAY-12 1387622877 18-MAY-12
2 609 1387622877 18-MAY-12 1390593239 18-MAY-12

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
139 3.17G DISK 00:08:06 18-MAY-12
BP Key: 143 Status: AVAILABLE Compressed: YES Tag: TAG20120518T204917
Piece Name: /u02/backup/rman/Primary_bkp_standby_4nnbam2e_1_1.arc

List of Archived Logs in backup set 139
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 768 1415520824 18-MAY-12 1419487053 18-MAY-12
1 769 1419487053 18-MAY-12 1423553921 18-MAY-12
1 770 1423553921 18-MAY-12 1427041014 18-MAY-12
2 617 1416095980 18-MAY-12 1419843766 18-MAY-12
2 618 1419843766 18-MAY-12 1423785744 18-MAY-12
2 619 1423785744 18-MAY-12 1427041002 18-MAY-12

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
140 3.79G DISK 00:09:42 18-MAY-12
BP Key: 144 Status: AVAILABLE Compressed: YES Tag: TAG20120518T204917
Piece Name: /u02/backup/rman/Primary_bkp_standby_4lnbam2e_1_1.arc

List of Archived Logs in backup set 140
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 761 1390593122 18-MAY-12 1394341280 18-MAY-12
1 762 1394341280 18-MAY-12 1398190030 18-MAY-12
1 763 1398190030 18-MAY-12 1401486217 18-MAY-12
1 764 1401486217 18-MAY-12 1404656935 18-MAY-12
2 610 1390593239 18-MAY-12 1394685530 18-MAY-12
2 611 1394685530 18-MAY-12 1398742849 18-MAY-12
2 612 1398742849 18-MAY-12 1401754742 18-MAY-12

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
141 3.86G DISK 00:09:48 18-MAY-12
BP Key: 145 Status: AVAILABLE Compressed: YES Tag: TAG20120518T204917
Piece Name: /u02/backup/rman/Primary_bkp_standby_4mnbam2e_1_1.arc

List of Archived Logs in backup set 141
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 765 1404656935 18-MAY-12 1407693733 18-MAY-12
1 766 1407693733 18-MAY-12 1411345355 18-MAY-12
1 767 1411345355 18-MAY-12 1415520824 18-MAY-12
2 613 1401754742 18-MAY-12 1405903024 18-MAY-12
2 614 1405903024 18-MAY-12 1410372568 18-MAY-12
2 615 1410372568 18-MAY-12 1412796923 18-MAY-12
2 616 1412796923 18-MAY-12 1416095980 18-MAY-12

RMAN> recover database until sequence 771;

Starting recover at 18-MAY-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=5671 device type=DISK

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=770
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=619
channel ORA_DISK_1: reading from backup piece /u02/backup/rman/Primary_bkp_standby_4nnbam2e_1_1.arc
channel ORA_DISK_1: piece handle=/u02/backup/rman/Primary_bkp_standby_4nnbam2e_1_1.arc tag=TAG20120518T204917
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:09:15
archived log file name=+ARCHIVE/ORCLLIVEsby/archivelog/2012_05_18/thread_1_seq_770.268.783644669 thread=1 sequence=770
archived log file name=+ARCHIVE/ORCLLIVEsby/archivelog/2012_05_18/thread_2_seq_619.270.783644667 thread=2 sequence=619
channel default: deleting archived log(s)
archived log file name=+ARCHIVE/ORCLLIVEsby/archivelog/2012_05_18/thread_2_seq_619.270.783644667 RECID=2 STAMP=783645219
unable to find archived log
archived log thread=2 sequence=620
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/18/2012 23:13:48
RMAN-06054: media recovery requesting unknown archived log for thread 2 with sequence 620 and starting SCN of 1427041002

3) Make appropriate changes for tnsnames.ora & create appropriate password file also

4) Enable MRP on standby database.