姚远的博客

文章目录现象分享解决办法现象rman备份失败：ORA-00245: control file backup failed; target is likely on a local file system2020-10-10 01:27:14.085@haltnwzcdb02@11317@LM_WARNING@agent|RMAN reports a non-fatal error:ORA-00245: control file backup failed; target is likely on a

The ProblemAfter restoring a controlfile, the restore database can take a long time to restore due to implicit croscchecking and cataloging.RMAN> restore database;RMAN-03090: Starting implicit crosscheck backup at 2012/10/05 01:56:55RMAN-08030: all

鼎甲第14期 Back You Up 公开课由鼎甲高级技术顾问姚远进行线上开讲，围绕“迪备在Oracle DataGuard环境中的使用”这个主题，向大家讲解鼎甲产品迪备在实际场景中的应用原理及技术性优势，以真实的案例展现鼎甲迪备的应用优势。https://mp.weixin.qq.com/s/P0xUOkuerLuaAF37LgCwqw...

问题表现某客户在恢复 Oracle 数据库的单表时，提示类似下面的信息：.......Creating automatic instance, with SID='<oracle_sid>'initialization parameters used for automatic instance:db_name=<db_name>db_unique_name=<db_unique_name>compatible=19.0.0db_block_size=

文章目录recover table失败问题分析解决和回顾recover table失败恢复表是提示类似下面的信息：.......Creating automatic instance, with SID='<oracle_sid>'initialization parameters used for automatic instance:db_name=<db_name>db_unique_name=<db_unique_name>compatible

文章目录检查归档日志第一次备份归档日志检查第一次备份归档日志后的日志第2次备份检查第2次备份归档日志后的日志试试在12.1~19c的RAC连续运行两次 backup archivelog like ‘+%’ not backed up 1 times; 看第二次有没有归档日志检查归档日志[oracle@rac1 ~]$ sqlplus / as sysdbaSQL*Plus: Release 19.0.0.0.0 - Production on Tue Sep 22 04:52:56 2020V

限制条件不支持sys用户和system表空间的表RMAN-05063: Cannot recover specified tablesRMAN-05056: Table SYS.TB belongs to SYSRMAN-05056: Table SYS.TA belongs to SYS恢复过程RMAN> create table scutech.ta as select object_id from dba_objects;Statement processedRMAN&g

Completed: alter database recover datafile list1 , 2 , 3 , 4 , 5alter database recover if neededstart until change 1331285Media Recovery Startstarted logmerger processThu Feb 07 16:43:47 2013Only allocated 107 recovery slaves (requested 128)Paralle

Starting in Oracle Database 11g Release 2 (11.2), the primary databaseautomatically attempts to repair the corrupted block in real time byfetching a good version of the same block from a physical standbydatabase. This capability is referred to as autom.

rman target / catalog rco/dingjia@192.168.17.201/test1run{allocate channel c1 type 'sbt_tape' parms='SBT_LIBRARY=/opt/scutech/dbackup3/lib/libobk.so,ENV=(URL=http://192.168.87.155:50306/d2/data/0d36020eecec11ea8000b49691622ac4/c7873e9aed0811ea8000b4969

change backup … for db_unique_name 可以改变备份集所属的db_unique_name，但oracle官方文档里面没有说会不会同步到db_unique_name对应的数据库的control file。我自己测试发现不会同步到control file。RMAN> change backup tag='DBACKUP3_20200908_204238' for db_unique_name orcl1by reset db_unique_name to orcl;

数据库处于mount状态不一定是一致的，要看mrp进程是否存在！SQL> set linesize 200select d.DB_UNIQUE_NAME,d.open_mode,d.log_mode,d.DATABASE_ROLE,d.PROTECTION_MODE from v$database d;SQL>DB_UNIQUE_NAME OPEN_MODE LOG_MODE DATABASE_ROLE PROTECTION_MODEorclby MOUNTED ARCHIVELOG

一个经典的备份语句：backup database plus archivelog;完成的4个步骤：备份现有的归档日志备份数据文件归档当前日志再次备份归档日志在备库上执行这条语句在第3步时可能会遇到问题。用os用户登录rman时，不能滚主库的归档[oracle@dg121-2 ~]$ rman target /Recovery Manager: Release 12.1.0.2.0 - Production on Tue Sep 8 19:29:13 2020Copyright (c

切换主库日志的脚本 logswitch.sh：sqlplus -s "sys/<passwd>@<primary_db> as sysdba" <<EOFalter system archive log current;exitEOF先备份数据库，再运行脚本切换主库的日志，再备份归档日志，具体步骤：[oracle@dg121-2 ~]$ rman target /Recovery Manager: Release 12.1.0.2.0 - Product

文章目录RMAN Recovery Catalog的作用一、pandas是什么？二、使用步骤1.引入库2.读入数据总结RMAN Recovery Catalog的作用RMAN Recovery catalog 是一个用于存放 RMAN 元数据的 schema。有一下作用：A recovery catalog provides the following benefits:A recovery catalog creates redundancy for the RMAN repository s

RMAN> show ARCHIVELOG DELETION POLICY ;RMAN configuration parameters for database with db_unique_name ORCL are:CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # defaultSQL> set linesize 200; select * from v$flash_recovery_area_usage where FILE_T

SQL> select name from v$datafile;NAME/u01/app/oracle/oradata/cdr1/orcl/system01.dbf/u01/app/oracle/oradata/cdr1/orcl/sysaux01.dbf/u01/app/oracle/oradata/cdr1/orcl/undotbs01.dbf/u01/app/oracle/oradata/cdr1/orcl/pdbseed/system01.dbf/u01/app/oracle/o

文章目录数据库现状修改linux内核参数shmmax和shmall修改之前共享内存修改之前linux内核参数修改之后共享内存修改之后linux内核参数前后对比改成异步IO修改成hugepage没有优化前备份性能优化后的备份性能对比分析数据库现状SQL> select * from v$version;BANNER-----------------------------------...

rman备份失败ORA-19809: limit exceeded for recovery filesORA-19804: cannot reclaim 1561238528 bytes disk space from 21474836480 limit查看错误提示[oracle@oracle11-1 ~]$ oerr ora 1980419804, 00000, "cannot reclaim %s bytes disk space from %s limit"// *Cause: Ora

RMAN 恢复的时候出错RMAN-06091RMAN-03023: executing command: SET DBIDRMAN> 2> 3> 4> 5> 6> 7> 8> 9> RMAN-08030: allocated channel: c1RMAN-08500: channel c1: SID=10 device type=SBT_TAPERMAN-08526: channel c1: DBackup3 Oracle MMS Libr

SGA 设置成100G的时候SQL> show sgaTotal System Global Area 1.0689E+11 bytesFixed Size 2265864 bytesVariable Size 1.0469E+10 bytesDatabase Buffers 9.6368E+10 bytesRedo Buffers 55242752 bytesSQL> show parameter sgaNAME TYPE VALU

文章目录数据库恢复后打开时遇到 ORA-01152分析原因恢复到超过controlfile的SCN状态利用隐含参数"_allow_resetlogs_corruption"=true打开数据库数据库恢复后打开时遇到 ORA-01152数据库恢复后打开时遇到：RMAN> alter database open resetlogs;RMAN-00571: ===========================================================RMAN-00569: