首页 / ORACLE / oracle集群asm备份备份脚本、可选优化归档路径

oracle集群asm备份备份脚本、可选优化归档路径

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了oracle集群asm备份备份脚本、可选优化归档路径，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含16379字，纯文字阅读大概需要24分钟。

内容图文

oracle备份脚本：

#!/bin/sh
# $Header$
#
#bcpyrght
#***************************************************************************
#* $Copyright: Copyright (c) 2016 Veritas Technologies LLC. All rights reserved VT25-0977-2658-84-51-3 $ *
#***************************************************************************
#ecpyrght
#
# Note:  Only make modifications to a copy of this file. Changes to this file 
#        are lost when this example is overwritten during NetBackup upgrade.
#        Delete this comment from the copy.
#
# -----------------------------------------------------------------------------
#              hot_database_backup.sh
# -----------------------------------------------------------------------------
#  This script uses Recovery Manager to take a hot (inconsistent) database
#  backup. A hot backup is inconsistent because portions of the database are
#  being modified and written to the disk while the backup is progressing.
#  You must run your database in ARCHIVELOG mode to make hot backups. It is
#  assumed that this script will be executed by user root. In order for RMAN
#  to work properly we switch user (su -) to the oracle dba account before
#  execution. If this script runs under a user account that has Oracle dba
#  privilege, it will be executed using this user's account.
# -----------------------------------------------------------------------------

# -----------------------------------------------------------------------------
# Log the start of this script to both the stdout/obk_stdout 
# and stderr/obk_stderr.
# -----------------------------------------------------------------------------
echo "==== $0 started on `date` ==== stdout" 
echo "==== $0 started on `date` ==== stderr" 1>&2

DEBUG=0

if [ "$DEBUG" -gt 0 ]; then
    set -x
fi
 
# ---------------------------------------------------------------------------
# Put output in <this file name>.out. Change as desired.
# Note: output directory requires write permission.
# ---------------------------------------------------------------------------
RMAN_LOG_FILE=${0}.out

# -----------------------------------------------------------------------------
# Delete the log file before each execution so that it does not grow unbounded.  
# Remove or comment these lines if all historical output must be retained or if 
# the log file size is managed externally.
# -----------------------------------------------------------------------------

if [ -f "$RMAN_LOG_FILE" ]; then
    rm -f "$RMAN_LOG_FILE"
fi

# -----------------------------------------------------------------------------
# Initialize the log file. By default it is readable by the DBA and other
# users. Restrict the permissions as needed.
# -----------------------------------------------------------------------------
 
echo >> $RMAN_LOG_FILE
chmod 644 $RMAN_LOG_FILE

# -----------------------------------------------------------------------------
# Redirect all stderr and stdout into the specified log file and also to 
# stdout. No output will appear on stderr (or in the obk_stderr).
# -----------------------------------------------------------------------------

out=/tmp/`basename $0`.stdout.$$
trap "rm -f $out" EXIT SIGHUP SIGINT SIGQUIT SIGTRAP SIGKILL SIGUSR1 SIGUSR2 SIGPIPE SIGTERM SIGSTOP 
mkfifo "$out" 
tee -a $RMAN_LOG_FILE < "$out" &
exec 1>&- 2>&-
exec 1>"$out" 2>&1

# -----------------------------------------------------------------------------
# Log the start of this script to the log file and stdout.
# Log any additional arguments to the script.
# -----------------------------------------------------------------------------
echo "==== $0 started on `date` ====" 
echo "==== $0 $*" 
echo 

# *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
# *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
#
# NOTE: User modifications should be made only below this point.
#
# USER CUSTOMIZABLE VARIABLE SECTION
#
# ORACLE_HOME               - Oracle Home path                  
# ORACLE_SID                - Oracle Sid of the target database
# ORACLE_USER               - Oracle user with permissions to execute RMAN
# ORACLE_TARGET_CONNECT_STR - Connect string for the target database 
#                             [user]/[password][@TNSalias]
# RMAN_EXECUTABLE           - Path to the rman executable 
# RMAN_SBT_LIBRARY          - SBT library path;
#                             on AIX see technote TECH194511.
# RMAN_CATALOG              - Recovery catalog option and connect string
# BACKUP_SCHEDULE           - If overriding Default-Application-Backup schedule
# BACKUP_TAG                - User specified backup tag

