Question
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 4 123 ... LastLast
Results 1 to 10 of 34

Thread: Question

  1. #1
    Join Date
    Apr 2001
    Posts
    142
    Hi,

    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.

    C:\>rman target="sys/manager@zgts-cluster2" rcvcat="rman/rman@rman"

    Recovery Manager: Release 8.1.7.0.0 - Production

    RMAN-06005: connected to target database: PICIS_DB (DBID=1703831024)
    RMAN-06008: connected to recovery catalog database

    RMAN> run {
    2> allocate channel ch1 type disk;
    3> backup
    4> format='d:\backupfiles\%t.%d.%s.%p'
    5> database;
    6> release channel ch1;
    7> }

    RMAN-03022: compiling command: allocate
    RMAN-03023: executing command: allocate
    RMAN-08030: allocated channel: ch1
    RMAN-08500: channel ch1: sid=10 devtype=DISK

    RMAN-03022: compiling command: backup
    RMAN-03023: executing command: backup
    RMAN-08008: channel ch1: starting full datafile backupset
    RMAN-08502: set_count=2 set_stamp=433000241 creation_time=21-JUN-01
    RMAN-08010: channel ch1: specifying datafile(s) in backupset
    RMAN-08522: input datafile fno=00007 name=D:\ORACLEDATA\PCS_RT_INDXS.DBF
    RMAN-08522: input datafile fno=00008 name=D:\ORACLEDATA\PCS_RT_DATA.DBF
    RMAN-08522: input datafile fno=00010 name=D:\ORACLEDATA\PCS_CARE_INDXS.DBF
    RMAN-08522: input datafile fno=00009 name=D:\ORACLEDATA\PCS_CARE_DATA.DBF
    RMAN-08522: input datafile fno=00012 name=D:\ORACLEDATA\PCS_COMMON_INDXS.DBF
    RMAN-08522: input datafile fno=00001 name=F:\ORACLE\ORA817\DATABASE\SYSPICIS.ORA
    RMAN-08011: including current controlfile in backupset
    RMAN-08522: input datafile fno=00002 name=F:\ORACLE\ORA817\DATABASE\PCS_TEMP01.DBF
    RMAN-08522: input datafile fno=00011 name=D:\ORACLEDATA\PCS_COMMON_DATA.DBF
    RMAN-08522: input datafile fno=00013 name=D:\ORACLEDATA\PCS_LABS_INDXS.DBF
    RMAN-08522: input datafile fno=00014 name=D:\ORACLEDATA\PCS_LABS_DATA.DBF
    RMAN-08522: input datafile fno=00015 name=D:\ORACLEDATA\PCS_PREOP_DATA.DBF
    RMAN-08522: input datafile fno=00016 name=D:\ORACLEDATA\PCS_PREOP_INDXS.DBF
    RMAN-08522: input datafile fno=00017 name=D:\ORACLEDATA\PCS_EXTERNAL_DATA.DBF
    RMAN-08522: input datafile fno=00018 name=D:\ORACLEDATA\PCS_EXTERNAL_INDXS.DBF
    RMAN-08522: input datafile fno=00019 name=F:\RMAN\RMANDATA.DBF
    RMAN-08522: input datafile fno=00003 name=F:\ORACLE\ORA817\DATABASE\PCS_RBS_01.DBF
    RMAN-08522: input datafile fno=00004 name=F:\ORACLE\ORA817\DATABASE\PCS_RBS_02.DBF
    RMAN-08522: input datafile fno=00005 name=F:\ORACLE\ORA817\DATABASE\PCS_RBS_03.DBF
    RMAN-08522: input datafile fno=00006 name=F:\ORACLE\ORA817\DATABASE\PCS_RBS_04.DBF
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03007: retryable error occurred during execution of command: backup
    RMAN-07004: unhandled exception during command execution on channel ch1
    RMAN-10035: exception raised in RPC: ORA-19504: failed to create file "d:\backupfiles\433000241.PICIS_DB.2.1"
    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.
    RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE


    Any ideas?

    Thanks

  2. #2
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    Check status of DBMS_BACKUP_RESTORE.BACKUPPIECECREATE
    it must be VALID.
    Check your paths.

  3. #3
    Join Date
    Apr 2001
    Posts
    142
    Hi,

    where can I find DBMS_BACKUP_RESTORE.BACKUPPIECECREATE .

    Thanks

  4. #4
    Join Date
    Nov 2000
    Posts
    245

    the error is you can not create a file in d:\backupfiles
    try to create a file in there see what error you get.

  5. #5
    Join Date
    Apr 2001
    Posts
    142
    I have found the DBMS_BACKUP_RESTORE, how do i see if its valid?

  6. #6
    Join Date
    Apr 2001
    Posts
    142
    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?

  7. #7
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  8. #8
    Join Date
    Apr 2001
    Posts
    142
    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?

  9. #9
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    To better u.stand your problem, could you please tell us more about the setup and the application and OS versions?

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  10. #10
    Join Date
    Apr 2001
    Posts
    142
    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?

    Any idea?

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width