How to resolve ORA-01111, ORA-01110, ORA-01157(UNNAMED00).

POSSIBLE REASON


1.Mount Point of Production and Standby DB is not similar.
2.Standby standby_archive_dest set to manual instead of Auto.
3.db_file_name_convert is not set if the production Data mount point is different from standby one.

ERROR


MRP0: Background Managed Standby Recovery process started (orclsb)
Managed Standby Recovery not using Real Time Apply
MRP0: Background Media Recovery terminated with error 1111
Wed Mar  1 08:35:19 2017
Errors in file /u01/app/oracle/admin/orclsb/bdump/orclsb_mrp0_8563.trc:
ORA-01111: Message 1111 not found; No message file for product=RDBMS, facility=ORA; arguments: [432]
ORA-01110: Message 1110 not found; No message file for product=RDBMS, facility=ORA; arguments: [432] [/u01/app/oracle/product/10.2/dbs/UNNAMED00432]
ORA-01157: Message 1157 not found; No message file for product=RDBMS, facility=ORA; arguments: [432]
ORA-01111: Message 1111 not found; No message file for product=RDBMS, facility=ORA; arguments: [432]
ORA-01110: Message 1110 not found; No message file for product=RDBMS, facility=ORA; arguments: [432] [/u01/app/oracle/product/10.2/dbs/UNNAMED00432]
MRP0: Background Media Recovery process shutdown (orclsb)
Wed Mar  1 08:35:20 2017
Completed:  alter database recover managed standby database  disconnect from session

TROUBLESHOOTING

1.In my case , I have set the standby_archive_dest set to Manual instead of Auto.

SQL>show parameter standby

NAME                                 TYPE                             VALUE
------------------------------------ -------------------------------- ------------------------------
standby_file_management              string                           MANUAL

2. Check for the files needs to be recovered.

SQL> select * from v$recover_file where error like '%FILE%';

     FILE# ONLINE  ONLINE_ ERROR                                                                CHANGE# TIME
---------- ------- ------- ----------------------------------------------------------------- ---------- ---------
       432 ONLINE  ONLINE  FILE MISSING                                                               0

3. check file 432 in Production

SQL> select name from V$datafile where file#=432;

NAME
-------------------------------------------------
/u18/oradata/orcl/data01/abc_data_83.dbf

4.Identify dummy file name created in (Standby)

SQL> select file#,name from v$datafile where file#=432;

     FILE# NAME
---------- --------------------------------------------------
       432 /u01/app/oracle/product/10.2/dbs/UNNAMED00432

5. Stop the MRP process if it is running and set standby_file_management to Manual.

SQL>alter database recover managed standby database cancel;
SQL>alter system set standby_file_management=Manual Scope=both;

6.Move UNNAMED00432 to its original location, like it is in Production.

SQL> alter database create datafile '/u01/app/oracle/product/10.2/dbs/UNNAMED00432' as '/u18/oradata/orcl/data01/abc_data_83.dbf';
Database altered.


NOTE:- FOR OMF managed file 

ORA-01276: Cannot add file'dbs/UNNAMED00432'.File has an Oracle Managed Files file name.

Run Below command.

SQL> alter database create datafile '/u01/app/oracle/product/10.2/dbs/UNNAMED00432' as  new;


7. Now enable the standby_file_management and start MRP.


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

System altered.


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

Database altered.


8.Check the Log


MRP0: Background Managed Standby Recovery process started (orclsb)
Managed Standby Recovery not using Real Time Apply
 parallel recovery started with 7 processes
Wed Mar  1 08:55:07 2017
Waiting for all non-current ORLs to be archived...
Media Recovery Log /u03/orarch/orclsb/standby/arch_1_10237_932005527.arc
Wed Mar  1 08:55:07 2017
Completed: alter database recover managed standby database disconnect from session
Wed Mar  1 08:55:10 2017
Media Recovery Log /u03/orarch/orclsb/standby/arch_1_10238_932005527.arc
Wed Mar  1 08:56:17 2017
Media Recovery Log /u03/orarch/orclsb/standby/arch_1_10239_932005527.arc

ORA-00604: error occurred at recursive SQL level "alter database register logfile"

we face this issue, while trying to register the archive log file with in database.

Error:-

alter database register logfile '/u03/orarch/orcl/standby/arch_1_2200_923546327.arc'; 

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level

Solution 1:

