4 Replies Latest reply: Apr 4, 2013 5:25 PM by Mohamed ELAzab RSS

    Configuring RMAN for multiple databases


      I have 4 databases all on four different machines, I want to configure RMAN for all the databases on a single machine. One of the database is a test DB. I would appreciate if some one can help me out in this.

      Thanks in advance.
        • 1. Re: Configuring RMAN for multiple databases
          Best advice: Read the docs which it seems you have not done.

          Start with page 1 and make it well past the instructions on the "REGISTER DATABASE" command.
          • 2. Re: Configuring RMAN for multiple databases
            Mohamed ELAzab
            Hello ,

            Developing a backup strategy is important for your company data safty. I can give you hints to use for example in the company i work for and it is a very large scale company we use RMAN catalog and this catalog we register the databases with to keep the backup information in a safe location and in order to be able to determine the latest status in case of disaster "EG: the whole machine was down or crashed and you need to restore to a different machine".You can refer always to the catalog in these cases.
            You need also to develop a backup scripts to backup the databases regularly .You need to set daily backup to backup the database every day and you need to backup the database every week which is known as full and incremental backups.

            You will need to use a way to schedule those scripts to run in a cretin time like the crontab job .We are using semantic netbackup for example to schedule backups.
            Please refer to the documentation and read the concept well as shown in the link below as the backup strategy and planing is important and very critical action you should care when designing in order to be able to recover when a major crash occur.

            Documentation Link:
            Mohamed ElAzab
            Blog: http://mohamedelazab.blogspot.com/
            • 3. Re: Configuring RMAN for multiple databases
              With respect to NetBackup and other tools ... my preference is to always back up to disk directly and then point the tape drive to an operating system directory.

              Why? Restoring from tape is too slow.

              Especially when the tape just left the building on a FedEx or UPS truck.
              • 4. Re: Configuring RMAN for multiple databases
                Mohamed ELAzab
                Hello damorgan ,

                I agree with you but we do this with very large databases by using Rman image copy.If the database is 100 or 200 giga the backup will take 2 to 4 hours depending on the tape library and netbackup bandwidth.

                if the database is 2 tera we cannot afford 2 days backup so we backup it using image copy and if a disaster occur we use switch copy.if you can take a backup of the image copy to a disk it will be cool and will offload the production.if you have a data guard you can offload the production and backup from it directly.

                Kind Regards
                Mohamed ELAzab
                Blog: http://mohamedelazab.blogspot.com/