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

Thread: Changing the location of backups

  1. 02-06-2009, 08:30 PM #1
    trans53
    trans53 is offline Junior Member
    Join Date
    Feb 2009
    Posts
    2

    Changing the location of backups

    Hi all,

    I am new in this field and wondering if you can help.

    We have an oracle 9i production system with hot backups and archive logs stored in one particualr location. Now the disk size is very low and we need to add more space into. How can i change the location of where the backups
    are stored? Do i need to stop databases in this case? We do also have a standby server where all backups are copied.

    Also it is possible just to add more space without stopping anything?

    Thanks in advance.
    Reply With Quote Reply With Quote
  2. 02-07-2009, 04:33 AM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    depends how you do your backups
    Reply With Quote Reply With Quote
  3. 02-07-2009, 06:31 AM #3
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Quote Originally Posted by trans53 View Post
    ... it is possible just to add more space without stopping anything?
    It all depends on the architecture of your shop.

    This is a question for your storage guy/gal, tell him/her how much space you need, where you need it... they will tell you were space can be provisioned with or without downtime.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
    Reply With Quote Reply With Quote
  4. 02-09-2009, 02:02 AM #4
    trans53
    trans53 is offline Junior Member
    Join Date
    Feb 2009
    Posts
    2
    Thank you for replies, i will try to talk to the sys admin.
    Also, how can i connect to 10g EM console or sql plus as sysdba? i am able to get as sys but not as sysdba.
    Reply With Quote Reply With Quote
  5. 02-09-2009, 03:09 AM #5
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    If you do...

    sqlplus /nolog
    conn sys as sysdba
    hit enter

    ... what happens?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
    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