tailieunhanh - Creating a Physical Standby Database by Using SQL

Các bước để tạo một cơ sở dữ liệu vật lý chờ 1. Chuẩn bị cơ sở dữ liệu chính. 2. Sao lưu cơ sở dữ liệu chính. 3. Sao chép tập tin hệ thống dự phòng. 4. Thiết lập các thông số trên cơ sở dữ liệu dự phòng vật lý. 5. Bắt đầu các cơ sở dữ liệu dự phòng. 6. Cấu hình Oracle Dịch vụ Net. 7. Thiết lập các thông số trên cơ sở dữ liệu chính. 8. Bắt đầu vận chuyển làm lại. | Creating a Physical Standby Database by Using SQL Oracle Database 10g: Data Guard Administration 5 - Objectives After completing this lesson, you should be able to use SQL commands to create a physical standby database. Oracle Database 10g: Data Guard Administration 5 - Steps to Create a Physical Standby Database Prepare the primary database. Back up the primary database. Copy files to the standby system. Set parameters on the physical standby database. Start the standby database. Configure Oracle Net Services. Set parameters on the primary database. Start the transport of redo. Steps to Create a Physical Standby Database Perform the following steps to create a physical standby database by using SQL commands: 1. Prepare the primary database. 2. Back up the primary database. 3. Copy files to the standby system. 4. Set parameters on the physical standby database. 5. Start the standby database. 6. Configure Oracle Net Services. 7. Set parameters on the primary database. 8. Start | Creating a Physical Standby Database by Using SQL Oracle Database 10g: Data Guard Administration 5 - Objectives After completing this lesson, you should be able to use SQL commands to create a physical standby database. Oracle Database 10g: Data Guard Administration 5 - Steps to Create a Physical Standby Database Prepare the primary database. Back up the primary database. Copy files to the standby system. Set parameters on the physical standby database. Start the standby database. Configure Oracle Net Services. Set parameters on the primary database. Start the transport of redo. Steps to Create a Physical Standby Database Perform the following steps to create a physical standby database by using SQL commands: 1. Prepare the primary database. 2. Back up the primary database. 3. Copy files to the standby system. 4. Set parameters on the physical standby database. 5. Start the standby database. 6. Configure Oracle Net Services. 7. Set parameters on the primary database. 8. Start the transport of redo. Oracle Database 10g: Data Guard Administration 5 - Preparing the Primary Database Enable FORCE LOGGING at the database level. Create a password file. Set initialization parameters. Enable archiving. SQL> ALTER DATABASE FORCE LOGGING; SQL> SHUTDOWN IMMEDIATE; SQL> STARTUP MOUNT; SQL> ALTER DATABASE ARCHIVELOG; SQL> ALTER DATABASE OPEN; Preparing the Primary Database The FORCE LOGGING mode determines whether or not the Oracle database server logs all changes in the database, except for changes to temporary tablespaces and temporary segments. The FORCE_LOGGING column in V$DATABASE contains a value of YES if the database is in FORCE LOGGING mode. Every database in a Data Guard configuration must use a password file, and the password for the SYS user must be identical on every system for redo data transmission to succeed. For details about creating a password file, see Oracle Database Administrator’s Guide. On the primary database, you define initialization .