Primary/Mirror Issues
Hi all, Someone please advice me, when i drop a table from the primary chunk, or delete data inside tables from the primary chunk, will the tables or data get restored back automatically from the mirror chunks? What about if i drop a dbspace from the primary chunk, will this again get restored from the mirror chunk? Paul
On 08/02/07, PAUL GATHOGO <pgathogo@gmail.com> wrote: > Hi all, > > Someone please advice me, when i drop a table from the primary chunk, or > delete data inside tables from the primary chunk, will the tables or data get > restored back automatically from the mirror chunks? > > What about if i drop a dbspace from the primary chunk, will this again get > restored from the mirror chunk? > > Paul > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > Paul No. Provided both chunks are on-line they will remain in step with each other (effectivly they are visible as a single chunk with mirroring providing continuation/recovery in the event of disk failure (they are on separate spindles aren't they !! ) ). If one chunk (of the pair) goes off-line for any reason the remaining will continue to service the engine and be kept up to date. When the off-line chunks comes back on-line it will be refreshed from the up to date chunks. To recover deleted data as you suggest you need to either restore a pre-deletion archive and extract the data or, if you have V10, undertake a table level restore. Keith
No Paul, the objects on the mirror chunks will be dropped/deleted as well. Art S. Kagel ----- Original Message ----- From: Paul Gathogo <ids@iiug.org> At: 2/08 1:48:52 Hi all, Someone please advice me, when i drop a table from the primary chunk, or delete data inside tables from the primary chunk, will the tables or data get restored back automatically from the mirror chunks? What about if i drop a dbspace from the primary chunk, will this again get restored from the mirror chunk? Paul ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
The answer is "no" to both questions. The mirror is exactly that, it will reflect the actions taken upon the primary chunk. The purpose of the mirror is to backup the primary chunk. The only way it can do that is to contain exactly what is stored within the primary. Take care. Clifton -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of PAUL GATHOGO Sent: Thursday, February 08, 2007 12:48 AM To: ids@iiug.org Subject: Primary/Mirror Issues [8378] Hi all, Someone please advice me, when i drop a table from the primary chunk, or delete data inside tables from the primary chunk, will the tables or data get restored back automatically from the mirror chunks? What about if i drop a dbspace from the primary chunk, will this again get restored from the mirror chunk? Paul **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.