mount -t nfs  10.98.32.72:/u01/backup  /u01/backup
[root@rac1 u01]# 


alter database force logging;






RAC2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.98.32.163)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = rac)
    )
  )


RAC1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.98.32.161)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = rac)
    )
  )


DG =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.98.32.72)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SID = dg)
    )
  )




alter system set db_unique_name=rac scope=spfile sid='*';
alter system set log_archive_config='dg_config=(rac,dg)' scope=both sid='*';


alter system set log_archive_dest_3= 'service=dg async  valid_for=(online_logfiles,primary_role) db_unique_name=dg' scope=both sid='*';
alter system set log_archive_dest_state_3=enable scope=both sid='*';
alter system set standby_file_management=auto scope=both sid='*';
alter system set fal_server=dg scope=both sid='*';
alter system set fal_client=rac1 scope=both sid='rac1';
alter system set fal_client=rac2 scope=both sid='rac2';
alter system set db_file_name_convert='/opt/oracle/oradata/rac/','+DATABASEDG/rac/datafile/','/opt/oracle/oradata/rac/','+EPORTDG/rac/datafile/' scope=spfile sid='*';
alter system set log_file_name_convert='/opt/oracle/oradata/rac/','+BACKUPDG/rac/onlinelog/','/opt/oracle/oradata/rac/','+DATABASEDG/rac/datafile/' scope=spfile sid='*';   










alter database create standby controlfile as '/u01/standby.ctl';
CREATE PFILE='/u01/initdg.ora' FROM SPFILE;




ORA-27054: NFS file system where the file is created or resides is not mounted
















alter database add standby logfile thread 1 group 7 ('/opt/oracle/oradata/rac/archive/stdbyredo_1_07.log') size 100m;
alter database add standby logfile thread 1 group 8 ('/opt/oracle/oradata/rac/archive/stdbyredo_1_08.log') size 100m;
alter database add standby logfile thread 1 group 9 ('/opt/oracle/oradata/rac/archive/stdbyredo_1_09.log') size 100m;
alter database add standby logfile thread 1 group 10 ('/opt/oracle/oradata/rac/archive/stdbyredo_1_10.log') size 100m; 


alter database add standby logfile thread 2 group 11 ('/opt/oracle/oradata/rac/archive/stdbyredo_2_11.log') size 100m;
alter database add standby logfile thread 2 group 12 ('/opt/oracle/oradata/rac/archive/stdbyredo_2_12.log') size 100m;
alter database add standby logfile thread 2 group 13 ('/opt/oracle/oradata/rac/archive/stdbyredo_2_13.log') size 100m;
alter database add standby logfile thread 2 group 14 ('/opt/oracle/oradata/rac/archive/stdbyredo_1_14.log') size 100m; 
























dg.__db_cache_size=457179136
dg.__java_pool_size=4194304
dg.__large_pool_size=12582912
dg.__oracle_base='/opt/oracle'#ORACLE_BASE set from environment
dg.__pga_aggregate_target=318767104
dg.__sga_target=947912704
dg.__shared_io_pool_size=0
dg.__shared_pool_size=461373440
dg.__streams_pool_size=0
*.audit_file_dest='/opt/oracle/admin/rac/adump'
*.audit_trail='db'
*.cluster_database=true
*.compatible='11.2.0.0.0'
*.control_files='/opt/oracle/oradata/rac/standby.ctl'#Restore Controlfile
*.db_block_size=8192
*.db_create_file_dest='/opt/oracle/oradata/rac'
*.db_domain=''
*.db_name='rac'
*.db_recovery_file_dest='/opt/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=4322230272
*.diagnostic_dest='/opt/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=racXDB)'
dg.instance_number=1
*.log_archive_format='%t_%s_%r.dbf'
*.open_cursors=300
*.pga_aggregate_target=315621376
*.processes=150
#*.remote_listener='rac-cluster:1521'
*.remote_login_passwordfile='exclusive'
*.sga_target=946864128
*.star_transformation_enabled='TRUE'
*.db_unique_name='dg'
*.log_archive_config='dg_config=(rac,dg)'
*.log_archive_dest_1=
 'location=/opt/oracle/oradata/rac/archive
  valid_for=(all_logfiles,all_roles)
  db_unique_name=dg'
