Creation of 2 Node RAC to non RAC DR (12c)

Steps to create 2 node RAC to non RAC physical standby

• Kindly follow steps to create standby database using url
• Make changes on RAC using spfile , So it will reflect on both instances.
• Make changes on  initstdrac file.
• Add tns entry on both primary and standby on tnsnames.ora file
• Restart listener and tnsping to check tns entry
• start standby database in nomount state using pfile
• Connect rman using Auxiliary db.
• Duplicate target database for standby nofilenamecheck
• Start MRP0 process on standby using recover command at session.

• Copy password file from ASM to local disk 

ASMCMD> pwd

+DATA/rac/PASSWORD

ASMCMD> ls

pwdrac.256.1088276167

ASMCMD> 

ASMCMD> ls

pwdrac.256.1088276167

ASMCMD> pwcopy pwdrac.256.1088276167 /tmp

copying +DATA/rac/PASSWORD/pwdrac.256.1088276167 -> /tmp/pwdrac.256.1088276167

ASMCMD> 

• Add standby logfile on primary rac instance 

SQL> ALTER DATABASE ADD STANDBY LOGFILE group 5 ('+DATA/RAC/ONLINELOG/redo05.log') size 200M;

Database altered.

SQL> ALTER DATABASE ADD STANDBY LOGFILE group 6 ('+DATA/RAC/ONLINELOG/redo06.log') size 200M;

Database altered.

SQL> ALTER DATABASE ADD STANDBY LOGFILE group 7 ('+DATA/RAC/ONLINELOG/redo07.log') size 200M;

Database altered.

• Some parameters used for standby creations  we can change same in pfile or dynamically using spfile.

db_unique_name='rac'

alter system set LOG_ARCHIVE_CONFIG='DG_CONFIG=(rac,racdr)' scope=both sid='*';

alter system set LOG_ARCHIVE_DEST_2='SERVICE=racdr LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=racdr' scope=both sid='*';

alter system set fal_server=racdr scope=both sid='*';

alter system set fal_client=rac scope=both sid='*';

alter system set standby_file_management=auto scope=both sid='*';

alter system set log_file_name_convert='/u01/app/oracle/oradata/racdr/','+DATA/RAC' scope=spfile sid='*';

alter system set db_file_name_convert='/u01/app/oracle/oradata/racdr/','+DATA/RAC' scope=spfile sid='*';

SQL> alter system set LOG_ARCHIVE_CONFIG='DG_CONFIG=(rac,racdr)' scope=both;

System altered.

SQL> alter system set LOG_ARCHIVE_DEST_2='SERVICE=racdr LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=racdr' scope=both;

System altered.

SQL> alter system set fal_server=racdr scope=both;

System altered.

SQL> alter system set fal_client=rac scope=both;

System altered.

SQL> alter system set standby_file_management=auto scope=both;

System altered.

SQL> alter system set log_file_name_convert='+DATA/RAC','/u01/app/oracle/oradata/racdr' scope=spfile; sid='*';;

System altered.

SQL> alter system set db_file_name_convert='+DATA/RAC','/u01/app/oracle/oradata/racdr' scope=spfile; sid='*';

System altered.

SQL> 

• Stop database instance using srvctl command for changes. 

[root@srv1 dbs]# srvctl status database -d rac

Instance rac1 is running on node srv1

Instance rac2 is running on node srv2

[root@srv1 dbs]# srvctl stop  database -d rac

[root@srv1 dbs]# srvctl start  database -d rac

[root@srv1 dbs]# srvctl status  database -d rac

Instance rac1 is running on node srv1

Instance rac2 is running on node srv2

[root@srv1 dbs]# 

• Pfile parameter entry in instance rac1 (This is information purpose only  you can make both  entry dynamically and static also) 

[oracle@srv1 dbs]$ cat initrac1.ora
rac2.__data_transfer_cache_size=0
rac1.__data_transfer_cache_size=0
rac2.__db_cache_size=1207959552
rac1.__db_cache_size=1191182336
rac2.__java_pool_size=16777216
rac1.__java_pool_size=16777216
rac2.__large_pool_size=33554432
rac1.__large_pool_size=33554432
rac2.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
rac1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
rac2.__pga_aggregate_target=603979776
rac1.__pga_aggregate_target=603979776
rac2.__sga_target=1795162112
rac1.__sga_target=1795162112
rac2.__shared_io_pool_size=83886080
rac1.__shared_io_pool_size=83886080
rac2.__shared_pool_size=436207616
rac1.__shared_pool_size=452984832
rac2.__streams_pool_size=0
rac1.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/rac/adump'
*.audit_trail='db'
*.cluster_database=true
*.compatible='12.1.0.2.0'
*.control_files='+DATA/RAC/CONTROLFILE/current.273.1020351747','+FRA/RAC/CONTROLFILE/current.261.1020351747'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_domain=''
*.db_name='rac'
*.db_unique_name='rac'
*.LOG_ARCHIVE_DEST_2='SERVICE=stdrac LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=stdrac'
*.fal_server=stdrac
*.fal_client=rac
*.standby_file_management=auto
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(rac,stdrac)'
*.log_file_name_convert='/u01/app/oracle/fast_recovery_area/RAC/onlinelog/','+DATA/RAC/ONLINELOG/'
*.db_file_name_convert='/u01/app/oracle/oradata/RAC/','+DATA/RAC/DATAFILE/'
*.db_recovery_file_dest='+FRA'
*.db_recovery_file_dest_size=4785m
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=racXDB)'
rac2.instance_number=2
rac1.instance_number=1
RAC1.local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.81)(PORT=1521))'
RAC2.local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.82)(PORT=1521))'
*.log_archive_dest_1='LOCATION=+FRA/RAC/ARCHIVELOG'
*.open_cursors=300
*.pga_aggregate_target=570m
*.processes=300
*.remote_listener='srv-scan:1521'
*.remote_login_passwordfile='exclusive'
*.resource_manager_plan=''
*.sga_target=1710m
rac2.thread=2
rac1.thread=1
rac1.undo_tablespace='UNDOTBS1'
rac2.undo_tablespace='UNDOTBS2'
[oracle@srv1 dbs]$

#################################################################################

• Tnsnames.ora

[oracle@srv1 admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.1.0/dbhome_2/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

PRETAF =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = srv-scan.example.com)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = pretaf)
    )
  )


STDRAC =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = srv3.example.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = STDRAC)
    )
  )
[oracle@srv1 admin]$

• Standby Pfile 

[root@srv3 dbs]# cat initSTDRAC.ora

STDRAC.__data_transfer_cache_size=0

STDRAC.__db_cache_size=260046848

STDRAC.__java_pool_size=4194304

STDRAC.__large_pool_size=8388608

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

STDRAC.__pga_aggregate_target=301989888

STDRAC.__sga_target=452984832

STDRAC.__shared_io_pool_size=12582912

STDRAC.__shared_pool_size=159383552

STDRAC.__streams_pool_size=0

*.audit_file_dest='/u01/app/oracle/admin/STDRAC/adump'

*.audit_trail='db'

*.compatible='12.1.0.2.0'

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

*.db_block_size=8192

*.db_domain=''

*.db_name='RAC'

*.db_unique_name='STDRAC'

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

*.fal_server=rac

*.fal_client=stdrac

*.standby_file_management=auto

*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(stdrac,rac)'

*.log_file_name_convert='+DATA/RAC/ONLINELOG/,'/u01/app/oracle/fast_recovery_area/RAC/onlinelog/'

*.db_file_name_convert='+DATA/RAC/DATAFILE/','/u01/app/oracle/oradata/RAC/'

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

*.db_recovery_file_dest_size=4560m

*.diagnostic_dest='/u01/app/oracle'

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

*.log_archive_format='%t_%s_%r.dbf'

*.memory_target=720m

*.open_cursors=300

*.processes=300

*.remote_login_passwordfile='EXCLUSIVE'

*.undo_tablespace='UNDOTBS1'

*.LOG_ARCHIVE_DEST_STATE_2='ENABLE'

[root@srv3 dbs]#

• Login standby database and start db using pfile in no mount state 

[oracle@srv3 dbs]$ . oraenv
ORACLE_SID = [STDRAC] ?
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@srv3 dbs]$[oracle@srv3 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Fri Dec 6 19:12:03 2019

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

Connected to an idle instance.

SQL> startup nomount pfile='/u01/app/oracle/product/12.1.0/dbhome_1/dbs/initSTDRAC.ora';
ORACLE instance started.

Total System Global Area  754974720 bytes
Fixed Size                  2928968 bytes
Variable Size             566234808 bytes
Database Buffers          180355072 bytes
Redo Buffers                5455872 bytes
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

• login primary db with auxiliary instance 

[oracle@srv3 dbs]$  rman target sys/system123@pretaf auxiliary /

Recovery Manager: Release 12.1.0.2.0 - Production on Fri Dec 6 19:12:32 2019

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

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

• Run duplicate command for creating standby database 

RMAN> duplicate target database for standby nofilenamecheck;

Starting Duplicate Db at 06-DEC-2019 19:12:55
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=22 device type=DISK

contents of Memory Script:
{
   restore clone standby controlfile;
}
executing Memory Script

Starting restore at 06-DEC-2019 19:12:56
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 /u01/rmanbkp/44uimg4j_1_1
channel ORA_AUX_DISK_1: piece handle=/u01/rmanbkp/44uimg4j_1_1 tag=TAG20191205T195915
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/u01/app/oracle/oradata/STDRAC/control01.ctl
output file name=/u01/app/oracle/fast_recovery_area/STDRAC/control02.ctl
Finished restore at 06-DEC-2019 19:12:58

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
 "/u01/app/oracle/oradata/RAC/system.279.1020351597";
   set newname for datafile  2 to
 "/u01/app/oracle/oradata/RAC/idata.284.1020709157";
   set newname for datafile  3 to
 "/u01/app/oracle/oradata/RAC/sysaux.271.1020351511";
   set newname for datafile  4 to
 "/u01/app/oracle/oradata/RAC/undotbs1.270.1020351693";
   set newname for datafile  5 to
 "/u01/app/oracle/oradata/RAC/undotbs2.278.1020352203";
   set newname for datafile  6 to
 "/u01/app/oracle/oradata/RAC/users.272.1020351691";
   set newname for datafile  7 to
 "/u01/app/oracle/oradata/RAC/ilog.285.1020709245";
   set newname for datafile  8 to
 "/u01/app/oracle/oradata/RAC/indx.286.1020709561";
   restore
   clone database
   ;
}
executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to +DATA in control file

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 06-DEC-2019 19:13:03
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 /u01/app/oracle/oradata/RAC/system.279.1020351597
channel ORA_AUX_DISK_1: restoring datafile 00002 to /u01/app/oracle/oradata/RAC/idata.284.1020709157
channel ORA_AUX_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/RAC/sysaux.271.1020351511
channel ORA_AUX_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/RAC/undotbs1.270.1020351693
channel ORA_AUX_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/RAC/undotbs2.278.1020352203
channel ORA_AUX_DISK_1: restoring datafile 00006 to /u01/app/oracle/oradata/RAC/users.272.1020351691
channel ORA_AUX_DISK_1: restoring datafile 00007 to /u01/app/oracle/oradata/RAC/ilog.285.1020709245
channel ORA_AUX_DISK_1: restoring datafile 00008 to /u01/app/oracle/oradata/RAC/indx.286.1020709561
channel ORA_AUX_DISK_1: reading from backup piece /u01/rmanbkp/ RAC_41uimfth_1_1.bckp
channel ORA_AUX_DISK_1: piece handle=/u01/rmanbkp/ RAC_41uimfth_1_1.bckp tag=TAG20191205T195528
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:03:05
Finished restore at 06-DEC-2019 19:16:09

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

