Physical restore

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mohitanchlia@gmail.com - 21 Sep 2007 15:27 GMT

Version: IDS 10

What does this mean ?

20:19:45 DR: Reservation of the last logical log for log backup
turned on
20:19:45 Data replication type and state information reset. To start
DR, use
the 'onmode -d' command and wait for the pair to be
operational,
before shutting down the database server

20:19:45 Dataskip is now OFF for all dbspaces
20:19:45 Restartable Restore has been DISABLED
20:19:45 Recovery Mode
20:19:46 External restore started.
20:19:46 External restore ABORTED.

1. What does first line in the message mean
2. How should I dig deep into Physical resrote ABORTED problem

I'll try increasing BAR_DEBUG level and see if that helps.

Reply to this Message

TBP (The Big Potato) - 21 Sep 2007 16:17 GMT

> Version: IDS 10
>
[quoted text clipped - 18 lines]
>
> I'll try increasing BAR_DEBUG level and see if that helps.

Err, what are you actually doing?

Useful information like :

Version of IDS
Operating System

command run, along with a reason of WHY you are running the command.

An external restore means "external to the database engine" - i.e. there is NO onbar activity here, so ... what command did you issue?

(> 2. How should I dig deep into Physical resrote ABORTED problem)
vs
(> 20:19:46 External restore ABORTED.)

Reply to this Message

mohitanchlia@gmail.com - 22 Sep 2007 14:16 GMT

> mohitanch...@gmail.com wrote:
> > Version: IDS 10
[quoted text clipped - 34 lines]
> vs
> (> 20:19:46 External restore ABORTED.)

What's the difference between external restore vs physical restore.

Reply to this Message

TBP - 22 Sep 2007 19:11 GMT

>> mohitanch...@gmail.com wrote:
>>> Version: IDS 10
[quoted text clipped - 30 lines]
>
> What's the difference between external restore vs physical restore.

Err, what are you actually doing?

Reply to this Message

TBP - 22 Sep 2007 19:16 GMT

>>> mohitanch...@gmail.com wrote:
>>>> Version: IDS 10
[quoted text clipped - 33 lines]
>
> Err, what are you actually doing?

Oh allright, I will try and be a bit more specific about external and
"internal" physical restores.

External mean that "you did the backup using a method outstide of the
database engine - which requires the command onmode -c block prior to
doing something like split physical disks or dd off the raw devices or
... whatever, just not using database utilities like onbar or ontape".
When you come to restore you do the external command (i.e. dd the raw
devices back in), and then issue the onbar -r -e -p command (something
like that I am sure) which will bring the engine up with the External
Restore commands.

If you were doing ontape -s -L 0 or onbar -b -w, then a straight ontape
-r or onbar -r -w would be required which would be a physical restore
and no logical restore (optionally).

Reply to this Message

mohitanchlia@gmail.com - 24 Sep 2007 07:16 GMT

> > mohitanch...@gmail.com wrote:
> >>> mohitanch...@gmail.com wrote:
[quoted text clipped - 50 lines]
> -r or onbar -r -w would be required which would be a physical restore
> and no logical restore (optionally).

Now I understand. Yes, problem I am seeing is while doing External
Restore after running comman onbar -r -e -p.

Reply to this Message