oracle 11g rac开启修改归档模式目的：把归档模式打开并且将日志放在共享存储（ASM）上。环境信息：主机名：db1,db2  实例名：rac11,rac121.配置归档目录在db上执行  [root@db1 ~] # su - grid  [grid@db11 ~]$ sqlplus  / as  sysasm    SQL> select name from v$asm_diskgroup; NAME------------------------------ARCHCRSDATA需要将归档日志存放在ASM上。因此需要在ASM建归档路径[root@db1 ~]# su - grid[grid@db1 ~]$ asmcmdASMCMD> lsARCH/CRS/DATA/ASMCMD> cd ARCH/ASMCMD> mkdir ARCH1ASMCMD> mkdir ARCH2ASMCMD> cd ARCH2     ASMCMD> pwd+ARCH/ARCH2ASMCMD> 当然也可以采用此方法:SQL> alter diskgroup ARCH add directory '+ARCH/ARCH1';SQL> alter diskgroup ARCH add directory '+ARCH/ARCH2';修改归档参数任意一个实例,oracle用户下：SQL> alter system set log_archive_dest_1='LOCATION=+ARCH/ARCH1' scope=spfile sid='racdb11';SQL> alter system set log_archive_dest_1='LOCATION=+ARCH/ARCH2' scope=spfile sid='racdb12';这是分别将两个实例的归档目...

您所在的组无权查看该日志

Oracle11gR2 11.2.0.4:Linux x86:https://updates.oracle.com/Orion/Services/download/p13390677_112040_LINUX_1of7.zip?aru=16720989&patch_file=p13390677_112040_LINUX_1of7.ziphttps://updates.oracle.com/Orion/Services/download/p13390677_112040_LINUX_2of7.zip?aru=16720989&patch_file=p13390677_112040_LINUX_2of7.ziphttps://updates.oracle.com/Orion/Services/download/p13390677_112040_LINUX_3of7.zip?aru=16720989&patch_file=p13390677_112040_LINUX_3of7.ziphttps://updates.oracle.com/Orion/Services/download/p13390677_112040_LINUX_4of7.zip?aru=16720989&patch_file=p13390677_112040_LINUX_4of7.ziphttps://updates.oracle.com/Orion/Services/download/p13390677_112040_LINUX_5of7.zip?aru=16720989&patch_file=p13390677_112040_LINUX_5of7.ziphttps://updates.oracle.com/Orion/Services/download/p13390677_112040_LINUX_6of7.zip?aru=16720989&patch_file=p13390677_112040_LINUX_6of7.ziphttps://updates.oracle.com/Orion/Services/download/p13390677_112040_LINUX_7of7.zip?aru=16720989&am...

Error in invoking target 'agent nmhs' of makefile   日志文件报错如下：# vim /u01/app/oraInventory/logs/installActions2015-01-22_09-44-33AM.logINFO: make[1]: *** [/u01/app/Oracle/product/11.2.0.3/sysman/lib/emdctl] Error 1INFO: make[1]: Leaving directory `/u01/app/oracle/product/11.2.0.3/sysman/lib'INFO: make: *** [emdctl] Error 2INFO: End output from spawned process.INFO: ----------------------------------INFO: Exception thrown from action: makeException Name: MakefileExceptionException String: Error in invoking target 'agent nmhs' of makefile '/u01/app/oracle/product/11.2.0.3/sysman/lib/ins_emagent.mk'. See '/u01/app/oraInventory/logs/installActions2015-01-22_09-44-33AM.log' for details.Exception Severity: 1解决方法：vi $ORACLE_HOME/sysman/lib/ins_emagent.mk搜索以下行：$(MK_EMAGENT_NMECTL)改变为：$(MK_EMAGENT_NMECTL) -lnnz11如图：然后点击：retry另附其他相关问题：1.1 ins_ctx.mk 问题[oracle@zhang logs]$ tail  installActions2012-05-05_01-20-00PM.log   ...

您所在的组无权查看该日志

您所在的组无权查看该日志