datafile 1 switched to datafile copy
input datafile copy RECID=5 STAMP=1026328569 file name=/u01/app/oracle/oradata/RAC/system.279.1020351597
datafile 2 switched to datafile copy
input datafile copy RECID=6 STAMP=1026328569 file name=/u01/app/oracle/oradata/RAC/idata.284.1020709157
datafile 3 switched to datafile copy
input datafile copy RECID=7 STAMP=1026328569 file name=/u01/app/oracle/oradata/RAC/sysaux.271.1020351511
datafile 4 switched to datafile copy
input datafile copy RECID=8 STAMP=1026328569 file name=/u01/app/oracle/oradata/RAC/undotbs1.270.1020351693
datafile 5 switched to datafile copy
input datafile copy RECID=9 STAMP=1026328569 file name=/u01/app/oracle/oradata/RAC/undotbs2.278.1020352203
datafile 6 switched to datafile copy
input datafile copy RECID=10 STAMP=1026328569 file name=/u01/app/oracle/oradata/RAC/users.272.1020351691
datafile 7 switched to datafile copy
input datafile copy RECID=11 STAMP=1026328569 file name=/u01/app/oracle/oradata/RAC/ilog.285.1020709245
datafile 8 switched to datafile copy
input datafile copy RECID=12 STAMP=1026328569 file name=/u01/app/oracle/oradata/RAC/indx.286.1020709561

Finished Duplicate Db at 06-DEC-2019 19:18:32

RMAN>
RMAN>

###############################################################################

• Login standby database and perform mrp process and check the same

[oracle@srv3 ~]$ . oraenv
ORACLE_SID = [stdrac] ?
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@srv3 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Wed Dec 11 12:31:54 2019

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> set lines 200
select name, instance_name,db_unique_name, open_mode, database_role, flashback_on  current_scn,to_char(standby_became_primary_scn) failover_scn from v$database,v$instance;
select PROCESS,STATUS, SEQUENCE#,THREAD# from v$managed_standby;SQL>
NAME      INSTANCE_NAME    DB_UNIQUE_NAME                 OPEN_MODE            DATABASE_ROLE    CURRENT_SCN        FAILOVER_SCN
--------- ---------------- ------------------------------ -------------------- ---------------- ------------------ ----------------------------------------
RAC       stdrac           STDRAC                         MOUNTED              PHYSICAL STANDBY NO                 0

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

SQL> select PROCESS,STATUS,THREAD#,SEQUENCE# from v$managed_standby;

PROCESS   STATUS          THREAD#  SEQUENCE#

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

ARCH      CONNECTED             0          0

ARCH      CONNECTED             0          0

ARCH      CONNECTED             0          0

ARCH      CONNECTED             0          0

MRP0      WAIT_FOR_LOG          2        610

RFS       IDLE                  0          0

RFS       IDLE                  1        583

RFS       IDLE                  0          0

RFS       IDLE                  0          0

RFS       IDLE                  2        610

RFS       IDLE                  0          0

PROCESS   STATUS          THREAD#  SEQUENCE#

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

RFS       IDLE                  0          0

12 rows selected.

SQL>

12c RAC 2 node RMAN Backup Restoration to standalone database archivelog log recovery

12c RAC RMAN Backup Restoration to standalone database archivelog log recovery

• RAC full rman backup 
•  Restore controlfile from rman backup
• Database mount
• Catalog start with
• Set new name fro datafile
• Restore and revover database
• Change redo logfile location
• recover database 
• Copy archivelog from RAC db to standalone database.
• recover database.

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

• open database in reset logs

• Check the status and group# of  redolog thread #2

• Disable Thread#2

• Clear un archived log of thread#2

• Check and drop undo tablespace of thread#2

• Create new tempfile and drop old tempfile, Mark new tempfile as default.

##########################################################################


SQL*Plus: Release 12.1.0.2.0 Production on Wed Jan 29 14:21:16 2020

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

Connected to an idle instance.

SQL> startup nomount;
ORACLE instance started.

Total System Global Area 3942645760 bytes
Fixed Size                  2931616 bytes
Variable Size             939525216 bytes
Database Buffers         2986344448 bytes
Redo Buffers               13844480 bytes
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
oracle@sgdcpl08:~> rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Wed Jan 29 14:23:35 2020

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

connected to target database: SMRRAC (not mounted)

RMAN> restore controlfile from '/u02/rman_smrrac/control_SMRRAC_20200129.bak';

Starting restore at 29-JAN-2020 14:23:50
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=527 device type=DISK

channel ORA_DISK_1: copied control file copy
output file name=/u01/app/oracle/oradata/smrrac/control01.ctl
output file name=/u01/app/oracle/fast_recovery_area/smrrac/control02.ctl
Finished restore at 29-JAN-2020 14:23:52

RMAN> alter database mount;

Statement processed
released channel: ORA_DISK_1

RMAN> catalog start with '/u02/rman_smrrac/';

Starting implicit crosscheck backup at 29-JAN-2020 14:24:45
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=357 device type=DISK
Crosschecked 255 objects
Finished implicit crosscheck backup at 29-JAN-2020 14:24:47

Starting implicit crosscheck copy at 29-JAN-2020 14:24:47
using channel ORA_DISK_1
Crosschecked 32 objects
Finished implicit crosscheck copy at 29-JAN-2020 14:24:47

