This post is more than 5 years old
2 Intern
•
139 Posts
0
37816
March 19th, 2012 09:00
Error: ORA-19870: error while restoring backup piece during NMO restoration
Hi,
I am getting below error while restoring oracle database....Any help?
channel CH5: reading from backup piece MDA_9qn57i96_1_1
channel CH2: ORA-19870: error while restoring backup piece MDA_9nn57i92_1_1
ORA-19507: failed to retrieve sequential file, handle="MDA_9nn57i92_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Could not locate the LNM save file 'MDA_9nn57i92_1_1' on server 'dc1bkpsrvr02.cidr.gov.in'. (2:9:2)
Backup and client OS: REDHAT
Bkp server Version: 7.6.3
Client bkp version: 7.6.2
NMO : 5.0
No Events found!
SabarnaDeb
2 Intern
•
139 Posts
0
April 10th, 2012 07:00
Last time also restore database failed. Then we did crosscheck backup; post restoration of control file
Sample script:
RUN {
ALLOCATE CHANNEL CH1 TYPE 'SBT_TAPE';
SEND 'NSR_ENV=(NSR_SERVER=Backup server,NSR_CLIENT=client)';
Crosscheck backup;
RELEASE CHANNEL CH1; }
Restore and recover database completed successfully.
masonb
445 Posts
0
March 19th, 2012 10:00
Sabarna,
This could be an issue with your restore script - is it in format below?
run
{
allocate channel t1 type 'SBT_TAPE' parms
'ENV=(NSR_SERVER=server,NSR_CLIENT=client,NSR_DPRINTF=TRUE, NSR_DEBUG_FILE=/nsr/applogs/t1.log,NSR_DEBUG_LEVEL=2)' ;
release channel t1;
}
I think you may have send instead of parms in the script.
If so please amend and retry.
Regards,
Bill Mason
Bebo2k
544 Posts
0
March 19th, 2012 12:00
Hi Sabarna_Deb,
If you are performing directed recovery , make sure that the communications between the two clients is perfect , also check the hosts file on both clients, to make sure that there is entries for each client's hosts file to the other client.
Otherwise if you are recovering to the same machine, I believe the issue will be in the restore script as mentioned by William Mason in the previous post.
Thanks,
Ahmed Bahaa
SabarnaDeb
2 Intern
•
139 Posts
0
March 20th, 2012 07:00
Actually in backend, few RMAN backup sessions was running from stopped backup which makes controlfile inconsistent therefore controlfile is referring to some other database files which dosen't belong to latest full backup. I put all incomplete saveset in 'recyclable' mode and started fresh database full backup. I believe this time we should complete restoration. I will let you the result. Thanks for your valuable reply.
Bebo2k
544 Posts
0
March 23rd, 2012 03:00
Hi Sabarna_Deb,
How is it going now ? is there any updates ?
Thanks,
Ahmed Bahaa
SabarnaDeb
2 Intern
•
139 Posts
0
March 23rd, 2012 05:00
Hi,
RESTORE_DATABASE; - is in progress successfully. Lets see what will happen during RECOVER_DATABASE;.