ORACLE_HOME=/home/oracle/app/oracle/product/12.1.0/dbhome_1

ORACLE_SID=noncdb12c

ORACLE_USER=oracle

ORACLE_TARGET_CONNECT_STR=sys/manager
 
RMAN_EXECUTABLE=$ORACLE_HOME/bin/rman

RMAN_SBT_LIBRARY="/usr/openv/netbackup/bin/libobk.so64"

# Set the Recovery catalog to use. In This example we do not use a
# Recovery Catalog. If you choose to use one, replace the option 'nocatalog'
# with a "'catalog <userid>/<passwd>@<net service name>'" statement.

RMAN_CATALOG="nocatalog"

BACKUP_SCHEDULE=""

# Note: This tag will be appended with the dected schedule type, see schedule
# section.
BACKUP_TAG="hot_db_bk"

export ORACLE_HOME ORACLE_SID 

# Note: Additional tuning may be desired to RMAN_SEND and CMD_INPUT below.

# *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
# *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*

# -----------------------------------------------------------------------------
# Determine the user which is executing this script.
# -----------------------------------------------------------------------------

BACKUP_CUSER=`id |cut -d"(" -f2 | cut -d ")" -f1`

# -----------------------------------------------------------------------------
# This script assumes that the database is properly opened. If desired,
# this would be the place to verify that.
# -----------------------------------------------------------------------------


# -----------------------------------------------------------------------------
# If this script is executed from a NetBackup schedule, NetBackup
# sets NB_ORA environment variables based on the schedule type.
# These variables can then used to dynamically select the appropriate 
# RMAN backup type.
# For example, when:
#     schedule type is                BACKUP_TYPE is
#     ----------------                --------------
# Automatic Full                     INCREMENTAL LEVEL=0
# Automatic Differential Incremental INCREMENTAL LEVEL=1
# Automatic Cumulative Incremental   INCREMENTAL LEVEL=1 CUMULATIVE
# 
# For client initiated backups, BACKUP_TYPE defaults to incremental
# level 0 (full).  To change the default for a user initiated
# backup to incremental or incremental cumulative, uncomment
# one of the following two lines.
# BACKUP_TYPE="INCREMENTAL LEVEL=1"
# BACKUP_TYPE="INCREMENTAL LEVEL=1 CUMULATIVE"
# 
# Note that we use incremental level 0 to specify full backups.
# That is because, although they are identical in content, only
# the incremental level 0 backup can have incremental backups of
# level > 0 applied to it.
# -----------------------------------------------------------------------------
 
if [ "$NB_ORA_FULL" = "1" ]; then
    echo "Full backup requested from Schedule" 
    BACKUP_TYPE="INCREMENTAL LEVEL=0"
    BACKUP_TAG="${BACKUP_TAG}_inc_lvl0"
 
elif [ "$NB_ORA_INCR" = "1" ]; then
    echo "Differential incremental backup requested from Schedule" 
    BACKUP_TYPE="INCREMENTAL LEVEL=1"
    BACKUP_TAG="${BACKUP_TAG}_inc_lvl1"
 
elif [ "$NB_ORA_CINC" = "1" ]; then
    echo "Cumulative incremental backup requested from Schedule" 
    BACKUP_TYPE="INCREMENTAL LEVEL=1 CUMULATIVE"
    BACKUP_TAG="${BACKUP_TAG}_inc_lvl1_cinc"
 
elif [ "$BACKUP_TYPE" = "" ]; then
    echo "Manual execution - defaulting to Full backup" 
    BACKUP_TYPE="INCREMENTAL LEVEL=0"
    BACKUP_TAG="${BACKUP_TAG}_inc_lvl0"
fi

echo

