Re: Physical restore

mohitanchlia@gmail.com wrote: > 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. > 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.)

On Sep 21, 8:17 am, "TBP (The Big Potato)" <T...@NotHere.Co.Uk> wrote: > mohitanch...@gmail.com wrote: > > 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. > > 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.) What's the difference between external restore vs physical restore.

mohitanchlia@gmail.com wrote: > On Sep 21, 8:17 am, "TBP (The Big Potato)" <T...@NotHere.Co.Uk> wrote: >> mohitanch...@gmail.com wrote: >>> 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. >> 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.) > > What's the difference between external restore vs physical restore. > Err, what are you actually doing?

TBP wrote: > mohitanchlia@gmail.com wrote: >> On Sep 21, 8:17 am, "TBP (The Big Potato)" <T...@NotHere.Co.Uk> wrote: >>> mohitanch...@gmail.com wrote: >>>> 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. >>> 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.) >> >> What's the difference between external restore vs physical restore. >> > > 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).

On Sep 22, 11:16 am, TBP <TheBigPot...@NotHere.Co.Uk> wrote: > TBP wrote: > > mohitanch...@gmail.com wrote: > >> On Sep 21, 8:17 am, "TBP (The Big Potato)" <T...@NotHere.Co.Uk> wrote: > >>> mohitanch...@gmail.com wrote: > >>>> 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. > >>> 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.) > > >> What's the difference between external restore vs physical restore. > > > 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). Now I understand. Yes, problem I am seeing is while doing External Restore after running comman onbar -r -e -p.