dataguard standby数据库的关闭和启动
各位：standby数据库的关闭和启动命令如下，重启后数据库能继续复制吗？还有dataguard primary 数据库和standby数据库的启动参数如sort_area_size 大小不一致，有没有问题？
Starting Up a Physical Standby Database
Start the database:
SQL> STARTUP NOMOUNT;
Mount the standby database:
SQL> ALTER DATABASE MOUNT STANDBY DATABASE;
Start the managed recovery operation:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
Shutting Down a Physical Standby Database
SQL> SELECT PROCESS, STATUS FROM V$MANAGED_STANDBY;
Cancel managed recovery operations.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
Shut down the standby database.
SQL> SHUTDOWN IMMEDIATE;
[@more@]
Starting Up a Physical Standby Database
Start the database:
SQL> STARTUP NOMOUNT;
Mount the standby database:
SQL> ALTER DATABASE MOUNT STANDBY DATABASE;
Start the managed recovery operation:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
Shutting Down a Physical Standby Database
SQL> SELECT PROCESS, STATUS FROM V$MANAGED_STANDBY;
Cancel managed recovery operations.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
Shut down the standby database.
SQL> SHUTDOWN IMMEDIATE;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10748419/viewspace-995674/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
oracle无法用oracle认证的问题
下一篇：
请教orale高级复制问题！
请登录后发表评论
登录
全部评论
