Re: FW: Backup up oracle database, part II

[John R. Jackson]

>Switching all of the tablespaces into and out of hot backup mode once at
>the start and end of the backup is definitely simpler.  ...

And then what?  How does the data get to Amanda?

I talked with my Oracle person a bit more and it was clear from him and
some documentation he looked up that each tablespace should be done one
at a time, not all of them at once.

>The backup user has
>to be running essentially as root for a backup anyway so it should be
>possible to do a 'su oracle -c command' at the start and end of the
>backup.

Absolutely not.  Very few people run Amanda as root.

>Colin.

John R. Jackson, Technical Software Specialist, [EMAIL PROTECTED]