Saturday, 14 October 2017

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 !!

No comments:

Post a comment