searching for all files in the recovery area
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_27/o1_mf_1_15_h2x2qfh7_.arc
File Name: /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_27/o1_mf_1_16_h2x34psh_.arc
File Name: /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_27/o1_mf_1_17_h2xv84yz_.arc
File Name: /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_27/o1_mf_1_18_h2ymtxvt_.arc
File Name: /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_27/o1_mf_1_19_h2ymvdw9_.arc
File Name: /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_27/o1_mf_1_20_h2ymw7wl_.arc
File Name: /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_28/o1_mf_1_21_h2zctr18_.arc
File Name: /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_28/o1_mf_1_22_h30m5d1k_.arc
File Name: /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_28/o1_mf_1_23_h3186wg5_.arc
File Name: /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/o1_mf_1_24_h32cdtx0_.arc

searching for all files that match the pattern /u02/rman_smrrac/

List of Files Unknown to the Database
=====================================
File Name: /u02/rman_smrrac/Backup_SMRRAC_DB_lkun6eo2_1716_1_20200129
File Name: /u02/rman_smrrac/Backup_SMRRAC_DB_llun6esu_1717_1_20200129
File Name: /u02/rman_smrrac/Backup_SMRRAC_DB_lhun6eo1_1713_1_20200129
File Name: /u02/rman_smrrac/Backup_SMRRAC_DB_ljun6eo2_1715_1_20200129
File Name: /u02/rman_smrrac/Backup_SMRRAC_DB_liun6eo1_1714_1_20200129
File Name: /u02/rman_smrrac/Backup_SMRRAC_DB_loun6etd_1720_1_20200129
File Name: /u02/rman_smrrac/Backup_SMRRAC_DB_lqun6etg_1722_1_20200129
File Name: /u02/rman_smrrac/Backup_SMRRAC_DB_lrun6eti_1723_1_20200129
File Name: /u02/rman_smrrac/Backup_SMRRAC_DB_lnun6etd_1719_1_20200129
File Name: /u02/rman_smrrac/Backup_SMRRAC_DB_lpun6etd_1721_1_20200129
File Name: /u02/rman_smrrac/Backup_SMRRAC_DB_lmun6etd_1718_1_20200129
File Name: /u02/rman_smrrac/Backup_SMRRAC_DB_lsun6f1a_1724_1_20200129
File Name: /u02/rman_smrrac/Backup_SMRRAC_DB_ltun6f1a_1725_1_20200129
File Name: /u02/rman_smrrac/control_SMRRAC_20200129.bak
File Name: /u02/rman_smrrac/standbycontrol_SMRRAC_lvun6f1d_1_1.ctl

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

List of Cataloged Files
=======================
File Name: /u02/rman_smrrac/Backup_SMRRAC_DB_lkun6eo2_1716_1_20200129
File Name: /u02/rman_smrrac/Backup_SMRRAC_DB_llun6esu_1717_1_20200129
File Name: /u02/rman_smrrac/Backup_SMRRAC_DB_lhun6eo1_1713_1_20200129
File Name: /u02/rman_smrrac/Backup_SMRRAC_DB_ljun6eo2_1715_1_20200129
File Name: /u02/rman_smrrac/Backup_SMRRAC_DB_liun6eo1_1714_1_20200129
File Name: /u02/rman_smrrac/Backup_SMRRAC_DB_loun6etd_1720_1_20200129
File Name: /u02/rman_smrrac/Backup_SMRRAC_DB_lqun6etg_1722_1_20200129
File Name: /u02/rman_smrrac/Backup_SMRRAC_DB_lrun6eti_1723_1_20200129
File Name: /u02/rman_smrrac/Backup_SMRRAC_DB_lnun6etd_1719_1_20200129
File Name: /u02/rman_smrrac/Backup_SMRRAC_DB_lpun6etd_1721_1_20200129
File Name: /u02/rman_smrrac/Backup_SMRRAC_DB_lmun6etd_1718_1_20200129
File Name: /u02/rman_smrrac/Backup_SMRRAC_DB_lsun6f1a_1724_1_20200129
File Name: /u02/rman_smrrac/Backup_SMRRAC_DB_ltun6f1a_1725_1_20200129
File Name: /u02/rman_smrrac/control_SMRRAC_20200129.bak
File Name: /u02/rman_smrrac/standbycontrol_SMRRAC_lvun6f1d_1_1.ctl

RMAN> run
{
set newname for datafile 1 to "/u01/app/oracle/oradata/smrrac/system01.dbf";
set newname for datafile 2 to "/u02/oradata/smrrac/idata01.dbf";
set newname for datafile 3 to "/u01/app/oracle/oradata/smrrac/sysaux01.dbf";
set newname for datafile 4 to "/u01/app/oracle/oradata/smrrac/undotbs01.dbf";
set newname for datafile 5 to "/u01/app/oracle/oradata/smrrac/undotbs02.dbf";
set newname for datafile 6 to "/u02/oradata/smrrac/users01.dbf";
set newname for datafile 7 to "/u02/oradata/smrrac/ilog01.dbf";
2> 3> 4> set newname for datafile 8 to "/u02/oradata/smrrac/indx01.dbf";
5> 6> 7> 8> 9> 10> 11> set newname for tempfile 1 to "/u01/app/oracle/oradata/smrrac/temp01.dbf";
RESTORE DATABASE;
SWITCH DATAFILE ALL;
SWITCH TEMPFILE ALL;12> 13> 14>
15> }

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 29-JAN-2020 14:25:28
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 00004 to /u01/app/oracle/oradata/smrrac/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/smrrac/undotbs02.dbf
channel ORA_DISK_1: reading from backup piece /u02/rman_smrrac/Backup_SMRRAC_DB_loun6etd_1720_1_20200129
channel ORA_DISK_1: piece handle=/u02/rman_smrrac/Backup_SMRRAC_DB_loun6etd_1720_1_20200129 tag=TAG20200129T102133
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/smrrac/system01.dbf
channel ORA_DISK_1: restoring datafile 00008 to /u02/oradata/smrrac/indx01.dbf
channel ORA_DISK_1: reading from backup piece /u02/rman_smrrac/Backup_SMRRAC_DB_lnun6etd_1719_1_20200129
channel ORA_DISK_1: piece handle=/u02/rman_smrrac/Backup_SMRRAC_DB_lnun6etd_1719_1_20200129 tag=TAG20200129T102133
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:35
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 00003 to /u01/app/oracle/oradata/smrrac/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00007 to /u02/oradata/smrrac/ilog01.dbf
channel ORA_DISK_1: reading from backup piece /u02/rman_smrrac/Backup_SMRRAC_DB_lpun6etd_1721_1_20200129
channel ORA_DISK_1: piece handle=/u02/rman_smrrac/Backup_SMRRAC_DB_lpun6etd_1721_1_20200129 tag=TAG20200129T102133
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00: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 00002 to /u02/oradata/smrrac/idata01.dbf
channel ORA_DISK_1: restoring datafile 00006 to /u02/oradata/smrrac/users01.dbf
channel ORA_DISK_1: reading from backup piece /u02/rman_smrrac/Backup_SMRRAC_DB_lmun6etd_1718_1_20200129
channel ORA_DISK_1: piece handle=/u02/rman_smrrac/Backup_SMRRAC_DB_lmun6etd_1718_1_20200129 tag=TAG20200129T102133
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:02:45
Finished restore at 29-JAN-2020 14:29:58

