I have two servers, one with the target database and the other with the the recovery catalog. When I am making a bacuk up do I backup to the recovery catalog machine, I assume I do but when I try I get the following.
Check status of DBMS_BACKUP_RESTORE.BACKUPPIECECREATE
it must be VALID.
Check your paths.
06-21-2001, 10:14 AM
where can I find DBMS_BACKUP_RESTORE.BACKUPPIECECREATE .
06-21-2001, 10:26 AM
the error is you can not create a file in d:\backupfiles
try to create a file in there see what error you get.
06-21-2001, 10:26 AM
I have found the DBMS_BACKUP_RESTORE, how do i see if its valid?
06-21-2001, 11:38 AM
Should I be trying to create this backup on the recovery catalog machine or the database machine? I get the above error when trying to create it on the recovery catalog?
06-21-2001, 12:01 PM
Check to make sure that the user who does this backup has the write privileges on the directory that you have mentioned. To check whether your package is valid, you can query dba_objects.
06-21-2001, 12:08 PM
Yeah they have access through windows explorer but since rman is launched from a msdos window perhaps the machine is looking at its local drives and not the drives on the recovery catalog, and idea on how to make it look their?
06-21-2001, 12:24 PM
To better u.stand your problem, could you please tell us more about the setup and the application and OS versions?
06-21-2001, 12:57 PM
OK, here goes.
I have two machines, one NT server, the other is WinNT. I have Oracle 8.1.7 installed on both of them. On the NT Server I have one oracle database installed (the target database) on the other I have another database installed with the recovery catalog installed. When I try to make a backup with RMAN launched from an MS-DOS window I get the error as above where it says it cant find the drive d:\backup\. this drive is on the recovery catalog machine. If I change the backup dircetory to one on the target database machine the backup runs ok, but surely it should also backup to the recovery catalog machine without any problems?