ALTER DATABASE REGISTER OR REPLACE LOGFILE '/u03/orarch/orcl/standby/arch_1_2200_923546327.arc';

If above fails.

Solution 2:

ALTER DATABASE REGISTER PHYSICAL LOGFILE '/u03/orarch/orcl/standby/arch_1_2200_923546327.arc';

if above fails

Solution 3:

Rman>Connect target/

Rman> catalog start with '/u03/orarch/orcl/standby/';

Oracle agent Error

Generally We Faced During Agent Installation. When You Deleted Agent Binaries Forcefully / Moved to another Location without DE installation of agent. Now You Want To Install New Agent On Same Path And Location.

ERROR:-

Starting Oracle Universal Installer...

Checking installer requirements...

Checking operating system version: must be 5.8, 5.9 or 5.10.    Actual 5.10

                                      Passed

Checking Temp space: must be greater than 250 MB.   Actual 423 MB    Passed

Checking swap space: must be greater than 500 MB.   Actual 6532 MB    Passed

All installer requirements met.

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2016-06-02_10-38-47AM. Please wait ...oracle@server1$ Please specify a Unique Oracle Base directory, or remove previously installed products and their directories. Directory name should contain only valid alphanumeric characters, including '_', or '.' characters.

1. Check location of ORAINVENTORY

oracle@server1$ cat /var/opt/oracle/oraInst.loc

#Oracle Installer Location File Location

#Thu Dec 11 14:20:18 GMT 2008

inst_group=dba

inventory_loc=/u01/app/oracle/oraInventory

2. Now remove the entries from old agent /u01/app/oracle/oraInventory/ContentsXML/inventory.xml. Highlighted with yellow.

oracle@server1$ vi inventory.xml

"inventory.xml" 14 lines, 567 characters

<?xml version="1.0" standalone="yes" ?>

<!-- Copyright (c) 2005 Oracle Corporation. All rights Reserved -->

<!-- Do not modify the contents of this file by hand. -->

<INVENTORY>

<VERSION_INFO>

   <SAVED_WITH>10.2.0.3.0</SAVED_WITH>

   <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>

</VERSION_INFO>

<HOME_LIST>

<HOME NAME="Home1" LOC="/u01/app/oracle/product/9.2.0.1.0" TYPE="O" IDX="1"/>

<HOME NAME="agent10g" LOC="/u01/app/oracle/product/agent10g/agent10g" TYPE="O" IDX="3"/>

</HOME_LIST>

</INVENTORY>

3. please remove/move old agent home Binaries.

cd /u01/app/oracle/product/agent10g/

rm -rf agent10g

4. You can install agent.

oracle@server1$ ./runInstaller -silent -responseFile /u01/app/oracle/patch/solaris/response/additional_agent.rsp  INSTALLATION_NAME=agent10g  sl_OMSConnectInfo={"oemserver","4889"} BASEDIR="/u01/app/oracle/product/agent10g"

ORA-04030: out of process memory when trying to allocate 4194344 bytes (QERHJ hash-joi,QERHJ list array)

Error in Alert log file

Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_p005_8232.trc  (incident=200692):
ORA-04030: out of process memory when trying to allocate 4194344 bytes (QERHJ hash-joi,QERHJ list array)
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_p006_8236.trc  (incident=200701):
ORA-04030: out of process memory when trying to allocate 4194344 bytes (QERHJ hash-joi,QERHJ list array)
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Tue May 17 10:20:40 2016


Error In trace file

oracle@server1$ cat /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_p000_8222.trc
Trace file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_p000_8222.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/11.2
System name:    SunOS
Node name:      server1
Release:        5.10
Version:        Generic_150400-20
Machine:        sun4u
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 200
Unix process pid: 8222, image: oracle@server1 (P000)


*** 2016-05-17 10:20:40.630
*** SESSION ID:(60.7937) 2016-05-17 10:20:40.630
*** CLIENT ID:() 2016-05-17 10:20:40.630
*** SERVICE NAME:(SYS$USERS) 2016-05-17 10:20:40.630
*** MODULE NAME:(SQL Developer) 2016-05-17 10:20:40.630
*** ACTION NAME:() 2016-05-17 10:20:40.630

DDE: Problem Key 'ORA 4030' was flood controlled (0x4) (incident: 200613)
ORA-04030: out of process memory when trying to allocate 4194344 bytes (QERHJ hash-joi,QERHJ list array)
DDE: Problem Key 'ORA 4030' was flood controlled (0x6) (incident: 200614)
ORA-04030: out of process memory when trying to allocate 4194344 bytes (QERHJ hash-joi,QERHJ list array)

