ITPub博客

ora9i,LINUXas3 ,DG归档日志管理，看书笔记，测试 ,测试前请先配置SSH密钥[@more@]#first set envORACLE_BASE=/SERVER/ora9;export ORACLE_BASEORACLE_HOME=$ORACLE_BASE/product/9.2;export ORACLE_HOMEPATH=$ORACLE_HOME/bin:$PATH;export PATHORACLE_SID=ora9i; export ORACLE_SID#start checkDATE=`date +%Y-%m-%d:%H:%M:%S`filepath=$ORACLE_BASE/oradata/$ORACLE_SID/archive/logpath=$ORACLE_BASE/admin/$ORACLE_SID/bdumpremotefile=`ssh -p 10088 oracle@192.168.18.91 "ls -t /SERVER/ora9/oradata/ora9i/archive/*|head -

ora9i,LINUXas3 ,DG归档日志管理，看书笔记，测试[@more@]ORACLE_BASE=/SERVER/ora9;export ORACLE_BASEORACLE_HOME=$ORACLE_BASE/product/9.2;export ORACLE_HOMEPATH=$ORACLE_HOME/bin:$PATH;export PATHORACLE_SID=ora9i; export ORACLE_SID#delete archive log on STANDBY database which has been appliedgrep "Media Recovery Log" $ORACLE_BASE/admin/$ORACLE_SID/bdump/alert_${ORACLE_SID}.log| awk '{print "rm -f ",$4}' >$ORACLE_BASE/rmarchlog.shcd $ORACLE_BASE/admin/$ORACLE_SID/bdumpcat alert_

环境：LINUX AS 3＋ORA 9.2.4 ＋DATA GUARDMAX LOGFILES ,RESETLOGS[@more@]经过，已经搭建好了基于归档日记传输的最大性能保护模式的DG，想把它改成基于REDO 日记传输模式。在备库新建STANDBY REDO 的时候报错：SQL> alter database add standby logfile group 4 ('/SERVER/ora9/oradata/ora9i/redo04.log') size 100M;Database altered.SQL> alter database add standby logfile group 5 ('/SERVER/ora9/oradata/ora9i/redo05.log') size 100M;Database altered.SQL> alter database add standby logfile group 6 ('/SERVER/or

10G新特性[@more@]一,查看源数据库平台信息SQL> SELECT d.PLATFORM_NAME, ENDIAN_FORMAT FROM V$TRANSPORTABLE_PLATFORM tp, V$DATABASE d WHERE tp.PLATFORM_NAME = d.PLATFORM_NAME;PLATFORM_NAME ENDIAN_FORMAT---------------------------------------------Linux IA (32-bit) Little二,查看目标机平台信息SQL> SELECT d.PLATFORM_NAME, ENDIAN_FORMAT FROM V$TRANSPORTABLE_PLATFORM tp, V$DATABASE d WHERE tp.PLATFORM_NAME = d.PLATFORM_NAME;PLATFORM_NAME ENDIAN_FORMAT-------------

文件名与目录名重名[@more@]环境:RHEL AS3 测试库12:03:07 SQL> select * from v$version; BANNER----------------------------------------------------------------Oracle9i Enterprise Edition Release 9.2.0.4.0 - ProductionPL/SQL Release 9.2.0.4.0 - ProductionCORE 9.2.0.3.0 ProductionTNS for Linux: Version 9.2.0.4.0 - ProductionNLSRTL Version 9.2.0.4.0 – Production 问题: 测试库不能正常SHUTDOWNSQL>shutdown immediate;ORA-01116: error in opening database file 15ORA-01110: data file 15: '/SERV

早上发现测试库连不上, 启动时发现UNDO有坏块[@more@]SQL>startup mount;SQL> alter database open;alter database open*ERROR at line 1:ORA-01092: ORACLE instance terminated. Disconnection forced查看alert_ora9.logThu Jul 12 09:05:59 2007Errors in file /SERVER/ora9/admin/ora9/udump/ora9_ora_1202.trc:ORA-01578: ORACLE data block corrupted (file # 2, block # 9)ORA-01110: data file 2: '/SERVER/ora9/oradata/ora9/undotbs01.dbf'Thu Jul 12 09:05:59 2007Error 1578 happened during db open, shutting down da

RMAN参考手册,参考 http://www.itpub.net/showthread.php?s=&threadid=713055[@more@]ORACLE备份分为物理备份和逻辑备份两种：物理备份就是转储ORACLE物理文件(如数据文件、控制文件、归档日志文件等)，一旦数据库发生故障，我们可以利用这些文件进行还原；逻辑备份就是对数据库对象(如用户、表、存储过程等)利用EXPORT等工具进行导出工作，我们可以利用IMPORT等工具把逻辑备份文件导入到数据库。RMAN备份是一种物理备份，可以用RMAN来备份数据文件、控制文件、参数文件、归档日志文件。我们在数据库出现问题的时候可以通过RMAN物理备

转载:http://blog.chinaunix.net/u/7121/showart.php?id=139709http://www.itpub.net/727601.html [@more@]（1）、创建恢复目录[oracle@a admin]$ sqlplus /nologSQL*Plus: Release 9.2.0.4.0 - Production on Tue Jul 11 17:46:39 2006Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.SQL> connect sys/xueyao as sysdba;Connected.SQL> create tablespace cattbs datafile '/opt/oracle/oradata/primary/cattbs.dbf'size 15M;Tablespace created.SQL> create user rman identified by rman default table