Saturday, November 17, 2018

RMAN Issues And Solutions Troubleshooting

Hi DBA-Mates, Hope you all are doing Great!!!
We are back with some more issues and solutions.

Issue:
RMAN-03002: failure of Duplicate Db command at 10/24/2012 06:47:35
RMAN-05501: aborting duplication of target database
RMAN-06174: not connected to auxiliary database
RMAN-06217: not connected to auxiliary database with a net service name

Solution:
In our case we have created orapwfile and issue got resolved.
Create a password file for the auxiliary instance.

For the sysdba connection as sys, the password can be stored externally from the database in the password file.
Also, we can grant any user without sharing sys password with user like ABC.
Creating a password file via orapwd enables remote users to connect with administrative privileges through SQL*Net.

Password file on the production server as well as on the auxiliary server
When creating standby database from RMAN, the password file has to be same.

$ orapwd file=$ORACLE_HOME/dbs/orapwaux password=test entries=<number always multiple of 4>;

Error:
RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due
RMAN-06208:          to mismatched status.  Use CROSSCHECK command to fix status
RMAN-06210: List of Mismatched objects
RMAN-06212:   Object Type   Filename/Handle
RMAN-06214: Datafile Copy   /po1/rmanbkp/tech/backup/snapcf_tech.f

Solution:
Here, we need to cross check the controlfile.
CROSSCHECK COPY OF CONTROLFILE;

Please let us know for any suggestions or corrections. Hope this may useful and helpful here to you all.
If you people have any such error or solution and want to share with us here, please write to us either in contact or contact us box.
Also, if you have any issue and want solution please let us know, we will try our best to resolve issue.

No comments:

Post a Comment