*** 2016-05-17 10:20:42.310
DDE: Problem Key 'ORA 4030' was flood controlled (0x6) (incident: 200615)

ORA-04030: out of process memory when trying to allocate  bytes (,)


Solution

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later

Oracle Database - Standard Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]

It is a bug in oracle 11g version . To  resolve this issue set the value of  _PGA_MAX_SIZE to a lower value which internally forces the hash-join to use the less memory and avoid the ORA-4030

By default it is 200 MB.

SQL> alter system set _pga_max_size=120M;

RMAN-03002 RMAN-12001 RMAN-10008 RMAN-10003 ORA-12154

ORA-ERROR

RMAN> CATALOG START WITH '/u04/orabackup/orcl/rman_backup/';

Starting implicit crosscheck backup at 19-MAY-16

using target database control file instead of recovery catalog

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of catalog command at 05/19/2016 14:52:51

RMAN-12001: could not open channel ORA_DISK_1

RMAN-10008: could not create channel context

RMAN-10003: unable to connect to target database

ORA-12154: TNS:could not resolve the connect identifier specified

Sol:-

RMAN> CONFIGURE channel 1 device type disk clear;

old RMAN configuration parameters:

CONFIGURE CHANNEL 1 DEVICE TYPE DISK CONNECT '*';

old RMAN configuration parameters are successfully deleted

RMAN> CONFIGURE channel 1 device type 'SBT_TAPE' clear;

old RMAN configuration parameters are successfully deleted

RMAN> CATALOG START WITH '/u04/orabackup/orcl/rman_backup/';

Starting implicit crosscheck backup at 19-MAY-16

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=1647 devtype=DISK

Crosschecked 341 objects

Finished implicit crosscheck backup at 19-MAY-16

Starting implicit crosscheck copy at 19-MAY-16

using channel ORA_DISK_1

Finished implicit crosscheck copy at 19-MAY-16

searching for all files in the recovery area

cataloging files...

no files cataloged

IMPORT ONLY CONSTRAINTS IN ORACLE 10g,11g AND 12C USING IMPDP

IMPORT ONLY CONSTRAINTS IN ORACLE 10G,11G AND 12C


oracle@acserver01$ impdp system@server schemas=HR directory=pump1 dumpfile=contraint_only.dmp logfile=constraint_only.log include=ref_constraint

Import: Release 10.2.0.4.0 - 64bit Production on Wednesday, 11 May, 2016 6:06:57

Copyright (c) 2003, 2007, Oracle.  All rights reserved.
Password:

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Master table "SYSTEM"."SYS_IMPORT_SCHEMA_09" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_SCHEMA_09":  system/******** schemas=HR directory=pump1 dumpfile=constraint_only.dmp logfile=constraint_only.log include=ref_constraint


Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT.........

CLONING OF COMPLETE DATABASE FROM ONE SERVER TO ANOTHER ORACLE 11G.

CLONING OF COMPLETE DATABASE FROM ONE SERVER TO ANOTHER ORACLE 11G.
===========================================================

This Include.

1. Cloning of Oracle Home
2. Cloning of Rdbms Home
3. Setting up ASM
4. Restoring of Oracle database using Backup set
5. Recovery of database until last sequence number
6. Starting of database.

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

1. Copy Oracle Home from server Source to Target. Then re-link all the binary included ASM and RDBMS home . Just run following command from Oracle home

[Wed May 04 08:01 AM]
 [oracle@source ../11.2.0.4/dbhome_1/bin] orcl_NEW=> ./relink all
writing relink log to: /u01/app/oracle/product/11.2.0.4/dbhome_1/install/relink.log

bash-3.2# cd /tmp
bash-3.2#  /u01/app/grid/product/11.2.0/grid/root.sh
Performing root user operation for Oracle 11g

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/app/grid/product/11.2.0/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.

Entries will be added to the /var/opt/oracle/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/app/grid/product/11.2.0/grid/crs/install/crsconfig_params
LOCAL ADD MODE
Creating OCR keys for user 'grid', privgrp 'oinstall'..
Operation successful.
LOCAL ONLY MODE
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4664: Node source successfully pinned.
Adding Clusterware entries to /etc/inittab
source     2016/05/04 10:16:35     /u01/app/grid/product/11.2.0/grid/cdata/source/backup_20160504_101635.olr
Successfully configured Oracle Grid Infrastructure for a Standalone Server



