Database 10g Release 10.2.0.3.0 - 64bit Production -->OS 版本 SQL> ho cat /etc/issue Welcome to SUSE Linux....GOBO4A.inst ONLINE ONLINE on bo2dbp ora.GOBO4.GOBO4B.inst.../silent_login.sh GOBO4 INSTANCE_NAME ---------------- GOBO4B oracle@SZDB:~> !! ..../silent_login.sh GOBO4 INSTANCE_NAME ---------------- GOBO4B oracle@SZDB:~> !! ..../silent_login.sh GOBO4A INSTANCE_NAME ---------------- GOBO4A oracle@SZDB:~> !! .
. # the following steps was completed sucessful on Oracle 10g RAC + Suse Linux 10....Synopsis: source DB : GOBO1 on file system Target DB : GOBO1 on RAC +ASM Target Instance: GOBO1A, GOBO1B.../cntl1GOBO1.ctl','/u02/database/GOBO1/controlf/cntl2GOBO1.ctl', #'/u02/database/GOBO1/controlf/cntl3GOBO1.../controlf/cntl1GOBO1.ctl','+DG1/GOBO1/controlf/cntl2GOBO1.ctl' GOBO1A.undo_tablespace='UNDOTBS1'...GOBO1A.instance_name=GOBO1A GOBO1A.instance_number=1 GOBO1A.thread=1 #GOBO1A.local_listener
因此合理正确配置监听器以及tnsnames是Oracle RAC实现负载均衡以及failover的前提，本文将描述基于 suse linux 10 + Oracle 10g RAC 下监听器的配置。...LISTENER_BO2DBP oracle@bo2dbp:/u01/oracle/db/network/admin> lsnrctl status LISTENER_BO2DBP LSNRCTL for Linux...LISTENER_BO2DBS oracle@bo2dbs:/u01/oracle/db/network/admin> lsnrctl status LISTENER_BO2DBS LSNRCTL for Linux...LISTENER_BO2DBS LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 25-SEP-2012 17:23:03 Copyright...LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 25-SEP-2012 17:32:19 Copyright (c) 1991,
.2gotrade.com bo2dbs-vip #操作系统及Oracle版本 oracle@bo2dbp:~> cat /etc/issue Welcome to SUSE Linux...-------------- ------ ----- ora.GOBO4....GOBO4A.inst ONLINE ONLINE on bo2dbp ora.GOBO4.GOBO4B.inst...ONLINE ONLINE on bo2dbs ora.GOBO4.db ONLINE ONLINE on...GOBO4B ASM SID +ASM1 +ASM2 ASM Global DB
本文提供了一个简单易用的基于linux shell下的RMAN备份脚本供参考。大家可根据自己的需要进行适当调整。...catalog 的创建和使用 基于catalog 创建RMAN存储脚本 基于catalog 的RMAN 备份与恢复 RMAN 备份路径困惑 其次是对于shell脚本中调用sql,rman语句可以参考 Linux.../Unix shell 脚本中调用SQL,RMAN脚本 Linux/Unix shell sql 之间传递变量 下面是脚本的具体内容 ##==========================...GOBO1_lev0_201209281421_arc_4onmb9ro_1_1 GOBO1_lev0_201209281421_4knmb9jn..._1_1 GOBO1_lev0_201209281421_c-733951103-20120928-00 GOBO1_lev0_201209281421_4lnmb9jn_1_1 GOBO1
Linux/Unix shell 脚本中调用SQL,RMAN脚本 Linux/Unix shell 脚本清除归档日志文件 1、清除归档日志的方式 a、手动删除 使用rm 或者find方式来删除...crosscheck archivelog all 校验归档是否失效，如下面的操作: rm -rf arch_816906485_1_10.arc find /u02/database/GOBO1...connected to target database: GOBO1 (DBID=733951103) RMAN> host; robin@SZDB:~> cd /u02/database/GOBO1.../archive/ robin@SZDB:/u02/database/GOBO1/archive> ls arch_816906485_1_10.arc arch_816906485..._1_12.arc robin@SZDB:/u02/database/GOBO1/archive> exit; exit
.GOBO4A.inst ONLINE ONLINE on bo2dbp ora.GOBO4.GOBO4B.inst...ONLINE ONLINE on bo2dbp #客户端环境 robin@SZDB:~> cat /etc/issue Welcome to SUSE Linux...-s TAF -r GOBO4A -a GOBO4B -P basic oracle@bo2dbp:~> srvctl start service -d GOBO4 -s TAF oracle.../crs_stat.sh | grep TAF ora.GOBO4.TAF.GOBO4A.srv ONLINE ONLINE on bo2dbp...:~> srvctl config service -d GOBO4 -a TAF PREF: GOBO4A AVAIL: GOBO4B TAF: basic oracle@bo2dbp:~>
.GOBO4A.inst ONLINE ONLINE on bo2dbp ora.GOBO4.GOBO4B.inst...ONLINE ONLINE on bo2dbp #客户端环境 robin@SZDB:~> cat /etc/issue Welcome to SUSE Linux...，所以我们获得如下返回结果 robin@SZDB:~> sqlplus fail_over/fail@gobo4 fail_over@GOBO4> get verify.sql 1...bo2dbp #停止集群数据库的第一个instance，即GOBO4A oracle@bo2dbp:~> srvctl stop instance -d GOBO4 -i...GOBO4A #校验结果 oracle@bo2dbp:~> .
connected to target database: GOBO1 (DBID=733951103) RMAN> list incarnation; using target... ------- ------- -------- ---------------- --- ---------- ---------- 1 1 GOBO1... 733951103 PARENT 1 18-FEB-09 2 2 GOBO1 733951103 PARENT... 79915248 20-SEP-12 3 3 GOBO1 733951103 PARENT 80298787 31-MAY-13... 20130531 21:03:41 4 4 GOBO1 733951103 CURRENT 80307144 20130531 22
.GOBO4A.inst OFFLINE OFFLINE on bo2dbp #此时节点1上的实例被关闭 ora.GOBO4.GOBO4B.inst...ONLINE ONLINE on bo2dbp #客户端环境 robin@SZDB:~> cat /etc/issue Welcome to SUSE Linux...bo2dbs #此时启动第一个实例GOBO4A，并停止第二个实例 oracle@bo2dbp:~> srvctl start instance -d GOBO4 -i...GOBO4A oracle@bo2dbp:~> srvctl stop instance -d GOBO4 -i GOBO4B #查看两个实例的状态 oracle@bo2dbp:~>...ora.GOBO4.GOBO4B.inst OFFLINE OFFLINE #在客户端的session再次检查连接状态，即执行查询，
Service "GOBO4" has 2 instance(s)....* 0 #节点bo2dbs上的实例GOBO4B的更新到bo2dbp上监听器的更新信息 12-OCT-2012 12:00:35 * service_update * GOBO4B * 0...GOBO4B)) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.7.2)(PORT=61862)) * establish * GOBO4 * 0 12-OCT-2012...establish * GOBO4 * 0 12-OCT-2012 12:01:09 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=GOBO4)(CID...gobo4a，有245各客户端连接到了gobo4b #下面查看监听器日志来获得连接信息 #下面的查询中在节点bo2dbp上总共有接受了1000个用户连接 oracle@bo2dbp:/
.GOBO4A.inst ONLINE ONLINE on bo2dbp ora.GOBO4.GOBO4B.inst...ONLINE ONLINE on bo2dbs ora.GOBO4.db ONLINE ONLINE on bo2dbp....GOBO4A.inst OFFLINE OFFLINE ora.GOBO4.GOBO4B.inst...OFFLINE OFFLINE ora.GOBO4.db OFFLINE OFFLINE...SQL> ho lsnrctl status LISTENER_NEW_BO2DBP LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 09-
查看及清除现有的归档日志文件 oracle@bo2dbp:~> export ORACLE_SID=+ASM1 oracle@bo2dbp:~> asmcmd ASMCMD> cd +REV/GOBO4...connected to target database: GOBO4 (DBID=921286879) #下面通过使用rman backup archivelog方式来删除所有的归档日志文件 RMAN..._1_141.arc recid=216 stamp=797450308 ........ piece handle=/install_source/rman_bak/arch_GOBO4_1hnrhli2..._2_143.arc recid=433 stamp=800578944 archive log filename=+REV/gobo4/archivelog/arch_795194241_2_144....=454 stamp=800712037 deleted archive log archive log filename=+REV/gobo4/archivelog/arch_795194241_2_
State -------------- ------ ----- ora.GOBO4....GOBO4A.inst ONLINE ONLINE on bo2dbp ora.GOBO4.GOBO4B.inst...ONLINE ONLINE on bo2dbs ora.GOBO4.GOBO4_SRV.GOBO4A.srv ONLINE ONLINE on bo2dbp...ora.GOBO4.GOBO4_SRV.cs ONLINE ONLINE on bo2dbp ora.GOBO4.db
GOBO4A +ASM1 bo2dbs GOBO4 GOBO4B +ASM2 2、数据库状态 oracle@bo2dbp:~> .....GOBO4A.inst ONLINE ONLINE on bo2dbp ora.GOBO4.GOBO4B.inst...emctl stop dbconsole 2、关闭Oracle实例 srvctl stop instance -d GOBO4 -i GOBO4A 3、关闭ASM实例 srvctl....GOBO4A.inst OFFLINE OFFLINE ora.GOBO4.GOBO4B.inst....GOBO4A.inst OFFLINE OFFLINE ora.GOBO4.GOBO4B.inst
1、演示锁不能释放的情形 --演示环境 goex_admin@GOBO1> select * from v$version where rownum<2; BANNER ----------...--注意下面的SQL提示符之前的SID代表不同的session，如1073@GOBO1>，即表示session ID 为1073。...1073@GOBO1> SET SERVEROUTPUT ON 1073@GOBO1> DECLARE 2 s VARCHAR2 (200); 3 BEGIN 4 lock_demo.request_lock...--在第二个session 1032中尝试请求锁并插入数据 1032@GOBO1> SET SERVEROUTPUT ON 1032@GOBO1> DECLARE 2 s VARCHAR2...--在第三个session 1033中尝试请求锁并插入数据 1033@GOBO1> SET SERVEROUTPUT ON 1033@GOBO1> DECLARE 2 s VARCHAR2
/onlinelog/group_6.256.795194043' oracle@bo2dbp:/u01/database/GOBO4/bdump> tail -20 alert_GOBO4A.log...' does not exist in directory '/' Errors in file /u01/database/GOBO4/bdump/gobo4a_arc0_5419.trc: ORA-...Nov 30 16:08:25 2012 Errors in file /u01/database/GOBO4/bdump/gobo4a_arc1_5421.trc: ORA-16014: log 1...> ls GOBO1/ ORA10G/ ASMCMD> mkdir GOBO4 ASMCMD> cd GOBO4 ASMCMD> mkdir archivelog ASMCMD> pwd +REV/GOBO4...后来的演示环境中，除了删除archivelog外，连同上级目录GOBO4目录也删除了，因为GOBO4下没有任何文件或非空目录 针对这种情形，Oracle建议修改归档路径，且路径中的文件夹不能包含ORACLE_SID
oracle/db) (PROGRAM = extproc) ) ) oracle@bo2dbp:~> lsnrctl status Service "GOBO4...Instance "GOBO4A", status READY, has 2 handler(s) for this service......Instance "GOBO4B", status READY, has 1 handler(s) for this service... 2、服务器端的remote_listener参数设置...remote_lsnr_gobo4 = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.61)(PORT =.../bin/bash for i in {1..1000} do echo $i sqlplus -S system/oracle@GOBO4 <<EOF select instance_name from
">"是由SecureCRT设定的每300秒发送一次 oracle@Dev-DB-04:~> expdp goex_admin/xxx directory=db_dump_dir dumpfile=gobo2....dmp logfile=gobo2.log schemas=goex_admin Export: Release 10.2.0.4.0 - 64bit Production on Thursday...SYS_EXPORT_SCHEMA_01": goex_admin/******** directory=db_dump_dir dumpfile=gobo2.dmp logfile=gobo2... no rows selected -->查询job产生的对象的表，表存在 goex_admin@GOBO2> @datapump_master_tb STATUS...SYS_EXPORT_SCHEMA_01": goex_admin/******** directory=db_dump_dir dumpfile=gobo2.dmp logfile=gobo2
database open [resetlogs] 2、演示RMAN提示符下执行SQL语句 a、执行常用的starup, alter SQL 语句 robin@SZDB:~> export ORACLE_SID=GOBO1...------ ---- ------- - ----------------- ---- 2084 1 8 A 20130604 09:53:17 /u02/database/GOBO1...------ ---- ------- - ----------------- ---- 2084 1 8 A 20130604 09:53:17 /u02/database/GOBO1.../archive/arch_816906485_1_8.arc 2085 1 9 A 20130604 10:46:36 /u02/database/GOBO1/archive/...SQL语句 --下面的执行那个中没有使用双引号开头以及双单引号括住路径，收到错误提示 RMAN> sql ' create tablespace ts1 datafile '/u02/database/GOBO1
领取专属 10元无门槛券
手把手带您无忧上云
云服务器
ICP备案
对象存储
即时通信 IM
实时音视频
