tailieunhanh - Oracle Database Administration for Microsoft SQL Server DBAs part 4

Oracle Database Administration for Microsoft SQL Server DBAs part 4 takes the administration topics with which the SQL Server DBA is familiar, translates them into Oracle terms, and then expands on Oracle functionality. Definitions and comparative terms run throughout the book so the SQL Server DBA can easily leverage existing knowledge. This Oracle Press guide also expands on some of the features in Oracle that do not match up directly with SQL Server, and looks at other processes often performed on an Oracle database that would not typically be a standard practice in SQL Server environments | 12 Oracle Database Administration for Microsoft SQL Server DBAs Here s a checklist of common migration tasks Gather information about the source database including size running jobs objects and strange datatypes. Create an Oracle database for the target. Convert the object structures to Oracle using the Migration Wizard in Oracle SQL Developer. Validate indexes triggers and stored procedures. Validate permissions to make sure that the new users in Oracle have access to the objects and system privileges they need. Move the data over. You can use the Migration Wizard in Oracle SQL Developer or the bcp utility and SQL Loader or an SSIS package in SQL Server. Run update statistics on the Oracle tables. Review the indexes and referential integrity. Recompile all of the objects and make sure there are no invalid objects. Validate the data and application. Following a plan for testing pieces of the application would be the best route here. It might be a test plan that was used for a previous upgrade or a new one but you need a way to confirm that the results in the application are as expected. Look for performance issues. Look for areas that might benefit from changing to an Oracle feature. Adjust any of the stored procedures and indexes. Schedule jobs in DBMS_SCHEDULER. Run maintenance jobs against the Oracle database to perform backups and update statistics. Run through the test plan again. Chapter 1 The Database Administrator 13 These steps would be executed first in a development environment to work through any issues and make a couple of these adjustment steps. In production you could just make the changes to any of the stored procedures or indexes. Of course validation of performance as well as the application in production is highly recommended. The tools are useful for making this a more consistent process. You ll need to know more about Oracle to work through the rest of the conversion such as to develop the scheduled jobs Chapter 7 and validate indexes Chapter 8