Re: Oracle Database Recover with Archiving

First of all, I'm not sure why you address this ng as Oracle support: we aren't. You should have called Oracle support. A few remarks:

It is impossible for me to verify from your post you indeed have ALL files

There is a problem in the script: you should place tablespaces in backup mode ONE by ONE and not all at a time.

There is another problem in your script as you backup the controlfile FIRST, and the controlfile WILL change during the actual hot backup. Please refer to the Oracle 8 DBA handbook for a correct hot backup script.

You state that after you discover the controlfiles are not the same, you shutdown the database, while we can't see any startup command from your post. How can we help you out, when we don't have the EXACT steps you did to get into this mess?

Currently it looks like the only thing you can do is recover database until cancel using backup controlfile

Hth,

--
Sybrand Bakker, Oracle DBA
sikar <chaiskNOchSPAM_at_sains.com.my.invalid> wrote in message news:201d8cc4.d68511f6_at_usw-ex0109-066.remarq.com...
> Oracle Support,
>
> I have a oracle database recover problem which I already try
> to solve it for three day full times, but until today I
> still can not get rigth.
>
> Backup Step I done:
> --------------------
> I have one Sun Unix box machine with database 8.1.5 server
> edition. It running 24x7 with Archive log mode start. I
> running the Online backup every end of the day. The online
> backup script such as below:
>
> *************
> [Begin]
> alter system switch logfile;
> alter database backup controlfile to
> '/data7/backup/online/control1.bkp';
> alter database backup controlfile to trace;
>
> Alter tablespace {tablspacename1} begin backup;
> Alter tablespace {tablspacename2} begin backup;
> Alter tablespace {tablspacename3} begin backup;
> Alter tablespace {tablspacename4} begin backup;
> ....
> ....
> host tar cvf /dev/rmt/0n
> /data1/oracle_database/oradata/hislive
> /data2/oracle_database/oradata/hislive ...
>
> Alter tablespace {tablspacename1} end backup;
> Alter tablespace {tablspacename2} end backup;
> Alter tablespace {tablspacename3} end backup;
> Alter tablespace {tablspacename4} end backup;
> ....
> ....
>
> [END]
> *************
> The tape will content all the datafile, redo log file,
> control file, parameter file, arch file and all the database
> file.
>
> Question is:
> I have another new Sun Unix Machine, I would like to using
> that backup tape to recovery another same database at this
> new machine.
>
> Method I use for recover:
> --------------------------
> 1) I install the Oracle software without create the
> database. Then Extract all the tape content to the new
> machine which will have all the datafile, redo log file,
> control file, parameter file, arch file and all the database
> file.
>
> 2) run SVRMGRL
> 3) connect internal
> 4) Error message: ORA-00214: controlfile
> '/opt/.../control01.ctl' version 25205 inconsistent with
> file '/data1/oradata/.../control02.ctl' version 25184
> 5) I shutdown the database, I copy the
> '/opt/.../control01.ctl' to '/opt/.../control01.ctl' so that
> make it both have same version.
> >> ?? >> Is that I am correct ? which one I surpose to
> choice control01.ctl or control02.ctl.
>
> 6)RUN SVRMGRL, Startup again
> 7) Database mounted,
> but Error Message: ORA-01157: cannot identify/lock data file
> 1 - see DBWR trace file
> ORA-01110: data file 1: '/data1/...../system01.dbf';
> 8) I known why this is happen because during my extract from
> tape to hard disk, and my hard disk is not enough disk
> space, so I move some of the datafile to others location. so
> I using "alter database rename file '/../' to '/../';"
> changed all the datafile back to normah.
> 9) I startup again, Database mounted, but Error Message:
> ORA-01113: file 1 need media recovery, ORA-01110: data file
> 1: '/data1/.../system01.dbf';
> 10) SVRMGR> select * from v$log;
> Group# Thread# Sequence# Bytes Members ARC
> Status First_chan First_tim
> ------ ------- --------- ------- ------- ----
> --------- ----------- ----------
> 1 1 1191 8388608 1 No
> Current 3229153 02-dec-99
> 2 1 1189 8388608 1 YES
> Inactive 3229153 02-dec-99
> 3 1 1190 8388608 1 YES
> Active 3229153 02-dec-99
>
> 11) SVRMGR> select * from v$log_history;
> Recid Stamp Thread# Sequence# First_chan
> First_tim Next_chang
> ------ ------- ------- --------- -----------
> ---------- -----------
> 284 379638581 1 284 634331
> 23-oct-99 635289
> 285 379638594 1 285 635289
> 23-oct-99 636061
> . .. .. .. ..
> . ..
> . .. .. .. ..
> . ..
> . .. .. .. ..
> . ..
> . .. .. .. ..
> . ..
> 1186 383149869 1 1186 3208237
> 02-dec-99 3212415
> 1187 383251631 1 1187 3212415
> 02-dec-99 3216918
> 1188 383252964 1 1188 3216918
> 02-dec-99 3221169
> 1189 383154754 1 1189 3221169
> 02-dec-99 3239153
> 1190 383155266 1 1190 3225966
> 02-dec-99 3239153
> >> ?? >> What should I need to do ???? What I should do to
> recover this database to normal. Data loss for within few
> hours is not a problem. I just need a database back to
> normal and can startup.
>
>
> Few experince I had been tested:
> ---------------------------------
> SVRMGR> Recover Database until cancel;
> ORA-00279: change 322886 generated at 12/02/99 16:00:21
> needed for thread 1
> ORA-00289: suggestion : /dadta1/..../arch/1_1190.dbf
> ORA-00280: change 3228866 for thread 1 is in sequence #1190
> Specify log: {<RET>=suggested | filename | auto | cancel}
> cancel
> ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS
> would get error below
> ORA-01195: online backup of file 1 need more recovery to be
> consistent
> ORA-01110: data file 1: '/data1/.../system01.dbf'
> SVRMGR> alter database open resetlogs;
> alter database open resetlogs
> *
> ORA-01195: online backup of file 1 need more recovery to be
> consistent
> ORA-01110: data file 1: '/data1/.../system01.dbf'
>
>
>
>
>
>
>
>
> * Sent from AltaVista http://www.altavista.com Where you can also find
related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful Received on Sat Dec 04 1999 - 02:57:10 CST