Rman backup & Recovery for a datawarehouse noarchivelog mode - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Rman backup & Recovery for a datawarehouse noarchivelog mode

  1. #11
    Join Date
    Apr 2001
    Posts
    110
    Hi All,

    I finally understood what I have done for this test case.

    I am actually performing a (noarchivelog mode) restore from an older RMAN backup.

    It works perfectly.

    Regarding the data load performance issue on a archive log mode database, I tested it out loading the same millions of records from SQLPLUS and the timings for noarchivelog and archivelog are the same.

    So, I suspect the issue might be on the datawarehouse loading engine.

    Thanks all for your wonderful comments.

    Cheers
    Oracbase
    What's next after 10g?

  2. #12
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Originally posted by oracbase
    So, I suspect the issue might be on the datawarehouse loading engine.
    Informatica?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

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