Oracle-通过(RECOVER STANDBY DATABASE FROM SERVICE)方式修复DataGuard

于 2022-11-01 22:45:40 发布
阅读量1.4k 收藏 3
点赞数 1
分类专栏： Oracle 文章标签： 数据库 oracle sql 运维 dba
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/sinat_36757755/article/details/127643023
版权

前言:

Oracle在18c对(RESTORE/RECOVER ...FROM SERVICE)功能进行了加强，推出了(RECOVER STANDBY DATABASE ... FROM SERVICE)通过网络服务直接增量恢复备库数据,这个新特性也大大简化了DataGuard主备的问题修复。

修复主备gap

1 当前备库缺失47-55个归档,并且没有归档日志备

SQL> select open_mode,database_role from v$database;
​
OPEN_MODE       DATABASE_ROLE
-------------------- ----------------
READ ONLY WITH APPLY PHYSICAL STANDBY
​
SQL> select  * from v$archive_gap;
​
   THREAD# LOW_SEQUENCE# HIGH_SEQUENCE#     CON_ID
---------- ------------- -------------- ----------
   1        47       55    1
​
SQL>

2 关闭mrp进程

alter database recover managed standby database cancel;
​
---注意在数据库open的时候，要把mrp进程关闭，否则会出现以下错误
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/01/2022 17:35:51
RMAN-05150: Managed Recovery Process must be disabled before running RECOVER STANDBY DATABASE.

3 通过from service 进行recover的方式恢复

rman target sys/oracle
run
{
allocate channel c1 type disk connect '/@testdg';
allocate channel c2 type disk connect '/@testdg';
allocate channel c3 type disk connect '/@testdg';
allocate channel c4 type disk connect '/@testdg';
recover standby database from service 'testdb' ;
}
​

4 恢复的步骤

1 终止并重新启动实例到mount
License high water mark = 12
2022-11-01T17:38:11.813430+08:00
USER(prelim) (ospid: 24653): terminating the instance
2022-11-01T17:38:12.826936+08:00
Instance terminated by USER(prelim), pid = 24653
2022-11-01T17:38:16.129260+08:00
Starting ORACLE instance (normal) (OS id: 24658)
2022-11-01T17:38:16.138029+08:00
2 set standby_file_management=manual
3 重新从主库恢复新的standby control
4 切换控制文件路径到实际路径
5 进行增量recover恢复
6 set standby_file_management=auto

5 恢复日志