# -----------------------------------------------------------------------------
# Construct an RMAN SEND command when initiated from the master server.  
# This ensures that the resulting application backup jobs utilize the same 
# master server, client name, and policy name.  
#
# If desired, initialize RMAN_SEND with additional NB_ORA_* variable=value 
# pairs.
#
# NOTE WHEN USING NET SERVICE NAME: When connecting to a database
# using a net service name, you must use a send command or a parms operand to 
# specify environment variables.  In other words, when accessing a database
# through a listener, any environment variable set in this script are not 
# inherited by the Oracle channel processes because it is a child of the 
# listener process and not of this script.  For more information on the 
# environment variables, please refer to the NetBackup for Oracle Admin. Guide.
# -----------------------------------------------------------------------------

RMAN_SEND=""

if [ "$NB_ORA_SERV" != "" ]; then
    RMAN_SEND="NB_ORA_SERV=${NB_ORA_SERV}"
fi

if [ "$NB_ORA_CLIENT" != "" ]; then
    if [ "$RMAN_SEND" != "" ]; then
        RMAN_SEND="${RMAN_SEND},NB_ORA_CLIENT=${NB_ORA_CLIENT}"
    else
        RMAN_SEND="NB_ORA_CLIENT=${NB_ORA_CLIENT}"
    fi
fi

if [ "$NB_ORA_POLICY" != "" ]; then
    if [ "$RMAN_SEND" != "" ]; then
        RMAN_SEND="${RMAN_SEND},NB_ORA_POLICY=${NB_ORA_POLICY}"
    else
        RMAN_SEND="NB_ORA_POLICY=${NB_ORA_POLICY}"
    fi
fi

if [ "$BACKUP_SCHEDULE" != "" ]; then
    if [ "$RMAN_SEND" != "" ]; then
        RMAN_SEND="${RMAN_SEND},NB_ORA_SCHED=${BACKUP_SCHEDULE}"
    else
        RMAN_SEND="NB_ORA_SCHED=${BACKUP_SCHEDULE}"
    fi
fi

if [ "$RMAN_SEND" != "" ]; then
    RMAN_SEND="SEND '${RMAN_SEND}';"
fi

# ---------------------------------------------------------------------------
# Call Recovery Manager to initiate the backup.
#
# Note: Any environment variables needed at run time by RMAN 
#       must be set and exported within the CMDS variable.
# ---------------------------------------------------------------------------
#  Backs up the whole database.  This backup is part of the incremental
#  strategy (this means it can have incremental backups of levels > 0
#  applied to it).
#
#  We do not need to explicitly request the control file to be included
#  in this backup, as it is automatically included each time file 1 of
#  the system tablespace is backed up (the inference: as it is a whole
#  database backup, file 1 of the system tablespace will be backed up,
#  hence the controlfile will also be included automatically).
#
#  Typically, a level 0 backup would be done at least once a week.
#
#  The scenario assumes:
#     o you are backing your database up to two tape drives
#     o you want each backup set to include a maximum of 5 files
#     o you wish to include offline datafiles, and read-only tablespaces,
#       in the backup
#     o you want the backup to continue if any files are inaccessible.
#     o This script explicitly backs up the control file.  If you specify or 
#       default to nocatalog, the controlfile backup that occurs
#       automatically as the result of backing up the system file is
#       not sufficient; it will not contain records for the backup that
#       is currently in progress.
#     o you want to archive the current log, back up all the
#       archive logs using two channels, putting a maximum of 20 logs
#       in a backup set, and deleting them once the backup is complete.
#
#  Note that the format string is constructed to guarantee uniqueness and
#  to enhance NetBackup for Oracle backup and restore performance.
#
# -----------------------------------------------------------------------------

# When needed, commands to debug the environment present in the subshell where 
# RMAN will be started. 

if [ "$DEBUG" -gt 0 ]; then
    ENV_COMMANDS="
    echo ----- LIST OF DECLARED VARIABLES IN SUBSHELL ----- 
    echo 
    set | sort
    echo 
    echo ----- LANGUAGE AND LOCALE ----- 
    echo 
    locale 
    echo 
    echo ----- PROCESS LIST ----- 
    echo 
    ps -ef
    echo"
else
    ENV_COMMANDS=""
fi

# The RMAN commands to be executed.
# NOTE: If the default shell for the ORACLE_USER is the C shell, then update 
# the export syntax as follows:
# setenv ORACLE_HOME "$ORACLE_HOME"
# setenv ORACLE_SID "$ORACLE_SID"

