Oracle dataguard数据库常用操作说明

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:348

本帖最后由 paulyi 于 2014-1-17 23:24 编辑

[font=Wingdings][size=15pt]Oracle dataguard数据库常用操作说明
[font=Wingdings][size=15pt]u [size=15pt]Starting Up a Physical Standby Database
To start up a physical standby database, use SQL*Plus to connect to the databasewith administrator privileges1. Start the database:SQL> STARTUP NOMOUNT;2. Mount the standby database:SQL> ALTER DATABASE MOUNT STANDBY DATABASE;3. Start the managed recovery operation:SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;Once the database is performing managed recovery, log apply services apply thearchived redo logs to the standby database.[font=Wingdings][size=15pt]u [size=15pt]Shutting Down a Physical Standby Database To shut down a physical standby database:1. Find out if the standby database is performing managed recovery. If the MRP0or MRP process exists, then the standby database is performing managedrecovery.SQL> SELECT PROCESS, STATUS FROM V$MANAGED_STANDBY;2. Cancel managed recovery operations.SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;3. Shut down the standby database.SQL> SHUTDOWN IMMEDIATE;[font=Wingdings][size=15pt]u [size=15pt]Opening a Standby Database for Read-Only Access Having a physical standby database open for read-only access makes it unavailable for managed recovery operations.To open a standby database for read-only access when it is currentlyshut down:1. Start the Oracle instance for the standby database without mounting it:SQL> STARTUP NOMOUNT;2. Mount the standby database:SQL> ALTER DATABASE MOUNT STANDBY DATABASE;3. Open the database for read-only access:SQL> ALTER DATABASE OPEN READ ONLY;To open a standby database for read-only access when it is currentlyperforming managed recovery:1. Cancel log apply services:SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;2. Open the database for read-only access:SQL> ALTER DATABASE OPEN READ ONLY;To change the standby database from being open for read-only accessto performing managed recovery:1. Terminate all active user sessions on the standby database.2. Restart log apply services:SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】