*.log_archive_dest_2=
 'service=rac async
  valid_for=(online_logfiles,primary_role)
  db_unique_name=rac'
*.log_archive_dest_state_1=enable
*.log_archive_dest_state_2=enable
*.standby_file_management=auto
*.fal_server=rac1,rac2
*.fal_client=dg
*.thread=1
*.db_file_name_convert='+DATABASEDG/rac/datafile/','/opt/oracle/oradata/rac/','+EPORTDG/rac/datafile/','/opt/oracle/oradata/rac/'
*.log_file_name_convert='+BACKUPDG/rac/onlinelog/','/opt/oracle/oradata/rac/','+DATABASEDG/rac/datafile/','/opt/oracle/oradata/rac/' 










[oracle@rac1 ~]$ sqlplus /nolog


SQL*Plus: Release 11.2.0.3.0 Production on Mon Mar 3 06:50:03 2014


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


SQL> connect / as sysdba
Connected.
SQL> alter system set db_unique_name=rac scope=spfile sid='*';
alter system set log_archive_config='dg_config=(rac,dg)' scope=both sid='*';
System altered.


SQL> 


System altered.


SQL> alter system set log_archive_dest_3= 'service=dg async  valid_for=(online_logfiles,primary_role) db_unique_name=dg' scope=both sid='*';
alter system set log_archive_dest_state_3=enable scope=both sid='*';
System altered.


SQL> 


System altered.


SQL> alter system set standby_file_management=auto scope=both sid='*';
alter system set fal_server=dg scope=both sid='*';
alter system set fal_client=rac1 scope=both sid='rac1';
alter system set fal_client=rac2 scope=both sid='rac2';
System altered.


SQL> 
System altered.


SQL> 
System altered.


SQL> 


System altered.


SQL> 
SQL> alter system set db_file_name_convert='/opt/oracle/oradata/rac/','+DATABASEDG/rac/datafile/','/opt/oracle/oradata/rac/','+EPORTDG/rac/datafile/' scope=spfile sid='*';
alter system set log_file_name_convert='/opt/oracle/oradata/rac/','+BACKUPDG/rac/onlinelog/','/opt/oracle/oradata/rac/','+DATABASEDG/rac/datafile/' scope=spfile sid='*';   


System altered.


SQL> 
System altered.


SQL> 
SQL> 








-bash-3.2$ sqlplus /nolog


SQL*Plus: Release 11.2.0.3.0 Production on Mon Mar 3 14:30:37 2014


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


SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup nomount pfile='/opt/oracle/oradata/rac/initdg.ora';
ORACLE instance started.


Total System Global Area  945786880 bytes
Fixed Size                  1348888 bytes
Variable Size             478153448 bytes
Database Buffers          457179136 bytes
Redo Buffers                9105408 bytes
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
-bash-3.2$ rman target sys/sys123@rac1 auxiliary /


Recovery Manager: Release 11.2.0.3.0 - Production on Mon Mar 3 14:33:14 2014


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


connected to target database: RAC (DBID=2424771316)
connected to auxiliary database: RAC (not mounted)


RMAN> duplicate target database for standby dorecover nofilenamecheck;


Starting Duplicate Db at 03-MAR-14
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=254 device type=DISK


contents of Memory Script:
{
   set until scn  9548214488081;
   restore clone standby controlfile;
}
executing Memory Script


executing command: SET until clause


Starting restore at 03-MAR-14
using channel ORA_AUX_DISK_1


channel ORA_AUX_DISK_1: restoring control file
ORA-19625: error identifying file /u01/standby.ctl
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-19600: input file is control file  (/u01/standby.ctl)
ORA-19601: output file is control file  (/opt/oracle/oradata/rac/standby.ctl)


failover to previous backup


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 /u01/backup/rac_20140224_18_1.ctl
channel ORA_AUX_DISK_1: piece handle=/u01/backup/rac_20140224_18_1.ctl tag=TAG20140224T084434
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/opt/oracle/oradata/rac/standby.ctl
Finished restore at 03-MAR-14


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 until scn  9548214488081;
   set newname for tempfile  1 to 
 "+databasedg";
   switch clone tempfile all;
   set newname for datafile  1 to 
 "/opt/oracle/oradata/rac/system.256.836789011";
   set newname for datafile  2 to 
 "/opt/oracle/oradata/rac/sysaux.257.836789015";
   set newname for datafile  3 to 
 "/opt/oracle/oradata/rac/undotbs1.258.836789019";
   set newname for datafile  4 to 
 "/opt/oracle/oradata/rac/users.259.836789019";
   set newname for datafile  5 to 
 "/opt/oracle/oradata/rac/undotbs2.266.836810891";
   set newname for datafile  6 to 
 "/opt/oracle/oradata/rac/eport.256.839815189";
   set newname for datafile  7 to 
 "/opt/oracle/oradata/rac/eport.257.839815371";
   restore
   clone database
   ;
}
executing Memory Script


