Hi,
Could you please suggest me how to corrupt a data
file, for testing recovery.
I am trying to test Block Recovery with my Personal
Oracle 9i on Windows Me. I am not able to open or overwrite the files because
oracle.exe locks them.
Thanks, Krishna
Hello all,
when sometimes, oracle will ask tool old archive logs
that are even 2-3 days older, when recovering a
datafile that is taken from todays backup.
does it mean the datafile is not properly backed up or
something wrong with controlfile.
todya there is another scenario:
creating a datab
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
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
-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
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
-
From:
Krishna
Rao Kakatur
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, December 11, 2002 2:00
AM
Subject: Recovery Scenarios
Hi,
Could you please suggest me how to corrupt a data
file, for testing recovery.
I am trying to test Block Recovery with my
Sorry folks .. i asked a wrong question. thanks for ur answers but those
crashing dbs recovery was totally heavy for me. i shud i have asked, what r
the different types of crashes and how to recover from them ? i mean, only
the general recovery scenarious. since i m learning, i just want to
underst
Hi,
I want to test and learn more about backups and recovery's.
Does anyone have a list of backup/recovery scenarios that I can test???
Thanks
Sujatha Madan
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sujatha Madan
INET: [EMAIL PROTECTED]
Fat City Ne
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
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
Since you want to learn, how about getting Rama Velpuri's Oracle Backup and Recovery
Guide. I find it to be the *best* book on this subject. It also has a number recovery
scenarios for you to practice and learn.
- Kirti
(Just finished recovering a database from a loss of 7 data files. Than
to be the *best* book on this subject. It also has
a number recovery scenarios for you to practice and learn.
- Kirti
(Just finished recovering a database from a loss of 7 data files. Thanks to
our brave & bold SAs, who were installing Veritas VM and moving files around
to newer disk..)
ltiple recipients of list ORACLE-L
Since you want to learn, how about getting Rama Velpuri's Oracle Backup and
Recovery Guide. I find it to be the *best* book on this subject. It also has
a number recovery scenarios for you to practice and learn.
- Kirti
(Just finished recovering a database fro
nd on Amazon.com!
-Original Message-
Sent: Saturday, February 22, 2003 7:24 PM
To: Multiple recipients of list ORACLE-L
Since you want to learn, how about getting Rama Velpuri's Oracle Backup and
Recovery Guide. I find it to be the *best* book on this subject. It also has
a numbe
gt;
>I want to test and learn more about backups and recovery's.
>
>Does anyone have a list of backup/recovery scenarios that I can test???
>
>Thanks
>
>Sujatha Madan
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Sujatha Mada
E-L
Hi,
I want to test and learn more about backups and recovery's.
Does anyone have a list of backup/recovery scenarios that I can test???
Thanks
Sujatha Madan
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sujatha Madan
INET: [EMAIL PROTECTED]
Fat Cit
>I want to test and learn more about backups and recovery's.
>
>Does anyone have a list of backup/recovery scenarios that I can test???
>
>Thanks
>
>Sujatha Madan
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Sujatha Madan
&g
> From: Sujatha Madan <[EMAIL PROTECTED]>
> Date: Wed, 5 Sep 2001 16:38:42 +1000
> Subject: Backup & Recovery Scenarios
>
>Hi,
>
>I want to test and learn more about backups and recovery's.
>
>Does anyone have a list of backup/recovery scenarios t
buy the backup/recovery book by Rama Velpuri, all you'd ever want to
know about backup/recovery.
joe
Sujatha Madan wrote:
>
> Hi,
>
> I want to test and learn more about backups and recovery's.
>
> Does anyone have a list of backup/recovery scenarios th
ltiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Backup & Recovery Scenarios
>Date: Tue, 04 Sep 2001 23:40:22 -0800
>
>
>Hi,
>
>I want to test and learn more about backups and recovery's.
>
>Does anyone have a list of backup/recovery scenario
Thanks a lot for all your assistance!
-Original Message-
Sent: Wednesday, 5 September 2001 5:40 PM
To: Multiple recipients of list ORACLE-L
Hi,
I want to test and learn more about backups and recovery's.
Does anyone have a list of backup/recovery scenarios that I can
Hi all,
Is there any doc./URL which lists out RMAN backup and recovery scenarios ?
did not find one in metalink.
Thanks & Regards,
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858
Thanx Govind.
as Robert said, it has a dedicated chapter for that.
...and i'm trying all the scenarios one by one with his book beside.
but just thought, i could some more inputs from the LIST.
I will continue with the book now.
Regards,
Jp.
--
Please see the official ORACLE-L FAQ: http://www
ts of list ORACLE-L
(B
(B
(BHi all,
(B
(BIs there any doc./URL which lists out RMAN backup and recovery scenarios ?
(Bdid not find one in metalink.
(B
(BThanks & Regards,
(BJp.
(B
(B
(B
(B--
(BPlease see the official ORACLE-L FAQ: http://www.orafaq.net
(B--
(BAuthor: Prem
hanna J
> Sent: Thursday, September 04, 2003 2:44 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RMAN backup and recovery scenarios
>
>
> Hi all,
>
> Is there any doc./URL which lists out RMAN backup and recovery scenarios ?
> did not find one in metalink.
>
> Than
LE-L
> Subject: RMAN backup and recovery scenarios
>
>
> Hi all,
>
> Is there any doc./URL which lists out RMAN backup and recovery
scenarios ?
> did not find one in metalink.
>
> Thanks & Regards,
> Jp.
>
>
>
> --
> Please see the official ORACLE-L FAQ
t;
> HTH,
> Ruth
>
>> -Original Message-
>> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
>> Prem Khanna J
>> Sent: Thursday, September 04, 2003 2:44 AM
>> To: Multiple recipients of list ORACLE-L
>> Subject: RMAN backup and rec
Well yours truly is doing a 3 hr backup/reocvery presetation on a geek
cruise in may(2002). Those of you who've had backup/recovery
problems(more like recovery problems), if you'd like to share some of
the scenarios/problems you've run into, the more bizarre the better,
corrupted redo logs, etc.
Thanx Dennis,Robert,and Ruth.
I'm going thro' Roberts's book now.
as Robert said, it has a dedicated chapter for that.
...and i'm trying all the scenarios one by one .
but just thought, i could some more inputs from you Gurus.
thanx a lot guys.
I will continue with the book.
Regards,
Jp.
--
Joe,
We (I and few want to be anonymous) are trying to build a tool like Data
Unloader which converts the data file from one Operating System to another
Operating System format.. (i.e. it will convert Oracle datafile from NT to
any Unix and vice versa).. If this works well you don't need to
expor
Hum, anonymous works best when you do not send the email to the whole
group. I will try hard not to look at the name though;-)
-Original Message-
Gopalakrishnan
Sent: Monday, December 24, 2001 6:05 AM
To: Multiple recipients of list ORACLE-L
Joe,
We (I and few want to be anonymous) ar
32 matches
Mail list logo
