Unsolved
This post is more than 5 years old
202 Posts
0
1224
Oracle recover failing (nmda)
Dear Experts!
Our customer using a quite old NW version 8.2.2 and and Oracle 11 with nmda. (nmda version: 8.2.2)
We want to recover data with rman scripts from Oracle.
The plan is:
-------------
Database backup from server1 to tape
Restore data from backup to server2
We use the following rman script:
...
send 'NSR_ENV=(NSR_SERVER=backup_server,NSR_CLIENT=server1,NSR_DATA_VOLUME_POOL=
"Pool test",NSR_DEBUG_LEVEL=8)';
duplicate target database for standby
...
However the backup is failing with the following error:
SBT-105412 02/05/2018 03:52:18 PM lnm_index_cfx_pconn:
Exceeded the number of retries. The NetWorker server may be down or unreachable. (2:10:11)
in another case it has a timeout for many times ...
There is nothing in the Networker logs. The backup from server1 is working well.
Question:
---------
- How can we recover?
- Any tipps and suggestions?
Thanks a lot!
BR:
Pal
wlee
263 Posts
1
February 9th, 2018 19:00
The errors clearly suggests a connection issue between the NetWorker server and server2
Database backup from server1 to tape ... Restore data from backup to server2
SBT-105412 02/05/2018 03:52:18 PM lnm_index_cfx_pconn:
Exceeded the number of retries. The NetWorker server may be down or unreachable. (2:10:11)
in another case it has a timeout for many times ...
The backup from server1 is working well.
Please check the following:
Is server2 also defined and configured as a NetWorker client on the NetWorker server?
In the NetWorker client resource for server1, look at the remote access field. Is server2 listed? It should have one of the following for server2 to be able to recover server1's data:
server2
user@server2
*@server2
*@*
Did you ever try backing up server2 successfully? If not then try backing up server2's host file.
If server2's file system backups are working, then try recovering a file from server2's file system backup. ex: server2's host file. Please redirect to a recover directory on server2.
If server2's file system backup and recovery are successful, then it is more likely an issue with the Oracle recovery, and an in depth review of the RMAN recovery logs should be done
paulo3
202 Posts
0
February 12th, 2018 01:00
Thanks for the suggestions!
Simple file level backups and restore to different server is working well. (tmp files)
Customer is testing now the oracle backups and recovery from rman scripts ...
wlee
263 Posts
1
February 12th, 2018 06:00
If local file system backup and recovery for server2 is working... then try recovering a file from server1 to server2. This task is called a Directed Recovery.
Question: for server1, which storage node is used to save the backup? The backup server, or a remote storage node? If the data was written to a storage node device, can server2 also backup to that storage node?
Question: can server1 and server2 communicate with each other? using ping, traceroute, nsradmin?