DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: scripts

  1. 08-04-2003, 03:04 AM #1
    seshib
    seshib is offline Junior Member
    Join Date
    Feb 2003
    Posts
    69

    scripts

    Hai Gurus,

    Can any one send the scripts of Start up and Shut down for multiple databases...It is very urgent to me.. or any links for scripts..
    HTML
    Reply With Quote Reply With Quote
  2. 08-04-2003, 03:28 AM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    what os?
    Reply With Quote Reply With Quote
  3. 08-04-2003, 03:34 AM #3
    rotem_fo
    rotem_fo is offline Hangin Around,,,
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268
    Hi,
    You can use the /etc/init.d/dbora or simply call $ORACLE_HOME/bin/dbshut

    It reads the oratab file (/var/opt/oracle/oratab) and starts/stops each database entry in the file.

    Cheers.
    It is better to ask and appear ignorant, than to remain silent and remain ignorant.

    Oracle OCP DBA 9i,
    C++, Java developer
    Reply With Quote Reply With Quote
  4. 08-04-2003, 03:40 AM #4
    seshib
    seshib is offline Junior Member
    Join Date
    Feb 2003
    Posts
    69
    unix o/s..

    Requirement is:

    I have 3 DBs which are 24/7 servers. For that i need scripts to take back ups and start up and shut down script..I am not much aware of Unix scripts....Please help me out...
    HTML
    Reply With Quote Reply With Quote
  5. 08-04-2003, 03:59 AM #5
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    Which UNIX OS? It is important.

    Your best best is to use the oratab and put each database you have in there, then you dbsrart and dbshut from ORACLE_HOME/bin.

    And if you want the databases to come up on machine bootup, link it into the run level directories for your specific OS (need root for that)
    Reply With Quote Reply With Quote
  6. 08-04-2003, 04:09 AM #6
    seshib
    seshib is offline Junior Member
    Join Date
    Feb 2003
    Posts
    69
    hi davey23uk,

    Is there any script available for hot backups as specified by my requirement above. i am using solaries o/s. it very urgent..
    HTML
    Reply With Quote Reply With Quote
  7. 08-04-2003, 04:21 AM #7
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    very urgent?

    open an priority 1 iTar on Metalink
    Reply With Quote Reply With Quote
  8. 08-04-2003, 04:38 AM #8
    seshib
    seshib is offline Junior Member
    Join Date
    Feb 2003
    Posts
    69
    Pando,


    If you have scripts send it.
    HTML
    Reply With Quote Reply With Quote
  9. 08-04-2003, 06:00 AM #9
    abhaysk's Avatar
    abhaysk
    abhaysk is offline Krishna
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    STW or write a script by urself.

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
    Reply With Quote Reply With Quote
  10. 08-05-2003, 12:56 AM #10
    padawin
    padawin is offline Junior Member
    Join Date
    Jun 2003
    Posts
    22
    Check the sample script in 8i Backup & Recovery by Velapuri, it'll give you a good idea even if you are new to UNIX. Carefully research whatever you do before implementing on a production/test/QA database. There are plenty of resources on the web (ie: http://www.orsweb.com/)
    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