executing command: SET until clause


executing command: SET NEWNAME


renamed tempfile 1 to +databasedg in control file


executing command: SET NEWNAME


executing command: SET NEWNAME


executing command: SET NEWNAME


executing command: SET NEWNAME


executing command: SET NEWNAME


executing command: SET NEWNAME


executing command: SET NEWNAME


Starting restore at 03-MAR-14
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 /opt/oracle/oradata/rac/system.256.836789011
channel ORA_AUX_DISK_1: restoring datafile 00002 to /opt/oracle/oradata/rac/sysaux.257.836789015
channel ORA_AUX_DISK_1: restoring datafile 00006 to /opt/oracle/oradata/rac/eport.256.839815189
channel ORA_AUX_DISK_1: reading from backup piece /u01/backup/rac_20140224_13_1.dbf
channel ORA_AUX_DISK_1: piece handle=/u01/backup/rac_20140224_13_1.dbf tag=TAG20140224T073034
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:04:35
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 00003 to /opt/oracle/oradata/rac/undotbs1.258.836789019
channel ORA_AUX_DISK_1: restoring datafile 00004 to /opt/oracle/oradata/rac/users.259.836789019
channel ORA_AUX_DISK_1: restoring datafile 00005 to /opt/oracle/oradata/rac/undotbs2.266.836810891
channel ORA_AUX_DISK_1: restoring datafile 00007 to /opt/oracle/oradata/rac/eport.257.839815371
channel ORA_AUX_DISK_1: reading from backup piece /u01/backup/rac_20140224_14_1.dbf
channel ORA_AUX_DISK_1: piece handle=/u01/backup/rac_20140224_14_1.dbf tag=TAG20140224T073034
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:04:15
Finished restore at 03-MAR-14


contents of Memory Script:
{
   switch clone datafile all;
}
executing Memory Script


datafile 1 switched to datafile copy
input datafile copy RECID=1 STAMP=841243413 file name=/opt/oracle/oradata/rac/system.256.836789011
datafile 2 switched to datafile copy
input datafile copy RECID=2 STAMP=841243413 file name=/opt/oracle/oradata/rac/sysaux.257.836789015
datafile 3 switched to datafile copy
input datafile copy RECID=3 STAMP=841243413 file name=/opt/oracle/oradata/rac/undotbs1.258.836789019
datafile 4 switched to datafile copy
input datafile copy RECID=4 STAMP=841243413 file name=/opt/oracle/oradata/rac/users.259.836789019
datafile 5 switched to datafile copy
input datafile copy RECID=5 STAMP=841243413 file name=/opt/oracle/oradata/rac/undotbs2.266.836810891
datafile 6 switched to datafile copy
input datafile copy RECID=6 STAMP=841243413 file name=/opt/oracle/oradata/rac/eport.256.839815189
datafile 7 switched to datafile copy
input datafile copy RECID=7 STAMP=841243413 file name=/opt/oracle/oradata/rac/eport.257.839815371


contents of Memory Script:
{
   set until scn  9548214488081;
   recover
   standby
   clone database
    delete archivelog
   ;
}
executing Memory Script


executing command: SET until clause


Starting recover at 03-MAR-14
using channel ORA_AUX_DISK_1


starting media recovery


channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=33
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=1011
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=1012
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=34
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=35
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=1013
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=36
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=1014
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=1015
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=37
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=1016
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=38
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=1017
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=39
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=1018
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=40
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=1019
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=1020
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=41
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=1021
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=42
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=43
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=1022
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=44
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=1023
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=45
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=1024
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=1025
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=46
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=47
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=1026
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=48
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=49
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=1027
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=1028
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=50
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=51
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=52
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=53
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=54
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=55
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=56
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=57
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=58
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=59
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=60
channel ORA_AUX_DISK_1: reading from backup piece /u01/backup/ar_RAC_21_1_841213288.arc
channel ORA_AUX_DISK_1: piece handle=/u01/backup/ar_RAC_21_1_841213288.arc tag=TAG20140303T061534
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:25
archived log file name=/opt/oracle/oradata/rac/archive/1_33_839321989.dbf thread=1 sequence=33
archived log file name=/opt/oracle/oradata/rac/archive/2_1011_839321989.dbf thread=2 sequence=1011
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/2_1011_839321989.dbf RECID=15 STAMP=841243446
archived log file name=/opt/oracle/oradata/rac/archive/2_1012_839321989.dbf thread=2 sequence=1012
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/1_33_839321989.dbf RECID=14 STAMP=841243445
archived log file name=/opt/oracle/oradata/rac/archive/1_34_839321989.dbf thread=1 sequence=34
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/1_34_839321989.dbf RECID=34 STAMP=841243446
archived log file name=/opt/oracle/oradata/rac/archive/1_35_839321989.dbf thread=1 sequence=35
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/2_1012_839321989.dbf RECID=33 STAMP=841243446
archived log file name=/opt/oracle/oradata/rac/archive/2_1013_839321989.dbf thread=2 sequence=1013
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/1_35_839321989.dbf RECID=30 STAMP=841243446
archived log file name=/opt/oracle/oradata/rac/archive/1_36_839321989.dbf thread=1 sequence=36
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/2_1013_839321989.dbf RECID=31 STAMP=841243446
archived log file name=/opt/oracle/oradata/rac/archive/2_1014_839321989.dbf thread=2 sequence=1014
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/2_1014_839321989.dbf RECID=36 STAMP=841243446
archived log file name=/opt/oracle/oradata/rac/archive/2_1015_839321989.dbf thread=2 sequence=1015
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/1_36_839321989.dbf RECID=35 STAMP=841243446
archived log file name=/opt/oracle/oradata/rac/archive/1_37_839321989.dbf thread=1 sequence=37
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/2_1015_839321989.dbf RECID=37 STAMP=841243446
archived log file name=/opt/oracle/oradata/rac/archive/2_1016_839321989.dbf thread=2 sequence=1016
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/1_37_839321989.dbf RECID=29 STAMP=841243446
archived log file name=/opt/oracle/oradata/rac/archive/1_38_839321989.dbf thread=1 sequence=38
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/2_1016_839321989.dbf RECID=38 STAMP=841243446
archived log file name=/opt/oracle/oradata/rac/archive/2_1017_839321989.dbf thread=2 sequence=1017
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/1_38_839321989.dbf RECID=28 STAMP=841243446
archived log file name=/opt/oracle/oradata/rac/archive/1_39_839321989.dbf thread=1 sequence=39
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/2_1017_839321989.dbf RECID=6 STAMP=841243441
archived log file name=/opt/oracle/oradata/rac/archive/2_1018_839321989.dbf thread=2 sequence=1018
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/1_39_839321989.dbf RECID=1 STAMP=841243438
archived log file name=/opt/oracle/oradata/rac/archive/1_40_839321989.dbf thread=1 sequence=40
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/2_1018_839321989.dbf RECID=7 STAMP=841243441
archived log file name=/opt/oracle/oradata/rac/archive/2_1019_839321989.dbf thread=2 sequence=1019
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/2_1019_839321989.dbf RECID=44 STAMP=841243447
archived log file name=/opt/oracle/oradata/rac/archive/2_1020_839321989.dbf thread=2 sequence=1020
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/1_40_839321989.dbf RECID=42 STAMP=841243447
archived log file name=/opt/oracle/oradata/rac/archive/1_41_839321989.dbf thread=1 sequence=41
archived log file name=/opt/oracle/oradata/rac/archive/1_42_839321989.dbf thread=1 sequence=42
archived log file name=/opt/oracle/oradata/rac/archive/2_1021_839321989.dbf thread=2 sequence=1021
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/1_41_839321989.dbf RECID=17 STAMP=841243446
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/1_42_839321989.dbf RECID=39 STAMP=841243446
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/2_1020_839321989.dbf RECID=12 STAMP=841243445
archived log file name=/opt/oracle/oradata/rac/archive/1_43_839321989.dbf thread=1 sequence=43
archived log file name=/opt/oracle/oradata/rac/archive/2_1022_839321989.dbf thread=2 sequence=1022
archived log file name=/opt/oracle/oradata/rac/archive/1_44_839321989.dbf thread=1 sequence=44
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/1_43_839321989.dbf RECID=18 STAMP=841243446
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/2_1021_839321989.dbf RECID=20 STAMP=841243446
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/2_1022_839321989.dbf RECID=16 STAMP=841243446
archived log file name=/opt/oracle/oradata/rac/archive/2_1023_839321989.dbf thread=2 sequence=1023
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/1_44_839321989.dbf RECID=13 STAMP=841243445
archived log file name=/opt/oracle/oradata/rac/archive/1_45_839321989.dbf thread=1 sequence=45
archived log file name=/opt/oracle/oradata/rac/archive/2_1024_839321989.dbf thread=2 sequence=1024
archived log file name=/opt/oracle/oradata/rac/archive/2_1025_839321989.dbf thread=2 sequence=1025
archived log file name=/opt/oracle/oradata/rac/archive/1_46_839321989.dbf thread=1 sequence=46
archived log file name=/opt/oracle/oradata/rac/archive/1_47_839321989.dbf thread=1 sequence=47
archived log file name=/opt/oracle/oradata/rac/archive/1_48_839321989.dbf thread=1 sequence=48
archived log file name=/opt/oracle/oradata/rac/archive/2_1026_839321989.dbf thread=2 sequence=1026
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/1_45_839321989.dbf RECID=10 STAMP=841243444
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/1_46_839321989.dbf RECID=26 STAMP=841243446
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/1_47_839321989.dbf RECID=21 STAMP=841243446
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/1_48_839321989.dbf RECID=41 STAMP=841243446
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/2_1023_839321989.dbf RECID=40 STAMP=841243446
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/2_1024_839321989.dbf RECID=22 STAMP=841243446
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/2_1025_839321989.dbf RECID=19 STAMP=841243446
archived log file name=/opt/oracle/oradata/rac/archive/1_49_839321989.dbf thread=1 sequence=49
archived log file name=/opt/oracle/oradata/rac/archive/2_1027_839321989.dbf thread=2 sequence=1027
archived log file name=/opt/oracle/oradata/rac/archive/2_1028_839321989.dbf thread=2 sequence=1028
archived log file name=/opt/oracle/oradata/rac/archive/1_50_839321989.dbf thread=1 sequence=50
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/1_49_839321989.dbf RECID=3 STAMP=841243440
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/1_50_839321989.dbf RECID=4 STAMP=841243440
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/2_1026_839321989.dbf RECID=23 STAMP=841243446
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/2_1027_839321989.dbf RECID=24 STAMP=841243446
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/2_1028_839321989.dbf RECID=25 STAMP=841243446
archived log file name=/opt/oracle/oradata/rac/archive/1_51_839321989.dbf thread=1 sequence=51
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/1_51_839321989.dbf RECID=46 STAMP=841243447
archived log file name=/opt/oracle/oradata/rac/archive/1_52_839321989.dbf thread=1 sequence=52
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/1_52_839321989.dbf RECID=45 STAMP=841243447
archived log file name=/opt/oracle/oradata/rac/archive/1_53_839321989.dbf thread=1 sequence=53
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/1_53_839321989.dbf RECID=8 STAMP=841243441
archived log file name=/opt/oracle/oradata/rac/archive/1_54_839321989.dbf thread=1 sequence=54
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/1_54_839321989.dbf RECID=2 STAMP=841243439
archived log file name=/opt/oracle/oradata/rac/archive/1_55_839321989.dbf thread=1 sequence=55
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/1_55_839321989.dbf RECID=43 STAMP=841243447
archived log file name=/opt/oracle/oradata/rac/archive/1_56_839321989.dbf thread=1 sequence=56
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/1_56_839321989.dbf RECID=5 STAMP=841243440
archived log file name=/opt/oracle/oradata/rac/archive/1_57_839321989.dbf thread=1 sequence=57
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/1_57_839321989.dbf RECID=11 STAMP=841243445
archived log file name=/opt/oracle/oradata/rac/archive/1_58_839321989.dbf thread=1 sequence=58
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/1_58_839321989.dbf RECID=9 STAMP=841243443
archived log file name=/opt/oracle/oradata/rac/archive/1_59_839321989.dbf thread=1 sequence=59
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/1_59_839321989.dbf RECID=32 STAMP=841243446
archived log file name=/opt/oracle/oradata/rac/archive/1_60_839321989.dbf thread=1 sequence=60
channel clone_default: deleting archived log(s)
archived log file name=/opt/oracle/oradata/rac/archive/1_60_839321989.dbf RECID=27 STAMP=841243446
media recovery complete, elapsed time: 00:01:27
Finished recover at 03-MAR-14
Finished Duplicate Db at 03-MAR-14


