On Friday 14 October 2005 17:24, Yu Safin wrote:
> I am thinking that we RMAN we can accomplish the same as Net Backup
> does native. For example:
>
> # crontab
>
> connect target rman/YourPasswd;
> connect catalog rman/YourPasswd;
>
> run {
> allocate channel ch1 type disk;
> sql "alter system archive log current";
>
> copy current controlfile to '/oracle/back/controlXX_SID.ctl';
>
> copy datafile '/oracle/data/oradatafile01_SID.dbf'
> to '/oracle/back/oradatafile01_SID.dbf';
> copy datafile '/oracle/data/oradatafile02_SID.dbf'
> to '/oracle/back/oradatafile02_SID.dbf';
>
> ...
>
> release channel ch1;
> }
>
>
> -----
> If that is the case, then I can use BACULA to backup the "back"
> directory in the example.
>
> any other ideas? suggestions?
We've done this before using other backup solutions that didn't have RMAN
integration. It works fine, but remember that RMAN is managing it's own
catalog (in the control files, or a dedicated DB) and the RMAN catalog and
the RMAN files you're dumping need to be from the same time - you can't
effectively do a partial restore of RMAN data.
In our case, we let RMAN manage storage and retention of backup files in a big
disk spool, and treated it like any other block of files to back up. If we
had to recover a single oracle database, it was done from the RMAN spool
only. The backups of the RMAN spools themselves was strictly a disaster
recovery process in case the spool array died.
Brian
--
Brian McDonald
Never confuse being nice with being a tool.
-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