datafile 1 switched to datafile copy
input datafile copy RECID=122 STAMP=1030976998 file name=/u01/app/oracle/oradata/smrrac/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=123 STAMP=1030976998 file name=/u02/oradata/smrrac/idata01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=124 STAMP=1030976998 file name=/u01/app/oracle/oradata/smrrac/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=125 STAMP=1030976998 file name=/u01/app/oracle/oradata/smrrac/undotbs01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=126 STAMP=1030976998 file name=/u01/app/oracle/oradata/smrrac/undotbs02.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=127 STAMP=1030976998 file name=/u02/oradata/smrrac/users01.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=128 STAMP=1030976998 file name=/u02/oradata/smrrac/ilog01.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=129 STAMP=1030976998 file name=/u02/oradata/smrrac/indx01.dbf

renamed tempfile 1 to /u01/app/oracle/oradata/smrrac/temp01.dbf in control file

RMAN> exit


Recovery Manager complete.
oracle@sgdcpl08:~> sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Wed Jan 29 14:48:34 2020

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> @d

NAME      INSTANCE_NAME    DB_UNIQUE_NAME                 OPEN_MODE            DATABASE_ROLE    CURRENT_SCN        FAILOVER_SCN
--------- ---------------- ------------------------------ -------------------- ---------------- ------------------ ----------------------------------------
SMRRAC    smrrac           smrrac                         MOUNTED              PRIMARY          YES                0

SQL> recover database until cancel;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

################################################################################

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
oracle@sgdcpl08:~> sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Wed Jan 29 14:50:54 2020

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
oracle@sgdcpl08:~> rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Wed Jan 29 14:50:58 2020

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

connected to target database: SMRRAC (DBID=4255065810, not open)

RMAN> SQL "ALTER DATABASE RENAME FILE ''+DATA/SMRRAC/ONLINELOG/group_1.267.1020692667''  to  ''/u01/app/oracle/oradata/smrrac/redo01.log'' ";
SQL "ALTER DATABASE RENAME FILE ''+FRA1/SMRRAC/ONLINELOG/group_1.260.1020692669''  to  ''/u01/app/oracle/oradata/smrrac/redo02.log'' ";
SQL "ALTER DATABASE RENAME FILE ''+DATA/SMRRAC/ONLINELOG/group_2.266.1020692669''  to  ''/u01/app/oracle/oradata/smrrac/redo03.log'' ";
SQL "ALTER DATABASE RENAME FILE ''+FRA1/SMRRAC/ONLINELOG/group_2.259.1020692671''  to  ''/u01/app/oracle/oradata/smrrac/redo04.log'' ";
SQL "ALTER DATABASE RENAME FILE ''+DATA/SMRRAC/ONLINELOG/group_3.263.1020692675''  to  ''/u01/app/oracle/oradata/smrrac/redo05.log'' ";
SQL "ALTER DATABASE RENAME FILE ''+FRA1/SMRRAC/ONLINELOG/group_3.258.1020692677''  to  ''/u01/app/oracle/oradata/smrrac/redo06.log'' ";
SQL "ALTER DATABASE RENAME FILE ''+DATA/SMRRAC/ONLINELOG/group_4.262.1020692677''  to  ''/u01/app/oracle/oradata/smrrac/redo07.log'' ";
SQL "ALTER DATABASE RENAME FILE ''+FRA1/SMRRAC/ONLINELOG/group_4.257.1020692679''  to  ''/u01/app/oracle/oradata/smrrac/redo08.log'' ";
SQL "ALTER DATABASE RENAME FILE ''+DATA/SMRRAC/ONLINELOG/group_5.271.1030949473''  to  ''/u01/app/oracle/oradata/smrrac/redo09.log'' ";

using target database control file instead of recovery catalog
sql statement: ALTER DATABASE RENAME FILE ''+DATA/SMRRAC/ONLINELOG/group_1.267.1020692667''  to  ''/u01/app/oracle/oradata/smrrac/redo01.log''
SQL "ALTER DATABASE RENAME FILE ''+FRA1/SMRRAC/ONLINELOG/group_5.284.1030949475''  to  ''/u01/app/oracle/oradata/smrrac/redo10.log'' ";
SQL "ALTER DATABASE RENAME FILE ''+DATA/SMRRAC/ONLINELOG/group_6.274.1030949487''  to  ''/u01/app/oracle/oradata/smrrac/redo11.log'' ";
SQL "ALTER DATABASE RENAME FILE ''+FRA1/SMRRAC/ONLINELOG/group_6.285.1030949487''  to  ''/u01/app/oracle/oradata/smrrac/redo12.log'' ";
RMAN>
sql statement: ALTER DATABASE RENAME FILE ''+FRA1/SMRRAC/ONLINELOG/group_1.260.1020692669''  to  ''/u01/app/oracle/oradata/smrrac/redo02.log''

