Re: Upgrade from Database 9i to 10g on Linux

On Apr 10, 10:56�am, alex.berin..._at_gmail.com wrote:
> Hello,
>
> I am supposed to upgrade a 9i database to 10g on Linux x86 on 32bits.
>
> Things to know:
> - I want to preserve old installation. On 9i some very good DBA (not
> like me) installed the database and there are many scripts which
> automate things like backup

You probably want to replace these with the Enterprise Manager backup scripts. You probably want to use the script generator for custom backup and go through the four screens (select the Maintenance tab on the Database Instance screen, then click on Schedule Backup). Then you can easily navigate through and see what has run and what will run. Do you really know that the old scripts are that good? I've seen things that were good in the distant past be not-so-good in the present. One thing in particular - are they RMAN backups?

It also helps to make a repository database to help you with management and backups, though not strictly necessary.

As a novice, you need to learn exactly what your system is doing and the tools to do it. Many people say, the one thing a DBA CANNOT get wrong is recovery. And you can't have recovery without backups.

jg

--
@home.com is bogus.
People also say don't drive on bald tires, but that doesn't seem to
stop some people.