using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=34 device type=DISK
​
allocated channel: c2
channel c2: SID=270 device type=DISK
​
allocated channel: c3
channel c3: SID=35 device type=DISK
​
allocated channel: c4
channel c4: SID=266 device type=DISK
​
Starting recover at 2022/11/01 17:38:10
Oracle instance started
​
Total System Global Area    1543500144 bytes
​
Fixed Size                     8896880 bytes
Variable Size                889192448 bytes
Database Buffers             637534208 bytes
Redo Buffers                   7876608 bytes
​
contents of Memory Script:
{
   restore standby controlfile from service  'testdb';
   alter database mount standby database;
}
executing Memory Script
​
Starting restore at 2022/11/01 17:38:23
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=253 device type=DISK
​
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: using network backup set from service testdb
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/u01/app/oracle/oradata/TESTDG/controlfile/control01.ctl
Finished restore at 2022/11/01 17:38:26
​
released channel: ORA_DISK_1
Statement processed
Executing: alter system set standby_file_management=manual
​
contents of Memory Script:
{
set newname for tempfile  1 to 
 "/u01/app/oracle/oradata/TESTDG/datafile/o1_mf_temp_kp1q02wb_.tmp";
   switch tempfile all;
set newname for datafile  1 to 
 "/u01/app/oracle/oradata/TESTDG/datafile/o1_mf_system_kp1phykz_.dbf";
set newname for datafile  3 to 
 "/u01/app/oracle/oradata/TESTDG/datafile/o1_mf_sysaux_kp1phyo1_.dbf";
set newname for datafile  4 to 
 "/u01/app/oracle/oradata/TESTDG/datafile/o1_mf_undotbs1_kp1phyt2_.dbf";
set newname for datafile  7 to 
 "/u01/app/oracle/oradata/TESTDG/datafile/o1_mf_users_kp1phz14_.dbf";
   catalog datafilecopy  "/u01/app/oracle/oradata/TESTDG/datafile/o1_mf_system_kp1phykz_.dbf", 
 "/u01/app/oracle/oradata/TESTDG/datafile/o1_mf_sysaux_kp1phyo1_.dbf", 
 "/u01/app/oracle/oradata/TESTDG/datafile/o1_mf_undotbs1_kp1phyt2_.dbf", 
 "/u01/app/oracle/oradata/TESTDG/datafile/o1_mf_users_kp1phz14_.dbf";
   switch datafile all;
}
executing Memory Script
​
executing command: SET NEWNAME
​
renamed tempfile 1 to /u01/app/oracle/oradata/TESTDG/datafile/o1_mf_temp_kp1q02wb_.tmp in control file
​
executing command: SET NEWNAME
​
executing command: SET NEWNAME
​
executing command: SET NEWNAME
​
executing command: SET NEWNAME
​
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/TESTDG/datafile/o1_mf_system_kp1phykz_.dbf RECID=1 STAMP=1119634711
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/TESTDG/datafile/o1_mf_sysaux_kp1phyo1_.dbf RECID=2 STAMP=1119634711
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/TESTDG/datafile/o1_mf_undotbs1_kp1phyt2_.dbf RECID=3 STAMP=1119634711
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/TESTDG/datafile/o1_mf_users_kp1phz14_.dbf RECID=4 STAMP=1119634711
​
datafile 1 switched to datafile copy
input datafile copy RECID=1 STAMP=1119634711 file name=/u01/app/oracle/oradata/TESTDG/datafile/o1_mf_system_kp1phykz_.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=1119634711 file name=/u01/app/oracle/oradata/TESTDG/datafile/o1_mf_sysaux_kp1phyo1_.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=1119634711 file name=/u01/app/oracle/oradata/TESTDG/datafile/o1_mf_undotbs1_kp1phyt2_.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=4 STAMP=1119634711 file name=/u01/app/oracle/oradata/TESTDG/datafile/o1_mf_users_kp1phz14_.dbf
​
contents of Memory Script:
{
  recover database from service  'testdb';
}
executing Memory Script
​
Starting recover at 2022/11/01 17:38:31
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=260 device type=DISK
RMAN-06900: warning: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row
RMAN-06901: warning: disabling update of the V$RMAN_STATUS and V$RMAN_OUTPUT rows
Oracle error from target database: 
ORA-19922: there is no parent row with id 0 and level 2
​
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service testdb
destination for restore of datafile 00001: /u01/app/oracle/oradata/TESTDG/datafile/o1_mf_system_kp1phykz_.dbf
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service testdb
destination for restore of datafile 00003: /u01/app/oracle/oradata/TESTDG/datafile/o1_mf_sysaux_kp1phyo1_.dbf
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service testdb
destination for restore of datafile 00004: /u01/app/oracle/oradata/TESTDG/datafile/o1_mf_undotbs1_kp1phyt2_.dbf
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service testdb
destination for restore of datafile 00007: /u01/app/oracle/oradata/TESTDG/datafile/o1_mf_users_kp1phz14_.dbf
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
​
starting media recovery
​
media recovery complete, elapsed time: 00:00:00
Finished recover at 2022/11/01 17:38:39
Executing: alter system set standby_file_management=auto
Finished recover at 2022/11/01 17:38:39

6 重建standby log

---因为standby log的路径是主库的，可能跟实际的不一致
select 'alter database drop standby logfile group '||group#||';'
from v$standby_log;
​
alter database ADD standby logfile thread 1 group 21 ('/u01/app/oracle/oradata/TESTDG/onlinelog/redo01.log') size 200M ;
alter database ADD standby logfile thread 1 group 22 ('/u01/app/oracle/oradata/TESTDG/onlinelog/redo02.log') size 200M ; 
alter database ADD standby logfile thread 1 group 23 ('/u01/app/oracle/oradata/TESTDG/onlinelog/redo03.log') size 200M ; 
alter database ADD standby logfile thread 1 group 24 ('/u01/app/oracle/oradata/TESTDG/onlinelog/redo04.log') size 200M ;

