DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 16 of 16

Thread: Oracle Error in during Arcserve2000 backup process

  1. #11
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    Originally posted by marist89
    I wonder if he might need the Oracle Agent??
    dooooh!
    I'm stmontgo and I approve of this message

  2. #12
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Yes, agreed - he needs THE Oracle Agent.

    however, does the OA just put the TBSs in hot backup mode? Or is clever enough to differentiate the files it should backup and those it shouldn't (on-line redo?).

    Most network admins, if recovering a data server, will just issue a blanket recover and recover the entire server (Not an Oracle style disaster recovery recover-datafile-x scenario), so does it matter if the on-line redo is backed-up? I ask because an ORA DBA wouldn't do that type of recovery (usually! )

    But yes - I agree - HE NEEDS THE ORA AGENT!

    (Just asking in case anyone has any experience of doing this)

  3. #13
    Join Date
    Oct 2004
    Posts
    3
    hi,
    how to confirm whether the redo logs are back-up during hot backup.how to address that?.pls explain.thanks.








    Originally posted by Axr2
    To initial poster -

    You shouldn't be backing up online redo logs during a hot backup in the first place. So address that.

  4. #14
    Join Date
    Oct 2004
    Posts
    3
    hi,
    how does Oracle Agent can help me to solve the problem?
    Pls explain.thanks.





    Originally posted by marist89
    I wonder if he might need the Oracle Agent??

  5. #15
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Basically, just by copying the datafiles you may not have a complete backup. You might, you might not. The time when you need to restore is not the time you want to be finding out that your backup is not valid.

    Most "oracle agent" pieces of backup software know how to put the tablespaces in backup mode, copy the datafiles, and take the tablespaces out of backup mode.

    IMHO, if you are serious about backup/recovery you would be looking at RMAN. This comes standard with Oracle Standard Edition and Enterprise Edition.

    Online redo log files most likely will not get backed up during a backup. That's what the archived redo logs are for.
    Jeff Hunter

  6. #16
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    Originally posted by sasi
    hi,
    how does Oracle Agent can help me to solve the problem?
    Pls explain.thanks.
    sigh...

    in my first post I provided this link below
    http://www3.ca.com/Solutions/Collate...=62594&ID=2747

    Please go to that link and read.

    Alternatively you can dump the db to an alternate location on disk (rman, hot bkp, cold bkp whatever) and have the backp software backup that sepcific location and not the open db files
    I'm stmontgo and I approve of this message

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