2. Start the GRID throug root user & GRID user

$ crsctl start has
$ crsctl status resource -t
bash-3.2#




--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ons
               OFFLINE OFFLINE      source
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        OFFLINE OFFLINE
ora.diskmon
      1        OFFLINE OFFLINE
ora.evmd
      1        ONLINE  ONLINE       source


3. Manually making setting to start some resource , alter we will start all.

grid@source$
grid@source$ crsctl start resource ora.cssd
CRS-2672: Attempting to start 'ora.cssd' on 'source'
CRS-2672: Attempting to start 'ora.diskmon' on 'source'
CRS-2676: Start of 'ora.diskmon' on 'source' succeeded
CRS-2676: Start of 'ora.cssd' on 'source' succeeded
grid@source$  crsctl start resource ora.diskmon
CRS-2672: Attempting to start 'ora.diskmon' on 'source'
CRS-2676: Start of 'ora.diskmon' on 'source' succeeded



4. Startup ASM

grid@source$ . oraenv
ORACLE_SID = [+ASM] ?
The Oracle base remains unchanged with value /u01/app/grid
grid@source$ sqlplus

SQL*Plus: Release 11.2.0.4.0 Production on Wed May 4 10:53:14 2016

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

Enter user-name: /as sysdba
Connected to an idle instance.

SQL> startup nomount
ORA-00099: warning: no parameter file specified for ASM instance


grid@source$ vi init+ASM.ora
"init+ASM.ora" [New file]
+ASM.__oracle_base='/u01/app/grid'#ORACLE_BASE set from in memory value
*._asm_hbeatiowait=120
+ASM.asm_diskgroups='FRA','REDO','DATA'#Manual Mount
*.asm_diskstring='/dev/asm/*'
*.asm_power_limit=1
*.diagnostic_dest='/u01/app/grid'
*.instance_name='ASM'
*.instance_type='ASM'
*.large_pool_size=12M
*.remote_login_passwordfile='EXCLUSIVE'


~
~
"init+ASM.ora" [New file] 11 lines, 339 characters



grid@source$ . oraenv
ORACLE_SID = [+ASM] ?
The Oracle base remains unchanged with value /u01/app/grid
grid@source$ sqlplus

SQL*Plus: Release 11.2.0.4.0 Production on Wed May 4 10:58:35 2016

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

Enter user-name: /as sysasm
Connected to an idle instance.

SQL> startup nomount
ASM instance started

Total System Global Area 1136082944 bytes
Fixed Size                  2189048 bytes
Variable Size            1108728072 bytes
ASM Cache                  25165824 bytes
SQL>



5. Create diskgroup
=========================

SQL> conn /as sysasm
Connected.
SQL> create diskgroup FRA external redundancy
disk '/dev/asm/oraarch01';  2

Diskgroup created.

SQL> CREATE DISKGROUP DATA EXTERNAL REDUNDANCY
DISK '/dev/asm/oradata01','/dev/asm/oradata02','/dev/asm/oradata03';
  2

Diskgroup created.




CREATE DISKGROUP REDO NORMAL REDUNDANCY  DISK '/dev/asm/oraredo01','/dev/asm/oraredo02';SQL> SQL>

Diskgroup created.

SQL>  select group_number, disk_number, mount_status, header_status, state, path, failgroup from v$asm_disk;

GROUP_NUMBER DISK_NUMBER MOUNT_S HEADER_STATU STATE    PATH                           FAILGROUP
------------ ----------- ------- ------------ -------- ------------------------------ ------------------------------
           2           0 CACHED  MEMBER       NORMAL   /dev/asm/oradata01             DATA_0000
           2           1 CACHED  MEMBER       NORMAL   /dev/asm/oradata02             DATA_0001
           1           0 CACHED  MEMBER       NORMAL   /dev/asm/oraarch01             FRA_0000
           3           1 CACHED  MEMBER       NORMAL   /dev/asm/oraredo02             REDO_0001
           3           0 CACHED  MEMBER       NORMAL   /dev/asm/oraredo01             REDO_0000
           2           2 CACHED  MEMBER       NORMAL   /dev/asm/oradata03             DATA_0002



SQL>
SQL>
SQL> shut immediate
ASM diskgroups dismounted
ASM instance shutdown
SQL> startup mount
ASM instance started

