How to Safely delete oracle db datafiles in AIX?


 
Thread Tools Search this Thread
Operating Systems AIX How to Safely delete oracle db datafiles in AIX?
# 1  
Old 02-26-2010
How to Safely delete oracle db datafiles in AIX?

We have an oracle Database on AIX box. We want to delete the database safely.

How can scrubb the datafile prior to delete on AIX?
# 2  
Old 02-27-2010
Do you mean you need to erase the file - scrub the disk sectors of the file so disk scrounging cannot happen?

diag -T "format" command used to do that, I believe.

Also for a better tool try this from security paranoia central:
http://www.lanl.gov/orgs/tt/pdf/techs/filescrub.pdf

I worked there for several years, and so can attest to the paranoia.

Last edited by jim mcnamara; 02-27-2010 at 10:06 PM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. HP-UX

Reason to keep old /var/opt/perf/datafiles/logproc files

Would there be a reason to keep old logproc files that have been tarred up for any longer than a few days? (1 Reply)
Discussion started by: jeffbusz
1 Replies

2. AIX

AIX and Oracle

Hello All, I was approached by DBAs, and they want me to create a large_page on AIX and also change oracle file systems to CIO. They are complaining the system is taking longer time for processing and we are unnecessary wasting memory and CPU for file system cache. To do that I have to change... (12 Replies)
Discussion started by: m6248m
12 Replies

3. Solaris

need to safely reboot to cdrom

I am using: reboot -- cdrom However I'm afraid of causing file system errors/corruption. I've seen many threads say that init 6 is safer, but I need to get to CDROM. Is there a command that is as safe as init, but can boot to cdrom, or should I not worry so much about the reboot... (5 Replies)
Discussion started by: lcoreyl
5 Replies

4. Shell Programming and Scripting

Perl script to change values in datafiles

Hi all, Let say I have 2 files, 1 is source file and another is destination file. Source file contains the following : Kitten Dogs Donkey Chicken Turkey And destination file contains : Kitten, 0 Dogs, 0 Donkey, 0 Chicken, 0 Turkey, 0 Kitten, 0 Dogs, 0 Donkey, 0 (16 Replies)
Discussion started by: luna_soleil
16 Replies

5. AIX

aix 61 and oracle 11

Hi, we need to upgrade from aix 5.3 oracle 9 to aix 6.1 oracle 11. Our base interest is on vmo and disk setup On aix 5.3 we change lru_file_repage to 0. We split disk layout ( emc cx4 ) to tree volume groups: - one for data base files ( one filesystem over two lun/hdiskpower, block size... (5 Replies)
Discussion started by: prebila
5 Replies

6. Shell Programming and Scripting

Delete oracle table from UNIX script

Hi, Is it possible to delete oracle table datas using a UNIX script/Shell script? how can we do this?? I have oracle Database and i have to delete millions of record everyday.. adn it is taking hours togather to execute this. Will the delete query triggered from UNIX be faster can we expect any... (1 Reply)
Discussion started by: Codesearcher
1 Replies

7. AIX

AIX 6.1 and Oracle 9.2.0

Hi All, I need to update some AIX servers from 5.2 to 5.3 OR 6.1 . The management is pressing for 6.1, but on our systems runs Oracle 9.2.0 . I couldn't find any clear warning about the possibility of compatibility issues between AIX 6.1 and Oracle 9.2.0 but, on the other hand, I couldn't find... (0 Replies)
Discussion started by: padawan75
0 Replies

8. AIX

oracle 9i on AIX 5.2

Hello, mornig can you help me whit this error: "Oracle Universal Installer cannot be run" and i can't start the installation of ORACLE 9i... see you later (1 Reply)
Discussion started by: joseantoniohv
1 Replies

9. UNIX for Advanced & Expert Users

Oracle and AIX

Hi @all Who's able to help me? I've a running Oracle DB on AIX 4.3.3. You've also an Oracle Client running for this. So however, how it's possible, that I can see the CURRENT VERSION of my Oracle CLIENT. I've tried several things, but it doesn't work. Thanks a lot! Regards Oliver :( :( (4 Replies)
Discussion started by: olli2002
4 Replies

10. UNIX for Advanced & Expert Users

aix-oracle

what is the reason oracle is giving ora-600 space leak error? how to rectify this error? (6 Replies)
Discussion started by: varadakumar
6 Replies
Login or Register to Ask a Question