1 2 Previous Next 16 Replies Latest reply: Aug 4, 2014 10:32 AM by L-MachineGun RSS

    how do I collect databases?

    988763

      Thank you very much

      I have used the method of import / export and succeeded
      The problem now is how do I collect databases, numbering more than 100 database and is on three levels
      The first level where one database
      The second level which is about 30 database
      The third level where the rest
      The fact that they are similar in each level and reach the top level
      What is the best way for this to work
      Thank you very much

        • 1. Re: how do I collect databases?
          FreddieEssex

          What do you mean by "collect" a database and what do you mean by "level"?

          • 2. Re: how do I collect databases?
            Chandru-Oracle

            Hi

            Thanks for using community, do you want the backup strategy for this or pointing some thing else.

             

            Thank you

            Chandra

            • 3. Re: how do I collect databases?
              988763

              hi

              Yes, I want to backup strategy for this.

              i mean by "collect", centralization

              i mean by "level", layer

              The rules of the data layer is divided into three layers hierarchical level contains the first level and the second turn, contains a third level in the tree

              Thank you


              • 4. Re: how do I collect databases?
                Chandru-Oracle

                Hi

                Please try to post your query on High availability-backup/RMAN area for fast response.

                 

                Thank you

                Chandra

                • 5. Re: how do I collect databases?
                  FreddieEssex

                  I don't think that will help....the question doesn't relate to RMAN...or if it does the OP hasn't stated that.

                   

                  The OP needs to be more specific....what does he mean by centralise?

                   

                  What is he specifically trying to achieve?

                  • 6. Re: how do I collect databases?
                    EdStevens

                    988763 wrote:

                     

                    hi

                    Yes, I want to backup strategy for this.

                    i mean by "collect", centralization

                    i mean by "level", layer

                    The rules of the data layer is divided into three layers hierarchical level contains the first level and the second turn, contains a third level in the tree

                    Thank you


                    I'm afraid simply replacing the word "collect" with "centralization" and "level" with "layer" imparts no additional information or understanding.

                    Please describe what you mean.

                    • 7. Re: how do I collect databases?
                      Aman....

                      Seems like , and it's just a guess , that you want to manage multiple databases being managed as "one" . If yes, you don't have this option available till the version 12c. But since you are not telling us precisely what you are looking for, it's hard to suggest anything. Tell us in detail what you want and then only we shall be able to answer.

                       

                      Aman....

                      • 8. Re: how do I collect databases?
                        L-MachineGun

                        As Aman stated the best way to centralize databases would be to do it if you had Oracle version 12c.

                         

                        For other versions and if you already had success using export/import, perhaps you could better use datapump or trasportable tablespaces or rman depending on the specific version(s) of the OS and Oracle of each database.

                         

                        Your strategy should be to move them by layers, first all layer 1 then all layer 2 and finally layer3.

                         

                        Good luck!

                         

                        • 9. Re: how do I collect databases?
                          Hemant K Chitale

                          Before you talk of the database you need to look at the design.  What really is the design ?  For example, Is it data that is aggregated / disaggregated at different "levels" ?  Or do the levels / layers indicate navigation paths (e.g. joins) for queries ?  You need to look at the schemas in the databases and identify dependencies / links.

                           

                           

                          Hemant K Chitale

                          • 10. Re: how do I collect databases?
                            Girish Sharma

                            You write a question like a poem, starting with Thanks

                             

                            If I guess is it something like your question :

                             

                            You have total 100 databases, 69 databases at the third level, application and users uses the data of these dbs, do some kind of processing and then puts the data to 30 databases at second level; again, application and users uses the data of these 30 dbs, do some kind of processing and then transfers the data to 1 databases at first level right ?

                             

                            If yes, then calling the same data as a different "level" don't make sense, it just waste of resource, nothing more than it.  Take an example :

                            I have a table in which new employee info get inserted like name, address, phone, join_date, age, gender and salary etc.  After completing one year, employee gets increment in his salary and now his salary incremented by suppose 100$.  Now, if I says this table is "second level" is it technically right ?  What does it mean by second level ?  Why should I put the table in another "second level" database ?  Can't I do the same select and DMLs on the table at "second level" ?  If second level, it need some more and joined columns with other tables, then views are there for you.  If still it don't works, it means there is flaw in data design, it requires normalization, a complete and thorough study of business data, flow etc.  A single table or database can be used perfectly at any level, if it is talking the business data in proper sense, normalized manner.

                             

                            I just wish to echo what Ed, Aman and Hemant said.  Simply tell us what is application, how the application uses database. and what is 4 digit Oracle version.  All we don't know nothing about what you knows and what you are looking for.

                             

                            Regards

                            Girish Sharma

                            • 11. Re: how do I collect databases?
                              988763

                              Thank you very much for your interaction with the subject matter and sorry for not being able to explain the issue well I'll try to have attached file shows what I want to do


                              Sans titre.png

                              • 12. Re: how do I collect databases?
                                Aman....

                                As we said before, there is no such option in oracle database until 12c to compile/consolidate multiple databases into a single large database . So if that's what your intention is by saying "compile databases in one place" , as long as you are not on 12c and don't use the new multitenant concept, the answer is, its not possible.

                                 

                                Aman....

                                • 13. Re: how do I collect databases?
                                  EdStevens

                                  So, cutting through all your of your organization-specific terminology (which we cannot be expected to understand), it looks like the problem reduces to collecting data (not databases) from multiple databases and putting it into one single (aha!  "Central") database.

                                   

                                  Part of the problem will be application-specefic.  Is the structure of the application schema(s) identical across all regional databases?  Will the data in the central database need to be identifiable as to which regional database it came from?

                                   

                                  Part of the problem is more general, though still application related.  How current does the central database need to be?  eg, how often does it need to be refreshed from the regional databases?

                                  • 14. Re: how do I collect databases?
                                    tvCa-Oracle

                                    If I understand the problem, you want different databases, a lot, to be merged into 1.

                                    You can, if each single non-system schema is copied into the new database, which a name that is unique inside that new one database.

                                    You may be entering hell, if lots of duplicates exist and if lots of code uses any of those, since that code may need to be rewritten.

                                    There's no database version issue with that action, but the chance is high it'll not be easy if you want 1 database. Not knowing for us what is in all of those databases.

                                    1 2 Previous Next