Total System Global Area 1136082944 bytes
Fixed Size                  2189048 bytes
Variable Size            1108728072 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted


SQL> SQL>  break on report on disk_group_name skip 1
 compute sum label "Grand Total: " of total_mb used_mb on report
SQL> SQL>

 SELECT
     name                                     group_name
   , sector_size                              sector_size
SQL> SQL>   2    3     , block_size                               block_size
   , allocation_unit_size                     allocation_unit_size
   , state                                    state
   , type                                     type
  4    5    6    7    8     , total_mb                                 total_mb
   , (total_mb - free_mb)                     used_mb
   , ROUND((1- (free_mb / total_mb))*100, 2)  pct_used
 FROM
     v$asm_diskgroup
  9   10   11   ORDER BY
     name
 /
 12   13   14   15
Disk Group            Sector   Block   Allocation
Name                    Size    Size    Unit Size State       Type   Total Size (MB) Used Size (MB) Pct. Used
-------------------- ------- ------- ------------ ----------- ------ --------------- -------------- ---------
DATA                     512   4,096    1,048,576 MOUNTED     EXTERN         343,992             57       .02
FRA                      512   4,096    1,048,576 MOUNTED     EXTERN          65,512             50       .08
REDO                     512   4,096    1,048,576 MOUNTED     NORMAL          32,720            102       .31
                                                                     --------------- --------------
Grand Total:                                                                 442,224            209

SQL>


7. Starting up Listener
==============================


grid@source$ lsnrctl

LSNRCTL for Solaris: Version 11.2.0.4.0 - Production on 04-MAY-2016 11:53:38

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> start
Starting /u01/app/grid/product/11.2.0/grid/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 11.2.0.4.0 - Production
System parameter file is /u01/app/grid/product/11.2.0/grid/network/admin/listener.ora
Log messages written to /u01/app/grid/diag/tnslsnr/source/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=source)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version 11.2.0.4.0 - Production
Start Date                04-MAY-2016 11:53:40
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/grid/product/11.2.0/grid/network/admin/listener.ora
Listener Log File         /u01/app/grid/diag/tnslsnr/source/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=source)(PORT=1521)))
The listener supports no services
The command completed successfully
LSNRCTL> exit

IT takes time to load all the service around 1 minues

8. Configuring database
=============================================



Starting Oracle database



-bash-3.2$ /opt/xts/sudo/bin/sudo -u oracle -i bash
Enter your password, vermapan:

[Wed May 04 11:33 AM]
 [oracle@source ~] orcl_NEW=> . oraenv
ORACLE_SID = [orcl] ?
The Oracle base remains unchanged with value /u01/app/oracle

[Wed May 04 11:34 AM]
 [oracle@source ~] orcl_NEW=> sqlplus

SQL*Plus: Release 11.2.0.4.0 Production on Wed May 4 11:34:09 2016

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

Enter user-name: /as sysdba
Connected to an idle instance.

SQL> startup nomount
ORACLE instance started.

Total System Global Area  939769856 bytes
Fixed Size                  2187160 bytes
Variable Size             880803944 bytes
Database Buffers           50331648 bytes
Redo Buffers                6447104 bytes
SQL>




RMAN> connect target/

connected to target database: orcl (not mounted)



RMAN> restore controlfile from '/u02/orabackup/backups/orcl/rman_backup/ora_cfc-135524791-20160422-02';

Starting restore at 04-MAY-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=62 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/orcl/control01.ctl
output file name=+FRA/orcl/control02.ctl
Finished restore at 04-MAY-16



RMAN> sql 'alter database mount';

using target database control file instead of recovery catalog
sql statement: alter database mount

RMAN> crosscheck backupset;

Starting implicit crosscheck backup at 04-MAY-16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=239 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=298 device type=DISK
Crosschecked 116 objects
Finished implicit crosscheck backup at 04-MAY-16

Starting implicit crosscheck copy at 04-MAY-16
using channel ORA_DISK_1
using channel ORA_DISK_2
Finished implicit crosscheck copy at 04-MAY-16

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

using channel ORA_DISK_1
using channel ORA_DISK_2

crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25775_20160415_1_1 RECID=26135 STAMP=909248474
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25776_20160415_1_1 RECID=26136 STAMP=909248474
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25777_20160415_1_1 RECID=26137 STAMP=909248482
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25779_20160415_1_1 RECID=26138 STAMP=909248536
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25778_20160415_1_1 RECID=26139 STAMP=909248489
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25780_20160415_1_1 RECID=26140 STAMP=909248552
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25781_20160415_1_1 RECID=26141 STAMP=909248552
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25782_20160415_1_1 RECID=26142 STAMP=909248557
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25784_20160415_1_1 RECID=26143 STAMP=909248574
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25785_20160415_1_1 RECID=26144 STAMP=909248591
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25783_20160415_1_1 RECID=26145 STAMP=909248558
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_cfc-135524791-20160415-00 RECID=26146 STAMP=909248627
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_arch_orcl_25788_20160415_1_1 RECID=26147 STAMP=909248635
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_arch_orcl_25787_20160415_1_1 RECID=26148 STAMP=909248634
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_cfc-135524791-20160415-01 RECID=26149 STAMP=909248643
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_cfc-135524791-20160415-02 RECID=26151 STAMP=909248657
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_20160416_25793_1_1 RECID=26152 STAMP=909306042
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_20160416_25792_1_1 RECID=26153 STAMP=909306042
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_20160416_25795_1_1 RECID=26154 STAMP=909311208
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_20160416_25794_1_1 RECID=26155 STAMP=909310249
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_20160416_25797_1_1 RECID=26156 STAMP=909314644
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_20160416_25798_1_1 RECID=26157 STAMP=909315070
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_20160416_25796_1_1 RECID=26158 STAMP=909313156
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_20160416_25800_1_1 RECID=26159 STAMP=909315802
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_20160416_25799_1_1 RECID=26160 STAMP=909315486
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_20160416_25802_1_1 RECID=26161 STAMP=909317816
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_20160416_25801_1_1 RECID=26162 STAMP=909317701
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_cfc-135524791-20160416-00 RECID=26163 STAMP=909318914
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_arch_orcl_25805_20160416_1_1 RECID=26164 STAMP=909318918
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_arch_orcl_25804_20160416_1_1 RECID=26165 STAMP=909318918
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_cfc-135524791-20160416-01 RECID=26166 STAMP=909318926
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_cfc-135524791-20160416-02 RECID=26168 STAMP=909318934
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25809_20160418_1_1 RECID=26169 STAMP=909507670
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25810_20160418_1_1 RECID=26170 STAMP=909507670
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25811_20160418_1_1 RECID=26171 STAMP=909507686
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25812_20160418_1_1 RECID=26172 STAMP=909507693
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25814_20160418_1_1 RECID=26173 STAMP=909507760
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25813_20160418_1_1 RECID=26174 STAMP=909507759
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25815_20160418_1_1 RECID=26175 STAMP=909507775
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25816_20160418_1_1 RECID=26176 STAMP=909507777
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25818_20160418_1_1 RECID=26177 STAMP=909507829
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25819_20160418_1_1 RECID=26178 STAMP=909507836
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25817_20160418_1_1 RECID=26179 STAMP=909507813
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_cfc-135524791-20160418-00 RECID=26180 STAMP=909507932
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_arch_orcl_25821_20160418_1_1 RECID=26181 STAMP=909507937
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_arch_orcl_25822_20160418_1_1 RECID=26182 STAMP=909507937
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_cfc-135524791-20160418-01 RECID=26183 STAMP=909507954
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/spfile_orcl_20160418_25824_1 RECID=26184 STAMP=909507971
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_cfc-135524791-20160418-02 RECID=26185 STAMP=909507973
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25826_20160419_1_1 RECID=26186 STAMP=909594076
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25827_20160419_1_1 RECID=26187 STAMP=909594077
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25829_20160419_1_1 RECID=26188 STAMP=909594133
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25830_20160419_1_1 RECID=26189 STAMP=909594228
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25828_20160419_1_1 RECID=26190 STAMP=909594103
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25831_20160419_1_1 RECID=26191 STAMP=909594246
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25832_20160419_1_1 RECID=26192 STAMP=909594249
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25834_20160419_1_1 RECID=26193 STAMP=909594252
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25835_20160419_1_1 RECID=26194 STAMP=909594319
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25833_20160419_1_1 RECID=26195 STAMP=909594251
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25836_20160419_1_1 RECID=26196 STAMP=909594334
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_cfc-135524791-20160419-00 RECID=26197 STAMP=909594361
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_arch_orcl_25838_20160419_1_1 RECID=26198 STAMP=909594373
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_arch_orcl_25839_20160419_1_1 RECID=26199 STAMP=909594373
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_cfc-135524791-20160419-01 RECID=26200 STAMP=909594390
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/spfile_orcl_20160419_25841_1 RECID=26201 STAMP=909594413
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_cfc-135524791-20160419-02 RECID=26202 STAMP=909594415
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25843_20160420_1_1 RECID=26203 STAMP=909680477
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25844_20160420_1_1 RECID=26204 STAMP=909680477
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25845_20160420_1_1 RECID=26205 STAMP=909680485
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25847_20160420_1_1 RECID=26206 STAMP=909680537
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25848_20160420_1_1 RECID=26207 STAMP=909680544
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25849_20160420_1_1 RECID=26208 STAMP=909680546
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25850_20160420_1_1 RECID=26209 STAMP=909680548
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25846_20160420_1_1 RECID=26210 STAMP=909680501
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25852_20160420_1_1 RECID=26211 STAMP=909680579
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25851_20160420_1_1 RECID=26212 STAMP=909680564
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25853_20160420_1_1 RECID=26213 STAMP=909680597
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_cfc-135524791-20160420-00 RECID=26214 STAMP=909680624
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_arch_orcl_25856_20160420_1_1 RECID=26215 STAMP=909680635
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_arch_orcl_25855_20160420_1_1 RECID=26216 STAMP=909680635
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_cfc-135524791-20160420-01 RECID=26217 STAMP=909680652
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/spfile_orcl_20160420_25858_1 RECID=26218 STAMP=909680667
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_cfc-135524791-20160420-02 RECID=26219 STAMP=909680670
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25860_20160421_1_1 RECID=26220 STAMP=909766914
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25861_20160421_1_1 RECID=26221 STAMP=909766914
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25863_20160421_1_1 RECID=26222 STAMP=909766937
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25864_20160421_1_1 RECID=26223 STAMP=909766973
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25865_20160421_1_1 RECID=26224 STAMP=909766990
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25862_20160421_1_1 RECID=26225 STAMP=909766930
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25866_20160421_1_1 RECID=26226 STAMP=909767057
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25867_20160421_1_1 RECID=26227 STAMP=909767058
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25869_20160421_1_1 RECID=26228 STAMP=909767140
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25868_20160421_1_1 RECID=26229 STAMP=909767104
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25870_20160421_1_1 RECID=26230 STAMP=909767148
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_cfc-135524791-20160421-00 RECID=26231 STAMP=909767174
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_arch_orcl_25873_20160421_1_1 RECID=26232 STAMP=909767180
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_arch_orcl_25872_20160421_1_1 RECID=26233 STAMP=909767179
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_cfc-135524791-20160421-01 RECID=26234 STAMP=909767196
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/spfile_orcl_20160421_25875_1 RECID=26235 STAMP=909767212
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_cfc-135524791-20160421-02 RECID=26236 STAMP=909767214
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25877_20160422_1_1 RECID=26237 STAMP=909853293
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25878_20160422_1_1 RECID=26238 STAMP=909853293
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25879_20160422_1_1 RECID=26239 STAMP=909853320
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25880_20160422_1_1 RECID=26240 STAMP=909853327
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25881_20160422_1_1 RECID=26241 STAMP=909853373
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25882_20160422_1_1 RECID=26242 STAMP=909853388
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25883_20160422_1_1 RECID=26243 STAMP=909853390
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25884_20160422_1_1 RECID=26244 STAMP=909853391
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25886_20160422_1_1 RECID=26245 STAMP=909853419
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25887_20160422_1_1 RECID=26246 STAMP=909853434
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_25885_20160422_1_1 RECID=26247 STAMP=909853394
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_cfc-135524791-20160422-00 RECID=26248 STAMP=909853450
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_arch_orcl_25890_20160422_1_1 RECID=26249 STAMP=909853456
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_arch_orcl_25889_20160422_1_1 RECID=26250 STAMP=909853456
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/ora_cfc-135524791-20160422-01 RECID=26251 STAMP=909853472
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/orabackup/backups/orcl/rman_backup/spfile_orcl_20160422_25892_1 RECID=26252 STAMP=909853482
Crosschecked 116 objects