CMDS="
export ORACLE_HOME=$ORACLE_HOME
export ORACLE_SID=$ORACLE_SID
echo
echo ----- SUBSHELL ENV VARIABLES ----- 
echo 
env | sort | egrep '^ORACLE_|^NB_ORA_|^RMAN_|^BACKUP_|^TNS_' 
echo
$ENV_COMMANDS
echo ----- STARTING RMAN EXECUTION -----
echo
$RMAN_EXECUTABLE target $ORACLE_TARGET_CONNECT_STR $RMAN_CATALOG"

# Building the PARMS option for the RMAN channels

if [ $RMAN_SBT_LIBRARY != "" ]; then
    RMAN_SBT_LIBRARY_PARMS="PARMS 'SBT_LIBRARY=$RMAN_SBT_LIBRARY'"
else
    RMAN_SBT_LIBRARY_PARMS=""
fi

# The RMAN statements that are needed to perform the desired backup.
# Add, delete, or modify the CMD_INPUT per the backup requirements for the 
# instance.

CMD_INPUT="<< EOF
SHOW ALL;
RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' $RMAN_SBT_LIBRARY_PARMS;
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE' $RMAN_SBT_LIBRARY_PARMS;
$RMAN_SEND
BACKUP
    $BACKUP_TYPE
    SKIP INACCESSIBLE
    TAG $BACKUP_TAG
    FILESPERSET 5
    # recommended format, must end with %t
    FORMAT 'bk_%s_%p_%t'
    DATABASE;
    sql 'alter system archive log current';
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
# backup all archive logs
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' $RMAN_SBT_LIBRARY_PARMS;
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE' $RMAN_SBT_LIBRARY_PARMS;
$RMAN_SEND
BACKUP
    filesperset 20
    # recommended format, must end with %t
    FORMAT 'al_%s_%p_%t'
    ARCHIVELOG ALL DELETE INPUT;
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
#
# Note: During the process of backing up the database, RMAN also backs up the
# control file.  That backup of the control file does not contain the 
# information about the archive log backup if "nocatalog" has been specified.
# To include the information about the current backup, the control file should
# be backed up as the last step.  This step may not be necessary if using 
# a recovery catalog or AUTOBACKUP CONTROLFILE.
#
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' $RMAN_SBT_LIBRARY_PARMS;
$RMAN_SEND
BACKUP
    # recommended format, must end with %t
    FORMAT 'cntrl_%s_%p_%t'
    CURRENT CONTROLFILE;
RELEASE CHANNEL ch00;
}
EOF
"

# -----------------------------------------------------------------------------
# Print out the values of various variables matched by the following patterns.
# -----------------------------------------------------------------------------
if [ "$DEBUG" -gt 0 ]; then
    echo ----- LIST OF DECLARED VARIABLES IN SCRIPT ----- 
    echo 
    set | sort
    echo
fi

echo 
echo "----- SCRIPT VARIABLES -----" 
echo 
set | sort | egrep '^ORACLE_|^NB_ORA_|^RMAN_|^BACKUP_|^TNS_' 
echo 
echo "----- RMAN CMD -----" 
echo 
echo "$CMDS" 
echo 
echo "----- RMAN INPUT -----" 
echo 
echo "$CMD_INPUT" 
echo 

# Sanity check the environment.

if [ ! -x $RMAN_EXECUTABLE ]; then
    echo "ERR: $RMAN_EXECUTABLE: required executable not found!" 1>&2
    exit 1
fi

if [ ! -f  `echo $RMAN_SBT_LIBRARY | cut -d'(' -f1`  ]; then
    echo "ERR: $RMAN_SBT_LIBRARY: required library not found!" 1>&2
    exit 1
fi

echo "----- STARTING CMDS EXECUTION -----"
echo

if [ "$BACKUP_CUSER" = "root" ]; then
    su - $ORACLE_USER -c "$CMDS $CMD_INPUT" 
    RSTAT=$?
else
    /bin/sh -c "$CMDS $CMD_INPUT" 
    RSTAT=$?
fi
 
