| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Oracle Database Recover with Archiving
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:
[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;
/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]
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:
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
Few experince I had been tested:
 |
 |