 |
IDS Forum
Re: Can you resize a dbspace? HDR swap primary....
Posted By: Kern Doquang
Date: Tuesday, 25 April 2017, at 6:20 p.m.
In Response To: Re: Can you resize a dbspace? HDR swap primary.... (LARRY SORENSEN)
If your ntwk sucks then take a level 0 from primary, zip it, transfer over secondary, restore, it may be faster?
> On Apr 25, 2017, at 5:53 PM, LARRY SORENSEN <LSORENSEN25@msn.com> wrote:
>
> The secondary was blocking the checkpoint of the primary. Apparently, someone
> unplugged a network cable in the middle of the final logical log download to
> the secondary. This caused the secondary to be in a bad state. I had Support
> log in and see if they could fix it, but alas they couldn't. Now my new
> primary is up, but I am going through the 30 hour process of restarting
> replication to the corrupt secondary.
>
> Such is life.
>
> Thanks to all those who helped.
>
> Larry
>
> ________________________________
> From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Marcus Haarmann
> <marcus.haarmann@midoco.de>
> Sent: Tuesday, April 25, 2017 2:39 PM
> To: ids@iiug.org
> Subject: Re: Can you resize a dbspace? HDR swap primary.... [39039]
>
> what is in the online.log of the primary ?
> Shutdown the secondary instance for test (onmode -ky), it might block the
> checkpoint of the primary.
>
> Marcus Haarmann
>
> Von: "LARRY SORENSEN" <LSORENSEN25@msn.com>
> An: "ids" <ids@iiug.org>
> Gesendet: Dienstag, 25. April 2017 19:36:41
> Betreff: Fw: Can you resize a dbspace? HDR swap primary.... [39036]
>
> I was able to get replication going from the below process. I then had to
> switch the Primary and secondary.
>
> I took the Primary offline.
>
> I ran hdrmkpri.sh new_sec_name
>
> This takes the new primary offline.
>
> I then ran hdrmksec.sh new_pri_name.
>
> Toward the end of the script it asks me to bring the primary online so they
> can sink. I did.
>
> It looked like everything was working.
>
> Logical Recovery Started.
>
> 24 Recovery worker threads will be started.
>
> Start Logical Recovery - Star Log 77121, End Log?
>
> Starting Log Position - 77121 0x7a60bc
>
> DR: Cleared 28550 KB of Logical log in - seconds.
>
> After that the secondary remains in Fast Recovery (Sec)
>
> The primary remains in -- On-Line (Prim) (CKPT REQ) -- Blocked:CKPT
>
> Any ideas?
>
> Larry
>
> ________________________________
> From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of LARRY SORENSEN
> <LSORENSEN25@msn.com>
> Sent: Monday, April 24, 2017 10:27 PM
> To: ids@iiug.org
> Subject: Re: Can you resize a dbspace? [39026]
>
> Thank you, both of you. I can watch the final dbspaces filling with doing
> onstat -D every so often and doing a diff on results. I was just worried that
> nothing was happening.
>
> Larry
>
> ________________________________
> From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
> <art.kagel@gmail.com>
> Sent: Monday, April 24, 2017 8:38 PM
> To: ids@iiug.org
> Subject: Re: Can you resize a dbspace? [39024]
>
> No and no.
>
> Art
>
> Art S. Kagel, President and Principal Consultant
> ASK Database Management
> www.askdbmgt.com<http://www.askdbmgt.com>
>
> ASK Database Management - Home<http://www.askdbmgt.com/>
> www.askdbmgt.com
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> ASK Database Management - Home<http://www.askdbmgt.com/>
>
> ASK Database Management - Home<http://www.askdbmgt.com/>
> www.askdbmgt.com
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> www.askdbmgt.com<http://www.askdbmgt.com>
>
> ASK Database Management - Home<http://www.askdbmgt.com/>
> www.askdbmgt.com
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> ASK Database Management - Home<http://www.askdbmgt.com/>
>
> ASK Database Management - Home<http://www.askdbmgt.com/>
> www.askdbmgt.com
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> ASK Database Management - Home<http://www.askdbmgt.com/>
>
> ASK Database Management - Home<http://www.askdbmgt.com/>
> www.askdbmgt.com
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> www.askdbmgt.com<http://www.askdbmgt.com>
>
> ASK Database Management - Home<http://www.askdbmgt.com/>
> www.askdbmgt.com
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> www.askdbmgt.com<http://www.askdbmgt.com>
>
> ASK Database Management - Home<http://www.askdbmgt.com/>
> www.askdbmgt.com
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> ASK Database Management - Home<http://www.askdbmgt.com/>
>
> ASK Database Management - Home<http://www.askdbmgt.com/>
> www.askdbmgt.com
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> www.askdbmgt.com<http://www.askdbmgt.com>
>
> ASK Database Management - Home<http://www.askdbmgt.com/>
> www.askdbmgt.com
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> Blog: http://informix-myview.blogspot.com/
>
> Informix - My view<http://informix-myview.blogspot.com/>
> informix-myview.blogspot.com
> A place to share my views and ideas which may be of interest to the Informix
> user Community.
>
> Informix - My view<http://informix-myview.blogspot.com/>
> informix-myview.blogspot.com
> A place to share my views and ideas which may be of interest to the Informix
> user Community.
>
> Informix - My view<http://informix-myview.blogspot.com/>
>
> Informix - My view<http://informix-myview.blogspot.com/>
> informix-myview.blogspot.com
> A place to share my views and ideas which may be of interest to the Informix
> user Community.
>
> informix-myview.blogspot.com
> A place to share my views and ideas which may be of interest to the Informix
> user Community.
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and do not reflect on the IIUG, nor any other organization with which I am
> associated either explicitly, implicitly, or by inference. Neither do
> those opinions reflect those of other individuals affiliated with any
> entity with which I am affiliated nor those of the entities themselves.
>
> On Mon, Apr 24, 2017 at 10:11 PM, LARRY SORENSEN <LSORENSEN25@msn.com>
> wrote:
>
>> Should an onstat -D show exactly the same results on both the primary and
>> the
>> secondary?
>>
>> Also, I am just letting it overwrite a previous copy of the database. Do
>> you
>> see any issues with this?
>>
>> Larry
>>
>> ________________________________
>> From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
>> <art.kagel@gmail.com>
>> Sent: Monday, April 24, 2017 7:54 PM
>> To: ids@iiug.org
>> Subject: Re: Can you resize a dbspace? [39019]
>>
>> On the secondary you can run "onstat -D" and see which chunks have already
>> been written out. The restore restores one dbspaces at a time in dbsnum
>> order writting to all chunks in each dbspace before moving on to the next
>> dbspace. So, you can tell how far the restore has progressed. Note that
>> the number of pages that will be written to each chunk will be roughly the
>> number of used pages in that chunk (from onstat -d) plus a few pages for
>> the physical log pages that overwrite pages modified during the archive to
>> return them to their condition as of the beginning of the archive.
>>
>> Art
>>
>> Art S. Kagel, President and Principal Consultant
>> ASK Database Management
>> www.askdbmgt.com<http://www.askdbmgt.com>
>
> ASK Database Management - Home<http://www.askdbmgt.com/>
> www.askdbmgt.com<http://www.askdbmgt.com>
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> ASK Database Management - Home<http://www.askdbmgt.com/>
>
> ASK Database Management - Home<http://www.askdbmgt.com/>
> www.askdbmgt.com<http://www.askdbmgt.com>
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> www.askdbmgt.com<http://www.askdbmgt.com>
>
> ASK Database Management - Home<http://www.askdbmgt.com/>
> www.askdbmgt.com<http://www.askdbmgt.com>
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
>>
>> ASK Database Management - Home<http://www.askdbmgt.com/>
>
> ASK Database Management - Home<http://www.askdbmgt.com/>
> www.askdbmgt.com<http://www.askdbmgt.com>
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> ASK Database Management - Home<http://www.askdbmgt.com/>
>
> ASK Database Management - Home<http://www.askdbmgt.com/>
> www.askdbmgt.com<http://www.askdbmgt.com>
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> www.askdbmgt.com<http://www.askdbmgt.com>
>
> ASK Database Management - Home<http://www.askdbmgt.com/>
> www.askdbmgt.com<http://www.askdbmgt.com>
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
>> www.askdbmgt.com<http://www.askdbmgt.com>
>
> ASK Database Management - Home<http://www.askdbmgt.com/>
> www.askdbmgt.com<http://www.askdbmgt.com>
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> ASK Database Management - Home<http://www.askdbmgt.com/>
>
> ASK Database Management - Home<http://www.askdbmgt.com/>
> www.askdbmgt.com<http://www.askdbmgt.com>
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> www.askdbmgt.com<http://www.askdbmgt.com>
>
> ASK Database Management - Home<http://www.askdbmgt.com/>
> www.askdbmgt.com<http://www.askdbmgt.com>
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
>> Database Consulting and Support ... This is the site for Art S. Kagel's
>> consultancy. The soaring majesty and beauty in the image above hides the
>> complex ecology and ...
>>
>> Blog: http://informix-myview.blogspot.com/
>
> Informix - My view<http://informix-myview.blogspot.com/>
> informix-myview.blogspot.com
> A place to share my views and ideas which may be of interest to the Informix
> user Community.
>
>>
>> Informix - My view<http://informix-myview.blogspot.com/>
>
> Informix - My view<http://informix-myview.blogspot.com/>
> informix-myview.blogspot.com
> A place to share my views and ideas which may be of interest to the Informix
> user Community.
>
>> informix-myview.blogspot.com
>> A place to share my views and ideas which may be of interest to the
>> Informix
>> user Community.
>>
>> Disclaimer: Please keep in mind that my own opinions are my own opinions
>> and do not reflect on the IIUG, nor any other organization with which I am
>> associated either explicitly, implicitly, or by inference. Neither do
>> those opinions reflect those of other individuals affiliated with any
>> entity with which I am affiliated nor those of the entities themselves.
>>
>> On Mon, Apr 24, 2017 at 9:31 PM, LARRY SORENSEN <LSORENSEN25@msn.com>
>> wrote:
>>
>>> Solaris 10
>>>
>>> IDS 11.50.FC5
>>>
>>> I am using the HDR scripts, ontape_HDR_backup.ksh as well as its
>>> counterpart
>>> on the secondary server. It has been running for 20 hours, and a sar on
>> the
>>> secondary shows 99-100% idle. Is there anyway to check the progress or to
>>> even
>>> see if it is making progress?
>>>
>>> The primary shows that the backup was started 20 hours ago, and the
>> ontape
>>> is
>>> still running. The secondary shows that the ontape -p is also running on
>>> it.
>>>
>>> On the secondary, the online.log shows the server starting up at the same
>>> time
>>> the archive began on the primary. There were a few quick checkpoints and
>>> then
>>> nothing for about 14 hours. After the 14 hours there were 2 checkpoints
>>> and 2
>>> Checkpoint Statistics and then nothing.
>>>
>>> Larry
>>>
>>>
>>> ************************************************************
>>> *******************
>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>>
>>>
>>
>> --f403043a8e58b5c308054df400ac
>>
>>
>> ************************************************************
>> *******************
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>>
>> ************************************************************
>> *******************
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>>
>
> --f403045e38c6037d25054df49d7d
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Messages In This Thread
IDS Forum is maintained by Administrator with WebBBS 5.12.
|
|
