- 浏览: 45813 次
- 性别:
- 来自: 广州
最新评论
-
flyer646:
楼主 的效率低 (网友给的效率高一些,每个字符只做一次) 假如 ...
web前端笔试一道面试题目新解 -
liuzhiqiangruc:
z_joey 写道用正则表达式的那个算法效率太低了吧
哪种用 ...
web前端笔试一道面试题目新解 -
liuzhiqiangruc:
针对该问题,有两种解法,无非就是时间和空间的权衡,在实际应用中 ...
web前端笔试一道面试题目新解 -
z_joey:
用正则表达式的那个算法效率太低了吧
web前端笔试一道面试题目新解 -
drcjian:
把字符串放到hashtable中(字符串作为主键,添加的时候遇 ...
web前端笔试一道面试题目新解
转 RH4 oracle rman
Red Hat Enterprise Linux AS release 4 (Nahant Update 2)下ORACLE9.2的安装
[原创 2006-12-14 21:27:26 ] 发表者: westzq
#####################smb共享#######################
创建组 groupadd -g 601 dba
创建用户 useradd -u 801 -g dba -G dba oracle
vi /etc/samba/smb.conf
###
path=/home/oracle/pub
vailduser=oracle
public=Yes
writable=Yes
comment="......."
###
测试 testparm
smbpasswd -a oracle
service smb restart
关闭防火墙 setup
######################解压##########################
gunzip
cpio -idmv <
######################远程桌面######################
ssh root@192.168.123.95
######################资源包安装######################
rpm -ivh/uvh
#####################共享#########################
vi /etc/exports
共享文件夹 对象主机(ro)
启动服务 portmap nfs
对象机上启动 portmap
mount -t nfs 192.168.123.91:/home/oracle/pub /mnt
####################环境设置#####################
# grep MemTotal /proc/meminfo --查看内存总量
# /sbin/swapon --硬盘
# vi /etc/hosts --配置网络地址
# vi /etc/sysconfig/network --查看是否正确
# service network restart
# vi /etc/sysctl.conf
###bgn
kernel.sysrq=1
kernel.msgmni=1024
kernel.shmmax=2147483648
kernel.shmmni=4906
kernel.shmall=2097152
kernel.sem=1024 64000 200 512
fs.file-max=65536
net.ipv4.ip_local_port_range=1024 65000
net.ipv4.tcp_sack=0
net.ipv4.tcp_timestamps=0
net.ipv4.tcp_max_syn_backlog=8192
net.ipv4.tcp_keepalive_time=120
net.core.rmem_default=262144
net.core.rmem_max=262144
net.core.wmem_default=262144
net.core.wmem_max=262144
###end
# /sbin/sysctl -p
# su - oracle
$ vi .bash_profile
###bgn
export LD_ASSUME_KERNEL=2.4.1
export LC_CTYPE=en_US.UTF-8
export ORACLE_SID=PROD
export ORACLE_BASE=/oraapp/oracle
export ORACLE_HOME=/oraapp/oracle/92
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_DB=$ORACLE_HOME/dbs
export ORACLE_BDUMP=$ORACLE_BASE/shtkt/bdump
export ORACLE_TERM=xterm
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib
export LIBPATH=$ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib
export CLASSPATH=$ORACLE_HOME/JRE/lib:$ORACLE_HOME/JRE/lib/rt.jar:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export PATH
umask 022
###end
$ source .bash_profile --让新的环境变量生效
-----root下
# vi /etc/security/limits.conf
###bgn
* soft nproc 2047
* hard nproc 16384
* soft nofile 1024
* hard nofile 65536
###end
# vi /etc/pam.d/login
###bgn
session required /lib/security/pam_limits.so
###end
# vi /etc/profile
###bgn
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
###end
$ ulimit
(Red Hat Enterprise Linux AS release 4 (Nahant Update 2))
# mv /usr/bin/gcc /usr/bin/gcc34
# ln -s /usr/bin/gcc32 /usr/bin/gcc
# mv /usr/bin/g++ /usr/bin/g++34
# ln -s /usr/bin/g++32 /usr/bin/g++
# reboot
######################linux安装#####################
安装
1.enter
2.skip 回车
3.next
4.语言english next
5.manually partition with disk druid
/boot ext3 100M fixed size
swap 物理内存2倍
/ ext3 fixed size
6.enable firewall / remote login(SSH)
7.customize software packages to be installed
development下全部包
#######################oracle安装###################
# xhost +
su - oracle
解压在ORACLE下
盘一 ./runInstaller
一般会出错,需要安装资源包
compat-oracle-rhel4-1.0-5.i386.rpm
compat-libcwait-2.1-1.i386.rpm
libaio-devel-0.3.103-3.i386.rpm
#############查看监听是否正常#####################
tnsping prod
###############PROD脚本##########################
init.ora
### 内存配置
DB_BLOCK_SIZE=8192
LOG_BUFFER=3145728
SORT_AREA_SIZE=524288
SGA_MAX_SIZE=130M
DB_CACHE_SIZE=32M
JAVA_POOL_SIZE=0M
LARGE_POOL_SIZE=24M
SHARED_POOL_SIZE=24M
PGA_AGGREGATE_TARGET=24M
###
### $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
### 归档服务器配置
LOG_ARCHIVE_DEST_1=('LOCATION=/oradata/prod/arch') MANDATORY REOPEN
LOG_ARCHIVE_FORMAT='%t_%s.arc'
LOG_ARCHIVE_START=TRUE
# DISPATCHERS='(PROTOCOL=TCP)(DISPATCHERS=1)'
# SHARED_SERVERS=1
# MAX_DISPATCHERS=5
# MAX_SHARED_SERVERS=8
###
### $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
### 路径配置
UTL_FILE_DIR='/oradata/prod/logmnr'
BACKGROUND_DUMP_DEST='/oradata/prod/dump/bdump'
CORE_DUMP_DEST='/oradata/prod/dump/cdump'
USER_DUMP_DEST='/oradata/prod/dump/udump'
CONTROL_FILES=('/oradata/prod/data/PROD_control01','/oradata/prod/data/PROD_control02','/oradata/prod/data/PROD_control03')
DB_DOMAIN='PKIBM.COM'
DB_NAME='PROD'
INSTANCE_NAME='PROD'
UNDO_MANAGEMENT=AUTO
UNDO_RETENTION=7200
UNDO_TABLESPACE='UNDOTBS'
###
### $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
### 其它参数
DB_FILE_MULTIBLOCK_READ_COUNT=16
OPEN_CURSORS=100
OPTIMIZER_MODE=CHOOSE
CURSOR_SHARING=SIMILAR
TIMED_STATISTICS=TRUE
COMPATIBLE=9.2.0.0.0
HASH_JOIN_ENABLED=TRUE
STAR_TRANSFORMATION_ENABLED=FALSE
QUERY_REWRITE_ENABLED=TRUE
QUERY_REWRITE_INTEGRITY=TRUSTED
PROCESSES=200
FAST_START_MTTR_TARGET=300
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
DML_LOCKS=2048
O7_DICTIONARY_ACCESSIBILITY=FALSE
WORKAREA_SIZE_POLICY=AUTO
JOB_QUEUE_PROCESSES=2
REPLICATION_DEPENDENCY_TRACKING=TRUE
OPEN_LINKS=2
GLOBAL_NAMES=FALSE
AQ_TM_PROCESSES=1
createDB.sh
#REM 创建必要的目录
mkdir -p /oradata/prod/dump/bdump
mkdir -p /oradata/prod/dump/cdump
mkdir -p /oradata/prod/dump/udump
mkdir -p /oradata/prod/dump/create
mkdir -p /oradata/prod/data
mkdir -p /oradata/prod/arch
mkdir -p /oradata/prod/bkup
mkdir -p /oradata/prod/logmnr
#REM
#REM $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
#REM 设置临时环境变量
export ORACLE_SID=PROD
#REM
#REM $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
#REM 启动Oracle后台服务
#D:\oracle\ora92\bin\oradim -delete -sid PROD
#D:\oracle\ora92\bin\oradim -new -sid PROD -startmode m -pfile D:\oradata\prod\dump\create\init.ora
#D:\oracle\ora92\bin\oradim -edit -sid PROD -startmode a
#REM
#REM $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
#REM 创建密码文件
rm /oraapp/oracle/92/dbs/orapwPROD
/oraapp/oracle/92/bin/orapwd file=/oraapp/oracle/92/dbs/orapwPROD password=PKIBM entries=5
#REM
#REM $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
#REM 开始创建数据库
/oraapp/oracle/92/bin/sqlplus /nolog @/oradata/prod/dump/create/createDB.sql
#REM
#REM $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
#REM 配置数据库网络
cp /oradata/prod/dump/create/listener.ora /oraapp/oracle/92/network/admin
cp /oradata/prod/dump/create/tnsnames.ora /oraapp/oracle/92/network/admin
cp /oradata/prod/dump/create/sqlnet.ora /oraapp/oracle/92/network/admin
#REM
#REM $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
#REM 启动监听
/oraapp/oracle/92/bin/lsnrctl stop
/oraapp/oracle/92/bin/lsnrctl start
#REM
#REM $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
#REM (end)
createDB.sql
--- 启动实例
CONNECT SYS/PKIBM AS SYSDBA
SET ECHO ON
SPOOL /oradata/prod/dump/create/createDB.log
STARTUP NOMOUNT PFILE='/oradata/prod/dump/create/init.ora';
---
--- $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
--- 创建数据库
CREATE DATABASE "PROD"
LOGFILE GROUP 1 ('/oradata/prod/data/PROD_redo11','/oradata/prod/data/PROD_redo12') SIZE 5M,
GROUP 2 ('/oradata/prod/data/PROD_redo21','/oradata/prod/data/PROD_redo22') SIZE 5M,
GROUP 3 ('/oradata/prod/data/PROD_redo31','/oradata/prod/data/PROD_redo32') SIZE 5M
MAXINSTANCES 2
MAXLOGHISTORY 1
MAXLOGFILES 12
MAXLOGMEMBERS 3
MAXDATAFILES 1024
NOARCHIVELOG
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/oradata/prod/data/PROD_system01' SIZE 300M REUSE
AUTOEXTEND ON NEXT 50M MAXSIZE 2000M
UNDO TABLESPACE "UNDOTBS"
DATAFILE '/oradata/prod/data/PROD_undo01' SIZE 10M REUSE
AUTOEXTEND ON NEXT 10M MAXSIZE 2000M EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE "TEMPTBS"
TEMPFILE '/oradata/prod/data/PROD_temp01' SIZE 10M REUSE
AUTOEXTEND ON NEXT 5M MAXSIZE 2000M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K ;
---
--- $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
--- 创建数据词典
SET ECHO OFF
@/oraapp/oracle/92/rdbms/admin/catalog.sql;
@/oraapp/oracle/92/rdbms/admin/catproc.sql;
---
--- $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
--- 修改密码
CONNECT SYS/PKIBM AS SYSDBA
ALTER USER SYS IDENTIFIED BY PKIBM;
ALTER USER SYSTEM IDENTIFIED BY PKIBM;
---
--- $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
--- 创建帮助词典
connect SYSTEM/PKIBM
@/oraapp/oracle/92/sqlplus/admin/pupbld.sql;
connect SYSTEM/PKIBM
@/oraapp/oracle/92/sqlplus/admin/help/hlpbld.sql helpus.sql;
---
--- $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
--- 配置数据库
CONNECT SYS/PKIBM AS SYSDBA
SET ECHO ON
SHUTDOWN IMMEDIATE;
CONNECT SYS/PKIBM AS SYSDBA
STARTUP MOUNT PFILE='/oradata/prod/dump/create/init.ora';
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE OPEN;
CREATE SPFILE FROM PFILE='/oradata/prod/dump/create/init.ora';
SHUTDOWN IMMEDIATE;
CONNECT SYS/PKIBM AS SYSDBA
STARTUP
---
--- $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
--- 创建表空间
CREATE TABLESPACE "PKIBM"
DATAFILE '/oradata/prod/data/PKIBM_pkibm01' SIZE 10M
AUTOEXTEND ON NEXT 5M MAXSIZE 2000M
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO UNIFORM SIZE 128K;
---
--- $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
--- 修改默认存储
DROP TABLE "OUTLN"."OL$" ;
CREATE TABLE "OUTLN"."OL$"("OL_NAME" VARCHAR2(30),"SQL_TEXT" LONG,"TEXTLEN" NUMBER,"SIGNATURE" RAW(16),"HASH_VALUE" NUMBER,"HASH_VALUE2" NUMBER,
"CATEGORY" VARCHAR2(30),"VERSION" VARCHAR2(64),"CREATOR" VARCHAR2(30),"TIMESTAMP" DATE,"FLAGS" NUMBER, "HINTCOUNT" NUMBER, "SPARE1" NUMBER, "SPARE2" VARCHAR2(1000)
)TABLESPACE "PKIBM" INITRANS 4;
ALTER TABLE "OUTLN"."OL$HINTS" MOVE TABLESPACE "PKIBM" INITRANS 4;
ALTER TABLE "OUTLN"."OL$NODES" MOVE TABLESPACE "PKIBM" INITRANS 4;
ALTER USER "OUTLN" DEFAULT TABLESPACE "PKIBM" ;
ALTER USER "OUTLN" IDENTIFIED BY "LOCKEDBYDBA" ACCOUNT LOCK ;
ALTER USER "DBSNMP" DEFAULT TABLESPACE "PKIBM" ;
ALTER USER "DBSNMP" IDENTIFIED BY "LOCKEDBYDBA" ACCOUNT LOCK ;
---
--- $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
--- 创建默认用户
CREATE USER PKIBM IDENTIFIED BY PKIBM ACCOUNT UNLOCK;
GRANT CREATE SESSION TO PKIBM;
ALTER USER PKIBM DEFAULT TABLESPACE "PKIBM" ;
ALTER USER PKIBM ACCOUNT UNLOCK;
REVOKE UNLIMITED TABLESPACE FROM PKIBM;
ALTER USER PKIBM QUOTA UNLIMITED ON PKIBM;
---
--- $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
--- 结束创建
SPOOL OFF
DISCONNECT ;
EXIT ;
listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1688))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = PROD.PKIBM.COM)
(ORACLE_HOME = D:\oracle\ora92)
(SID_NAME = PROD)
)
)
tnsnames.ora
PKIBM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1688))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = PROD.PKIBM.COM)
)
)
sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES)
USE_DEDICATED_SERVER = on
#############################RCAT建立#######################################
RCATinit.ora
DB_BLOCK_SIZE=8192
LOG_BUFFER=3145728
SORT_AREA_SIZE=524288
SGA_MAX_SIZE=268435456
DB_CACHE_SIZE=167772160
JAVA_POOL_SIZE=0
LARGE_POOL_SIZE=25165824
SHARED_POOL_SIZE=50331648
PGA_AGGREGATE_TARGET=67108864
LOG_ARCHIVE_DEST_1=('LOCATION=/oradata/RCAT/arch') MANDATORY REOPEN
LOG_ARCHIVE_FORMAT='%t_%s.arc'
LOG_ARCHIVE_START=TRUE
# DISPATCHERS='(PROTOCOL=TCP)(DISPATCHERS=1)'
# SHARED_SERVERS=1
# MAX_DISPATCHERS=5
# MAX_SHARED_SERVERS=8
UTL_FILE_DIR='/oradata/RCAT/logmnr'
BACKGROUND_DUMP_DEST='/oradata/RCAT/bdump'
CORE_DUMP_DEST='/oradata/RCAT/cdump'
USER_DUMP_DEST='/oradata/RCAT/udump'
CONTROL_FILES=('/oradata/RCAT/data/RCAT_ctrl01','/oradata/RCAT/data/RCAT_ctrl02','/oradata/RCAT/data/RCAT_ctrl03')
DB_DOMAIN='PKIBM.COM'
DB_NAME='RCAT'
INSTANCE_NAME='RCAT'
UNDO_MANAGEMENT=AUTO
UNDO_RETENTION=7200
UNDO_TABLESPACE='UNDOTBS'
DB_FILE_MULTIBLOCK_READ_COUNT=16
OPEN_CURSORS=100
OPTIMIZER_MODE=CHOOSE
CURSOR_SHARING=SIMILAR
TIMED_STATISTICS=TRUE
COMPATIBLE=9.2.0.0.0
HASH_JOIN_ENABLED=TRUE
STAR_TRANSFORMATION_ENABLED=FALSE
QUERY_REWRITE_ENABLED=TRUE
QUERY_REWRITE_INTEGRITY=TRUSTED
PROCESSES=200
FAST_START_MTTR_TARGET=300
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
DML_LOCKS=2048
O7_DICTIONARY_ACCESSIBILITY=FALSE
WORKAREA_SIZE_POLICY=AUTO
JOB_QUEUE_PROCESSES=2
REPLICATION_DEPENDENCY_TRACKING=TRUE
OPEN_LINKS=2
GLOBAL_NAMES=FALSE
AQ_TM_PROCESSES=1
RCATcreate.sql
CONNECT SYS/pkibm AS SYSDBA
SET ECHO ON
SPOOL createDB.log
STARTUP NOMOUNT PFILE='/oraapp/oracle/92/dbs/initRCAT.ora'
CREATE DATABASE RCAT
LOGFILE
GROUP 1 ('/oradata/RCAT/data/RCAT_redo11','/oradata/RCAT/data/RCAT_redo12') SIZE 50M,
GROUP 2 ('/oradata/RCAT/data/RCAT_redo21','/oradata/RCAT/data/RCAT_redo22') SIZE 50M,
GROUP 3 ('/oradata/RCAT/data/RCAT_redo31','/oradata/RCAT/data/RCAT_redo32') SIZE 50M
MAXINSTANCES 4
MAXLOGHISTORY 1
MAXLOGFILES 12
MAXLOGMEMBERS 3
MAXDATAFILES 1024
NOARCHIVELOG
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/oradata/RCAT/data/RCAT_system01' SIZE 300M REUSE
AUTOEXTEND ON NEXT 50M MAXSIZE 2000M
UNDO TABLESPACE UNDOTBS
DATAFILE '/oradata/RCAT/data/RCAT_undo01' SIZE 10M REUSE
AUTOEXTEND ON NEXT 10M MAXSIZE 2000M EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMPTBS
TEMPFILE '/oradata/RCAT/data/RCAT_temp01' SIZE 10M REUSE
AUTOEXTEND ON NEXT 5M MAXSIZE 2000M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K;
SET ECHO OFF
@/oraapp/oracle/92/rdbms/admin/catalog.sql;
@/oraapp/oracle/92/rdbms/admin/catproc.sql;
CONNECT SYS/pkibm AS SYSDBA
ALTER USER SYS IDENTIFIED BY pkibm;
ALTER USER SYSTEM IDENTIFIED BY pkibm;
connect SYSTEM/pkibm
@/oraapp/oracle/92/sqlplus/admin/pupbld.sql;
connect SYSTEM/pkibm
@/oraapp/oracle/92/sqlplus/admin/hlpbld.sql helpus.sql;
CONNECT SYS/pkibm AS SYSDBA
SET ECHO ON
SHUTDOWN IMMEDIATE
CONNECT SYS/pkibm AS SYSDBA
STARTUP MOUNT PFILE='/oraapp/oracle/92/dbs/initRCAT.ora'
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE OPEN;
CREATE SPFILE FROM PFILE='/oraapp/oracle/92/dbs/initRCAT.ora';
SHUTDOWN IMMEDIATE;
CONNECT SYS/pkibm AS SYSDBA
STARTUP
CREATE TABLESPACE sysaux
DATAFILE '/oradata/RCAT/data/RCAT_sysaux01' SIZE 10M
AUTOEXTEND ON NEXT 5M MAXSIZE 2000M
LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO UNIFORM SIZE 128K;
DROP TABLE outln.ol$ ;
CREATE TABLE outln.ol$(
ol_name VARCHAR2(30),sql_text LONG,textlen NUMBER,
signature RAW(16),hash_value NUMBER,hash_value2 NUMBER,
category VARCHAR2(30),version VARCHAR2(64),creator VARCHAR2(30),
timestamp DATE,flags NUMBER,hintcount NUMBER,spare1 NUMBER,
spare2 VARCHAR2(1000))TABLESPACE sysaux INITRANS 4;
ALTER TABLE outln.ol$hints MOVE TABLESPACE sysaux INITRANS 4;
ALTER TABLE outln.ol$nodes MOVE TABLESPACE sysaux INITRANS 4;
ALTER USER outln DEFAULT TABLESPACE sysaux;
ALTER USER outln IDENTIFIED BY LOCKEDBYDBA ACCOUNT LOCK;
ALTER USER dbsnmp DEFAULT TABLESPACE sysaux;
ALTER USER dbsnmp IDENTIFIED BY LOCKEDBYDBA ACCOUNT LOCK;
CREATE USER PKIBM IDENTIFIED BY PKIBM ACCOUNT UNLOCK;
GRANT CREATE SESSION TO PKIBM;
ALTER USER PKIBM DEFAULT TABLESPACE sysaux;
ALTER USER PKIBM ACCOUNT UNLOCK;
REVOKE UNLIMITED TABLESPACE FROM PKIBM;
ALTER USER PKIBM QUOTA UNLIMITED ON sysaux;
SPOOL OFF
DISCONNECT
EXIT
RCATcreate.sh
#!/bin/sh
mkdir -p /oradata/RCAT/bdump
mkdir -p /oradata/RCAT/cdump
mkdir -p /oradata/RCAT/udump
mkdir -p /oradata/RCAT/data
mkdir -p /oradata/RCAT/arch
mkdir -p /oradata/RCAT/bkup
mkdir -p /oradata/RCAT/logmnr
export ORACLE_SID=RCAT
cp ./RCATinit.ora /oraapp/oracle/92/dbs/initRCAT.ora
/oraapp/oracle/92/bin/orapwd file=/oraapp/oracle/92/dbs/orapwRCAT password=pkibm entries=5
/oraapp/oracle/92/bin/sqlplus /nolog @./RCATcreate.sql
cp ./RCATlistener.ora /oraapp/oracle/92/network/admin/listener.ora
cp ./RCATtnsnames.ora /oraapp/oracle/92/network/admin/tnsnames.ora
/oraapp/oracle/92/bin/lsnrctl stop
/oraapp/oracle/92/bin/lsnrctl start
tnsnames.ora
RCAT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1688))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = RCAT)
)
)
PROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = PROD)
)
)
listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1688))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = RCAT.PKIBM.COM)
(ORACLE_HOME = /oraapp/oracle/92)
(SID_NAME = RCAT)
)
(SID_DESC =
(GLOBAL_DBNAME = PROD.PKIBM.COM)
(ORACLE_HOME = /oraapp/oracle/92)
(SID_NAME = PROD)
)
)
##################################################
####################RMAN配置####################
##################################################
1.在目录数据库中创建恢复目录所需的表空间
CREATE TABLESPACE rman_ts DATAFILE '/oradata/RCAT/data/rman.dbf' SIZE 200m;
PS:删除掉该表空间 DROP TABLESPACE rman_ts INCLUDING CONTENTS;
2.在目录数据库中创建RMAN用户
CREATE USER rman IDENTIFIED BY rman
DEFAULT TABLESPACE rman_ts
TEMPORARY TABLESPACE TEMP
QUOTA UNLIMITED ON rman_ts;
PS:删除用户 DROP USER rman CASCADE;
3.给rman用户授权
GRANT recovery_catalog_owner,connect,resource TO rman;
4.新开启一个CMD
rman catalog rman/rman
或者: -C:\>rman
-RMAN>connect catalog rman/rman@idba;
-RMAN>create catalog tablespace rman_ts //创建catalog于rman_ts表空间
5.在D:\oracle\ora92\network\admin\tnsnames.ora建立
PROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.123.127)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = IDBA)
)
)
6.以sys用户登陆上生产数据库上创建备份用户
-SQL>CREATE USER rman IDENTIFIED BY rman
-SQL>GRANT sysdba TO rman;
7.连接上生产数据库注册
-RMAN>CONNECT TARGET rman/rman@prod
-RMAN>REGISTER DATABASE
##################################################
####################crontab -e####################
##################################################
0 2 28 1 * /oraapp/oracle/dba/full_bkup.sh
10 0 * * 0 /oraapp/oracle/dba/lev0_bkup.sh
10 0 * * 1-2 /oraapp/oracle/dba/lev2_bkup.sh
10 0 * * 3 /oraapp/oracle/dba/lev1_bkup.sh
10 0 * * 4-6 /oraapp/oracle/dba/lev2_bkup.sh
10 3 * * 0 /oraapp/oracle/dba/ora_wk.sh
##################################################
########/oraapp/oracle/dba/DBA_rename.sql#########
##################################################
connect RMAN/RMAN@RCAT;
set echo off
set feedback off
set linesize 1000
set pagesize 0
set verify off
spool /oraapp/oracle/dba/log/rename.txt
select 'dd bs=1024 if=&1 of=/oraapp/oracle/dba/log/RLog_'||to_char(sysdate,'d')||'.txt' from dual;
spool off
host chmod 755 /oraapp/oracle/dba/log/rename.txt
host /oraapp/oracle/dba/log/rename.txt
host rm -rf /oraapp/oracle/dba/log/rename.txt
exit;
##################################################
###########/oraapp/oracle/dba/ora_os.sh###########
##################################################
#!/bin/sh
#
# copy all backup files from the db server72
#
cp /hotbkup/data/orabk/* /hotbkup/data/tmp/ >>/oraapp/oracle/dba/log/bkup.log
#
# move the daily backup to current week directory
#
cp /hotbkup/data/tmp/* /offbkup/data/cweek/ >>/oraapp/oracle/dba/log/bkup.log
#
# remove the yestoday's backup files
#
rm -rf /hotbkup/data/day/* >>/oraapp/oracle/dba/log/bkup.log
#
# copy all the backup file to day directory
#
mv /hotbkup/data/tmp/* /hotbkup/data/day/ >>/oraapp/oracle/dba/log/bkup.log
#
# delete all the db server72's backup files to free diskspace
# must delete at last for security
#
rm -rf /hotbkup/data/orabk/* >>/oraapp/oracle/dba/log/bkup.log
#
# list all the backup file
#
ls -l /hotbkup/data/orabk/ >>/oraapp/oracle/dba/log/bkup.log
ls -l /hotbkup/data/tmp/ >>/oraapp/oracle/dba/log/bkup.log
ls -l /hotbkup/data/day/ >>/oraapp/oracle/dba/log/bkup.log
ls -l /offbkup/data/cweek/ >>/oraapp/oracle/dba/log/bkup.log
#
# send email to dba
#
mail -s "BK_`date "+%Y-%m-%d"`_log" westzq@hotmail.com </oraapp/oracle/dba/log/bkup.log
##################################################
###########/oraapp/oracle/dba/ora_wk.sh###########
##################################################
#!/bin/sh
#
# remove all the last week backup files
#
rm -rf /offbkup/data/pweek/*
#
# move current week backup file to preview week folder
#
mv /offbkup/data/cweek/* /offbkup/data/pweek/
##################################################
#########/oraapp/oracle/dba/full_bkup.sh##########
##################################################
#!/bin/sh
export ORACLE_HOME=/oraapp/oracle/92
export DBA_HOME=/oraapp/oracle/dba
export ORACLE_SID=RCAT
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export NLS_DATE_FORMAT='YYYY-MM-DD_HH24:MI:SS'
$ORACLE_HOME/bin/rman cmdfile $DBA_HOME/full_bk.rcv msglog $DBA_HOME/log/bkup.log
$ORACLE_HOME/bin/sqlplus /nolog @$DBA_HOME/DBA_rename.sql $DBA_HOME/log/bkup.log
/oraapp/oracle/dba/ora_os.sh &
##################################################
#########/oraapp/oracle/dba/full_bkup.rcv#########
##################################################
connect catalog RMAN/RMAN@RCAT;
connect target RMAN/RMAN@PROD;
run {
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
backup full filesperset=2 tag='Full_%d' format='/oradata/orabk/%T_full_%d_%s_%p' database include current controlfile;
sql 'alter system archive log current';
backup filesperset=4 format='/oradata/orabk/arch_%T_%d_%s_%p' archivelog all delete input;
release channel ch1;
release channel ch2;
}
quit;
##################################################
#########/oraapp/oracle/dba/lev0_bkup.sh##########
##################################################
#!/bin/sh
export ORACLE_HOME=/oraapp/oracle/92
export DBA_HOME=/oraapp/oracle/dba
export ORACLE_SID=RCVCAT
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export NLS_DATE_FORMAT='YYYY-MM-DD_HH24:MI:SS'
$ORACLE_HOME/bin/rman cmdfile $DBA_HOME/lev0_bkup.rcv log $DBA_HOME/log/bkup.log
$ORACLE_HOME/bin/sqlplus /nolog @$DBA_HOME/DBA_rename.sql $DBA_HOME/log/bkup.log
/oraapp/oracle/dba/ora_os.sh &
##################################################
#########/oraapp/oracle/dba/lev0_bkup.rcv#########
##################################################
connect catalog RMAN/RMAN@RCAT;
connect target RMAN/RMAN@PROD;
run {
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
backup incremental level=0 filesperset=2 tag='Lev0_%d' format='/oradata/orabk/%T_lev0_%d_%s_%p' database include current controlfile;
sql 'alter system archive log current';
backup filesperset=4 format='/oradata/orabk/arch_%T_%d_%s_%p'
archivelog all delete input;
release channel ch1;
release channel ch2;
}
quit;
##################################################
#########/oraapp/oracle/dba/lev1_bkup.sh##########
##################################################
#!/bin/sh
export ORACLE_HOME=/oraapp/oracle/92
export DBA_HOME=/oraapp/oracle/dba
export ORACLE_SID=RCAT
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export NLS_DATE_FORMAT='YYYY-MM-DD_HH24:MI:SS'
$ORACLE_HOME/bin/rman cmdfile $DBA_HOME/lev1_bkup.rcv log $DBA_HOME/log/bkup.log
$ORACLE_HOME/bin/sqlplus /nolog @$DBA_HOME/DBA_rename.sql $DBA_HOME/log/bkup.log
/oraapp/oracle/dba/ora_os.sh &
##################################################
#########/oraapp/oracle/dba/lev1_bkup.rcv#########
##################################################
connect catalog RMAN/RMAN@RCAT;
connect target RMAN/RMAN@PROD;
run {
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
backup incremental
level=1
filesperset=2
tag='Lev1_%d'
format='/oradata/orabk/%T_lev1_%d_%s_%p'
database include current controlfile;
sql 'alter system archive log current';
backup filesperset=4
format='/oradata/orabk/arch_%T_%d_%s_%p'
archivelog all delete input;
release channel ch1;
release channel ch2;
}
quit;
##################################################
#########/oraapp/oracle/dba/lev2_bkup.sh##########
##################################################
#!/bin/sh
export ORACLE_HOME=/oraapp/oracle/92
export DBA_HOME=/oraapp/oracle/dba
export ORACLE_SID=RCVCAT
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export NLS_DATE_FORMAT='YYYY-MM-DD_HH24:MI:SS'
$ORACLE_HOME/bin/rman cmdfile $DBA_HOME/lev2_bkup.rcv log $DBA_HOME/log/bkup.log
$ORACLE_HOME/bin/sqlplus /nolog @$DBA_HOME/DBA_rename.sql $DBA_HOME/log/bkup.log
/oraapp/oracle/dba/ora_os.sh &
##################################################
#########/oraapp/oracle/dba/lev2_bkup.rcv#########
##################################################
connect catalog RMAN/RMAN@RCAT;
connect target RMAN/RMAN@PROD;
run {
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
backup incremental
level=2
filesperset=2
tag='Lev2_%d'
format='/oradata/orabk/%T_lev2_%d_%s_%p'
database include current controlfile;
sql 'alter system archive log current';
backup filesperset=4
format='/oradata/orabk/arch_%T_%d_%s_%p'
archivelog all delete input;
release channel ch1;
release channel ch2;
}
quit;
相关推荐
oraclerman备份原理[参照].pdf
Oracle Rman文档,最详细的Oracle Rman备份文档,权威官方文档
Oracle Rman命令详解,包括rman命令和rman语句解析。
oracle RMAN 备份恢复总结 oracle RMAN 备份恢复总结 oracle RMAN 备份恢复总结
oracle rman备份的脚本,公司近段时间改用rman备份。大家可以看看
oracle rman 的使用介绍,对rman一些场景恢复进行案例分析
window oracle rman 增量备份脚本
Oracle Rman 详解,Oracle Rman 详解。Oracle Rman 详解,Oracle Rman 详解。
详细的介绍了oracle 12c中的Oracle 12c Rman Backup and Recovery
RMAN只能用于ORACLE8或更高的版本中。它能够备份整个数据 库或数据库部件,如表空间、数据文件、控制文件、归档文件以及Spfile参数文件。RMAN 也允许您进行增量数据块级别的备份,增量RMAN备份是时间和空间有效的,...
Oracle RMAN增量备份恢复测试记录
一个完整的Oracle rman备份恢复参考示例,阅读一个完整的Oracle rman备份恢复参考示例,完整的Oracle rman备份恢复参考示例: 1、建rman库作为repository $more createrman_db1.sh set echo on spool makedb1.log ...
学习ORACLE很好的资料,不仅包括RMAN的原理,还包括动手实践部分,一步步教你完全掌握RMAN,在PDF中加入了目录,方便查找,是ORACLE DBA的必备手册。
Oracle数据库RMAN备份与恢复.pdf
oracle rman命令详解,详细的介绍了rman的各种命令
Oracle RMAN快速入门指南的具体介绍
教程名称:傻瓜式实战Oracle RMAN数据库备份和恢复视频课程目录:【】数据库备份和恢复系列].ITBOBA_RMAN_1【】数据库备份和恢复系列].ITBOBA_RMAN_10【】数据库备份和恢复系列].ITBOBA_RMAN_2【】数据库备份和恢复...
顶级DBA漫谈Oracle Rman备份与恢复
旧版Oracle Rman 备份!
RMAN备份技术详解 包括 命令 备份策略 故障恢复等,很实用