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

Thread: Consistent backup

  1. 07-23-2003, 01:28 AM #1
    richyip
    richyip is offline Junior Member
    Join Date
    Apr 2003
    Location
    Kuala Lumpur
    Posts
    59

    Consistent backup

    Shutdown the DB and backup using RMAN is consider a consistent backup. Does copying datafile after issuing 'alter tablespace tab1 begin backup' consider a consistent backup?
    Reply With Quote Reply With Quote
  2. 07-23-2003, 01:55 AM #2
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    It is inconsistent backup. But you can fully recover your db with this backup and archived logs.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"
    Reply With Quote Reply With Quote
  3. 07-23-2003, 05:30 AM #3
    adewri's Avatar
    adewri
    adewri is offline Oracle Monk
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    A cold backup = consistent. Hot backup or online backup using RMAN = incosistent (u need archivelogs to make them consistent.)
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!
    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