Re: Is it possible to rename/move datafile online - possibly under RMAN?

If you are using 10g and if you are specifically using the procedure that uses RMAN, Did you try Incremental merge backups? You can use RMAN to copy the datafiles to a different location and then recover these files using incremental merge backups. You should be able to switch datafiles using RMAN. This will reduce the downtime.

  You can put the tablespaces begin backup mode. Please note that you need to do this when there is not much activity on the database. You preferably may want to do one datafile at a time. Oracle generates lots of redo when there are are any changes to the data in the data files that are in begin backup mode.

Vijay

On 11/8/07, John Darrah <darrah.john_at_gmail.com> wrote:
>
> As long as the procedure had been practiced, I wouldn't be concerned
> with using it on a production DB. Basically all this is is backup and
> recovery which, hopefully, is one of the most reliable parts of
> Oracle's database. If I get time, I am going to try to update this
> method to use RMAN entirely.
> On Nov 8, 2007 11:14 AM, Vitalis Jerome <vitalisman_at_gmail.com> wrote:
> > Nice trick John.
> > I'm not sure I would choose a recovery-based solution for a production
> > database though.
> >
> > Jerome
> >
> >
> >
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l