8 Replies Latest reply on Jan 25, 2018 1:48 AM by 3624179

    ORACLE DATABASE STORAGE

    3624179
    3624179 Jan 23, 2018 6:02 AM

      Hello everyone,

       

           I want to ask a question in Oracle database. Now, my system use Oracle Solaris and installed Oracle database 10g. My database store in SAN storage. I want to copy my database to NAS storage devices and configure it to become high availability database. That mean:

      Now: My Solaris server -> SAN storage.

      Future: My Solaris server -> SAN storage + NAS storage run HA together.

      But I do not know what method that i could configure to replicate the database.

      Could you guys give me some advice and solution. 

        • 1. Re: ORACLE DATABASE STORAGE
          Nik
          Nik Jan 23, 2018 6:42 AM (in response to 3624179)

          Hi.

          But you nothing say  how currently your database is configured.

            - It's can be on raw-device

            - You can use ASM

            - You can use general FS on SAN.

           

          For configure HA you not require NAS. Depend from caonfiguration, NAS can be single point of failure....

          May be this will help:  https://docs.oracle.com/cd/B28359_01/server.111/b28310/dfiles005.htm#ADMIN11434

           

          Regards,

            Nik

          • 2. Re: ORACLE DATABASE STORAGE
            3624179
            3624179 Jan 23, 2018 9:05 AM (in response to Nik)

            Dear NIK,

             

            Thanks for your reply, My system now work fine. It mount storage form SAN and i installed Oracle DB on them. Howerver, Because of many special problems, My SAN storage might going to out of date (Out of warranty, no spare parts for my SAN)

            > Because of that I want to move my database to NAS for temporary solution. 

            For more information: My Oracle DB install on disk A on Solaris (Disk A mount from SAN).

            I want to mount disk B to my Solaris and migrate Oracle DB to disk B. Could you give me any advice.

            • 3. Re: ORACLE DATABASE STORAGE
              Nik
              Nik Jan 23, 2018 10:30 AM (in response to 3624179)

              Hi.

                What OS ?

              0.  Create Backup.

              1. Stop database.

              2.  Mount NAS

              3. Copy all from mount_point SAN to mount_point NAS.

              4.  Umount SAN ; mount NAS on original mount_point

              5. Try start database.

               

              Oracle recommend use Direct-NFS client for store database.

               

              Regards,

              Nik.

              • 4. Re: ORACLE DATABASE STORAGE
                3624179
                3624179 Jan 24, 2018 1:31 AM (in response to Nik)

                Hello NIK,

                 

                     Thanks for your information. Now my server is runningSolaris 9 9/04 s9s_u7wos_09 SPARC.

                     I have thinking about this but I got a big question.

                     Will my Oracle DB work if I just copy data form mount_point SAN to new mount_point NAS.

                     >>4.  Umount SAN ; mount NAS on original mount_point

                          SAN and NAS have different mount methods. Do i need to re-configure for Oracle?

                • 5. Re: ORACLE DATABASE STORAGE
                  Nik
                  Nik Jan 24, 2018 4:54 AM (in response to 3624179)

                  Hi.

                  Oracle will work in case you save all path to files.

                  Perfomance will very depend from network and NAS.

                   

                  You not write what version of Oracle DB you use, so difficult find this configuration supported or not.

                   

                  Regards,

                     Nik. 

                  • 6. Re: ORACLE DATABASE STORAGE
                    3624179
                    3624179 Jan 24, 2018 7:37 AM (in response to Nik)

                    Dear NIK,

                    Thank you for that. I worry more about the Oracle DB work or not. Now I use: Oracle Database 10g Release 10.2.0.5.0 - 64bit.

                    How can I save path files and recover that? I also have another question: Are there any solution like: Migrate Oracle DB form "disk_mount_1" to "disk_mount_2"

                    I have to many research on the internet but the answer still zero

                    • 7. Re: ORACLE DATABASE STORAGE
                      Nik
                      Nik Jan 24, 2018 8:12 AM (in response to 3624179)

                      Hi.

                      Some step by step example for move oracle on other drive:

                        Steps To Move Oracle Database Data Files, Control files, Log Files From One To Another Windows Drive Which Consumes Ma…

                       

                      > How can I save path files and recover that?

                      What problem you see ?  Just  copy files.

                      mount <NAS_Path> /mnt1

                      cd <SAN_dir>

                      find . | cpio -pumd /mnt1

                      umount <SAN_dir>

                      umount /mnt1

                      mount <NAS_PATH> <SAN_dir>

                       

                      You have unsupported  Solaris version; unsupported Oracle version.

                      It's look like this database not required for business.....

                       

                      Create backup and try.

                       

                       

                      Regards,

                        Nik.

                      • 8. Re: ORACLE DATABASE STORAGE
                        3624179
                        3624179 Jan 25, 2018 1:48 AM (in response to Nik)

                        Dear NIK,

                         

                        Thanks for your fully information.

                        It's an running DB for manufacturing. So that we can't stop it and upgrade new version for more support.

                        I have understood your idea. I'm not sure my DB will work after that migration step. But I will try.