Re: Sql BackTrack vs RMAN

I was looking for somebody to answer this question . I have used both these products but do not have a lot of experience . I hope i can help you with few tips . I would rather wait for guru's to answer . Let us see if my answers triggers a response .

We changed from using SQL Backtrack to RMAN . RMAN gives us cost savings . But still you would have to pay for MML software license . That would be the same with SQL Backtrack also .

I think Backup Manager could be used with RMAN as it gui . But i have so far never tried to do that . I myself prefer the RMAN Scripts . They are fairly easier to write .

RMAN (and sql backtrack) would read the archive log files from tape and do a restore and recover .

I think RMAN has a duplicate database feature which i have never used .

You can surely review the catalog or control file to see the backups that were done before and validate the backupsets . Validate backupset is like dry run recovery of sql backtrack .

Both the products are similar and RMAN gives us cost savings .

"Lorri" <llfett_at_yahoo.com> wrote in message news:e2759cd2.0204251133.16bd6573_at_posting.google.com...
> Currently my company is using SQL BackTrack for Oracle backups &
> recoveries. Recently there has been questions about the cost of SQL
> BackTrack & in general would it save the company money to use RMAN
> instead. Has anyone switched from one to the other? If so, why & how
> did it go. Was it worth the cost or the savings depending on which way
> you went? From reviewing the RMAN documentation it looks like RMAN is
> command line -- it their a GUI interface? How easy is it to use? When
> a recovery is done in RMAN, does it expect that the archive logs are
> available or is that a manual process to restore these logs? How easy
> is it to "restore" databases from one box to another. It looks like
> RMAN allows me to have a central repository that keeps track of all
> backups that are done -- is this so? Does it really allow a DBA to
> review by instance all the backups that were done so one can decide
> which backup can be restored from? Please provide any general or
> specific knowledge that you may have with either of these two tools.
>
> Thanks so very much
> Lorri
>
Received on Mon May 06 2002 - 17:27:07 CDT