This discussion is archived
1 2 Previous Next 26 Replies Latest reply: Nov 7, 2012 1:01 PM by ReubenC RSS

backingup rman backups to a different static ip

949210 Newbie
Currently Being Moderated
Greetings Oracle Network!!

(using oracle 10g on windows server 2003)
i have two static ips A and B
the database runs on static ip A
as soon as i execute the rman backup script the backup should be backed up in static ip B

i have shared a folder and used UNC(Universal naming convention) in my rman script
this is working perfectly while i use it between two computers in LAN
but when i use the same script between two static ips i get OS 53 ERROR

i did get os5 and os 3 errors previously which were resolved when i used UNC
(i had used map a network drive option )
please help
googling it does not provide any concrete results
Thanks in advance
  • 1. Re: backingup rman backups to a different static ip
    Balazs Papp Expert
    Currently Being Moderated
    you have to use UNC path when referencing network shares, mapped network folders wont work with Oracle on Windows

    Error 53 is related to name resolution:
    http://technet.microsoft.com/en-us/library/cc940100

    make sure the netbios name and DNS are configured properly (or use the IP address instead of hostname)
  • 2. Re: backingup rman backups to a different static ip
    949210 Newbie
    Currently Being Moderated
    hi
    Balazs Papp     

    so will backing up the backup to remote location work on windows server 2003??
    (
    plz let me repeat
    i dont want a stored backup to exist on the static ip A
    as soon as the "backup database" command is executed it should be using the location on static ip B
    )

    also
    mapping a network drive requires me to share a folder first,
    is there any other idea altogether??
    thanks in advance
  • 3. Re: backingup rman backups to a different static ip
    Ahmer Mansoor Journeyer
    Currently Being Moderated
    Share a Folder with Limited Security and Sharing Permissions Specific to the user used to copy backup. and then map it as network drive and use.

    Rgds,

    Ahmer
  • 4. Re: backingup rman backups to a different static ip
    949210 Newbie
    Currently Being Moderated
    hi ahmer
    (thanx)
    thats what i did...
    rman shows errors like OS 53 , OS5 AND 0S3
    of which OS 5 and OS 53 are persistent..
    any suggestion to circumvent these please..
  • 5. Re: backingup rman backups to a different static ip
    Ahmer Mansoor Journeyer
    Currently Being Moderated
    Please post the exact error messages.

    Rgds,

    Ahmer
  • 6. Re: backingup rman backups to a different static ip
    949210 Newbie
    Currently Being Moderated
    RMAN> backup tablespace statspack_ts format '\\Vault\testbackup\test\%U';

    Starting backup at 14-JUL-12
    using channel ORA_DISK_1
    channel ORA_DISK_1: starting full datafile backupset
    channel ORA_DISK_1: specifying datafile(s) in backupset
    input datafile fno=00005 name=E:\DB\AL4TEST\DATA\STATSPACK_TS.DBF
    channel ORA_DISK_1: starting piece 1 at 14-JUL-12
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/14/2012 10:49:
    17
    ORA-19504: failed to create file "\\VAULT\TESTBACKUP\TEST\11NG2GLA_1_1"
    ORA-27040: file create error, unable to create file
    OSD-04002: unable to open file
    O/S-Error: (OS 5) Access is denied.

    RMAN> backup tablespace statspack_ts format '\\Vault\testbackup\test\%U';

    Starting backup at 14-JUL-12
    using channel ORA_DISK_1
    channel ORA_DISK_1: starting full datafile backupset
    channel ORA_DISK_1: specifying datafile(s) in backupset
    input datafile fno=00005 name=E:\DB\AL4TEST\DATA\STATSPACK_TS.DBF
    channel ORA_DISK_1: starting piece 1 at 14-JUL-12
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/14/2012 11:03:
    54
    ORA-19504: failed to create file "\\VAULT\TESTBACKUP\TEST\12NG2HG1_1_1"
    ORA-27040: file create error, unable to create file
    OSD-04002: unable to open file
    O/S-Error: (OS 53) The network path was not found.
    ========================================================================
    ========================================================================
    using ipadress instead of Vault will not do any good.. it will return an error of os 3
    regards
    946207
  • 7. Re: backingup rman backups to a different static ip
    Ahmer Mansoor Journeyer
    Currently Being Moderated
    ORA-19504: failed to create file "\\VAULT\TESTBACKUP\TEST\11NG2GLA_1_1"
    you tell us that you are using "MAPPED NETWORK DRIVE".

    Well!

    Do following steps to resolve the issue

    run "\\VAULT\TESTBACKUP\TEST" to check the destination exists and accessible.
    then check the FOLDER security setting on the destination machine to check the user has necessary Write Permissions or not.
    Also check that the necessary space is available at the Destination Drive.

    Hopefully, Your problem will be resolved.


    Rgds,

    Ahmer
  • 8. Re: backingup rman backups to a different static ip
    949210 Newbie
    Currently Being Moderated
    1)yeah the "mapped drive" exists as testbackup on 'xx.xx.xx.xx'(Z:)
    2)win+r>\\Vault\testbackup asks for the password of the static ip B
    as soon as i enter the password the location DOES OPEN

    i think:
    rman says 'access denied' coz rman cannot display the password-entering interface
    also
    rman is not using the mapped drive,its trying to transfer the contents directly
  • 9. Re: backingup rman backups to a different static ip
    949210 Newbie
    Currently Being Moderated
    os 1326
    is the error when i try to use the below link
    http://www.dba-oracle.com/t_os_error_os5_access_denied.htm

    also plz check the post
    making rman-backup-to-shared-disk fix-up work how i want it to
    thanks in advance
  • 10. Re: backingup rman backups to a different static ip
    Balazs Papp Expert
    Currently Being Moderated
    rman says 'access denied' coz rman cannot display the password-entering interface
    so what have you done to solve this? did you turn off password protected sharing and give the proper access rights?
    this problem is on Windows side, not Oracle
  • 11. Re: backingup rman backups to a different static ip
    949210 Newbie
    Currently Being Moderated
    the errors are all prefixed with 'os' so it is evident that it is an error of windows
    however, the writing to the files from static ip a to b and vice versa is possible from windows explorer if you open a notepad and type few lines
    rman is an oracle utility and is not able to use this

    and yes the access rights are there
    and password prompt is off

    i have not been able to figure out a way out of this
    one of the site has asked me to use 5146667 patch
    any idea regarding this?? will it help??
    heres the link
    http://exploreoracle.blogspot.in/2009/01/backup-to-remote-location-fails-with_19.html its inside this site
    can patches be reverted??
    any ideas regarding fixing it without patching would be a great help
    else
    i'l have to patch
    someone plz help.. this is driving me nuts..
    thanks in advance

    Edited by: 946207 on Jul 16, 2012 5:53 AM
  • 12. Re: backingup rman backups to a different static ip
    720708 Newbie
    Currently Being Moderated
    hi,
    if you have metalink access privs.

    check this doc [ID 145843.1]

    "The problem of backing up to a mapped network drive using the SYSTEM account is a security issue. By default, Oracle requires the SYSTEM user to have privileges to write to the drives. Microsoft considers granting SYSTEM owned service access to a shared drive a security issue.

    However, there is a workaround that allows Oracle to access a shared drive.
    The Oracle services are originally configured to log on using the SYSTEM account. The SYSTEM account should not be granted access to the shared drive, therefore the Oracle services for the TARGET DB need to be reconfigured to logon using an Administrator account (preferably a Domain Administrator).
    "

    regards
  • 13. Re: backingup rman backups to a different static ip
    949210 Newbie
    Currently Being Moderated
    hi ym
    yes i have changed the service to work as administrator
    what else should i exactly do?? please tell me
    i will be getting access to metalink after a day... have already told the organization about the id...
    what do you mean by preferrably a domain administrator?? will you elaborate on how to find that in windows server 2003??
    for a certain period i got os 1326 also
    now its os 53 once again"network path not found"
    regards

    Edited by: 946207 on Jul 17, 2012 4:01 AM
  • 14. Re: backingup rman backups to a different static ip
    720708 Newbie
    Currently Being Moderated
    hi,

    1-don't use $ in shared drive name
    2-change backup script to

    allocate channel ch1 type disk;
    backup database format '\\<SERVER_NAME>\ORADATA\PD01\%d_s%s_%p';

    Or use RMAN configuration like this
    CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '\\<SERVER_NAME>\BACKUP\%format%';

    3- check user privs
         - Go to Administrative Tools
         - Click on Local Security Policy
         - Select User Right Assignments under Local Policies
         - Ensure that the rights "Log on as a service" and "Log on as a batch job" are provided for the Local Admins, the local admin user, the domain admin user or user who you are using to connect.


    4-Give full control grant to the "Administrator" on the shared location(on the machine where you write the backup files to)
    5-On the DB machine verify the Administrator user has the same password with target machine administrator user.(if you use domain admin user for this issue you can automatically have same password on db machine and target machine)

    (important tip is db server user and target server user have full privs on shared location and those users have same password)

    6-On the db machine start the Oracle services and listener services must be start using the administrator account/password.
    - Go to the Control Panel and then open up the Services panel.
    - Double click on the appropriate service (TNSListener or OracleService<SID>).
    - Change the "Log on as" user from the "Local System Account" to "This Account".
    - Specify the service to log on as the Administrator user.
    - Click on "OK".

    7-shutdown db(shutdown immediate), stop services(db and listener). Then start listener and db services afterwards.

    You should now be able to use RMAN.



    Note:

    -Make sure user who is starting the services is in the same domain as the
    network drive on which you are trying to create the datafile.

    -Make sure user who is starting the Listener is in the same domain as the network
    drive on which you are trying to create the datafile.

    -You can use Oracle Software Owner User to resolve this issue for applying step 3,4,5 to this user.

    regards
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points