| Napster |
Posted: Feb 28, 2008 12:31:56 AM |
Total Post: 6
Joined: Jan, 2008
|
Hi all,
I'am new to oracle 9i. i've a mock database in my personal comp(just for practising). i'm trying to work on backup and recovery scenario's.
i have a backup of all my datafiles,controlfiles and redologs.
my database was in archive log mode.
the scenario was as follows
1) i did alter system switch logfile; (3 times)
2) and the shutdown the db
3) deleted one of the datafiles
4) tried to start the db but it gave me an error
5) restored the datafile to it's location and the did
recover datafile '/..path/ ...dbf';
6) still got an error asking for some archive file
{ plz note in pfile i'd given
log_archive_dest_1='.....'
log_archive_dest_2='.....'
log_archive_dest_3='.....' }
7) also in the different locations of archive file it shows different format even though i haven't set the log_archive_format parameter
8) Now what i tried to do is restore all files with the cold backup but after i do this i get the following error at mount stage
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: '/oracle/home/testdb/data/system01.dbf'
ORA-01207: file is more recent than controlfile - old controlfile
9) i guess this means that my old backup is not consistent hence the error!!!!!
10) can anyone help me with this and provide any solution (if applicable), also plz tell me things that i have to be very carefull about to avoid such a scenario
regards
Suraj M. |
|
|
 seema |
| Posted: Mar 05, 2008 12:25:27 AM |  |
|
Total Post: 62
Joined: Jan, 2008
|
Hi
You do one thing after restore the datafile follow the below steps.
1.startup mount (start database in mount stage )
2.recover database.
3.alter database open.
try this and let me know the result.
|
|
|
|
|
| Gitesh |
| Posted: Mar 11, 2008 07:33:12 AM | |
|
Total Post: 322
Joined: May, 2005
|
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: '/oracle/home/testdb/data/system01.dbf'
ORA-01207: file is more recent than controlfile - old controlfile
You are using newer controlfile for recovery. Then you should use "recover database using backup controlfile". This command will identify controlfile is newer one and initiate recovery.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
