Home » RDBMS Server » Backup & Recovery » Duplicate Database Unable to Read Backupset (Oracle 10.2 - Windows 2003 Server)
Duplicate Database Unable to Read Backupset [message #592064] Fri, 02 August 2013 15:54 Go to next message
guardian__J
Messages: 7
Registered: August 2013
Location: United States
Junior Member
I'm running the following and getting access denied errors.
What do I need to do to make the recovery files available of the duplicate host?
I cataloged the backupsets at the network path of where they are, I don't have space on the drive for the backupset and the restored database once it's done. What should I be looking at?

*Results filtered for length on duplicate lines

RMAN> DUPLICATE TARGET DATABASE TO Test
2> DEVICE TYPE DISK PFILE='D:\ORACLE\ORA102\DATABASE\INITTEST.ORA';

Starting Duplicate Db at 02-AUG-13
released channel: ORA_AUX_DISK_1
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=155 devtype=DISK

contents of Memory Script:
{
set until scn 2875467028;
set newname for clone datafile 1 to new;
set newname for clone datafile 2 to new;
...TRIMMED
set newname for clone datafile 81 to new;
set newname for clone datafile 82 to new;
restore
check readonly
clone database
;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

...TRIMMED

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 02-AUG-13
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00002 to D:\ORACLE\ORADATA\TEST\DATAFILE\O1_MF_SYSTEM_%U_.DBF
restoring datafile 00005 to D:\ORACLE\ORADATA\TEST\DATAFILE\O1_MF_SYSAUX_%U_.DBF
restoring datafile 00006 to D:\ORACLE\ORADATA\TEST\DATAFILE\O1_MF_SYSAUX_%U_.DBF
restoring datafile 00009 to D:\ORACLE\ORADATA\TEST\DATAFILE\O1_MF_MASTER_L_%U_.DBF
restoring datafile 00010 to D:\ORACLE\ORADATA\TEST\DATAFILE\O1_MF_MASTER_L_%U_.DBF
restoring datafile 00012 to D:\ORACLE\ORADATA\TEST\DATAFILE\O1_MF_MASTER_I_%U_.DBF
...TRIMMED
restoring datafile 00080 to D:\ORACLE\ORADATA\TEST\DATAFILE\O1_MF_DTL_TRNH_%U_.DBF
restoring datafile 00082 to D:\ORACLE\ORADATA\TEST\DATAFILE\O1_MF_SYS_UNDO_%U_.DBF
channel ORA_AUX_DISK_1: reading from backup piece D:\BACKUP\RMAN\ORA_PROD_T822340824_S63_P1
ORA-19870: error reading backup piece \\ORACLE1\D$\BACKUP\RMAN\ORA_PROD_T822340824_S63_P1
ORA-19505: failed to identify file "\\ORACLE1\D$\BACKUP\RMAN\ORA_PROD_T822340824_S63_P1"
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.
channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to D:\ORACLE\ORADATA\TEST\DATAFILE\O1_MF_SYSTEM_%U_.DBF
restoring datafile 00003 to D:\ORACLE\ORADATA\TEST\DATAFILE\O1_MF_IDX_FDCO_%U_.DBF
restoring datafile 00007 to D:\ORACLE\ORADATA\TEST\DATAFILE\O1_MF_MASTER_C_%U_.DBF
restoring datafile 00008 to D:\ORACLE\ORADATA\TEST\DATAFILE\O1_MF_MASTER_C_%U_.DBF
restoring datafile 00011 to D:\ORACLE\ORADATA\TEST\DATAFILE\O1_MF_MASTER_I_%U_.DBF
...TRIMMED
restoring datafile 00079 to D:\ORACLE\ORADATA\TEST\DATAFILE\O1_MF_DTL_TRNH_%U_.DBF
restoring datafile 00081 to D:\ORACLE\ORADATA\TEST\DATAFILE\O1_MF_SYS_UNDO_%U_.DBF
channel ORA_AUX_DISK_1: reading from backup piece D:\BACKUP\RMAN\ORA_PROD_T822341830_S64_P1
ORA-19870: error reading backup piece \\ORACLE1\D$\BACKUP\RMAN\ORA_PROD_T822341830_S64_P1
ORA-19505: failed to identify file "\\ORACLE1\D$\BACKUP\RMAN\ORA_PROD_T822341830_S64_P1"
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.
failover to previous backup

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 08/02/2013 16:43:42
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 82 found to restore
RMAN-06023: no backup or copy of datafile 81 found to restore
...TRIMMED
RMAN-06023: no backup or copy of datafile 10 found to restore
RMAN-06023: no backup or copy of datafile 9 found to restore
MAN-06023: no ba
RMAN>
Re: Duplicate Database Unable to Read Backupset [message #592065 is a reply to message #592064] Fri, 02 August 2013 16:07 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>O/S-Error: (OS 5) Access is denied.
Either the file does not exist or has incorrect OS file permission mask
Re: Duplicate Database Unable to Read Backupset [message #592066 is a reply to message #592065] Fri, 02 August 2013 16:10 Go to previous messageGo to next message
guardian__J
Messages: 7
Registered: August 2013
Location: United States
Junior Member
How can I check? I can fully access the path from both the host and the duplicate.

Before I cataloged the backups on the dup, I was getting an error about file not found. So I know it can see it now. I granted Everyone-Full Access permissions to the folder and files, still no success.
Re: Duplicate Database Unable to Read Backupset [message #592067 is a reply to message #592066] Fri, 02 August 2013 16:12 Go to previous messageGo to next message
guardian__J
Messages: 7
Registered: August 2013
Location: United States
Junior Member
Does it have anything to do with how the channel is allocated? How do I know what user it is connecting as?
Re: Duplicate Database Unable to Read Backupset [message #592068 is a reply to message #592067] Fri, 02 August 2013 16:15 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I granted Everyone-Full Access permissions to the folder and files, still no success.
Not only does the file permission mask on the file matter, the same is true for every folder from the root folder down to the folder where the file resides.
Re: Duplicate Database Unable to Read Backupset [message #592069 is a reply to message #592068] Fri, 02 August 2013 16:19 Go to previous messageGo to next message
guardian__J
Messages: 7
Registered: August 2013
Location: United States
Junior Member
I was able to access the files from rman on the dup system to add them to the catalog. I can see and access the files. What other permissions would it be?
Is it using the user that I am logged onto the server and running the rman executable?

[Updated on: Fri, 02 August 2013 16:19]

Report message to a moderator

Re: Duplicate Database Unable to Read Backupset [message #592070 is a reply to message #592069] Fri, 02 August 2013 16:25 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Which user owns the file?
Which user owns RMAN.EXE?
Which user is invoking RMAN?

Needless to say, it simplifies things if the same OS user is same answer to all 3 questions above.
Re: Duplicate Database Unable to Read Backupset [message #592071 is a reply to message #592070] Fri, 02 August 2013 16:30 Go to previous messageGo to next message
guardian__J
Messages: 7
Registered: August 2013
Location: United States
Junior Member
Yes, it is my user. The one I logged into the box and created the backups with.
Technically, it is listed as "Administrators" in file properties. Of which I am.
Re: Duplicate Database Unable to Read Backupset [message #592072 is a reply to message #592071] Fri, 02 August 2013 16:38 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>ORA-19505: failed to identify file "\\ORACLE1\D$\BACKUP\RMAN\ORA_PROD_T822340824_S63_P1"

does this file actually reside on different system & is "remote mounted" onto your local system?
Re: Duplicate Database Unable to Read Backupset [message #592073 is a reply to message #592072] Fri, 02 August 2013 16:42 Go to previous messageGo to next message
guardian__J
Messages: 7
Registered: August 2013
Location: United States
Junior Member
It is a different system, I did not map a drive to the other system.
But in the same command prompt instance I am running rman, I can run "dir \\ORACLE1\D$\BACKUP\RMAN\" and get a full listing of the files.

Not sure "remote mounted" translates in windows networking...
Re: Duplicate Database Unable to Read Backupset [message #592078 is a reply to message #592073] Sat, 03 August 2013 00:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Owner of the instance is most often (and by default) local SYSTEM which has no access right on the network and so on network drives.
Check Oracle services.

Regards
Michel

[Updated on: Sat, 03 August 2013 00:19]

Report message to a moderator

Re: Duplicate Database Unable to Read Backupset [message #592192 is a reply to message #592078] Mon, 05 August 2013 09:43 Go to previous messageGo to next message
guardian__J
Messages: 7
Registered: August 2013
Location: United States
Junior Member
Thank you, Michel. After changing the user account for the service, I had ORA-12631: Username retrieval failed trying to log in.
This page: http://geotiger.wordpress.com/2009/07/20/how-to-solve-ora-12631-username-retrieval-failed/ had useful information.

Thanks, my duplicate is now functioning.
Re: Duplicate Database Unable to Read Backupset [message #592197 is a reply to message #592192] Mon, 05 August 2013 10:35 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks to let us know.

Regards
Michel
Previous Topic: ORA-01652: unable to extend temp segment by 128
Next Topic: Restore with archive log only
Goto Forum:
  


Current Time: Thu Mar 28 11:41:25 CDT 2024