Sign in or 

HAGGAR |
Latest page update: made by HAGGAR
, Nov 24 2007, 3:36 PM EST
(about this update
About This Update
Edited by HAGGAR
No content added or deleted. - complete history) |
|
Keyword tags:
None
More Info: links to this page
|
| Started By | Thread Subject | Replies | Last Post | ||
|---|---|---|---|---|---|
| jagmeet.singh01 | how to recover a database | 1 | Oct 1 2009, 1:35 PM EDT by Sumit_Sengupta | ||
|
Thread started: Sep 29 2009, 1:02 AM EDT
Watch
Hi Guys,
I have small query or u can say a real life incident. I have taken the full database in the night at around 23:00 hrs. On next day at around 09:00 hrs I added one more datafile to the same database and at around 14:30 hrs my database got corrupted and lost all my datafiles. The only way was to do a full database recovery. But is there some way so that i could recovery my new datafile which i added at around 09:30 hrs in the morning. pls suggest somthing on this. |
|||||
| HAGGAR | HOW TO MOVE DATAFILES FROM ONE DISK RAID TO ANOTHER | 4 | May 2 2008, 2:40 PM EDT by emocat | ||
|
Thread started: Nov 24 2007, 3:42 PM EST
Watch
For Tunning reasons : perform The I/O from the Instance to datafiles (database). I decide to move some Index datafiles from One DISK RAID to another.
I'm on Linux Redhat Server and Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 My database 's On PRODUCTION and there 're many web applications updating some databases tables and for sure using Index tablespace. I preapared yet my procedure to move datafiles but I'm posting this to be sure that I will not have BAD EFFECTS on my Oracle database. So I plan without SHUTDOWN MY DATABASE to these steps : /*Step1 : */ ALTER TABLESPACE INDX OFFLINE ; /*Step 2 : move datafiles to new disk raid*/ mv /u01/oraindx/DB01/indx01_05.dbf /u01/oraindx2/DB01/indx01_05.dbf /*Step 3 : */ ALTER TABLESPACE INDX RENAME DATAFILE '/u01/oraindx/DB01/indx01_05.dbf' TO '/u01/oraindx2/DB01/indx01_05.dbf'; /*Step 4 : */ ALTER TABLESPACE INDX ONLINE ; |
|||||
| LotusOracle | Creating Reports | 0 | Mar 5 2008, 9:09 PM EST by LotusOracle | ||
|
Thread started: Mar 5 2008, 9:09 PM EST
Watch
Hi, I am a high school oracle student, studying for our VA FBLA state competition. I was wondering can anyone tell me how to create a report using SQL in a 10g environment.
|
|||||