DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: upgrade oracle 8.1.7 to 9.2, with backup filesystem

  1. 07-25-2004, 06:39 AM #1
    yls177
    yls177 is offline Senior Member
    Join Date
    Oct 2002
    Posts
    391

    upgrade oracle 8.1.7 to 9.2, with backup filesystem

    hi, i am in the midst of doing an oracle update as suggested by my subject post. In addition, i am thinking of
    doing a copy of all my sapdata, /oracle/SID and related files, directories to another place. This is so that when
    my upgrade fails, i can always copy these "copied stuff" back and i get my oracle 8.1.7 back instantly.

    what is your opinion?
    Reply With Quote Reply With Quote
  2. 07-25-2004, 07:26 AM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    why not just do a backup, always a chance you will miss something doing it your way
    Reply With Quote Reply With Quote
  3. 07-25-2004, 09:27 AM #3
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Take a full backup before you upgrade. Also keep your 8.1.7 Oracle Home intact until your upgrade and testing finish.
    If something goes wrong you can put the things back in a short time.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"
    Reply With Quote Reply With Quote
  4. 07-26-2004, 02:13 AM #4
    yls177
    yls177 is offline Senior Member
    Join Date
    Oct 2002
    Posts
    391
    agreed... i will do a backup. but at the same time, i will do a exact replica of my filesystems in my logical volumes.

    my question is that will these replicas be used to reset my database back to the original if necessary?
    Reply With Quote Reply With Quote
  5. 07-26-2004, 03:44 AM #5
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by yls177
    my question is that will these replicas be used to reset my database back to the original if necessary?
    Yes. provided the files are consistent.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"
    Reply With Quote Reply With Quote
  6. 07-26-2004, 09:17 PM #6
    yls177
    yls177 is offline Senior Member
    Join Date
    Oct 2002
    Posts
    391
    yeah... that is what i hoped to confirm.. thanks sanjay
    Reply With Quote Reply With Quote
  7. 07-26-2004, 09:48 PM #7
    reydp's Avatar
    reydp
    reydp is offline Senior Advisor
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    Originally posted by yls177

    my question is that will these replicas be used to reset my database back to the original if necessary?
    Yes. provided the files are consistent.
    Thus this means that the db must be offline to do the replicas of the filesystems of the logical volumes? Because a full backup can be done in both ONLINE and OFFLINE. But I think the replicas will not work if the DB is ONLINE, that is why perhaps, SANJAY_G mentioned that the files should be consistent.
    Reply With Quote Reply With Quote
  8. 07-27-2004, 09:19 PM #8
    yls177
    yls177 is offline Senior Member
    Join Date
    Oct 2002
    Posts
    391
    hmmm, i replied this as to discuss and not to argue..


    the datafiles will be consistent when the tablespaces are put in begin backup mode.

    of course, there could be some gaps in the 2 databases depending on when the upgrade and when the replication is done, right?

    but otherwise, the understanding and concepts that we have been discussing should work well...
    Reply With Quote Reply With Quote
  9. 07-27-2004, 11:42 PM #9
    reydp's Avatar
    reydp
    reydp is offline Senior Advisor
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    Originally posted by yls177
    hmmm, i replied this as to discuss and not to argue..
    hello yls117,
    My apologies if it gives you an impression that I am trying to make an
    argument out of this. But honestly I am just trying to confirm here
    what I know, if still it is or out of date. But I am sure we're ok yls117.
    I only ask those question because of this quote:
    agreed... i will do a backup. but at the same time, i will do a exact replica of my filesystems in my logical volumes.

    my question is that will these replicas be used to reset my database back to the original if necessary?
    Reply With Quote Reply With Quote
  10. 07-28-2004, 10:37 PM #10
    yls177
    yls177 is offline Senior Member
    Join Date
    Oct 2002
    Posts
    391
    no worries.... i am fine with it... i am learing from u either

    /usr/sap/SID
    /sapmnt/SID
    /oracle/SID
    /oracle/SID/sapreorg
    /oracle/SID/sapdata6
    /oracle/SID/sapdata5
    /oracle/SID/sapdata4
    /oracle/SID/sapdata3
    /oracle/SID/sapdata2
    /oracle/SID/sapdata1
    /oracle/SID/saparch
    /oracle/SID/origlogB
    /oracle/SID/origlogA
    /oracle/SID/mirrlogB
    /oracle/SID/mirrlogA


    These are what i meant by SID? so basically, these are the existing oracle filesystems. I was posting that if we have a backup of all these, then if something went amiss while upgrading, then i could have them back without a restore, though a restore will do the same.

    what is your opinion?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width