Shulou(Shulou.com)06/01 Report--

Of course, the preparatory stage of cloud relocation work is not without a survey of the existing environment, this is a very important stage, how to move, but also need this as a basis, so this stage can not be careless.

1, on the whole, you need to draw a new topology diagram according to the old database topology diagram and your own understanding, which is a macro way to understand the overall situation of the database. Here is another detail that needs to be paid attention to: pay attention to the association of dblink. Generally, it is easy to sort out through ogg,dg, rac and storage, and dblink is easy to be ignored.

When sorting out the dblink this time, there are the following situations: 1, many edge databases have dblink association with the core production database; 2, there are many invalid dblink in the edge database and the core database (usually only each other's tnsping does not work); 3, the business side is no longer used but can still access the dblink;4, there are a lot of public dblink;5,dblink naming is not easy to distinguish.

2, database capacity, although a database capacity survey will be done every year to see how much data has been increased this year compared with last year, it is also necessary to count the capacity of each database in the early stage of migration. Databases with small database capacity can use (expdp/impdp, exp/imp). The survey found that the capacity of the edge database is less than 200G, and the capacity of the core database is about 500g and 2.5T, so the edge database is migrated from 9i, 10g, 11g to 11g by expdp/impdp and exp/imp, and the core database has to do character set conversion at the beginning, so the migration method has not been determined.

3, the version of the database, what kind of version also determines what kind of migration mode, the edge database has 9i, 10g, 11g and other versions, the core database is 9i. Exp/imp,10g is used for the small capacity migration of edge database 9i to 11g, and expdp/impdp is used for 11g to 11g, followed by which components are installed in each version, such as XDB, XML,XDK, etc., these components migrate to 11g compatibility, in fact, the most important thing in the version survey is to affect the migration mode.

4, database backup, what are the current database backup methods, rman or expdp, backup strategy and backup frequency and so on. After this survey, it is found that some edge databases are not backed up, which feels like a mistake at work. Although it is an unimportant edge database, it is necessary to retain dmp files for about 7 days.

5, database server, the database is hosted on the server, so the database server should also be taken into account. The version of the core database operating system, the current frequency of CPU (number * frequency * core) what is the average usage value of CPU, what is the peak value of CPU, the memory capacity of the operating system, the utilization rate of recent memory, whether there is pageout or pagein exchange, the usage of various directories of the operating system, and whether or not raid protection has been done. At present, edge databases are all windows, some database data are directly stored on the local hard disk, some do raid, some do not do any protection, all rely on backup, all the above backup is very important, especially need to have multiple places to store backup.

6, storage, here is mainly the core database storage, considering the existing data capacity, how much capacity is increased each year, how much capacity is needed for backup (backup storage strategy), how much capacity is required for logs (how many logs are generated each day and how long they are stored)

7. The existing disaster preparedness situation, such as the topology diagram in this http://blog.itpub.net/29609161/viewspace-2677628/ post, mainly uses storage snapshots, dg, ogg and backup. Logs have a separate storage point, which is placed in a netAPP and retained for 60 days. I feel that it is necessary to use a single nas to store archived logs, that is, safe and convenient.

-here's a brief introduction to some big directions.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.