Topic: Backup & Recovery >> Backup And Recovery in non archive mode
|
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: Backup And Recovery in non archive mode |
| pandu |
Posted: Aug 11, 2007 05:34:57 AM |
Total Post: 7
Joined: Aug, 2007
|
Hi,My database is in non archive log mode. I have the backup of all the datafiles, control files and redologs (cold backup). while my instance is running and when i entered some data into a table which is on a particular datafile which is lost physically by some mistake. i issued commit after entering data. when i tried to shut down normally i'm getting
error saying that unable to open the datafile.when i shut the instance forcefully(shut abort) and copied the lost datafile from backup to original location and tried to start the instance media recovery error is coming.what to do in this situation. please help me in his situation.
Thanks in advance
kvl narayana |
|
|
 Mohammed Taj |
| Posted: Aug 11, 2007 08:35:25 AM |  |
|
Total Post: 746
Joined: Jul, 2007
|
Hi,
Only one way ...Restore Last Valid Cold Backup and open your database
Reason: You have ONLY COLD BACKUP and you have to lost all data after last valid backup.
That is why Oracle Corporation Recommeneded : Run Database in ARCHIVE LOG MODE and Do FULL DATABASE RECOVERY.
How to restore
1. shutdown abort;
2. delete all copy of datafiles, redo log files and control files
3. Restore all datafiles,redolog files, ctl files copy from Valid Recent backup.
4. connect to database with SYS USER
5. startup
Regards
Taj
http://dbataj.blogspot.com
|
|
|
|
|
| pandu |
| Posted: Aug 11, 2007 01:50:55 PM | |
|
Total Post: 7
Joined: Aug, 2007
|
Hello Taj,Thanks for ur reply.But if there are many users who had just done their transactions and for only one datafile do they all need to suffer? Is there any other way for this?
KVL Narayana
|
|
|
|
|
| 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 | 334 |
| Gitesh Trivedi | 322 |
| Vinoth Kumar | 264 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