RMAN> exit




Recovery Manager complete.
-bash-3.2$ sqlplus /nolog


SQL*Plus: Release 11.2.0.3.0 Production on Mon Mar 3 14:50:19 2014


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


SQL> connect / as sysdba
Connected.
SQL> alter database recover managed standby database using current logfile disconnect from session;
alter database recover managed standby database using current logfile disconnect from session
*
ERROR at line 1:
ORA-38500: USING CURRENT LOGFILE option not available without standby redo logs




SQL> alter database add standby logfile thread 1 group 7 ('/opt/oracle/oradata/rac/archive/stdbyredo_1_07.log') size 100m;


Database altered.


SQL> alter database add standby logfile thread 1 group 8 ('/opt/oracle/oradata/rac/archive/stdbyredo_1_08.log') size 100m;
alter database add standby logfile thread 1 group 9 ('/opt/oracle/oradata/rac/archive/stdbyredo_1_09.log') size 100m;
alter database add standby logfile thread 1 group 10 ('/opt/oracle/oradata/rac/archive/stdbyredo_1_10.log') size 100m; 


alter database add standby logfile thread 2 group 11 ('/opt/oracle/oradata/rac/archive/stdbyredo_2_11.log') size 100m;
alter database add standby logfile thread 2 group 12 ('/opt/oracle/oradata/rac/archive/stdbyredo_2_12.log') size 100m;
alter database add standby logfile thread 2 group 13 ('/opt/oracle/oradata/rac/archive/stdbyredo_2_13.log') size 100m;
alter database add standby logfile thread 2 group 14 ('/opt/oracle/oradata/rac/archive/stdbyredo_1_14.log') size 100m; 


