Re: Archived redo log file lost.

From: Dave Hill <hilld_at_COUGAR.BARTON.CC.KS.US>
Date: Mon, 29 Jan 1996 08:31:43 -0600
Message-Id: <9601291435.AA10815@alice.jcc.com>

• =_NextPart_000_01BAEE24.38B79A60 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit

Pisano-

It is my understanding this is a YES and NO question.

No, you will not be able to just readd the SYSTEM.DBF -- the control files will  be out of sync.

Yes, if you have Oracle 7 you should be able to readd the file and then recreate  the control files.

HTH,
Dave

---

Dave Hill                                   HILLD_at_cougar.barton.cc.ks.us
DBA/Systems Analyst/Programmer
BCCC, Great Bend, KS, USA                       A great place to work!
------------------------------------------------------------------------

Opportunity often knocks softly.

---

I am testing my hot-backup procedure and I deleted file SYSTEM.DBF. After restoring this file I use the recovery procedure with command:

"alter database recover database"

the recovery procedure ask me for file :log18_1.arc. For a bug in my procedure I lost this file

1. is there a solution for this situation. Can I use the old file SYSTEM.DBF ?

Thanks in advance.
Pisano Fiore
e-mail address <pisano_at_solaria.bsav.bull.it> phone 0-825-764388
Bull Sud HN
(Avellino) Italy

• =_NextPart_000_01BAEE24.38B79A60 Content-Type: application/ms-tnef Content-Transfer-Encoding: base64

eJ8+IiwOAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAENgAQAAgAAAAIAAgABBJAG ADwBAAABAAAADAAAAAMAADADAAAACwAPDgAAAAACAf8PAQAAAFQAAAAAAAAAgSsfpL6jEBmdbgDd AQ9UAgAAAABPUkFDTEUgZGF0YWJhc2UgbWFpbGluZyBsaXN0LgBTTVRQAE9SQUNMRS1MQGNjdm0u c3VueXNiLmVkdQAeAAIwAQAAAAUAAABTTVRQAAAAAB4AAzABAAAAGQAAAE9SQUNMRS1MQGNjdm0u c3VueXNiLmVkdQAAAAADABUMAQAAAAMA/g8GAAAAHgABMAEAAAAgAAAAJ09SQUNMRSBkYXRhYmFz ZSBtYWlsaW5nIGxpc3QuJwACAQswAQAAAB4AAABTTVRQOk9SQUNMRS1MQENDVk0uU1VOWVNCLkVE VQAAAAMAADkAAAAACwBAOgEAAAACAfYPAQAAAAQAAAAAAAADlTsBCIAHABgAAABJUE0uTWljcm9z b2Z0IE1haWwuTm90ZQAxCAEEgAEAIQAAAFJFOiBBcmNoaXZlZCByZWRvIGxvZyBmaWxlIGxvc3Qu ABMLAQWAAwAOAAAAzAcBAB0ACAAfACsAAQBEAQEggAMADgAAAMwHAQAdAAgAHAAkAAEAOgEBCYAB ACEAAABCNEZCMEJENDEyNUFDRjExQkQ2OTQ0NDU1MzU0MDAwMAADBwEDkAYARAUAABIAAAALACMA AAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAEAAOQCAkKKCVu66AR4AcAABAAAAIQAAAFJFOiBB cmNoaXZlZCByZWRvIGxvZyBmaWxlIGxvc3QuAAAAAAIBcQABAAAAFgAAAAG67laCmdQL+7VaEhHP vWlERVNUAAAAAB4AHgwBAAAABQAAAFNNVFAAAAAAHgAfDAEAAAAdAAAAaGlsbGRAY291Z2FyLmJh cnRvbi5jYy5rcy51cwAAAAADAAYQhA4zQQMABxCpAwAAHgAIEAEAAABlAAAAUElTQU5PLUlUSVNN WVVOREVSU1RBTkRJTkdUSElTSVNBWUVTQU5ETk9RVUVTVElPTk5PLFlPVVdJTExOT1RCRUFCTEVU T0pVU1RSRUFERFRIRVNZU1RFTURCRi0tVEhFQ09OVAAAAAACAQkQAQAAALIDAACuAwAA8gYAAExa RnVxkKzt/wAKAQ8CFQKoBesCgwBQAvIJAgBjaArAc2V0MjcGAAbDAoMyA8UCAHByQnER4nN0ZW0C gzM3AuQHEwKDNARGEzMxILsIVQKAfQqACM8J2TsXz3gyNTUCgAqBDbELYG7wZzEwMxRQCwoVYQvy +mMAQCAKhwtkFFEL8hNQam8T0GMFQFAEAABwb9sbjxZALQqFCoVJBUAEAMAgbXkgdW4EgRPAhQBw ZAuAZyB0aCFB4SFBYSBZRQXwIhEHsFhPIHEKUBPAaQIgLkEgPE5vLCB5CGAgnQPwbAMgHtAFQGJl IvCDAmAmYHRvIGp1E8ByIBfQYWQjgCKAJmBTAFlTVEVNLkRC+kYgEC0nowWgAjADYAMgfmYDEAeR JcMmUQhgBUBvQGYgc3luYyRdWV8HkCVgBpAlcxGAdiZgT5ZyANAmoTclc3NoCGD+bCOAJlknWCmS I1MnsQOgXxfQBQAnYBPQKM9zJF1I6FRILAqFRCzhCoUooP80nzWvNr83zyigM2kzECXSAzoPOx9I SUxMREDJBaB1ZwrALmIKwCbQdSRAYysQazIgJxAzZkLMQS8TpAQgQW4HQBOxTC9QA2AJwGFtB4By 2QqFQkNAwCVgRzDCQKAlCfBkJWBLUyVgVVN+QTsvQqRCMAnBQUELUWPlJrN3BbBrITQfRh9HL2dI PzhfLRBwcBdxIaBpXnQhgCqwE9ADoGse0GP/PaAq0EsxP1AkVkj/Te9O/4dQDzjJCvRsaTM2HfHv HU8eUiCmIvBtInAj8iJRMyFxLgB0LT0AS8B1cPdEIANgRGBkCHAv5FRgDbC/JqAT0COAL7Mn+CRW QUtB/wXAF9ATwAWwIkcvs1RgJxDrMQQwkW8s8HIhgFYYA/CvIoApAUAAIhE6IDwiB0DtWSJkMOAB oGFa0VtFXofOIiA8Ww9WVXNrIWAvkRsFsS+zOhdgGuA4XzG2LgrAKxdGBbEjAGI8sP8hMAOgIWJW GFRgF2AnIVoH8SA8IDEpITInsVaCS/H/CkAkEmLjIoMAkErAMOAkIv8WUAORWqgG8Fd0Z+ZCoSf5 6j8gPFQRgG5L0WVhJ3D+dgBwRGAkVh6UZLAkIBfQ+QqFZS0AwAMRJ3FZYQQg9DxwHqNAaUEKwAcw PPBNHrB2PPAuIGwuSvA+FQqFcC4AbiZgMC04ARoALTc2NDM4OJdARnPRBgB1I4BITgqF3ChBLPAl 4AuAb2hwIRC/P0EgPFHfG+dTfRbxAHwQAAADABAQAAAAAAMAERAAAAAAQAAHMICPYxNW7roBQAAI MICPYxNW7roBHgA9AAEAAAAFAAAAUkU6IAAAAACEiw==

• =_NextPart_000_01BAEE24.38B79A60--

Received on Mon Jan 29 1996 - 09:35:59 CST