# ---------------------------------------------------------------------------
# Log the completion of this script to both stdout/obk_stdout 
# and stderr/obk_stderr.
# ---------------------------------------------------------------------------
 
if [ "$RSTAT" = "0" ]; then
    LOGMSG="ended successfully"
else
    LOGMSG="ended in error"
fi
 
echo 
echo "==== $0 $LOGMSG on `date` ==== stdout"  
echo "==== $0 $LOGMSG on `date` ==== stderr" 1>&2 
echo 

exit $RSTAT

oracle集群优化 Archive destination ，防止出错：

[oracle@db04 ~]$sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sun May 5 14:24:15 2019

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> archive log list;
Database log mode           Archive Mode
Automatic archival           Enabled
Archive destination           +ORA_DATA
Oldest online log sequence     1
Next log sequence to archive   6
Current log sequence           6



rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Sun May 5 14:26:23 2019

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: NDMCDB (DBID=3222458319)

RMAN> show all;

using target database control file instead of recovery catalog
....
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/opt/oracle/app/oracle/product/11.2.0/db_1/dbs/snapcf_DB2.f'; # default



RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+ORA_DATA/snapcf_DB2.f';

内容总结

以上是互联网集市为您收集整理的oracle集群asm备份备份脚本、可选优化归档路径全部内容，希望文章能够帮你解决oracle集群asm备份备份脚本、可选优化归档路径所遇到的程序开发问题。如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容，请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

扫描二维码推送至手机访问。

本文链接：https://qyyshop.com/info/912254.html

来源：【匿名】

【上一篇】ORACLE创建触发器和序列【下一篇】Oracle Faq(Oracle TAF的配置)

更多 ►

【oracle集群asm备份备份脚本、可选优化归档路径】教程文章相关的互联网学习教程文章

Oracle Index Clustering Factor(集群因子)【代码】【图】

一、本文说明：今天在做测试的时候发现字段上有索引，但是执行计划就是不走索引，经过在网上查找才发现原来是索引的集群因子过高导致的。本文属于转载二、官网说明 The index clustering factor measures row order in relation to an indexed value suches employee last name.The more order that exists in rowstorage for this value,the lower the clustering factor. ----row存储的越有序，clustering factor的值越...

windows 环境如何恢复（oracle 11g grid） ocr voting 损坏的集群

??windows 环境如何恢复（oracle 11g grid） ocr voting 损坏的集群oracle 11g 以后 ocr 可以放到 asm 磁盘上，而ASM的启动依赖于ocr和votedisk，所以在丢失ocr或votedisk 会导致cluter无法正常启动如果原来的ocr 位置已经不存在，则必须使用相同的名字在原来相同的位置创建一个空 OCR 。建议使用以下步骤来恢复OCR：1、确定当前集群节点数 C:\>olsnodes 2、关闭 oracle clusterware （all of the nodes） C:\crsctl stop crs可能...

ORACLE RAC集群原理【图】

ORACLE RAC原理：在一个应用环境当中，所有的服务器使用和管理同一个数据库，目的是为了分散每一台服务器的工作量，硬件上至少需要两台以上的服务器，而且还需要一个共享存储设备。同时还需要两类软件，一个是集群软件，另外一个就是Oracle数据库中的RAC组件。同时所有服务器上的OS都应该是同一类OS, 根据负载均衡的配置策略，当一个客户端发送请求到某一台服务的listener后，这台服务器根据我们的负载均衡策略，会把请求发送给本...

Oracle RAC集群安装【代码】【图】

安装企业版Oracle数据库需要安装两部分：Oracle RAC, Oracle Database. Oracle RAC原理请参考这篇文章。本篇原创介绍的是RAC 安装的实操部分,数据库的安装部分请参考这篇文章。以Oracle 12C为例。Oracle官方网站下载grid 安装包：http://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle12c-linux-12201-3608234.html650) this.width=650;" title="捕获.PNG" src="/upload/getfiles/default/2022/11/5/20...

基于CentOS与VmwareStation10搭建Oracle11G RAC 64集群环境：3.安装Oracle RAC-3.6.集群管理命令

