Hi,
* Question background :
My DB is in ArchiveLog mode.
I have TS in ReadOnly mode.
As i know,
- Oracle allows to DROP table resides in ReadOnly TS (& other objects
also) even though that TS is in ReadOnly mode.
- Oracle will not recover ReadOnly TS during Oracle startup.
I have backup of db files "after" making TS readOnly but "before"
dropping tables from ReadOnly TS.
That means...
1st, made TS as ReadOnly
2nd, took backup of ReadOnly TS
3rd, dropped few tables from ReadOnly TS
Assume now media failure occurred.
* Question :
After restore + recovery operation, those dropped table will be
available or not ? WHY ?
I am in doubt because
1) there is chance of having those tables BACK after restore +
recovery operation because restored files are before dropping tables.
2) there is chance of NOT having those tables back after restore +
recovery operation because Oracle doesn't perform recovery for
ReadOnly TS.
Which one is correct ???
Thanks,
Darshak 2 4326 da******@coreob jects.com (Darshak Shah) wrote in message news:<92******* *************** ****@posting.go ogle.com>... Hi,
* Question background :
My DB is in ArchiveLog mode. I have TS in ReadOnly mode. As i know, - Oracle allows to DROP table resides in ReadOnly TS (& other objects also) even though that TS is in ReadOnly mode. - Oracle will not recover ReadOnly TS during Oracle startup.
I have backup of db files "after" making TS readOnly but "before" dropping tables from ReadOnly TS. That means... 1st, made TS as ReadOnly 2nd, took backup of ReadOnly TS 3rd, dropped few tables from ReadOnly TS Assume now media failure occurred.
* Question : After restore + recovery operation, those dropped table will be available or not ? WHY ? I am in doubt because 1) there is chance of having those tables BACK after restore + recovery operation because restored files are before dropping tables. 2) there is chance of NOT having those tables back after restore + recovery operation because Oracle doesn't perform recovery for ReadOnly TS.
Which one is correct ???
Thanks, Darshak
Information about tables is maintained in the datadictionary in the
system tablespace. The affected tables have been deleted from the
dictionary.
And NO you will not get them back EVER. Not recovering read only
tablespaces has NOTHING to do with it.
Sybrand Bakker
Senior Oracle DBA sy******@yahoo. com wrote in message news:<a1******* *************** ****@posting.go ogle.com>... da******@coreob jects.com (Darshak Shah) wrote in message news:<92******* *************** ****@posting.go ogle.com>... Hi,
* Question background :
My DB is in ArchiveLog mode. I have TS in ReadOnly mode. As i know, - Oracle allows to DROP table resides in ReadOnly TS (& other objects also) even though that TS is in ReadOnly mode. - Oracle will not recover ReadOnly TS during Oracle startup.
I have backup of db files "after" making TS readOnly but "before" dropping tables from ReadOnly TS. That means... 1st, made TS as ReadOnly 2nd, took backup of ReadOnly TS 3rd, dropped few tables from ReadOnly TS Assume now media failure occurred.
* Question : After restore + recovery operation, those dropped table will be available or not ? WHY ? I am in doubt because 1) there is chance of having those tables BACK after restore + recovery operation because restored files are before dropping tables. 2) there is chance of NOT having those tables back after restore + recovery operation because Oracle doesn't perform recovery for ReadOnly TS.
Which one is correct ???
Thanks, Darshak
Information about tables is maintained in the datadictionary in the system tablespace. The affected tables have been deleted from the dictionary. And NO you will not get them back EVER. Not recovering read only tablespaces has NOTHING to do with it.
Sybrand Bakker Senior Oracle DBA
Hi,
actually this is kind of interesting - I think.
If this tablespace is local managed, Oracle would have to update the
free space bitmaps in the 'read only' datafiles, i.e. they change.
Thus a new backup would be required.
I did nt't test this, but i doubt that it would be allowed to drop
tables from read-only local managed tablespaces.
Karsten This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: daveland |
last post by:
I am working on some JavaScript that dynamically adds rows to a table
in response to a button click. A new row does appear on the screen
when the button is clicked. However, that table to which a row has
been added is itself contained within an outer table (to handle the
desired screen layout). That outer table does not properly grow to
contain the new size of the table to which the row was added. (More
specifically, I have...
|
by: Matt |
last post by:
I want to know if readOnly attribute doesn't work for drop down list?
If I try disabled attribute, it works fine for drop down list. When I
try text box, it works fine for both disabled and readOnly attribute.
For example, #1 will work, but #2 doesn't work
1) <SELECT name="streetDirection" class="FormInput" DISABLED>
In JavaScript, I have InputForm.streetDirection.disabled = false;
2) <SELECT name="streetDirection" class="FormInput"...
|
by: Leo |
last post by:
Thanks for the Help in Advance!
I am a beginner in VB.Net. I am trying to create a form which is displayed in a email for our customers to fill in a Request for quote. I would like them to type data into fields and have it added to the Datagrid
I am constantly getting the error Column 'OALen' does not belong to table .
Any Ideas
Public tblJobItems As New DataTabl
|
by: Junior |
last post by:
Hi All,
I haven't got a response for this question lately and i really need to
get this done ASAP.
I have a .aspx page that has table two column four rows on it.
1. How do i use codebehind C# to populate the HTML table?
2. How do i pull some figures from the second column and add them up in
the Total field.
|
by: James Black |
last post by:
I am dynamically generating a table in IE to display some information.
I will probably change it to divs later, but I just want to get it
working properly first.
In my div I have the following as the value of innerHTML:
"<TABLE>
<TR>
<TD id=td6x vAlign=top align=right><IMG height=14 alt=Required
src=\"/images/ci/icons/required.gif\" width=7 border=0
vAlign=\"top\"><INPUT id=anchor6x width=0 size=10
| |
by: James Black |
last post by:
I am dynamically generating a table in IE to display some information.
I will probably change it to divs later, but I just want to get it
working properly first.
In my div I have the following as the value of innerHTML:
"<TABLE>
<TR>
<TD id=td6x vAlign=top align=right><IMG height=14 alt=Required
src=\"/images/ci/icons/required.gif\" width=7 border=0
vAlign=\"top\"><INPUT id=anchor6x width=0 size=10
|
by: jonniethecodeprince |
last post by:
Hi all,
I have trouble getting an array of data stored in a separate javascript file i.e. a file called books.js into a table of data for a .xhtml file.
There are 50 Records in this file.
There are 5 colums of data I wish to display.
I want to display these records in groups of 10.
Based on the fact that the records I want are located in a separate file, how can I get these details to show on the form and manipulate the data to...
|
by: Darshak Shah |
last post by:
Hi,
* Question background :
My DB is in ArchiveLog mode.
I have TS in ReadOnly mode.
As i know,
- Oracle allows to DROP table resides in ReadOnly TS (& other objects
also) even though that TS is in ReadOnly mode.
- Oracle will not recover ReadOnly TS during Oracle startup.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |