03-27-2019 12:10 AM
Hello,
We are unable to restore Oracle DB to another server.
Oracle Version 11.2.0.2.0
attached file is the detail of error messages.
TNS names has been defined in ORACLE_HOME\NETWORK\ADMIN, but at the end of the file it says " ORA-12154 "
tnsnames.ora:
COMMS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <hostname>)(PORT = 1521))
)
(CONNECT_DATA =
(SID = COMMS)
)
)
The server itself can telnet to port 1521, so network conenction is not an issue.
did i miss something ?
Thanks,
MR
03-27-2019 03:13 AM
I see this error in the log file: 0xE0000340
Please have a look at this TN and see if it helps: https://www.veritas.com/support/en_US/article.100024618.html
Please also have a look at this TN for redirected restore:
https://www.veritas.com/support/en_US/article.100018450.html
(The link for Oracle user access no longer exists - please see this URL: https://www.veritas.com/support/en_US/article.100001916.html#Oracle_Agent)
Another related TN: https://www.veritas.com/content/support/en_US/article.100019620.html
03-27-2019 03:15 AM
For the benefit of everyone; here are some infos which are based from the attached log file (the latest restore attempt)
In this part everything is going correctly:
CDbsbOra::processMessage: 10> RESTORE CONTROLFILE FROM 'BE_c-3793180428-20190322-00';
CDbsbOra::processMessage: 13> alter database mount;
CDbsbOra::processMessage: Starting restore at 25-MAR-19
Then we get the RMAN error itself:
RMAN-03002: failure of restore command at 03/25/2019 10:51:35
ORA-27191: sbtinfo2 returned error
and then BE logs this error message telling us RMAN reported back an error:
CDbsbOra::runRmanCmd: Error occured while trying to execute RMAN
OCI_ERROR: ORA-12154: TNS:could not resolve the connect identifier specified
This points more to a general agent configuration issue on the new Oracle server
Have a look at:
https://www.veritas.com/content/support/en_US/article.100019620.html