+ Reply to Thread
Results 1 to 10 of 10

RMAN restore and the location backupset is different

  1. RMAN restore and the location backupset is different

    RMAN restore and the location backupset is different

    Hi,
    Here is scenario:
    - RDBMS: 9.2.0.3
    - rman backup using controlfile (no catalog db)
    - Rman backup with CONTROLFILE AUTOBACKUP ON and backup set was
    pointed to /prod/prod_backup.bk of prod server.
    - ftp the auto control file backupset and databse backupset to /uat of
    uat server.
    - Proceed restore database on uat node
    - Succeed restore control file using:
    RMAN> restore controlfile from '/u02/control_backup.bk'

    - However, I can not restore database, I receive message
    ORA-19505: "failed to identify file '/prod/prod_backup.bk'."

    Anybody know how to update for rman to know my new backupset location
    (as now it's in /uat/prod_backup.bk)?

    Note: I don't want to use soft link on this case.

  2. Re: RMAN restore and the location backupset is different

    Your toast ... if you use RMAN without a recovery catalog, it stores
    the backup/recovery information in the controlfile -- you cannot use a
    backup controlfile and expect it to work.

    Domenic.

    hvcao_vn@yahoo.com (Vinh) wrote in message news:...
    > RMAN restore and the location backupset is different
    >
    > Hi,
    > Here is scenario:
    > - RDBMS: 9.2.0.3
    > - rman backup using controlfile (no catalog db)
    > - Rman backup with CONTROLFILE AUTOBACKUP ON and backup set was
    > pointed to /prod/prod_backup.bk of prod server.
    > - ftp the auto control file backupset and databse backupset to /uat of
    > uat server.
    > - Proceed restore database on uat node
    > - Succeed restore control file using:
    > RMAN> restore controlfile from '/u02/control_backup.bk'
    >
    > - However, I can not restore database, I receive message
    > ORA-19505: "failed to identify file '/prod/prod_backup.bk'."
    >
    > Anybody know how to update for rman to know my new backupset location
    > (as now it's in /uat/prod_backup.bk)?
    >
    > Note: I don't want to use soft link on this case.


  3. Re: RMAN restore and the location backupset is different

    hvcao_vn@yahoo.com (Vinh) wrote in message news:...
    > RMAN restore and the location backupset is different
    >
    > Hi,
    > Here is scenario:
    > - RDBMS: 9.2.0.3
    > - rman backup using controlfile (no catalog db)
    > - Rman backup with CONTROLFILE AUTOBACKUP ON and backup set was
    > pointed to /prod/prod_backup.bk of prod server.
    > - ftp the auto control file backupset and databse backupset to /uat of
    > uat server.
    > - Proceed restore database on uat node
    > - Succeed restore control file using:
    > RMAN> restore controlfile from '/u02/control_backup.bk'
    >
    > - However, I can not restore database, I receive message
    > ORA-19505: "failed to identify file '/prod/prod_backup.bk'."
    >
    > Anybody know how to update for rman to know my new backupset location
    > (as now it's in /uat/prod_backup.bk)?
    >
    > Note: I don't want to use soft link on this case.


    I believe Oracle does not care what you want. The filename must be the same.

    jg
    --
    @home.com is bogus.
    http://www.signonsandiego.com/news/u...s_1b16ibm.html

  4. Re: RMAN restore and the location backupset is different

    Thx for your info.
    If I use rman qwith catalog, can I specify the new location of backupset?
    Regards
    Vinh

    domenicg@hotmail.com (Domenic G.) wrote in message news:...
    > Your toast ... if you use RMAN without a recovery catalog, it stores
    > the backup/recovery information in the controlfile -- you cannot use a
    > backup controlfile and expect it to work.
    >
    > Domenic.
    >


  5. Re: RMAN restore and the location backupset is different

    On 16 Oct 2003 17:28:31 -0700, joel-garry@home.com (Joel Garry) wrote:

    >> Anybody know how to update for rman to know my new backupset location
    >> (as now it's in /uat/prod_backup.bk)?
    >>
    >> Note: I don't want to use soft link on this case.

    >
    >I believe Oracle does not care what you want. The filename must be the same.



    I don't think that is true, but I also don't want to RTFM on behalf of
    the OP. For duplicating purposes you definitely can change
    directories.


    --
    Sybrand Bakker, Senior Oracle DBA

  6. Re: RMAN restore and the location backupset is different

    Domenic G. wrote:

    > Your toast ... if you use RMAN without a recovery catalog, it stores
    > the backup/recovery information in the controlfile -- you cannot use a
    > backup controlfile and expect it to work.



    The whole point of setting autobackup on, of course.

    Which our OP did.

    Therefore he is not toast.

    However, under no circumstances can a backup done to /bin/bong suddenly
    appear in /bing/bong and be expected to work.

    Sym links are the only way I know of to make this work.

    Regards
    HJR




    >
    > Domenic.
    >
    > hvcao_vn@yahoo.com (Vinh) wrote in message
    > news:...
    >> RMAN restore and the location backupset is different
    >>
    >> Hi,
    >> Here is scenario:
    >> - RDBMS: 9.2.0.3
    >> - rman backup using controlfile (no catalog db)
    >> - Rman backup with CONTROLFILE AUTOBACKUP ON and backup set was
    >> pointed to /prod/prod_backup.bk of prod server.
    >> - ftp the auto control file backupset and databse backupset to /uat of
    >> uat server.
    >> - Proceed restore database on uat node
    >> - Succeed restore control file using:
    >> RMAN> restore controlfile from '/u02/control_backup.bk'
    >>
    >> - However, I can not restore database, I receive message
    >> ORA-19505: "failed to identify file '/prod/prod_backup.bk'."
    >>
    >> Anybody know how to update for rman to know my new backupset location
    >> (as now it's in /uat/prod_backup.bk)?
    >>
    >> Note: I don't want to use soft link on this case.


    --
    --------------------------------------------
    See my brand new website, soon to be full of
    new articles: www.dizwell.com.
    Nothing much there yet, but give it time!!
    --------------------------------------------


  7. Re: RMAN restore and the location backupset is different

    Domenic G. wrote:

    >Your toast ... if you use RMAN without a recovery catalog, it stores
    >the backup/recovery information in the controlfile -- you cannot use a
    >backup controlfile and expect it to work.
    >
    >Domenic.
    >
    >
    >
    >

    What is the origin of this incorrect advice?

    --
    Daniel Morgan
    http://www.outreach.washington.edu/e...ad/oad_crs.asp
    http://www.outreach.washington.edu/e...oa/aoa_crs.asp
    damorgan@x.washington.edu
    (replace 'x' with a 'u' to reply)


  8. Re: RMAN restore and the location backupset is different

    Sybrand Bakker wrote in message news:...
    > On 16 Oct 2003 17:28:31 -0700, joel-garry@home.com (Joel Garry) wrote:
    >
    > >> Anybody know how to update for rman to know my new backupset location
    > >> (as now it's in /uat/prod_backup.bk)?
    > >>
    > >> Note: I don't want to use soft link on this case.

    > >
    > >I believe Oracle does not care what you want. The filename must be the same.

    >
    >
    > I don't think that is true, but I also don't want to RTFM on behalf of
    > the OP. For duplicating purposes you definitely can change
    > directories.


    Well, you can change the location of where the files wind up, but if
    you can change where they come from, let me know how. From
    Note:183570.1 Summary of Test Environment:

    "Backups and copies on disk are available at the standby host with the
    same path names as in the target host."

    Now, one would hope this was not a prerequisite, but it was in 8i, so
    if you RTFM different (there was no syntax to do it in 8i), let us
    know what you find.

    jg
    --
    @home.com is bogus.
    I love watching people work on running hardware.

  9. Re: RMAN restore and the location backupset is different

    "Howard J. Rogers" wrote in message news:<3f8fece7$0$4845$afc38c87@news.optusnet.com.au>...
    > Domenic G. wrote:
    >
    > > Your toast ... if you use RMAN without a recovery catalog, it stores
    > > the backup/recovery information in the controlfile -- you cannot use a
    > > backup controlfile and expect it to work.

    >
    >
    > The whole point of setting autobackup on, of course.
    >
    > Which our OP did.
    >
    > Therefore he is not toast.
    >
    > However, under no circumstances can a backup done to /bin/bong suddenly
    > appear in /bing/bong and be expected to work.
    >
    > Sym links are the only way I know of to make this work.
    >
    > Regards
    > HJR


    Well, there's always hacking. But of course, symlinks are supported.

    An interesting exercise is to examine the actual contents of the
    original controlfile. Make a copy of it with the OS, called, say xxx.
    od -c xxx|grep "b o " (assuming your known backup dir is /bin/bong,
    and you don't have data files or arcs in a directory with bo in the
    path). This gives you most of the line numbers od would need, then
    you can od -c xxx|more , then slash to search for the first of those
    line numbers, then you can see the ASCII path encoded in the
    controlfile.

    So one can guess that the restored controlfile from the backupset has
    this same directory in it. I would go further and say that RMAN ought
    to be able to change it during a restore or duplicate, and if there is
    indeed still a lack of such ability, it is an obvious design flaw.

    And for those to whom it is not obvious, don't try to edit a
    controlfile on a running system :-O

    >
    >
    >
    >
    > >
    > > Domenic.
    > >
    > > hvcao_vn@yahoo.com (Vinh) wrote in message
    > > news:...
    > >> RMAN restore and the location backupset is different
    > >>
    > >> Hi,
    > >> Here is scenario:
    > >> - RDBMS: 9.2.0.3
    > >> - rman backup using controlfile (no catalog db)
    > >> - Rman backup with CONTROLFILE AUTOBACKUP ON and backup set was
    > >> pointed to /prod/prod_backup.bk of prod server.
    > >> - ftp the auto control file backupset and databse backupset to /uat of
    > >> uat server.
    > >> - Proceed restore database on uat node
    > >> - Succeed restore control file using:
    > >> RMAN> restore controlfile from '/u02/control_backup.bk'
    > >>
    > >> - However, I can not restore database, I receive message
    > >> ORA-19505: "failed to identify file '/prod/prod_backup.bk'."
    > >>
    > >> Anybody know how to update for rman to know my new backupset location
    > >> (as now it's in /uat/prod_backup.bk)?
    > >>
    > >> Note: I don't want to use soft link on this case.


    jg
    --
    @home.com is bogus.
    http://www.signonsandiego.com/news/u...1b21kodak.html

  10. Re: RMAN restore and the location backupset is different

    Joel Garry wrote:

    > "Howard J. Rogers" wrote in message
    > news:<3f8fece7$0$4845$afc38c87@news.optusnet.com.au>...
    >> Domenic G. wrote:
    >>
    >> > Your toast ... if you use RMAN without a recovery catalog, it stores
    >> > the backup/recovery information in the controlfile -- you cannot use a
    >> > backup controlfile and expect it to work.

    >>
    >>
    >> The whole point of setting autobackup on, of course.
    >>
    >> Which our OP did.
    >>
    >> Therefore he is not toast.
    >>
    >> However, under no circumstances can a backup done to /bin/bong suddenly
    >> appear in /bing/bong and be expected to work.
    >>
    >> Sym links are the only way I know of to make this work.
    >>
    >> Regards
    >> HJR

    >
    > Well, there's always hacking. But of course, symlinks are supported.


    Not on Windows, they're not!! (Also not the OP explicitly didn't want to use
    them, for whatever reason).

    (Another good reason to switch to Linux/Unix, I agree)

    > An interesting exercise is to examine the actual contents of the
    > original controlfile. Make a copy of it with the OS, called, say xxx.
    > od -c xxx|grep "b o " (assuming your known backup dir is /bin/bong,
    > and you don't have data files or arcs in a directory with bo in the
    > path). This gives you most of the line numbers od would need, then
    > you can od -c xxx|more , then slash to search for the first of those
    > line numbers, then you can see the ASCII path encoded in the
    > controlfile.
    >
    > So one can guess that the restored controlfile from the backupset has
    > this same directory in it. I would go further and say that RMAN ought
    > to be able to change it during a restore or duplicate, and if there is
    > indeed still a lack of such ability, it is an obvious design flaw.
    >
    > And for those to whom it is not obvious, don't try to edit a
    > controlfile on a running system :-O


    I remember RMAN in 8.0, and it was horrid. I see it now in 9i, and love it.
    But this simple inability to directly re-locate the source for restores as
    you indicate, is a major PITA, frankly.

    It's not a show stopper, but it means RMAN use is not as 'transparent' as it
    was supposed (and advertised) to be.

    Regards
    HJR

    --
    --------------------------------------------
    See my brand new website, soon to be full of
    new articles: www.dizwell.com.
    Nothing much there yet, but give it time!!
    --------------------------------------------


+ Reply to Thread