Re: RMAN to copy database

"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message news:3E797CE7.18FE_at_yahoo.com...
> David J. Devejian wrote:
> >

<Snip Background>

>
> If you've lost 'everything' ie control files as well, there is some rman
> plsql which can be used to restore a control file from a backup
> (assuming you backed up the control file). I can't remember it off
> hand, but its in the rman doco. Once you've got a control file on the
> DR site, then you can restore/recovery/etc in the normal rman way

Thanks Connor. As I mentioned earlier, we have not actually lost anything at this time, but are looking to set up and test the DR proceedures. It turns out that the backups were not using controlfile autobackup. This has been corrected, but in the meantime...

Is it possible to backup just the controlfile? Since the DR site is some distance from us, and most actions are via PCAnywhere through a dialup connection, If I can backup just the control file, I can probably transfer that via dial-up, else I have to send someone this afternoon with new tapes.

>
> hth
> connor
> --
> =========================
> Connor McDonald
> http://www.oracledba.co.uk
>
> "Some days you're the pigeon, some days you're the statue"
Received on Thu Mar 20 2003 - 08:26:19 CST