+ Reply to Thread
Results 1 to 7 of 7

How to determine if tablespace/datafile is in BACKUP mode

  1. How to determine if tablespace/datafile is in BACKUP mode

    I have a 7.3.4.5.0 instance, that does hot backups to another machine via
    NFS. The NFS server had issues this weekend, and I believe that everything
    is back to normal now, but i would like to make certain that none of the
    instances tablespaces/datafiles were inadvertently left in BACKUP mode.

    How can I verify this?


    --
    "They that would give up essential liberty for temporary safety deserve
    neither liberty nor safety."
    -- Benjamin Franklin

  2. Re: How to determine if tablespace/datafile is in BACKUP mode

    On Jun 9, 9:07*am, Stan Brown wrote:
    > I have a 7.3.4.5.0 instance, that does hot backups to another machine via
    > NFS. The NFS server had issues this weekend, and I believe that everything
    > is back to normal now, but i would like to make certain that none of the
    > instances tablespaces/datafiles were inadvertently left in BACKUP mode.
    >
    > How can I verify this?
    >
    > --
    > "They that would give up essential liberty for temporary safety deserve
    > neither liberty nor safety."
    > * * * * * * * * * * * * * * * * * * * * * * * * -- Benjamin Franklin


    Query the V$BACKUP view. Should any file# have a status of ACTIVE
    it's still in backup mode and this needs to be corrected. As I
    understand it Oracle 7, if started with files in backup mode after a
    crash or a SHUTDOWN ABORT, will assume media recovery is required.


    David Fitzjarrell

  3. Re: How to determine if tablespace/datafile is in BACKUP mode

    In <1e468a94-2593-4714-bc29-2d852c8f4c54@y21g2000hsf.googlegroups.com> "fitzjarrell@cox.net" writes:

    >On Jun 9, 9:07=A0am, Stan Brown wrote:
    >> I have a 7.3.4.5.0 instance, that does hot backups to another machine via
    >> NFS. The NFS server had issues this weekend, and I believe that everything=


    >> is back to normal now, but i would like to make certain that none of the
    >> instances tablespaces/datafiles were inadvertently left in BACKUP mode.
    >>
    >> How can I verify this?
    >>
    >> --
    >> "They that would give up essential liberty for temporary safety deserve
    >> neither liberty nor safety."
    >> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =

    >=A0 =A0 =A0 =A0 =A0 =A0 -- Benjamin Franklin


    >Query the V$BACKUP view. Should any file# have a status of ACTIVE
    >it's still in backup mode and this needs to be corrected. As I
    >understand it Oracle 7, if started with files in backup mode after a
    >crash or a SHUTDOWN ABORT, will assume media recovery is required.


    Thanks, Good news is thta my machine was able to continue, once the NFS
    server was rebooted. Guess I lucked out on that one. Thanks for the quick
    answer.


    >David Fitzjarrell

    --
    "They that would give up essential liberty for temporary safety deserve
    neither liberty nor safety."
    -- Benjamin Franklin

  4. Re: How to determine if tablespace/datafile is in BACKUP mode

    Stan Brown wrote:
    > I have a 7.3.4.5.0 instance, that does hot backups to another machine via
    > NFS. The NFS server had issues this weekend, and I believe that everything
    > is back to normal now, but i would like to make certain that none of the
    > instances tablespaces/datafiles were inadvertently left in BACKUP mode.
    >
    > How can I verify this?
    >
    >



    I am guessing that your employer does not really care about their data
    to be running on a version that is almost a decade old...

    There is no upgrade path from that version. You will basically scrap
    everything and start over doing a painful export/import.

  5. Re: How to determine if tablespace/datafile is in BACKUP mode

    In Michael Austin writes:

    >Stan Brown wrote:
    >> I have a 7.3.4.5.0 instance, that does hot backups to another machine via
    >> NFS. The NFS server had issues this weekend, and I believe that everything
    >> is back to normal now, but i would like to make certain that none of the
    >> instances tablespaces/datafiles were inadvertently left in BACKUP mode.
    >>
    >> How can I verify this?
    >>
    >>



    >I am guessing that your employer does not really care about their data
    >to be running on a version that is almost a decade old...


    >There is no upgrade path from that version. You will basically scrap
    >everything and start over doing a painful export/import.


    It's a contol system, and the software that uses the Oracle backend cannot
    talk to versions much newer than that.
    --
    "They that would give up essential liberty for temporary safety deserve
    neither liberty nor safety."
    -- Benjamin Franklin

  6. Re: How to determine if tablespace/datafile is in BACKUP mode

    " As I understand it, Oracle 7, if started with files in backup mode
    after a
    crash or a SHUTDOWN ABORT, will assume media recovery is required."

    Prior to 7.2, media recovery would have been necessary. Effective with
    7.2, a simple

    "alter database datafile "full path file name" end backup" ;

    issued after the "media recovery needed messages" will take the file
    out of hot backup mode and allow you to then issue an "open".

    Eugene Pokopac (Oracle DBA - Tucker GA)


  7. Re: How to determine if tablespace/datafile is in BACKUP mode

    In epokopac@excite.com writes:

    >" As I understand it, Oracle 7, if started with files in backup mode
    >after a
    > crash or a SHUTDOWN ABORT, will assume media recovery is required."


    >Prior to 7.2, media recovery would have been necessary. Effective with
    >7.2, a simple


    >"alter database datafile "full path file name" end backup" ;


    >issued after the "media recovery needed messages" will take the file
    >out of hot backup mode and allow you to then issue an "open".


    Thanks, this is useful information.

    >Eugene Pokopac (Oracle DBA - Tucker GA)


    I used to live right next to there, in Clarkston.

    --
    "They that would give up essential liberty for temporary safety deserve
    neither liberty nor safety."
    -- Benjamin Franklin

+ Reply to Thread