Oracle 11i database backup
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Oracle 11i database backup

  1. #1
    Join Date
    Aug 2001
    Posts
    87

    Lightbulb

    we just install in our compnay oracle financial 11 i our platform is windows nt , so once i want to make backup
    throgh windows nt (closed backup) i have to shutdown the database the only way to do is through closing several services from windows nt , so are there any way to close this service automatically , or are there another way to mak batch file to do this job .

    hsbdba

  2. #2
    Join Date
    Aug 2001
    Posts
    8
    Hi,

    You can try the command "net stop servicename" in a batch file.

    e.g.

    net stop OracleServiceORCL


    Regards,

    Sonal.

  3. #3
    Join Date
    Sep 2001
    Location
    Dallas, TX
    Posts
    27
    Hi,

    You can automate schedule startups and shutdowns and backups using a combination of "at" and "net" commands.

    Hope this helps.

  4. #4
    Join Date
    Sep 2001
    Location
    USA
    Posts
    6
    You can creat a batch file with all net stop "service name" for the services and call this batch file in the NT scheduler..

    And your backup can be scheduled thru NT backup Manager.


    [Edited by ksnavin on 09-10-2001 at 02:44 PM]
    S.Navin
    ORACLE APPS DBA

  5. #5
    Join Date
    Jun 2000
    Posts
    179

    Talking

    be sure of :

    * closing the concurrent manager through :
    net stop oracleconcmgrprod

    * shut down the database from the server manager at first by using a simple script OR if you are working on Windows 2000 you can adjust the service to shut down in immediate mode

    * in case of using server manager , follow it up with :
    net stop oracleerviceprod

    * Take your backup

    * start everything again by :
    net start oralceserviceprod
    net start oracleconcmgrprod

    Hisham Nagia
    IT Manager For Development
    Oracle Consultant - OCP

Posting Permissions

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


Click Here to Expand Forum to Full Width