RMAN>
RMAN> run
{
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
allocate channel ch3 device type disk;
allocate channel ch4 device type disk;
allocate channel ch5 device type disk;
restore database;
}
2> 3> 4> 5> 6> 7> 8> 9>
released channel: ORA_DISK_1
released channel: ORA_DISK_2
allocated channel: ch1
channel ch1: SID=359 device type=DISK

allocated channel: ch2
channel ch2: SID=417 device type=DISK

allocated channel: ch3
channel ch3: SID=4 device type=DISK

allocated channel: ch4
channel ch4: SID=63 device type=DISK

allocated channel: ch5
channel ch5: SID=124 device type=DISK

Starting restore at 04-MAY-16

channel ch1: starting datafile backup set restore
channel ch1: specifying datafile(s) to restore from backup set
channel ch1: restoring datafile 00003 to +DATA/orcl/datafile/sysaux.291.850753205
channel ch1: restoring datafile 00005 to +DATA/orcl/datafile/tega_data.261.850752349
channel ch1: restoring datafile 00029 to +DATA/orcl/datafile/lids_legacy_indx.266.850752351
channel ch1: restoring datafile 00033 to +DATA/orcl/datafile/test_tts_indx.267.850752351
channel ch1: reading from backup piece /u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_20160416_25793_1_1
channel ch2: starting datafile backup set restore
channel ch2: specifying datafile(s) to restore from backup set
channel ch2: restoring datafile 00010 to +DATA/orcl/datafile/tega_data.260.850752349
channel ch2: restoring datafile 00030 to +DATA/orcl/datafile/posh_legacy_data.268.850752351
channel ch2: restoring datafile 00035 to +DATA/orcl/datafile/rdc_wfl_data.282.850753165
channel ch2: restoring datafile 00043 to +DATA/orcl/datafile/pas_data.300.859212427
channel ch2: reading from backup piece /u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_20160416_25792_1_1
channel ch3: starting datafile backup set restore
channel ch3: specifying datafile(s) to restore from backup set
channel ch3: restoring datafile 00001 to +DATA/orcl/datafile/system.269.850752351
channel ch3: restoring datafile 00006 to +DATA/orcl/datafile/tega_indx.274.850752505
channel ch3: restoring datafile 00027 to +DATA/orcl/datafile/ref_indx.265.850752351
channel ch3: restoring datafile 00036 to +DATA/orcl/datafile/undotbs1.281.850753165
channel ch3: reading from backup piece /u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_20160416_25795_1_1
channel ch4: starting datafile backup set restore
channel ch4: specifying datafile(s) to restore from backup set
channel ch4: restoring datafile 00008 to +DATA/orcl/datafile/tega_data.258.850752349
channel ch4: restoring datafile 00013 to +DATA/orcl/datafile/dcs_data.263.850752351
channel ch4: restoring datafile 00031 to +DATA/orcl/datafile/posh_legacy_indx.272.850752353
channel ch4: restoring datafile 00034 to +DATA/orcl/datafile/tega_data.259.850752349
channel ch4: reading from backup piece /u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_20160416_25794_1_1
channel ch5: starting datafile backup set restore
channel ch5: specifying datafile(s) to restore from backup set
channel ch5: restoring datafile 00021 to +DATA/orcl/datafile/xiswfl_indx.278.850752979
channel ch5: restoring datafile 00022 to +DATA/orcl/datafile/xeal_data.280.850752979
channel ch5: restoring datafile 00024 to +DATA/orcl/datafile/apix_data.271.850752353
channel ch5: restoring datafile 00041 to +DATA/orcl/datafile/pas_rules_data.295.860308597
channel ch5: reading from backup piece /u02/orabackup/backups/orcl/rman_backup/ora_df_orcl_20160416_25797_1_1




Once this done..

Please recover the database.


RMAN>recover database;

RMAN>sql 'alter database open resetlogs;'
=============================


Post activity

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

1.check agent is working
2. check all script working
3. Rsyc catalog with Rman .


Once all restored , stop database and login with GRID user and  add, register all the service.
srvctl add LISTENER
crsctl modify resource ora.cssd -attr AUTO_START=always
crsctl modify resource ora.evmd -attr AUTO_START=always
crsctl modify resource ora.DATA.dg -attr AUTO_START=always
crsctl modify resource ora.FRA.dg -attr AUTO_START=always
crsctl modify resource ora.REDO.dg -attr AUTO_START=always
crsctl modify resource ora.asm -attr AUTO_START=always
crsctl modify resource ora.ons -attr AUTO_START=always