Oracle Database 12c Installation on CentOS 7ContentsIntroductionPrerequisitesInstallation StepsOracle Installer ScreensPost Installation TasksFirewallOracle EnvironmentLogin to the database 1. IntroductionThis guide presents how to deploy Oracle Database 12c (12.1.0.2.0) on CentOS 7.1 (64-bit) using quick installation features. Reference System: [root@centos7 ~]# hostnamectl Static hostname: centos7.example.com Icon name: computer Chassis: n/a Machine ID: 583b4d69eaea465ea4bb96ac3b891e15 Boot ID: 931ed1af622046ebbde071a87844a7d5 Virtualization: kvm Operating System: CentOS Linux 7 (Core) CPE OS Name: cpe:/o:centos:centos:7 Kernel: Linux 3.10.0-229.11.1.el7.x86_64 Architecture: x86_64 2. PrerequisitesAfter a successful OS installation, verify the hostname and register it in your DNS. Alternatively add your hostname/IP to the /etc/hosts. [root@centos7 ~]# cat /etc/hostname centos7.example.com Leave the...

ORACLE RMAN增量备份经典理解   Oracle中，增量备份时分等级的，级别从0开始，一级一级递增，不过实际上用的最多的也就是0级和1级了，0级增量备份是后面级别的增量备份的 基础，0级备份实际上就是一个完全备份，与普通的完全备份唯一的不同点是0级备份可以作为其他级别增量备份的基础，而普通的完全备份是不能的。从级别1开始，Oracle的增量备份分为差异增量备份和积累增量备份两种，其中差异增量备份备份的是自上一次同级别的差异备份或者是上一次更高级 别的备份完成之后的数据库发生改变的数据块；而积累增量备份则是备份的自上一次上一级增量备份完成以来数据库发生改变的数据块。在《Backup and Recovery User’s Guide》的“增量备份”一节中有两幅图很形象的描述了这两个增量备份之间的异同：差异增量备份图示积累增量备份图示------------------------------------------------------------------------------------->>rman 全备与0、1级增量备份1、简单来说， rman全库备份只需要backup database;（未压缩），或者 backup as compressed backup...

采用RMAN差异增量备份模式，周期为7天，每周一进行0级增量，周二至星期天进行1级差异增量，始终保留30天恢复窗口，利用crontab在每天03:30进行CRONTAB 0级增量30 03 * * 1 /backup/scripts/0_backup.sh 2>/backup/logs/2.log  SHELL脚本0级增量#!/bin/sh  ORACLE_SID=test  ORACLE_BASE=/app/oracle  ORACLE_HOME=/app/oracle/product/10.2.0/db_1  PATH=/app/oracle/product/10.2.0/db_1/bin:$PATH  export ORACLE_SID ORACLE_BASE ORACLE_HOME PATH  /app/oracle/product/10.2.0/db_1/bin/rman target / cmdfile=/backup/scripts/0_backup.rman msglog=/backup/logs/`date +%Y%m%d_%w_0.log`  RMAN脚本0级增量RUN{  CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;  CONFIGURE CONTROLFILE AUTOBACKUP ON;  CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE...

oracle 数据文件丢换恢复方法，先测试第一种，数据库是归档模式下。新建TEST表空间，并建一个test,dbf 数据文件。并导入了大量信息。先作好一个rman> backup database    /*完整备份。然后再向表中导入一些数据，最好多次切换重任日志文件，并生归档日志。数据库关闭状态下删除非系统表空间TEST的数据文件，SQL> startup open;ORACLE 例程已经启动。Total System Global Area  872685568 bytesFixed Size                  2258200 bytesVariable Size             553650920 bytesDatabase Buffers          310378496 bytesRedo Buffers                6397952 bytes数据库装载完毕。ORA-01157: 无法标识/锁定数据文件 9 - 请参阅 DBWR 跟踪文件ORA-01110: 数据文件 9: '/data/app/oracle/oradata/hextrack/test01.dbf'会的以上错误。 SQL> select fi...