Re: Weird Backup, can it be done without resetlogs?

Why are you guys doing something weird like this with fuzzy files?

You want Oracle 9i DataGuard (excellent feature) if you want to maintain a duplicate ready-to-use copy of the database. Copying files like this is only supported when the database is fully closed (as they all sync at that point). You can't do this with the redos or control files while the db is open.

I do know that if you change the db name and re-create the controlfile, you have to do a resetlogs -- why I don't know.

Dom.

"Francisco J. Garcia Humphries" <fjgarcia_at_e-humphries.net> wrote in message news:<burtni$6q0$1_at_news.ya.com>...
> My company is implementing a backup solution for a 2 instance (A and B) RAC
> based on the following:
>
> - At a certain time we start mirroring the database (datafiles,
> controlfiles, redologs and archives) to a disk that gets shared with server
> C.
>
> - After about two hours, when the shared disk is an exact live copy of the
> database, we issue an "alter tablespace begin backup" on the database.
> Detach the mirror disk (so it doesn't get changed any more)and the "alter
> tablespace end backup" on the production database.
>
> - At this point i would expect the database on the mirrored disk to be
> pretty similar to a database that has just crashed ¿right?.
>
> - The backup strategy is based on a new instance on server C that opens the
> database files on the mirror disk and then get's backued up by third party
> software. The problem we are encountering is that whenever we try to open
> this copy of the database with a new instance
> we need to do a RESETLOGS in order to be able to open the database. I don't
> get why i should have to open resetlogs and i need to be able to open the
> database without RESETLOGS
>
> Does anyone see a problem in the way this process copies the database? I'm
> thinking there might be a problem for Controlfiles and Logfiles. Is there
> any problem with the database being opened by a single instance when it was
> a RAC at first?
>
> Any help will be greatly appreciated.
Received on Fri Jan 23 2004 - 19:45:33 CST