TAILIEUCHUNG - Oracle Database Administration for Microsoft SQL Server DBAs part 32

Oracle Database Administration for Microsoft SQL Server DBAs part 32 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 | 292 Oracle Database Administration for Microsoft SQL Server DBAs Setting Up a Standby Database An existing database can be configured to have a standby database. The first step is to install the Oracle software on the standby server. The database already exists on the primary server. The primary database will need some configuration with standby logs and parameters. Connections to the secondary database can be set up and then using RMAN the initial copy of the database can be set up on the standby server. On the primary database the following needs to be done SQLPLUS alter database force logging Database altered. Create the standby log files. They need to be the same size or larger than the primary database SQLPLUS alter database add standby logfile u01 oracle db01 size 50M Database altered. SQLPLUS alter database add standby logfile u01 oracle db01 size 50M Database altered. Continue creating the log files. One more log group than on the primary is recommended Parameters SQLPLUS show parameter db_name NAME TYPE VALUE db_name string DB01 Name stays the same SQLPLUS show parameter db_unique_name NAME TYPE VALUE db_unique_name string DB01 Standby and Primary will need unique names Names do not change even if roles switch SQLPLUS alter system set LOG_ARCHIVE_CONFIG DG_CONFIG db01 dbstby01 System altered. SQLPLUS alter system set log_archive_dest_2 service dbstby01 async valid_for online_logfile primary_role db_unique_name dbstby01 Chapter 10 High-Availability Architecture 293 System altered. The standby database server should already have the software and the needed directories for the database Create a parameter file for the standby with just the DB_NAME cat DB_NAME dbstby01 export ORACLE_SID dbstby01 SQLPLUS startup nomount pfile ORACLE_HOME dbs ORACLE instance started. . SQLPLUS exit To primary database run RMAN to copy database RMAN connect target connected to target database DB01 DBID 1382128337 RMAN connect

• Chứng chỉ quốc tế
• Học Oracle
• quản lý cơ sở dữ liệu
• luyện thi chứng chỉ quốc tế
• môi trường SQL Server
• cơ sở dữ liệu oracle
• Đề cương môn Chuyên đề Oracle
• Chuyên đề Oracle
• Quản trị cơ sở dữ liệu
• Biện pháp bảo vệ cơ sở dữ liệu
• Cấu trúc lưu trữ
• Tin học thực dụng
• Thực hành ORACLE 11g
• Lý thuyết ORACLE 11g
• Ngôn ngữ lập trình PL SQL
• Lập trình nâng cao với PL SQL
• Thư viện Java
• Topic Focused
• Multi document Summarization
• Approximate Oracle Score
• báo cáo khoa học
• mô hình ngôn ngữ
• xử lý ngôn ngữ tự nhiên