| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: hot-backup recovery question
The database has to be open to end backup mode... I can't open it:
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/oracle/PRD/data10/system.data1'
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 3536609605774 generated at 03/14/2005 10:50:00 needed for
thread 1
ORA-00289: suggestion : /oracle/PRD/arch/PRDarch1_877298.dbf
ORA-00280: change 3536609605774 for thread 1 is in sequence #877298
Specify log: {<RET>=suggested | filename | AUTO | CANCEL} <ENTER>
ORA-00279: change 3536609609759 generated at 03/14/2005 10:51:18 needed for thread 1
ORA-00289: suggestion : /oracle/PRD/arch/PRDarch1_877299.dbf ORA-00280: change 3536609609759 for thread 1 is in sequence #877299 ORA-00278: log file '/oracle/PRD/arch/PRDarch1_877298.dbf' no longer neededfor this recovery
Specify log: {<RET>=suggested | filename | AUTO | CANCEL} cancel
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'
ORA-01112: media recovery not started
--
Rich Holland (913) 645-1950 SAP Technical Consultant
print unpack("u","92G5S\=\"!A;F]T:&5R(\'!E<FP\@:&%C:V5R\"\@\`\`");
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On
> Behalf Of Fuad Arshad
> Sent: Monday, March 14, 2005 10:46 AM
> To: holland_at_guidancetech.com; oracle-l_at_freelists.org
> Subject: Re: hot-backup recovery question
>
> Are you giving a alter tablespace <tsname> end backup on the split node;
> we do this all the time
> when you tryo to being up the split mirror you need to first issue an alter
> tablespace <tsname> rnd backup and not do a recovery.
> Rich Holland <holland_at_guidancetech.com> wrote:
> 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 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 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
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> --
> http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 14 2005 - 11:05:22 CST
 |
 |