Is it possible to use a checkpoint from one Linux server and use this to create the database on another Linux server?
Both are 64 bit SUSE.

Thanks,
Rich

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

Rich Ford wrote:

Is it possible to use a checkpoint from one Linux server and use this to create the database on another Linux server?
Both are 64 bit SUSE.

Short answer, yes. We do it all the time for UAT, and not just on
Linux.

What are you planning?

Roy

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

On Friday, 3 December 2021 at 16:27:31 UTC-8, Roy Hann wrote:

Rich Ford wrote:

Is it possible to use a checkpoint from one Linux server and use this to create the database on another Linux server?
Both are 64 bit SUSE.

Short answer, yes. We do it all the time for UAT, and not just on
Linux.

What are you planning?

Roy

We are setting up a new Dev/QA environment and want to load prod data here.

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

To: [email protected] ([email protected])

Hi Rich,

Yes, but with some caveats.

The two hosts must be kept in synch with both OS and Ingres version levels. Furthermore they must have the same directory structure for the Ingres installations. That is II_SYSTEM, II_DATABASE, II_JOURNAL etc must be the same.

Do you need any instruction in how to proceed from here to effect the recovery?

If you intend to allow multiple Ingres installations to use a single recovery host then I suggest you create each of the primary installations with a distinct installation identifier and different paths for II_SYSTEM etc. Trust me that helps
significantly and it's far better to set that up initially than attempt to retrofit it later.

Marty

-----Original Message-----
From: Rich Ford <[email protected]>
Sent: 03 December 2021 22:48
To: [email protected]
Subject: [Info-ingres] create new database from checkpoint

Is it possible to use a checkpoint from one Linux server and use this to create the database on another Linux server?
Both are 64 bit SUSE.

Thanks,
Rich
_______________________________________________
Info-ingres mailing list
[email protected] https://lists.planetingres.org/mailman/listinfo/info-ingres

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

Rich Ford wrote:

On Friday, 3 December 2021 at 16:27:31 UTC-8, Roy Hann wrote:

Rich Ford wrote:

Is it possible to use a checkpoint from one Linux server and use this to create the database on another Linux server?
Both are 64 bit SUSE.

Short answer, yes. We do it all the time for UAT, and not just on
Linux.

What are you planning?

Roy

We are setting up a new Dev/QA environment and want to load prod data here.

Have you ruled out using relocatedb to clone the database? It can be
more flexible than restoring from a checkpoint (provided your database
is not colossal).

Roy

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

On Monday, 6 December 2021 at 06:17:07 UTC-8, Roy Hann wrote:

Rich Ford wrote:

On Friday, 3 December 2021 at 16:27:31 UTC-8, Roy Hann wrote:

Rich Ford wrote:

Is it possible to use a checkpoint from one Linux server and use this to create the database on another Linux server?
Both are 64 bit SUSE.

Short answer, yes. We do it all the time for UAT, and not just on
Linux.

What are you planning?

Roy

We are setting up a new Dev/QA environment and want to load prod data here.

Have you ruled out using relocatedb to clone the database? It can be
more flexible than restoring from a checkpoint (provided your database
is not colossal).

Roy

Our databases are not very big.
Will try relocatedb. Going forward we'll be doing weekly refreshes from prod into this environment.
Is relocatedb also a good method of doing refreshes?

Rich

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)