Database altered.


SQL> 
Database altered.


SQL> 
Database altered.


SQL> SQL> 
Database altered.


SQL> 
Database altered.


SQL> 
Database altered.


SQL> 
Database altered.


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


Database altered.


SQL> 








[grid@rac1 dbs]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.BACKUPDG.dg
               ONLINE  ONLINE       rac1                                         
               ONLINE  ONLINE       rac2                                         
ora.DATA.dg
               ONLINE  ONLINE       rac1                                         
               ONLINE  ONLINE       rac2                                         
ora.DATABASEDG.dg
               ONLINE  ONLINE       rac1                                         
               ONLINE  ONLINE       rac2                                         
ora.EPORTDG.dg
               ONLINE  ONLINE       rac1                                         
               ONLINE  ONLINE       rac2                                         
ora.LISTENER.lsnr
               ONLINE  ONLINE       rac1                                         
               ONLINE  ONLINE       rac2                                         
ora.asm
               ONLINE  ONLINE       rac1                     Started             
               ONLINE  ONLINE       rac2                     Started             
ora.gsd
               OFFLINE OFFLINE      rac1                                         
               OFFLINE OFFLINE      rac2                                         
ora.net1.network
               ONLINE  ONLINE       rac1                                         
               ONLINE  ONLINE       rac2                                         
ora.ons
               ONLINE  ONLINE       rac1                                         
               ONLINE  ONLINE       rac2                                         
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac1                                         
ora.cvu
      1        ONLINE  ONLINE       rac1                                         
ora.oc4j
      1        ONLINE  ONLINE       rac1                                         
ora.rac.db
      1        ONLINE  ONLINE       rac1                     Open                
      2        OFFLINE OFFLINE                               Instance Shutdown   
ora.rac1.vip
      1        ONLINE  ONLINE       rac1                                         
ora.rac2.vip
      1        ONLINE  ONLINE       rac2                                         
ora.scan1.vip
      1        ONLINE  ONLINE       rac1