DBAsupport.com Forums - Powered by vBulletin
Page 4 of 4 FirstFirst ... 234
Results 31 to 32 of 32

Thread: cold backup and hot backup

  1. 04-05-2002, 09:51 AM #31
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Sure, you can do b. Basically, it's an incomplete recovery with a backup control file. Restore your cold backup, recover with backup controlfile applying your archived redo logs. The whole procedure is outlined in http://metalink.oracle.com/metalink/...T&p_id=69468.1
    Jeff Hunter
    Reply With Quote Reply With Quote
  2. 04-05-2002, 06:16 PM #32
    thanigai
    thanigai is offline Senior Member
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330
    In Oracle trg class....they gave one Practical example about magnetic tapes...in NY...we donot know exactly but the ex was really good stuff about our backups.There was a transformer right next the tape room and due to that all the tapes got corrupt.They could not restore any thing from those tapes when db crashed.
    Luck is they dumped the cold backup in some other office and had the archive logs from that backup...So they could able to bring the database.They could able to ...
    Do not delete all the archive logs.Best way is keep them atleast for a week before deleting.If you have space constrain
    gunzip the files and keep, that way you can gain the space.
    Thanks.
    Thanigai.
    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