RMAN>
sql statement: ALTER DATABASE RENAME FILE ''+DATA/SMRRAC/ONLINELOG/group_2.266.1020692669''  to  ''/u01/app/oracle/oradata/smrrac/redo03.log''

RMAN>
sql statement: ALTER DATABASE RENAME FILE ''+FRA1/SMRRAC/ONLINELOG/group_2.259.1020692671''  to  ''/u01/app/oracle/oradata/smrrac/redo04.log''

RMAN>
sql statement: ALTER DATABASE RENAME FILE ''+DATA/SMRRAC/ONLINELOG/group_3.263.1020692675''  to  ''/u01/app/oracle/oradata/smrrac/redo05.log''

RMAN>
sql statement: ALTER DATABASE RENAME FILE ''+FRA1/SMRRAC/ONLINELOG/group_3.258.1020692677''  to  ''/u01/app/oracle/oradata/smrrac/redo06.log''

RMAN>
sql statement: ALTER DATABASE RENAME FILE ''+DATA/SMRRAC/ONLINELOG/group_4.262.1020692677''  to  ''/u01/app/oracle/oradata/smrrac/redo07.log''

RMAN>
sql statement: ALTER DATABASE RENAME FILE ''+FRA1/SMRRAC/ONLINELOG/group_4.257.1020692679''  to  ''/u01/app/oracle/oradata/smrrac/redo08.log''

RMAN>
sql statement: ALTER DATABASE RENAME FILE ''+DATA/SMRRAC/ONLINELOG/group_5.271.1030949473''  to  ''/u01/app/oracle/oradata/smrrac/redo09.log''

RMAN>
sql statement: ALTER DATABASE RENAME FILE ''+FRA1/SMRRAC/ONLINELOG/group_5.284.1030949475''  to  ''/u01/app/oracle/oradata/smrrac/redo10.log''

RMAN>
sql statement: ALTER DATABASE RENAME FILE ''+DATA/SMRRAC/ONLINELOG/group_6.274.1030949487''  to  ''/u01/app/oracle/oradata/smrrac/redo11.log''

RMAN>

sql statement: ALTER DATABASE RENAME FILE ''+FRA1/SMRRAC/ONLINELOG/group_6.285.1030949487''  to  ''/u01/app/oracle/oradata/smrrac/redo12.log''

RMAN>

RMAN> recover database until cancel;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "cancel": expecting one of: "scn, sequence, time"
RMAN-01007: at line 1 column 24 file: standard input

RMAN> recover database;

Starting recover at 29-JAN-2020 14:51:50
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=527 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=821
channel ORA_DISK_1: reading from backup piece /u02/rman_smrrac/Backup_SMRRAC_DB_lsun6f1a_1724_1_20200129
channel ORA_DISK_1: piece handle=/u02/rman_smrrac/Backup_SMRRAC_DB_lsun6f1a_1724_1_20200129 tag=TAG20200129T102338
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/o1_mf_1_821_h333hq6p_.arc thread=1 sequence=821
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=593
channel ORA_DISK_1: reading from backup piece /u02/rman_smrrac/Backup_SMRRAC_DB_ltun6f1a_1725_1_20200129
channel ORA_DISK_1: piece handle=/u02/rman_smrrac/Backup_SMRRAC_DB_ltun6f1a_1725_1_20200129 tag=TAG20200129T102338
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/o1_mf_2_593_h333hrcb_.arc thread=2 sequence=593
channel default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/o1_mf_1_821_h333hq6p_.arc RECID=1367 STAMP=1030978311
unable to find archived log
archived log thread=1 sequence=822
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/29/2020 14:51:54
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 822 and starting SCN of 64756182

RMAN>
login as: oracle
Keyboard-interactive authentication prompts from server:
| Password:
End of keyboard-interactive prompts from server
Last login: Thu Jan 30 07:46:09 2020 from 172.29.42.175
oracle@sgdcpl08:~> pwd
/home/oracle
oracle@sgdcpl08:~> . oraenv
ORACLE_SID = [SMRPATCH7] ? smrrac
The Oracle base remains unchanged with value /u01/app/oracle
oracle@sgdcpl08:~> rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Thu Jan 30 07:47:40 2020

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

connected to target database: SMRRAC (DBID=4255065810, not open)

RMAN> recover database;

Starting recover at 30-JAN-2020 07:52:00
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=176 device type=DISK

starting media recovery

archived log for thread 1 with sequence 822 is already on disk as file /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_1_822_1020157972.arc
archived log for thread 1 with sequence 823 is already on disk as file /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_1_823_1020157972.arc
archived log for thread 1 with sequence 824 is already on disk as file /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_1_824_1020157972.arc
archived log for thread 1 with sequence 825 is already on disk as file /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_1_825_1020157972.arc
archived log for thread 2 with sequence 593 is already on disk as file /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/o1_mf_2_593_h333hrcb_.arc
archived log for thread 2 with sequence 594 is already on disk as file /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_2_594_1020157972.arc
archived log for thread 2 with sequence 595 is already on disk as file /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_2_595_1020157972.arc
archived log file name=/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_1_822_1020157972.arc thread=1 sequence=822
archived log file name=/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/o1_mf_2_593_h333hrcb_.arc thread=2 sequence=593
archived log file name=/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_2_594_1020157972.arc thread=2 sequence=594
archived log file name=/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_2_595_1020157972.arc thread=2 sequence=595
archived log file name=/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_1_823_1020157972.arc thread=1 sequence=823

