hot-backup recovery question

I=92m trying to use a hot backup to make a copy of our production 817_32 = database
using a 3rd disk mirror split operation. Here are the steps I=92m = taking:

1. Create a text copy of the control file with: alter database backup controlfile to trace;
2. For all tablespaces in the database, execute: alter tablespace <tsname> begin backup;
3. Verify they are all in hot backup mode via: select count(*) from v$backup where not status =3D =91ACTIVE=92;
4. Split the mirrored disks (takes approximately 60 seconds).
5. Take all tablespaces out of hot backup mode via: alter tablespace <tsname> end backup;
6. Verify they are all out of backup mode via: select count(*) from v$backup where status =3D =91ACTIVE=92;
7. Archive the current redo log via: alter system archive log current;
8. Split the archived redo log file system=92s mirrors.

I then mount the data file file systems and archived redo log file = system on
the target host and do:
  SQL> connect / as sysdba
  SQL> alter database recover automatic using backup controlfile until = cancel;
  SQL> alter database recover cancel;

At this point, I get an error like this:   ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get = error
  below
  ORA-01194: file 83 needs more recovery to be consistent   ORA-01110: data file 83: '/oracle/PRD/data44/tsdata.data1'

In the alert log I see errors like this:   WARNING! Recovering data file 386 from a fuzzy file. If not the = current file
  it might be an online backup taken without entering the begin backup = command.
  WARNING! Recovering data file 397 from a fuzzy file. If not the = current file
  it might be an online backup taken without entering the begin backup = command.
  WARNING! Recovering data file 404 from a fuzzy file. If not the = current file
  it might be an online backup taken without entering the begin backup = command.

I=92ve tried both with the active control files which were copied as = part of the
split (when the database was in backup mode) as well as removing them = and
creating new copies on the target system (using the control.sql text = copy I
created in step #1). Both attempts resulted in the same problem.

I=92m missing something obvious, but can=92t for the life of me figure = out what it
is. I=92ve also had two other DBA=92s look at the procedure and = they=92re scratching
their heads as well. Any help or insights would be greatly appreciated.

Thanks!
Rich
--

Rich Holland=A0=A0=A0=A0=A0=A0=A0 (913) 645-1950=A0=A0=A0=A0=A0=A0=A0 = SAP Technical Consultant
print unpack("u","92G5S\=3D\"!A;F]T:&5R(\'!E<FP\@:&%C:V5R\"\@\`\`");

--

http://www.freelists.org/webpage/oracle-l Received on Mon Mar 14 2005 - 10:12:47 CST