Printable View
Regardless of whether you have a good backup or not, is irrelevent. Once you take the database OUT of archivelog mode, you are only able to recover UP TO the point you turned archiving off. If your database dies AFTER you switch archiving back on, you are SOL for recovery! Understand? http://www.dbasupport.com/forums/ima.../2001/11/9.gifQuote:
Originally posted by ybadejo
well, I will assume you have a good backup before doing.
Hey
I thought we have it in restricted mode and moreso nousers is on it. so if anyrecovery needs to be made once their is a good backup. wont you be fine???.
hello,
try this:
alter table. nologging;
all the activity on this table will not generate arc log until you again do
alter table. logging;
Is 'alter table xxx NOLOGGING' an option?
NOLOGGING is one of the most mis-understood operations in the Oracle Software. See http://technet.oracle.com/docs/produ...dlins.htm#4418 for operations that respect nologging and operations that don't.
No. Once you switch into noarchivelog mode, you can not recover past that point.Quote:
Originally posted by ybadejo
Hey
I thought we have it in restricted mode and moreso nousers is on it. so if anyrecovery needs to be made once their is a good backup. wont you be fine???.
that would be one of worst strategyQuote:
Originally posted by ybadejo
You might want to try this steps.
1 Check to see if users are logged on
if not
2. shutdown immediate
3. comment outout archiving in Init.ora file
4. startup restrict mount
5. alter database noarchivelog
6. alter database open
7. do your delete command
once done
8. shutdown immediate
9. uncomment out archiving in Init.ora file
10. startup mount
11. alter database archivelog
12. alter database open
13. alter system disable restricted session
Hopefully this works for you.
Here we have Oracle 7.3. Do we have partitioning option in 7.3?
If we have.... after truncating yesterday's partition, I would not need that partition, so, do you mean I should delete that parition? instead of that, I better play with two tables one for today and another for yesterday and delete yesterday's table right away?
I can not shutdown database and switch out of archive log mode.
Mr. hbk_emp,
Alter table . nologging, will not work for normal delete operation. It works only if we have to DELETE on LOBs in NOCACHE NOLOGGING mode stored out of line (not in the table). Am I correct?
This is a perfect example of why you should specify your OS, OS Version, DB version in any post.Quote:
Originally posted by Vimala
Here we have Oracle 7.3
Partitioning (the way you want to use it) was not a feature until version 8.0.x.