archived log file name=/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_1_824_1020157972.arc thread=1 sequence=824

archived log file name=/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_1_825_1020157972.arc thread=1 sequence=825
unable to find archived log
archived log thread=2 sequence=596
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/30/2020 07:52:59
RMAN-06054: media recovery requesting unknown archived log for thread 2 with sequence 596 and starting SCN of 65089014

RMAN> recover database;

Starting recover at 30-JAN-2020 08:30:07
using channel ORA_DISK_1

starting media recovery

archived log for thread 1 with sequence 825 is already on disk as file /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_1_825_1020157972.arc
unable to find archived log
archived log thread=2 sequence=596
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/30/2020 08:30:07
RMAN-06054: media recovery requesting unknown archived log for thread 2 with sequence 596 and starting SCN of 65089014

RMAN> recover database;

Starting recover at 30-JAN-2020 08:30:28
using channel ORA_DISK_1

starting media recovery

archived log for thread 1 with sequence 825 is already on disk as file /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_1_825_1020157972.arc
unable to find archived log
archived log thread=2 sequence=596
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/30/2020 08:30:28
RMAN-06054: media recovery requesting unknown archived log for thread 2 with sequence 596 and starting SCN of 65089014

RMAN>  recover database;

Starting recover at 30-JAN-2020 08:30:47
using channel ORA_DISK_1

starting media recovery

archived log for thread 1 with sequence 825 is already on disk as file /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_1_825_1020157972.arc
unable to find archived log
archived log thread=2 sequence=596
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/30/2020 08:30:48
RMAN-06054: media recovery requesting unknown archived log for thread 2 with sequence 596 and starting SCN of 65089014

RMAN> exit


Recovery Manager complete.
oracle@sgdcpl08:~> rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Thu Jan 30 08:31:21 2020

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

connected to target database: SMRRAC (DBID=4255065810, not open)

RMAN> recover database;

Starting recover at 30-JAN-2020 08:31:28
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=176 device type=DISK

starting media recovery

archived log for thread 1 with sequence 825 is already on disk as file /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_1_825_1020157972.arc
archived log for thread 1 with sequence 826 is already on disk as file /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_1_826_1020157972.arc
archived log for thread 1 with sequence 827 is already on disk as file /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_1_827_1020157972.arc
archived log for thread 1 with sequence 828 is already on disk as file /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_1_828_1020157972.arc
archived log for thread 1 with sequence 829 is already on disk as file /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_1_829_1020157972.arc
archived log for thread 1 with sequence 830 is already on disk as file /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_1_830_1020157972.arc
archived log for thread 1 with sequence 831 is already on disk as file /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_1_831_1020157972.arc
archived log for thread 2 with sequence 596 is already on disk as file /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_2_596_1020157972.arc
archived log for thread 2 with sequence 597 is already on disk as file /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_2_597_1020157972.arc
archived log for thread 2 with sequence 598 is already on disk as file /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_2_598_1020157972.arc
archived log for thread 2 with sequence 599 is already on disk as file /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_2_599_1020157972.arc
archived log for thread 2 with sequence 600 is already on disk as file /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_2_600_1020157972.arc
archived log file name=/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_2_596_1020157972.arc thread=2 sequence=596
archived log file name=/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_1_825_1020157972.arc thread=1 sequence=825
archived log file name=/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_1_826_1020157972.arc thread=1 sequence=826
archived log file name=/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_1_827_1020157972.arc thread=1 sequence=827
archived log file name=/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_1_828_1020157972.arc thread=1 sequence=828
archived log file name=/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_2_597_1020157972.arc thread=2 sequence=597
archived log file name=/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_2_598_1020157972.arc thread=2 sequence=598
archived log file name=/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_1_829_1020157972.arc thread=1 sequence=829
archived log file name=/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_1_830_1020157972.arc thread=1 sequence=830
archived log file name=/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_2_599_1020157972.arc thread=2 sequence=599
archived log file name=/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_2_600_1020157972.arc thread=2 sequence=600
archived log file name=/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_01_29/arch_1_831_1020157972.arc thread=1 sequence=831
unable to find archived log
archived log thread=1 sequence=832
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/30/2020 08:32:30
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 832 and starting SCN of 65557026

RMAN>


SQL> /

    GROUP# STATUS  TYPE    MEMBER                                             IS_     CON_ID
---------- ------- ------- -------------------------------------------------- --- ----------
         1         ONLINE  /u01/app/oracle/oradata/smrrac/redo01.log          NO           0
         1         ONLINE  /u01/app/oracle/oradata/smrrac/redo02.log          NO           0
         2         ONLINE  /u01/app/oracle/oradata/smrrac/redo03.log          NO           0
         2         ONLINE  /u01/app/oracle/oradata/smrrac/redo04.log          NO           0
         3         ONLINE  /u01/app/oracle/oradata/smrrac/redo05.log          NO           0
         3         ONLINE  /u01/app/oracle/oradata/smrrac/redo06.log          NO           0
         4         ONLINE  /u01/app/oracle/oradata/smrrac/redo07.log          NO           0
         4         ONLINE  /u01/app/oracle/oradata/smrrac/redo08.log          NO           0
         5         ONLINE  /u01/app/oracle/oradata/smrrac/redo09.log          NO           0
         5         ONLINE  /u01/app/oracle/oradata/smrrac/redo10.log          NO           0
         6         ONLINE  /u01/app/oracle/oradata/smrrac/redo11.log          NO           0

    GROUP# STATUS  TYPE    MEMBER                                             IS_     CON_ID
---------- ------- ------- -------------------------------------------------- --- ----------
         6         ONLINE  /u01/app/oracle/oradata/smrrac/redo12.log          NO           0

12 rows selected.

SQL> select name from v$controlfile;

NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/oradata/smrrac/control01.ctl
/u01/app/oracle/fast_recovery_area/smrrac/control02.ctl

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/oradata/smrrac/system01.dbf
/u02/oradata/smrrac/idata01.dbf
/u01/app/oracle/oradata/smrrac/sysaux01.dbf
/u01/app/oracle/oradata/smrrac/undotbs01.dbf
/u01/app/oracle/oradata/smrrac/undotbs02.dbf
/u02/oradata/smrrac/users01.dbf
/u02/oradata/smrrac/ilog01.dbf
/u02/oradata/smrrac/indx01.dbf

8 rows selected.

SQL> @d
SP2-0310: unable to open file "d.sql"
SQL> @/home/oracle/d

NAME      INSTANCE_NAME    DB_UNIQUE_NAME                 OPEN_MODE            DATABASE_ROLE    CURRENT_SCN        FAILOVER_SCN
--------- ---------------- ------------------------------ -------------------- ---------------- ------------------ ----------------------------------------
SMRRAC    smrrac           smrrac                         MOUNTED              PRIMARY          YES                0

SQL> alter database open resetlogs;

Database altered.

SQL> select total_size,awr_flush_emergency_count from v$ash_info;

TOTAL_SIZE AWR_FLUSH_EMERGENCY_COUNT
---------- -------------------------
   8388608                         1

SQL>  @/home/oracle/d

NAME      INSTANCE_NAME    DB_UNIQUE_NAME                 OPEN_MODE            DATABASE_ROLE    CURRENT_SCN        FAILOVER_SCN
--------- ---------------- ------------------------------ -------------------- ---------------- ------------------ ----------------------------------------
SMRRAC    smrrac           smrrac                         READ WRITE           PRIMARY          YES                0

SQL> select member from v$logfile;

MEMBER
--------------------------------------------------
/u01/app/oracle/oradata/smrrac/redo01.log
/u01/app/oracle/oradata/smrrac/redo02.log
/u01/app/oracle/oradata/smrrac/redo03.log
/u01/app/oracle/oradata/smrrac/redo04.log
/u01/app/oracle/oradata/smrrac/redo05.log
/u01/app/oracle/oradata/smrrac/redo06.log
/u01/app/oracle/oradata/smrrac/redo07.log
/u01/app/oracle/oradata/smrrac/redo08.log
/u01/app/oracle/oradata/smrrac/redo09.log
/u01/app/oracle/oradata/smrrac/redo10.log
/u01/app/oracle/oradata/smrrac/redo11.log

MEMBER
--------------------------------------------------
/u01/app/oracle/oradata/smrrac/redo12.log

12 rows selected.

SQL> select THREAD#, STATUS, ENABLED from v$thread;

   THREAD# STATUS ENABLED
---------- ------ --------
         1 OPEN   PUBLIC
         2 CLOSED PUBLIC

SQL> select group# from v$log where THREAD#=2;

    GROUP#
----------
         3
         4
         6

SQL> alter database disable thread 2;

Database altered.

SQL> alter database clear unarchived logfile group 3
  2  ;

Database altered.

SQL> alter database clear unarchived logfile group 4;

Database altered.

SQL> alter database clear unarchived logfile group 6;

Database altered.

SQL> select THREAD#, STATUS, ENABLED from v$thread;

   THREAD# STATUS ENABLED
---------- ------ --------
         1 OPEN   PUBLIC
         2 CLOSED DISABLED

SQL> sho parameter undo;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
temp_undo_enabled                    boolean     FALSE
undo_management                      string      AUTO
undo_retention                       integer     900
undo_tablespace                      string      UNDOTBS1
SQL> select tablespace_name from dba_tablespaces where contents='UNDO';

TABLESPACE_NAME
------------------------------
UNDOTBS1
UNDOTBS2

SQL> drop tablespace UNDOTBS2 including contents and datafiles;

Tablespace dropped.

SQL> select name from v$tempfile;

NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/oradata/smrrac/temp01.dbf

SQL> select tablespace_name from dba_tablespaces where contents='TEMPORARY';

TABLESPACE_NAME
------------------------------
TEMP

SQL> create temporary tablespace TEMP1 tempfile '/u01/app/oracle/oradata/smrrac/temp001.dbf' size 50m;

Tablespace created.

SQL> alter database default temporary tablespace TEMP1;

Database altered.

SQL> drop tablespace TEMP including contents and datafiles;

Tablespace dropped.

SQL> select tablespace_name from dba_tablespaces where contents='TEMPORARY';

TABLESPACE_NAME
------------------------------
TEMP1

SQL> @/home/oracle/d


$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$\

NOTE : --- increase pga_target , sga , temp file , undo file if required, match with production requirement.

[PRCF-2030 : Parallel transfer workload distribution error. 12c (12.1.0.2.0)

add node command
oracle@srv1 addnode]$ ./addnode.sh "CLUSTER_NEW_NODES={srv2}"


Error:

Error while copying directory /u01/app/oracle/product/12.1.0/dbhome_2 with exclude file list '/tmp/OraInstall2019-12-23_02-59-55PM/installExcludeFile.lst' to nodes 'srv2'. [PRCF-2030 : Parallel transfer workload distribution error.
PRCF-2023 : The following contents cannot be transferred as they are non-readable.
Directories:
 
Files:
   /u01/app/oracle/product/12.1.0/dbhome_2/p6880880_121010_Linux-x86-64_17.zip]
Refer to '/u01/app/oraInventory/logs/addNodeActions2019-12-23_02-59-55PM.log' for details. You may fix the errors on the required remote nodes. Refer to the install guide for error recovery. Click 'Yes' if you want to proceed. Click 'No' to exit the install. Do you want to continue?

Solution:
Check permission on directory and sub directories.

In this case p6880880_121010_Linux-x86-64_17.zip file having root permissions and it was conflicting while copying the nodes.

Check link below:

RAC : Add Failed cluster on 2nd node 12c R1 (12.1.0.2.0)