Re: 8.1.7.4 standby database - missing some log files???

BD wrote:
> >get rid of managed recovery
>
> Yeah, managed recovery ain't gonna fly for me - the whole point of the
> exercise is to have a reporting database, rather than recovery or
> failover - so it'd be in read-only mode the vast majority of the time.
> Scheduled manual recoveries are the best option.
>
> I ain't no shell script guru; thankfully, after I verbosely explained
> what I needed in the AIX group, and asked for pointers to similar
> sample scripts, some kind soul hacked out three lines of shell code
> that would fit the bill nicely - check dest1 for files, check dest2 for
> missing files, copy and rename from dest1 to dest2 as required. Easy
> peasy.

I'm sure the kind soul did this, but I'll say it anyways - check that dest2 has complete files. Partial files (corrupted in transit or just not finished writing yet) will, predictably, stop recovery cold. It can also help to have error messages that junior people can understand available where they can see them should things go wrong. I keep error logs and mail an uh-oh message.

>
> So I'll give that a run for awhile. It'd be _far_ easier on me if we
> were at 10g right now, but that is gonna have to wait for our server
> consolidation project to kick off later in the year.

jg

--
@home.com is bogus.
http://www.signonsandiego.com/news/metro/20060501-1056-bn01protest4.html