Skip to Content
author's profile photo Former Member
0
Former Member

brtools + RMAN versus RMAN only

Posted on Jun 04, 2007 at 02:58 PM 271 Views

Hi, ALL

I have read some white paper regarding brtools+RMAN versus RMAN,

it says: "'brtools+RMAN' is better than 'RMAN only' since brtools does not require recovery catalog",

From what I know of, RMAN has "nocatalog" option too, also, to have a catalog database seems safer than nocatalog,

So what is the advantage to use brtools+RMAN over RMAN only?

RMAN has command to control the backups, for example, delete certain backup, does brtools also have such function?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Lars Breddemann
    Lars Breddemann
    Posted on Jun 04, 2007 at 10:29 PM
    0

    Hi Bei Xu.

    Yes, you can use RMAN with the nocatalog option - no problem.

    Basically the BRTOOLS just start programs like sqlplus or rman to do their tasks.

    The real advantage is: the BRTOOLS know how it should work!

    They know the correct syntax for all the different features, they come with menu-userinterface in two languages and they check for valid input parameters.

    Complex DBA procedures like reorgansation or a efficient recovery of the database are covered by very simple menus and commands.

    And the best thing is (at least for supporters): everything is logged.

    Whenever anything goes wrong, it's at least possible to know what that was.

    The BRTOOLS do certainly not cover all command of RMAN. On the other hand the BRTOOLS make it harder to make mistakes.

    It is a bit like: "What's better: Windows Explorer or Command line?".

    One of them is more powerfull the other one has a better security net, just in case.

    I would propose: get used to the BRTOOLS. They work and makes a DBA life much simpler.

    KR Lars

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      Jun 05, 2007 at 10:28 PM

      Hi Bei Xu,

      The advantage of using RMAN, either with brtools or standalone is its incremental backup feature which is very effective for VLDB. Choosing RMAN usage depends on the comfort level of the team implementing it and their expertise with brtools or RMAN standalone.

      The advantage of using SAP provided tools is that there is additional level of testing done by SAP teams before the product is available for use and you have access to additional knowledgebase for it.

      Cheers,

      Nisch

    Comment on This Answer
  • author's profile photo Former Member
    Former Member
    Posted on Jun 06, 2007 at 08:56 AM
    0

    Hi Bei Xu,

    Rman can give you many advantages:

    - All blocks are checked for block corruption. So if you implement RMAN backup strategy, you don't have to schedule db verify/backup verify daily, the backup/archive can be guaranteed by RMAN as consistent;

    - Rman can check in every blocks, it only backup the used blocks;However, blocks that are empty but have been used before, they will be backed up;

    - RMAN can reduce large amount of redo log writing than traiditional backup mode. Because RMAN will not write whole dirty blocks into current redo log, but traiditional backup will.

    Hope these info can make you clear on RMAN's adv.

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 07, 2007 at 06:57 PM
    0

    Thanx all for help,

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.