Search

Join this Blog for direct reference of any post into your inbox. To join just click on "Join this Site" under "Follower" then Login with your Email.*** DECLARATION: I Maintain this Blog for Helping Myself While at Work and Welcome any body Needing Help!!!.*** CAUTION: Using any of the script from this Blog may contain at Own Risk. These scripts May or May not have been Tested.***

Sunday, 22 April 2012

RMAN Backup on Network Storage

While trying to take Oracle Backup using RMAN to network storage (windows shared folder), you will encounter some errors like the following.
Database: Oracle 9i
OS: Windows 2003
Symptom(s)
When attempting a backup via RMAN with shared disk's, you receive error message:
RMAN-03009: failure of copy command on c01  channel at 08/12/2003 15:22:51
ORA-19504: failed to create file "H:\ORACLE\ORADATA\PD01\SYSTEM01.DBF"
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified
Or error message:
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/07/2009 10:33:55
ORA-19504: failed to create file "\\192.168.1.99\NAS\BACKUP_CONTROLFILE_119.BKP"
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 1326) Logon failure: unknown user name or bad password.

What we will do ? to Resolve this Issue
The following are step-by-step instructions for configuring RMAN to write to mapped (shared/networked) drive(s) on Windows platforms.
Notes: 
§    We will create 'test' as password for Administrator user accounts on the two servers "Destination" and "Target DB".
§    Using local drive letters for mapping network shares will not work on Windows 2003/2008/XP/7/Vista.
1. On the "Destination" machine where you wish to write the backup files to, create a shared folder and grant the user 'Administrator' FULL Control.
2. On the machine with the Target DB, verify the Administrator user has the same password of the user that shared the drive on the destination machine. 
3. On the TARGET machine, BOTH the OracleTNSListener Service and theOracleService services must be configured to start using the Administrator/test account.
   a. Go to the Control Panel and then open up the Services panel.
   b. Double click on the appropriate service   (TNSListener or OracleService).
   c. Change the "Log on as" user from the "Local System Account" to "This Account".
   d. Specify the service to log on as the Administrator user. 
   c. Click on "OK".
4. Shutdown the TARGET database and stop and start the services on the Target   machine.  Restart the TARGET database.
5. You should now be able to use RMAN from the Catalog machine to copy the datafiles. In the RMAN script, specify the UNC locations directly. For example: \\192.168.14.32\orabackup

Some other common Mistakes:
If the OracleService<SID> and OracleTNSListener services are not configured to use the same account as the shared drive, you can expect the following errors:
RMAN-10035: exception raised in RPC: ORA-19504: failed to create file
"<file name>"
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.
ORA-19600: input file is datafile 1(<path and file name of Datafile 1>)
ORA-19601: output file is datafile-copy 0(<path and file name of file
to be created>)
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.COPYDATAFILE
If the mapped drive is created on the CATALOG machine and not on the TARGET you can expect the following errors.
RMAN-10035: exception raised in RPC: ORA-19504: failed to create file "<file name>"
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
ORA-19600: input file is datafile 1 (<path and file name of Datafile 1>)
ORA-19601: output file is datafile-copy 0 (<path and file name of file to be created>)
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.COPYDATAFILE


0 comments:

Post a Comment