Topic: Backup & Recovery >> ORA-00280..........
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: ORA-00280.......... |
| Navi |
Posted: Aug 21, 2007 10:13:03 AM |
Total Post: 60
Joined: Jun, 2007
|
Hi,
I got stuck up when i was doing recovery. Please help me.
I took backup of all the datafiles,redogfiles and controlfiles.
I opened the database and created table called student. After that I inserted values to it and purposely made log switch. So that when alter database recover command is given it should prompt the archive log file.
insert into student values(101);
alter system switch logfile;
insert into student values(102);
alter system switch logfile;
insert into student values(103);
alter system switch logfile;
Three Archived log files got generated:-
1) ARC00001.001 2) ARC00002.001 3) ARC00003.001
After that I shutdown the database and opened the database and I got the following error:-
SQL> startup;
ORACLE instance started.
Total System Global Area 118255568 bytes
Fixed Size 282576 bytes
Variable Size 83886080 bytes
Database Buffers 33554432 bytes
Redo Buffers 532480 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 9 - see DBWR trace file
ORA-01110: data file 9: 'C:\ORACLE\ORADATA\KARTHIK\NAVDBF.DBF'
After that I restored the datafile to its original location and when I gave alter database recover command I got the following error:-
SQL> alter database recover;
alter database recover
*
ERROR at line 1:
ORA-00279: change 271469 generated at 08/21/2007 18:05:51 needed for thread 1
ORA-00289: suggestion: C:\ORACLE\ADMIN\KARTHIK\ARCH\ARC00001.001
ORA-00280: change 271469 for thread 1 is in sequence #1
After that I gave the archived log name as follows and I got following error:-
SQL> ARC00001.001
SP2-0734: unknown command beginning "ARC00001.0..." - rest of line ignored.
What should I enter when it prompts for Archive files? Please guide me.
Regards,
Naveen
|
|
|
 Mohammed Taj |
| Posted: Aug 21, 2007 11:50:37 AM |  |
|
Total Post: 746
Joined: Jul, 2007
|
Hi,
You have to perform incomplete recovery.
try to auto after cancel, no need to give ARC log file destination.
Regards
Taj
|
|
|
|
|
| Navi |
| Posted: Aug 21, 2007 01:20:32 PM | |
|
Total Post: 60
Joined: Jun, 2007
|
Hi Taj,
Thank you Raj now its working. I had not given the absolute path of Archive log file, just i had given the Archive log file name.
Regards,
Naveen
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gopu Gopi | 333 |
| Gitesh Trivedi | 322 |
| Vinoth Kumar | 264 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
