Flashback Oracle Rac Database with Dataguard

Srinivasulu M Srinivasulu M

Srinivasulu M

Oracle Database / Exadata Administrator / Oracle cloud administrator

发布日期: 2022年1月16日
+ 关注

*****************??Creating?Restore Point*****************

1)?Stop Redo Transport and Redo Apply?

A)?When we Dont have Broker Configuration??

alter system set log_archive_dest_state_n='defer'?sid='*' ;??( On primary )?

alter database recover managed standby database cancel?;??( On Standby )?

B)?When we chave Broker Configuration??

edit database Chicago?set state='TRANSPORT-OFF';?

EDIT database Boston?set state='apply-off' ;?

2) Create Restore?Point (in Standby First??)?

create?restore point GRP_DG GUARANTEE FLASHBACK DATABASE ;??( On Standby )?

create?restore point GRP_PR?GUARANTEE FLASHBACK DATABASE ;??( On Primary )?

?3) Enable Log Transport and Apply?

?A) When we Dont have Broker Configuration??

alter system set log_archive_dest_state_n='enable'?sid='*' ;??( On primary )?

alter database recover managed standby databsae?using current logfile?disconnect ;?( on?Standby )?

?B)?When we chave Broker Configuration?

edit database Chicago?set state='TRANSPORT-On';?

EDIT database Boston?set state='apply-on' ;?

?*****************?Flashback Database?*****************

?1)?Stop Redo Transport and Redo Apply?

?A)?When we Dont have Broker Configuration??

alter system set log_archive_dest_state_n='defer'?sid='*'?;??( On primary )?

alter database recover managed standby database cancel?;??( On Standby )?

?B)?When we chave Broker Configuration??

edit database Chicago?set state='TRANSPORT-OFF';?

EDIT database Boston?set state='apply-off' ;?

?2) Flashbackup?Primary Database to restore Point?

?srvctl stop database -d DB_NAME?

srvctl start instance -d DB_NAME -i instance_name -o mount?

flashback database to restore point GRP_PR ;?

alter database open resetlogs ;?

srvctl stop instance -d DB_NAME -i instance_name??

srvctl start database -d DB_NAME?

?2) Flashbackup?Satndby Database to restore Point?

领英推荐

?srvctl stop database -db?DB_NAME -stopoption immediate?

srvctl start instance -d DB_NAME -i instance_name -o mount?

flashback database to restore point GRP_DG ;?

srvctl stop instance -db DB_NAME -i instance_name??

srvctl start database -db DB_NAME -startoption?mount?

?3) Enable Log Transport and Apply?

?A) When we Dont have Broker Configuration??

alter system set log_archive_dest_state_n='enable'?SID='*';??( On primary )?

alter database recover managed standby databsae?using current logfile?disconnect ;?( on?Standby )?

?B)?When we chave Broker Configuration?

edit database Chicago?set state='TRANSPORT-On';?

EDIT database Boston?set state='apply-on' ;?

?4)?Restart standby database on?Database pass through?resetlogs?and there is no lag?

*****************Drop Restore Point?*****************

?1)?Stop Redo Transport and Redo Apply?

?A)?When we Dont have Broker Configuration??

alter system set log_archive_dest_state_n='defer'?SID='*';??( On primary )?

alter database recover managed standby database cancel?;??( On Standby )?

?B)?When we chave Broker Configuration??

edit database Chicago?set state='TRANSPORT-OFF';?

EDIT database Boston?set state='apply-off' ;?

?2) Drop Restore?Point??

Drop?restore point GRP_PR?;??( On Primary )?

DROP?restore point GRP_dg??;??( On Standby )?

?3) Enable Log Transport and Apply?

A) When we Dont have Broker Configuration??

alter system set log_archive_dest_state_n='enable'?SID='*';??( On primary )?

alter database recover managed standby databsae?using current logfile?disconnect ;?( on?Standby )?

?B)?When we chave Broker Configuration?

edit database Chicago?set state='TRANSPORT-On';?

EDIT database Boston?set state='apply-on' ;?

?***************** Reference??*****************

Metalink Doc??2338328.1

要查看或添加评论，请登录

Srinivasulu M的更多文章

社区洞察

其他会员也浏览了