7 启动数据库恢复同步

alter database open read ONLY;
alter database recover managed standby database using current logfile disconnect from session;

修复备库数据文件坏块问题

1 备库有时会遇到由于主库没有设置force logging导致的坏块问题

Errors in file /u01/app/oracle/diag/rdbms/testdg/testdg/trace/testdg_ora_4978.trc  (incident=10025):
ORA-01578: ORACLE data block corrupted (file # 5, block # 368)
ORA-01110: data file 5: '/u01/app/oracle/oradata/TESTDG/datafile/o1_mf_tbs_test_kp27r5t8_.dbf'
ORA-26040: Data block was loaded using the NOLOGGING option
Incident details in: /u01/app/oracle/diag/rdbms/testdg/testdg/incident/incdir_10025/testdg_ora_4978_i10025.trc

2 关闭mrp进程

alter database recover managed standby database cancel;

3 将坏块问题文件手动转移到其他位置存放

mv /u01/app/oracle/oradata/TESTDG/datafile/o1_mf_tbs_test_kp27r5t8_.dbf /tmp/

4 通过from service 进行recover

rman target sys/oracle
run
{
allocate channel c1 type disk connect '/@testdg';
allocate channel c2 type disk connect '/@testdg';
allocate channel c3 type disk connect '/@testdg';
allocate channel c4 type disk connect '/@testdg';
recover standby database from service 'testdb' ;
}

5 恢复过程跟之前修改gap步骤完全一样，不需要人为的去干预

6 恢复日志

allocated channel: c1
channel c1: SID=25 device type=DISK
​
allocated channel: c2
channel c2: SID=261 device type=DISK
​
allocated channel: c3
channel c3: SID=26 device type=DISK
​
allocated channel: c4
channel c4: SID=262 device type=DISK
​
Starting recover at 2022/11/01 21:44:38
Oracle instance started
​
Total System Global Area    1543500144 bytes
​
Fixed Size                     8896880 bytes
Variable Size                889192448 bytes
Database Buffers             637534208 bytes
Redo Buffers                   7876608 bytes
​
contents of Memory Script:
{
   restore standby controlfile from service  'testdb';
   alter database mount standby database;
}
executing Memory Script
​
Starting restore at 2022/11/01 21:44:51
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=253 device type=DISK
​
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: using network backup set from service testdb
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/u01/app/oracle/oradata/TESTDG/controlfile/control01.ctl
Finished restore at 2022/11/01 21:44:54
​
released channel: ORA_DISK_1
Statement processed
Executing: alter system set standby_file_management=manual
​
contents of Memory Script:
{
set newname for tempfile  1 to 
 "/u01/app/oracle/oradata/TESTDG/datafile/o1_mf_temp_kp1q02wb_.tmp";
   switch tempfile all;
set newname for datafile  1 to 
 "/u01/app/oracle/oradata/TESTDG/datafile/o1_mf_system_kp1phykz_.dbf";
set newname for datafile  3 to 
 "/u01/app/oracle/oradata/TESTDG/datafile/o1_mf_sysaux_kp1phyo1_.dbf";
set newname for datafile  4 to 
 "/u01/app/oracle/oradata/TESTDG/datafile/o1_mf_undotbs1_kp1phyt2_.dbf";
set newname for datafile  5 to new;
set newname for datafile  7 to 
 "/u01/app/oracle/oradata/TESTDG/datafile/o1_mf_users_kp1phz14_.dbf";
   restore from service  'testdb' datafile
    5;
   catalog datafilecopy  "/u01/app/oracle/oradata/TESTDG/datafile/o1_mf_system_kp1phykz_.dbf", 
 "/u01/app/oracle/oradata/TESTDG/datafile/o1_mf_sysaux_kp1phyo1_.dbf", 
 "/u01/app/oracle/oradata/TESTDG/datafile/o1_mf_undotbs1_kp1phyt2_.dbf", 
 "/u01/app/oracle/oradata/TESTDG/datafile/o1_mf_users_kp1phz14_.dbf";
   switch datafile all;
}
executing Memory Script
​
executing command: SET NEWNAME
​
renamed tempfile 1 to /u01/app/oracle/oradata/TESTDG/datafile/o1_mf_temp_kp1q02wb_.tmp in control file
​
executing command: SET NEWNAME
​
executing command: SET NEWNAME
​
executing command: SET NEWNAME
​
executing command: SET NEWNAME
​
executing command: SET NEWNAME
​
Starting restore at 2022/11/01 21:44:59
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=260 device type=DISK
​
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: using network backup set from service testdb
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/TESTDG/datafile/o1_mf_tbs_test_%u_.dbf
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 2022/11/01 21:45:01
​
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/TESTDG/datafile/o1_mf_system_kp1phykz_.dbf RECID=2 STAMP=1119649501
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/TESTDG/datafile/o1_mf_sysaux_kp1phyo1_.dbf RECID=3 STAMP=1119649501
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/TESTDG/datafile/o1_mf_undotbs1_kp1phyt2_.dbf RECID=4 STAMP=1119649501
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/TESTDG/datafile/o1_mf_users_kp1phz14_.dbf RECID=5 STAMP=1119649501
​
datafile 5 switched to datafile copy
input datafile copy RECID=1 STAMP=1119649500 file name=/u01/app/oracle/oradata/TESTDG/datafile/o1_mf_tbs_test_kp28pw2t_.dbf
datafile 1 switched to datafile copy
input datafile copy RECID=2 STAMP=1119649501 file name=/u01/app/oracle/oradata/TESTDG/datafile/o1_mf_system_kp1phykz_.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=3 STAMP=1119649501 file name=/u01/app/oracle/oradata/TESTDG/datafile/o1_mf_sysaux_kp1phyo1_.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=4 STAMP=1119649501 file name=/u01/app/oracle/oradata/TESTDG/datafile/o1_mf_undotbs1_kp1phyt2_.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=5 STAMP=1119649501 file name=/u01/app/oracle/oradata/TESTDG/datafile/o1_mf_users_kp1phz14_.dbf
​
contents of Memory Script:
{
  recover database from service  'testdb';
}
executing Memory Script
​
Starting recover at 2022/11/01 21:45:01
using channel ORA_DISK_1
skipping datafile 5; already restored to SCN 2174252
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service testdb
destination for restore of datafile 00001: /u01/app/oracle/oradata/TESTDG/datafile/o1_mf_system_kp1phykz_.dbf
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service testdb
destination for restore of datafile 00003: /u01/app/oracle/oradata/TESTDG/datafile/o1_mf_sysaux_kp1phyo1_.dbf
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service testdb
destination for restore of datafile 00004: /u01/app/oracle/oradata/TESTDG/datafile/o1_mf_undotbs1_kp1phyt2_.dbf
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service testdb
destination for restore of datafile 00007: /u01/app/oracle/oradata/TESTDG/datafile/o1_mf_users_kp1phz14_.dbf
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
​
starting media recovery
​
media recovery complete, elapsed time: 00:00:00
Finished recover at 2022/11/01 21:45:08
Executing: alter system set standby_file_management=auto
Finished recover at 2022/11/01 21:45:08
​
RMAN> exit

7 重建standby log

---因为standby log的路径是主库的，可能跟实际的不一致
select 'alter database drop standby logfile group '||group#||';'
from v$standby_log;
​
alter database ADD standby logfile thread 1 group 21 ('/u01/app/oracle/oradata/TESTDG/onlinelog/redo01.log') size 200M ;
alter database ADD standby logfile thread 1 group 22 ('/u01/app/oracle/oradata/TESTDG/onlinelog/redo02.log') size 200M ; 
alter database ADD standby logfile thread 1 group 23 ('/u01/app/oracle/oradata/TESTDG/onlinelog/redo03.log') size 200M ; 
alter database ADD standby logfile thread 1 group 24 ('/u01/app/oracle/oradata/TESTDG/onlinelog/redo04.log') size 200M ;

8 启动数据库恢复同步

alter database open read ONLY;
alter database recover managed standby database using current logfile disconnect from session;

总结:

        通过(RECOVER STANDBY DATABASE ... FROM SERVICE)方式对备库问题进行修复，可以大大简化了备库问题的修复步骤以及时间。

牛牛的笔记
关注
  • 1
    点赞
  • 踩
  • 3
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
oracle recover database,standby库，在sqlplus下用recover standby database进行手工恢复
weixin_36371906的博客
04-05 925
一个standby库出问题，丢了1个归档检查主库的日志，发现丢失的归档的SEQ的redo还未被覆盖，马上将其拷贝出来传递到备库上尝试catalog，虽然没有报错，但是实际没有注册成功RMAN> catalog archivelog '/u01/app/oracle/oradata/ORCL/redo03_281.arc';cataloged archived logarchived log ...
ORACLE 使用rman备份通过restore、recover恢复standby库ORA-10877实战
csdn's blog
08-02 1万+
1、备库standby异常报错 昨天凌晨磁盘空间突然暴涨导致oracle备库异常，报警，后了过来清理掉磁盘的备份文件，去了之后，归档日志能同步过来了，但是启动备库standby发现mrp没有启动，后台报错如下，google了，说这种情况要重新再做备库（不知道是否还有其它修复办法呢？）：错误日志报错信息如下： Completed: alter database recover managed ...
Recover standby database manually
Enhancing Your Oracle Capability
09-18 1011
ORACLE_DATAGUARD_Recover standby database manually Check the standby status: SQL>select open_mode from v$database; SQL>select sequence#,applied from v$archived_log order by sequence#; SQL>SELECT T
【12c】12c RMAN新特性之通过网络远程恢复数据库（RESTORE/Recover from Service）
weixin_34238633的博客
07-13 243
  【12c】12c RMAN新特性之通过网络远程恢复数据库（RESTORE/Recover from Service）     通过网络远程恢复数据库（Restore/Recover from Service） 在Oracle 12c中，可以在主数据库和备用数据库之间用一个服务名重新获得或...
standby库，在sqlplus下用recover standby database进行手工恢复
cti27515的博客
02-25 458
一个standby库出问题，丢了1个归档 检查主库的日志，发现丢失的归档的SEQ的redo还未被覆盖，马上将其拷贝出来传递到备库上 尝试catalog，虽然没有报错，但是实际没有注册成功 RMAN> catalo...
Recover standby database after primary resetlogs
weixin_34245749的博客
12-03 115
一般在主库需要恢复并open resetlogs 方式打开的情况下，备库需要重做来构建主备同步架构，但有些情况其实不必大费周章，只需要备库开启flashback功能，就可以在较短的时间内恢复主备同步进程。 （一）在当主库resetlogs 之后，查询当时的RESETLOGS_CHANGE#（SCN），若小于备库SCN ，可以通过闪回备库到RESETLOG...
Oracle DataGuard物理Standby Database配置
05-09
Oracle DataGuard物理Standby Database配置是一项关键任务，用于创建一个实时同步的备份数据库，以确保在主数据库出现故障时能够迅速切换，保障业务连续性。以下是配置物理Standby Database的详细步骤： 1. **启用...
ORACLE-11G-搭建DATAGUARD步骤.docx
11-28
- **配置最大可用模式**：通过`ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE AVAILABILITY`命令，确保备用数据库能及时同步到主数据库的更改。 - **备份数据库**：使用RMAN（Recovery Manager）执行全库备份...
ORACLE-11G-搭建DATAGUARD步骤.pdf
11-17
Oracle 11g 数据守护（Data Guard）是一种高可用性和灾难恢复解决方案，它通过在多个位置维护数据库的副本来保护数据免受意外损失或系统故障的影响。以下是如何在Oracle 11g中搭建Data Guard的详细步骤： 1. **安装...
oracle 11g RAC<-->单机 高可用dataguard 主备正确切换步骤
12-07
SQL> alter database recover managed standby database using current logfile disconnect from session; 这条命令将使得主备库之间的数据重新同步。 五、重新同步 在重新同步后，需要检查备机的状态确保其状态...
Oracle11G DataGuard相同SID物理Standby搭建手册
10-30
- **配置逻辑切换**：通过`ALTER DATABASE RECOVER MANAGED STANDBY DATABASE`命令开始同步进程，启用Logical Standby Redo Apply。 4. **redo日志传输** - **Physical Standby的redo应用**：通过Fast ...
oracle 11G dataguard 恢复
weixin_33812433的博客
11-29 98
检查主备机的sys 密码是否一致，忘记密码可以修改，同步 。alter user sys identified by xxx； orapwd file=oraxxx.ora password=admin entries=40force=y; 检查静态tnsnames.ora 和listener.ora ，确保正常测试：sqlplus sys/oracle@COMSTAR2 as sysdb...
oracle11g dataguard undo恢复
冰刀(skate)
10-15 2955
author：skate time：2012/10/15   oracle11g dataguard undo恢复   环境： os：centos5.5 db：oracle11g datauard version：11.2.0.2.0   在primary收缩数据文件大小 ALTER DATABASE   DATAFILE '/oracle/oradata/skatedb
通过RMAN备份standby database成功恢复还原
cuilingqiao0657的博客
05-08 898
前言：为了提升系统安全，通常会在primary DB+standbyDB之外再做一份备份。但直接对primary DB备份可能会带来性能问题，所以决定在standby DB(open_mode:READ ONLY WITH A...
alter database recover managed standby database 语句
文档搬运工
02-17 3277
RDBMS 11.2.0.4 参考文档： ALTER DATABASE (oracle.com) 语法格式如下： 一种用法： alter database recover managed standby database until change 123456 disconnect from session; 官方的解释： STANDBY DATABASESpecify theSTANDBYDATABASEclause to manually recover a physic...
oracle 不完整恢复,Oracle——不完全恢复
weixin_36057741的博客
04-06 1423
不完全恢复分为用户不完全恢复和RMAN不完全恢复。若联机重做日志文件或者归档日志文件有丢失，则只能进行不完全恢复。一．不完全恢复的分类1.timerecover选项，指定恢复到某个时间点，常用。2.cancelrecover选项，停止在某个日志切换序列号处，通常只在归档日志文件受损或丢失的情况下使用，从而无法进一步恢复。3.change-baserecover选项，指定到某个SCN号。4.在...
如何用Restore DataBase把数据库还原到指定的路？
热门推荐
u012732371的专栏
12-20 1万+
 restore database 数据库名 from disk='备份文件路径' with move '数据库文件名' to '数据库文件放置路径', move '日志文件名' to '日志文件存放置路径' go 如： restore database EaseWe from disk='H:\EaseWe.bak' with move 'EaseWe' to
oracle 19c adg GAP恢复
fanzhuozhuo的博客
01-30 3057
oracle 19c adg GAP恢复故障现象故障分析GAP恢复总结参考 继上篇文章，回退成功后。发现我们在回退的过程中，为了不影响备库，把log_archive_dest_state_2设置为了defer。但是后面想想，已经来不及了，因为主库刷新数据字典的过程中，已经会把字典的变化同步到了备库。我们设置defer的时间迟了，应该在刷新数据字典之前，就把log_archive_dest_state_2设置为defer，让备库不会应用数据字典的变化。如果此时发生切换，switchover肯定不行，failo
recover standby database from service
最新发布
05-24
To recover a standby database from a service, you can follow the below steps: 1. Connect to the primary database using SQL*Plus or any other database client tool. 2. Check the status of the standby database using the following command: ``` SELECT NAME, DB_UNIQUE_NAME, DATABASE_ROLE, OPEN_MODE FROM V$DATABASE; ``` This command will display the name, unique name, database role, and open mode of the primary and standby databases. 3. If the standby database is not in sync with the primary database, you need to perform a switchover to make it the primary database. 4. Once the standby database is in sync with the primary database, you can start the recovery process by executing the following command: ``` RECOVER DATABASE USING SERVICE '<service_name>'; ``` This command will initiate the recovery process on the standby database using the specified service name. 5. Monitor the progress of the recovery process using the following command: ``` SELECT PROCESS, SEQUENCE#, BLOCK#, STATUS FROM V$MANAGED_STANDBY; ``` This command will display the current status of the recovery process. 6. Once the recovery process is complete, you can open the standby database in read-only mode using the following command: ``` ALTER DATABASE OPEN READ ONLY; ``` This command will allow you to access the standby database in read-only mode. Note: Make sure to maintain proper backups of both the primary and standby databases to avoid any data loss.
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值