Re: Recovery Scenarios -> Consolidated

2002-12-12 Thread Yechiel Adar
8:53 AM Subject: Re: Recovery Scenarios -> Consolidated   Finally, I have figured out a Freeware Hex editor at http://www.hhdsoftware.com/hexeditor.html. Using this freeware, I could open Oracle data files (while database is shutdown) and corrupt them (for testing, o

Re: Recovery Scenarios -> Consolidated

2002-12-11 Thread Krishna Rao Kakatur
o you.   HTH, Krishna   - Original Message - From: Yechiel Adar To: Multiple recipients of list ORACLE-L Sent: Wednesday, December 11, 2002 10:14 AM Subject: Re: Recovery Scenarios Hello Krishna   I just tried to open a datafile using textpad and got sh

Re: Recovery Scenarios

2002-12-11 Thread Yechiel Adar
Hello Krishna   I just tried to open a datafile using textpad and got sharing violation. I tried opening using notepad and it worked.   For obvious reasons (not trying to test recovery) I did not change and save the file with notepad.   Yechiel AdarMehish - Original Message - Fro

RE: Recovery Scenarios

2002-12-11 Thread DENNIS WILLIAMS
Stephen - I don't think that will work on Windows. I don't work on Windows, but I recall someone saying that Oracle locks the file while it is used. Ruth - If you drop a table, I don't think a recovery will be automatically triggered. You'd probably need to do a TSPITR, and I'm not sure that was t

RE: Recovery Scenarios

2002-12-11 Thread Stephen Lee
-Original Message- Could you please suggest me how to corrupt a data file, for testing recovery. -- How corrupt do you want the file to be? vi the file? copy /usr/bin/ksh on top of the file. That ought to corrupt it real good! -- Please s

Re: Recovery Scenarios

2002-12-11 Thread Ruth Gramolini
All you have to do is drop a couple of tables and try to get them back. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, December 10, 2002 7:00 PM Hi, Could you please suggest me how to corrupt a data file, for testing recovery. I

Re: Recovery Scenarios

2002-12-10 Thread chao_ping
Krishna Rao Kakatur, You can try bbed(password blockedit). Regards zhu chao [EMAIL PROTECTED] www.happyit.net www.cnoug.org(Chinese Oracle User Group) === 2002-12-10 16:00:00 ,you wrote£º=== >Hi, > >Could you please suggest me how to corrupt a data file, for testing r