 | | | hot-backup recovery question | hot-backup recovery question 2005-03-14 - By Rich Holland
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 (See ORA-01113.ora-code.com): file 1 needs media recovery
ORA-01110 (See ORA-01110.ora-code.com): data file 1: '/oracle/PRD/data10/system.data1'
SQL> recover database using backup controlfile until cancel;
ORA-00279 (See ORA-00279.ora-code.com): change 3536609605774 generated at 03/14/2005 10:50:00 needed for
thread 1
ORA-00289 (See ORA-00289.ora-code.com): suggestion : /oracle/PRD/arch/PRDarch1_877298.dbf
ORA-00280 (See ORA-00280.ora-code.com): change 3536609605774 for thread 1 is in sequence #877298
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
<ENTER>
ORA-00279 (See ORA-00279.ora-code.com): change 3536609609759 generated at 03/14/2005 10:51:18 needed for
thread 1
ORA-00289 (See ORA-00289.ora-code.com): suggestion : /oracle/PRD/arch/PRDarch1_877299.dbf
ORA-00280 (See ORA-00280.ora-code.com): change 3536609609759 for thread 1 is in sequence #877299
ORA-00278 (See ORA-00278.ora-code.com): log file '/oracle/PRD/arch/PRDarch1_877298.dbf' no longer needed
for this recovery
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
ORA-01547 (See ORA-01547.ora-code.com): warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194 (See ORA-01194.ora-code.com): file 83 needs more recovery to be consistent
ORA-01110 (See ORA-01110.ora-code.com): data file 83: '/oracle/PRD/data44/tsdata.data1'
ORA-01112 (See ORA-01112.ora-code.com): 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@(protected) [mailto:oracle-l-bounce@(protected)] On
> Behalf Of Fuad Arshad
> Sent: Monday, March 14, 2005 10:46 AM
> To: holland@(protected); oracle-l@(protected)
> 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@(protected)> 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 (See ORA-01547.ora-code.com): warning: RECOVER succeeded but OPEN RESETLOGS would get =
> error
> below
> ORA-01194 (See ORA-01194.ora-code.com): file 83 needs more recovery to be consistent
> ORA-01110 (See ORA-01110.ora-code.com): 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
|
|
|