3.6. 集群管理命令3.6.1. RAC的启动与关闭oracle rac默认会开机自启动，如需维护时可使用以下命令：关闭：crsctl stop cluster 停止本节点集群服务crsctl stop cluster –all 停止所有节点服务开启:crsctl start cluster 开启本节点集群服务crsctl stop cluster –all 开启所有节点服务注：以上命令需以 root用户执行 3.6.2.RAC检查运行状况以grid 用户运行[grid@linuxrac1 ~]$ crsctl check cluster CRS-4537: Cluster Ready Serv...

2.oracle的安装常识,Oralce服务器，oracle集群，oracle服务介绍,用户解锁相关【图】

??1 oracle的安装常识(oracle10g和oracle11g的版本差别)：A 安装目录都不要有中文和空格B oracle10g支持winxp 不支持win7,8和vista;Oracle11g支持所有版本 2 Oralce服务器：由oracle实例和oracle数据库组成oracle数据库：磁盘上物理文件的集合A 当配置了oracle_home时，可以通过echo$ORACLE_HOME来查看oracle的安装目录B bin目录（存放exe工具）、位置：F:\app\to-to\product\11.2.0\dbhome_1\BINC lib目录（oracle依赖的lib）、位...

基于OGG的Oracle与Hadoop集群准实时同步介绍【代码】

Oracle打开归档模式使用如下命令查看当前是否为归档模式（archive） SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination /u01/arch_log Oldest online log sequence 6 Next log sequence to archive 8 Current log sequence 8如非以上状态，手动调整即可 SQL> conn / as sysdba(以DBA身份连接数据库) SQL> shutdown im...

【Oracle 集群】ORACLE DATABASE 11G RAC 知识图文详细教程之缓存融合技术和主要后台进程（四）【图】

白宁超 2015年7月17日12:26:05 Cache Fusion 原理前面已经介绍了 RAC 的后台进程，为了更深入的了解这些后台进程的工作原理，先了解一下 RAC 中多节点对共享数据文件访问的管理是如何进行的。要了解 RAC 工作原理的中心，需要知道 Cache Fusion 这个重要的概念，要发挥 Cache Fusion 的作用，要有一个前提条件，那就是互联网络的速度要比访问磁盘的速度要快。否则，没有引入 Cache Fusion 的意义。而事实上，现在 100MB 的互...

Linux系统、jdk、redis及集群、rabbitmq、nginx、weblogic和oracle安装及配置

系统部署说明准备资料软件主要软件包版本路径系统镜像CentOS-6.10-x86_64-bin-DVD1.iso JDKjdk-8u211-linux-x64.rpm/data/soft/jdk Oraclelinuxamd64_12102_database_1of2.zipllinuxamd64_12102_database_2of2.zip /data/soft/oracleWeblogicfmw_12.2.1.3.0_wls_quick.jar/data/soft/weblogicRedisRedis-5.0.4/data/soft/redisRabbitMQRabbitMQ-3.7.14/data/soft/rabbitmqNginxnginx-1.16.1.tar.gz/data/soft/nginxrpm依赖包工具...

OracleRAC集群环境下删除归档日志【图】

Oracle 10G、oracle11g、oracle 12C版本如果操作系统是AIX、HPUX、Linux下，一般都会采取ASM建库方式，特别是oracle 11g和oracle 归档日志存放形式主要存放方式有以下方式：一、ASM方式 Oracle 10G、oracle11g、oracle 12C版本如果操作系统是AIX、HPUX、Linux下，，一般都会采取ASM建库方式，特别是oracle 11g和oracle12C，因为oracle已经不支持裸设备建库（手工建库还是可以裸设备），如果没有购买HACMP、HP MC软件，那一般开启归...

Oracle集群数据库中恢复归档日志【图】

恢复归档日志：select * from v$log_history t where t.THREAD#= 恢复归档日志：select * from v$log_history t where t.THREAD#=1order by t.FIRST_TIME desc实例1：恢复一个归档日志：run{allocate channel dev_0 type sbt_tapeparms SBT_LIBRARY=/opt/omni/lib/libob2Oracle8_64bit.so,ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=test,OB2BARLIST=db01);restore archivelog sequence 2102;release channel dev1;} 恢复多个归档日志：r...

