Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Help, Need to rebuild database
- Thread starter BryanY
- Start date
SantaMufasa
Technical User
Bryan,
Here are questions whose answers will help us help you get your database running again.
1) Have you shutdown your database yet? If not, DO NOT SHUTDOWN YOUR DATABASE !!!! Unix is peculiar in that even if you erase your database datafiles, as long as Oracle still "owns" the file handles of the deleted files, the files are still readable (and even writable). So this is the most important question. (If your database is still up, then do exports for each schema immediately).
2) How recent is you last full backup?
3) Was your database in ARCHIVELOG mode? If so, what is your most recent archived redo log file's timestamp?
4) Were your on-line redo log files duplexed onto somewhere besides your /u03 directory?
Let's start with answers to these questions, and depending upon the answers, we'll go from there.
![[santa]](/data/assets/smilies/santa.gif "[santa] [santa]")
Mufasa
(aka Dave of Sandy, Utah, USA)
@ 00:50 (23Feb05) UTC (aka "GMT" and "Zulu"),
@ 17:50 (22Feb05) Mountain Time
Do you use Oracle and live or work in Utah, USA? Then click here to join Utah Oracle Users Group on Tek-Tips.
Here are questions whose answers will help us help you get your database running again.
1) Have you shutdown your database yet? If not, DO NOT SHUTDOWN YOUR DATABASE !!!! Unix is peculiar in that even if you erase your database datafiles, as long as Oracle still "owns" the file handles of the deleted files, the files are still readable (and even writable). So this is the most important question. (If your database is still up, then do exports for each schema immediately).
2) How recent is you last full backup?
3) Was your database in ARCHIVELOG mode? If so, what is your most recent archived redo log file's timestamp?
4) Were your on-line redo log files duplexed onto somewhere besides your /u03 directory?
Let's start with answers to these questions, and depending upon the answers, we'll go from there.
Mufasa(aka Dave of Sandy, Utah, USA)
@ 00:50 (23Feb05) UTC (aka "GMT" and "Zulu"),
@ 17:50 (22Feb05) Mountain Time
Do you use Oracle and live or work in Utah, USA? Then click here to join Utah Oracle Users Group on Tek-Tips.
- Status
Similar threads
- Locked
- Question
