ORA-19870 | ORA-19504 | ORA-27040 Errors in RMAN | Oracle Database

ORA-19870, ORA-19504 and ORA-27040 Errors in RMAN | Oracle Database

ORA-19870 ORA-19504 ORA-27040 Oracle Errors

While creating DR Site from my 2 Node RAC Primary, I was trying to restore the controlfile from the standby controlfile backup file which I had created from Primary database via RMAN prompt using the below mentioned command,

RMAN> backup current controlfile for standby format '/backup/stdb_cntl_%U.bkp';

But after running the restore command, I got the below mentioned error,

$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Fri Oct 13 06:43:27 2017

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

connected to target database: IFSPROD (not mounted)

RMAN> restore standby controlfile from '/home/oracle/stdb_cntl_ldsgu14m_1_1.bkp';

Starting restore at 13-OCT-17

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=1982 device type=DISK

channel ORA_DISK_1: restoring control file

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

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

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

RMAN-03002: failure of restore command at 10/13/2017 06:45:44

ORA-19870: error while restoring backup piece /home/oracle/stdb_cntl_ldsgu14m_1_1.bkp

ORA-19504: failed to create file "/data/drtesterp/control01.ctl"

ORA-27040: file create error, unable to create file

IBM AIX RISC System/6000 Error: 2: No such file or directory

Additional information: 1

Resolution:

Again if you check the complete error description, you'll see "IBM AIX RISC System/6000 Error: 2: No such file or directory" which simply indicated that the directory where I was trying to restore the controlfile was

1. Either not created

2. Was not acessible - Privilege|permissions Issue

I checked for the reason and it was found that the directory was not available where I was trying to perform the restore. I created the same and provided the proper permissions to Oracle User. Once done, the restore was easily completed.

I hope this helps !!