Oracle归档日志所在目录时间不对&&Oracle集群日志时间显示错误【代码】

-s "2020-07-03 00:00:00" Fri Jul 3 00:00:00 CST 2020 然后，启动所有节点的集群，可以依次观察集群的警告日志，grid用户下，$ORACLE_HOME/log/rac1/alertrac1.log2020-07-02 09:00:26.667: [ohasd(24600)]CRS-2112:The OLR service started on node rac1. 2020-07-02 09:00:26.675: [ohasd(24600)]CRS-1301:Oracle High Availability Service started on node rac1. 2020-07-02 09:00:26.676: [ohasd(24600)]CRS-8017:loca...

Oracle 19c集群日志位置【代码】

11g RAC集群位置： Grid ： $ORACLE_HOME/log/`hostname -s` 19c RAC 集群日志位置： Grid： $ ADR_BASE /diag/crs/rac1/crs/trace 所有的集群日志文件被称为TRACE文件，并用带.trc扩展名（除集群警报日志）结束，而不是.log扩展这是在以前的版本的情况。在 Oracle 12c/ 19c 中，集群日志的位置在ADR_HOME。 $ADR_BASE/diag/crs/hostname/crs。我们可以证实，从ADRCI命令行，如下图所示：[+ASM1]@ht01[/home/grid]$adrci ADRCI...

OracleRAC集群、进程、日志简介【图】

在单机环境下，Oracle是运行在OS Kernel 之上的。 OS Kernel负责管理硬件设备，并提供硬件访问接口。 Oracle 不会直接操作硬件，在单机环境下，Oracle是运行在OS Kernel 之上的。 OS Kernel负责管理硬件设备，并提供硬件访问接口。 Oracle 不会直接操作硬件，而是有OS Kernel代替它来完成对硬件的调用请求。在集群环境下，存储设备是共享的。OS Kernel 的设计都是针对单机的，只能控制单机上多个进程间的访问。如果还依赖OS Ke...

oracle 12C RAC 集群日志（cluster log)目录

[grid@shurkcs ~]$ adrci ADRCI: Release 12.2.0.1.0 - Production on Thu Mar 1 09:25:45 2018 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. ADR base = "/U01/u01/grid"adrci> show homesADR Homes: diag/asm/user_root/host_3751460993_107diag/asm/user_grid/host_3751460993_107diag/asm/+asm/+ASMdiag/crs/shurkcs/crsdiag/clients/user_root/host_3751460993_107diag/clients/user_grid...

首页 / ORACLE / oracle集群asm备份备份脚本、可选优化归档路径

oracle集群asm备份备份脚本、可选优化归档路径

内容导读

内容图文

内容总结

内容备注

内容手机端

【oracle集群asm备份备份脚本、可选优化归档路径】教程文章相关的互联网学习教程文章

Oracle Index Clustering Factor(集群因子)【代码】【图】

windows 环境如何恢复（oracle 11g grid） ocr voting 损坏的集群

ORACLE RAC集群原理【图】

Oracle RAC集群安装【代码】【图】

基于CentOS与VmwareStation10搭建Oracle11G RAC 64集群环境：3.安装Oracle RAC-3.6.集群管理命令

2.oracle的安装常识,Oralce服务器，oracle集群，oracle服务介绍,用户解锁相关【图】

基于OGG的Oracle与Hadoop集群准实时同步介绍【代码】

【Oracle 集群】ORACLE DATABASE 11G RAC 知识图文详细教程之缓存融合技术和主要后台进程（四）【图】

Linux系统、jdk、redis及集群、rabbitmq、nginx、weblogic和oracle安装及配置

OracleRAC集群环境下删除归档日志【图】

Oracle集群数据库中恢复归档日志【图】

Oracle归档日志所在目录时间不对&&Oracle集群日志时间显示错误【代码】

Oracle 19c集群日志位置【代码】

OracleRAC集群、进程、日志简介【图】

oracle 12C RAC 集群日志（cluster log)目录

ORACLE - 相关标签

备份 - 相关标签

集群 - 相关标签

ORACLE - 最新教程

ORACLE - 最热教程