+ Reply to Thread
Results 1 to 6 of 6
  1. 11-25-2002 05:43 AM #1
    pnrdba
    pnrdba is offline Senior Member
    Join Date
    Apr 2002
    Posts
    291

    Oracle Hot backup Script

    Hi All,
    I'm running Oracle 9i Rel 2 on Linux 7.2. Right now we are doing a weekly cold backup and daily exports (full). My MGR decieded to go for a hotbackup. Does any one has an Exhaustive (comprehensive one) script for a hotbackup. Please let me know any URL or post the script if any one has a such.

    thanks in advance
    PNRDBA
    Reply With Quote Reply With Quote
  2. 11-25-2002 05:55 AM #2
    Calvin_Qiu's Avatar
    Calvin_Qiu
    Calvin_Qiu is offline Senior Member
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    Read RMAN manual for comprehensive concept understanding and complete guide of Backup and Recovery.
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998
    Reply With Quote Reply With Quote
  3. 11-25-2002 06:23 AM #3
    pnrdba
    pnrdba is offline Senior Member
    Join Date
    Apr 2002
    Posts
    291
    We are not using RMAN Calvin. Its through scripts we are planning.

    Thanks
    PNRDBA
    Reply With Quote Reply With Quote
  4. 11-25-2002 06:39 AM #4
    Calvin_Qiu's Avatar
    Calvin_Qiu
    Calvin_Qiu is offline Senior Member
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    I can not see any point to do hot backup through script (placing online tablespaces in backup mode) instead of RMAN. Also, you can use script with RMAN.
    Last edited by Calvin_Qiu; 11-25-2002 at 06:42 AM.
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998
    Reply With Quote Reply With Quote
  5. 11-25-2002 06:41 AM #5
    aarroyob
    aarroyob is offline Senior Advisor
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    In this page, in the tittle (I think very descriptive) SCRIPTS, you will find some scripts for doing backup

    Cheers

    Angel
    Reply With Quote Reply With Quote
  6. 11-25-2002 08:25 AM #6
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,094
    http://www.dbasupport.com/oracle/scr...ry/Hot_Backup/
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

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