add Redo logs/dorp redo logs in Physical Standby
来源:互联网 发布:僵尸变脸软件下载 编辑:程序博客网 时间:2024/05/21 14:47
add Redo logs/dorp redo logs in Physical Standby
1. Add Redologs on Standby
2. Drop Redologs on Standby
Add Redo Logs on Standby
1. Stop Redo apply:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
2. Set STANDBY_FILE_MANAGEMENT to MANUAL.
SQL> ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT='MANUAL';
3. Add Redolog File Group:
SQL> ALTER DATABASE ADD LOGFILE GROUP 4 ('\U01\oracle\stdby10g\redo04.log') SIZE 100M;
Add as many Redo Logfile Groups (or Members) you want to add.
4. Set STANDBY_FILE_MANAGEMENT to AUTO.
SQL> ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT='AUTO';
5. Start Redo Apply (Managed Recovery):
1. Check the Status of the Online Redolog Group.
Even if the online redo logs are not used on a physical standby database, the status within v$log will be updated through the standby control file. They are results of actions on the primary database eg. logswitches.
SQL> SELECT GROUP#, STATUS FROM V$LOG;
GROUP# STATUS
---------- ----------------
1 CLEARING_CURRENT
3 CLEARING
2 CLEARING
If Status is CLEARING_CURRENT or CURRENT then you cannot drop Online Redolog Group, please use "Sync Redo Logs on Primary and Standby" Section in this Case. You will get ORA-01623 if you try to drop a Redolog Group with Status CLEARING_CURRENT or CURRENT.
You can also change this status by doing a ALTER SYSTEM SWITCH LOGFILE; on primary.
For Status CLEARING, UNUSED, INACTIVE please follow below steps.
2. Stop Redo Apply:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
3. Set STANDBY_FILE_MANAGEMENT to MANUAL.
SQL> ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT='MANUAL';
4. Clear the Online Redo Logfile Group:
SQL> ALTER DATABASE CLEAR LOGFILE GROUP 2;
5. Drop the Online Redo Logfile Group:
SQL>ALTER DATABASE DROP LOGFILE GROUP 2;
If you have skipped Step 4 then you will get ORA-01624 while droping the Online Redolog Group with Status CLEARING.
6. Set STANDBY_FILE_MANAGEMENT to AUTO.
SQL> ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT='AUTO';
7. Start Redo Apply:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
1. Add Redologs on Standby
2. Drop Redologs on Standby
Add Redo Logs on Standby
1. Stop Redo apply:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
2. Set STANDBY_FILE_MANAGEMENT to MANUAL.
SQL> ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT='MANUAL';
3. Add Redolog File Group:
SQL> ALTER DATABASE ADD LOGFILE GROUP 4 ('\U01\oracle\stdby10g\redo04.log') SIZE 100M;
Add as many Redo Logfile Groups (or Members) you want to add.
4. Set STANDBY_FILE_MANAGEMENT to AUTO.
SQL> ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT='AUTO';
5. Start Redo Apply (Managed Recovery):
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
1. Check the Status of the Online Redolog Group.
Even if the online redo logs are not used on a physical standby database, the status within v$log will be updated through the standby control file. They are results of actions on the primary database eg. logswitches.
SQL> SELECT GROUP#, STATUS FROM V$LOG;
GROUP# STATUS
---------- ----------------
1 CLEARING_CURRENT
3 CLEARING
2 CLEARING
If Status is CLEARING_CURRENT or CURRENT then you cannot drop Online Redolog Group, please use "Sync Redo Logs on Primary and Standby" Section in this Case. You will get ORA-01623 if you try to drop a Redolog Group with Status CLEARING_CURRENT or CURRENT.
You can also change this status by doing a ALTER SYSTEM SWITCH LOGFILE; on primary.
For Status CLEARING, UNUSED, INACTIVE please follow below steps.
2. Stop Redo Apply:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
3. Set STANDBY_FILE_MANAGEMENT to MANUAL.
SQL> ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT='MANUAL';
4. Clear the Online Redo Logfile Group:
SQL> ALTER DATABASE CLEAR LOGFILE GROUP 2;
5. Drop the Online Redo Logfile Group:
SQL>ALTER DATABASE DROP LOGFILE GROUP 2;
If you have skipped Step 4 then you will get ORA-01624 while droping the Online Redolog Group with Status CLEARING.
6. Set STANDBY_FILE_MANAGEMENT to AUTO.
SQL> ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT='AUTO';
7. Start Redo Apply:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
0 0
- add Redo logs/dorp redo logs in Physical Standby
- data guard中的Online Redo Logs, Archived Redo Logs, and Standby Redo Logs
- Managing Archived Redo Logs
- 调整Redo Logs大小
- How to Add/Drop/Resize Redo Log with Physical Standby in place. [ID 473442.1]
- How to Add/Drop/Resize Redo Log with Physical Standby in place. [ID 473442.1]
- 调整Online Redo Logs大小(Resizing Oracle Online Redo Logs)
- 【翻译自mos文章】Standby Redo Logs (SRL)的用途,益处与限制
- ORA-19527: physical standby redo log must be renamed
- 理解standby redo log
- 配置standby redo log
- logs
- Performing User-Managed Database-18.4、Restoring Datafiles and Archived Redo Logs
- Improve Database Performance: Redo and Transaction Logs on Solid State Disks (SSDs)
- Oracle DG Standby Redo Log
- DataGuard standby redo log 管理
- redo
- redo
- POJ 1472
- cxf webservice + srping 整合 + 限制IP地址 + properties配置文件
- magento get sql profile
- 华尔街日报确认苹果将在9月9日发布新版iPhone
- 二叉树的后续遍历序列
- add Redo logs/dorp redo logs in Physical Standby
- cocos2d 3.2 生成Android项目文件问题 Invalid APP_STL value: c++_static
- 使用GIT进行源码管理——GIT托管服务
- 【转】Android BLE开发之Android手机与BLE终端通信
- delphi 中access数据库实现多库连接查询
- 最短路SPFA+DP+uva10917
- sgu112 高精度(用java水啊水)
- 用集算器解多元一次方程组
- 做程序猿的老婆应该注意的一些事情