“革命尚未成功 同志仍需努力”
[
2010/03/14 22:07 | by askwan ]
2010/03/14 22:07 | by askwan ]
今年的“两会”就要开完了，再听听《走向共和》中国父的演讲……
“革命尚未成功 同志仍需努力”
“Revolution does not succeed yet, comrades still need to struggle！”
------国父 孙中山
“革命尚未成功 同志仍需努力”
“Revolution does not succeed yet, comrades still need to struggle！”
------国父 孙中山
configuration oracle data guard for testing
[ 2010/03/11 14:39 | by askwan ]
2010/03/11 14:39 | by askwan ]
OS: CentOS 5.4 x86_64
Oracle: Oracle 10.2.0.1 64bit for linux
题外话：有些东西长时间不接触，而理解又不深刻的话，慢慢就淡忘了。。。
这个笔记是边参考文档oracle 10g《Data Guard Concepts and Administration》，边验证记录下的
仅供参考
单机环境配置oracle 10g dataguard (physical standby)
IP：192.168.0.21
预期规划如下：
主库：
db_name=dg1
sid=dg1
db_unique_name=primary
network_service_name=primary_21
ORACLE_BASE=/u01/oracle
ORACLE_HOME=/u01/oracle/product/10.2.0/db_1
数据文件路径=/u01/oracle/oradata/dg1
归档日志路径=/u01/oracle/oradata/dg1/archive
警告跟踪等日志文件路径=/u01/oracle/admin/dg1/
从库：
dg_name=dg1
sid=standby
db_unique_name=standby
network_service_name=standby_21
ORACLE_BASE=/u01/oracle
ORACLE_HOME=/u01/oracle/product/10.2.0/db_1
数据文件路径=/u01/oracle/oradata/standby
归档日志路径=/u01/oracle/oradata/standby/archive
警告跟踪等日志文件路径=/u01/oracle/admin/standby
1 准备工作
Oracle: Oracle 10.2.0.1 64bit for linux
题外话：有些东西长时间不接触，而理解又不深刻的话，慢慢就淡忘了。。。
这个笔记是边参考文档oracle 10g《Data Guard Concepts and Administration》，边验证记录下的
仅供参考
单机环境配置oracle 10g dataguard (physical standby)
IP：192.168.0.21
预期规划如下：
主库：
db_name=dg1
sid=dg1
db_unique_name=primary
network_service_name=primary_21
ORACLE_BASE=/u01/oracle
ORACLE_HOME=/u01/oracle/product/10.2.0/db_1
数据文件路径=/u01/oracle/oradata/dg1
归档日志路径=/u01/oracle/oradata/dg1/archive
警告跟踪等日志文件路径=/u01/oracle/admin/dg1/
从库：
dg_name=dg1
sid=standby
db_unique_name=standby
network_service_name=standby_21
ORACLE_BASE=/u01/oracle
ORACLE_HOME=/u01/oracle/product/10.2.0/db_1
数据文件路径=/u01/oracle/oradata/standby
归档日志路径=/u01/oracle/oradata/standby/archive
警告跟踪等日志文件路径=/u01/oracle/admin/standby
1 准备工作
A friend company's Linux server ext3 filesystem becomes read only
[ 2010/03/08 11:12 | by askwan ]
2010/03/08 11:12 | by askwan ]
System has been restarted everything seemed normal, the application starts normally! View the system boot log, there is no exception, the specific reasons for this situation also unknown now! It seems need to continue to observe.
However, open system, found that swap partition 0
Is it did not installed the system swap partition?
output Nothing, there is no swap partition indeed !
this System has 4G mem, so additional 8G swap space manually
[root@youke2 log]# mkswap /tmp/swapfree
Setting up swapspace version 1, size = 8589930 kB
Re-examine swap partition:
[root@youke2 log]# cat /proc/swaps
Filename Type Size Used Priority
/tmp/swapfree file 8388600 0 -1
USE top TO CHECK
OK! write this to fstab file,so it can valid at system start time !
However, open system, found that swap partition 0
Swap: 0k total, 0k used, 0k free, 300496k cached
Is it did not installed the system swap partition?
[root@youke2 log]# cat /proc/swaps
output Nothing, there is no swap partition indeed !
this System has 4G mem, so additional 8G swap space manually
[root@youke2 log]# dd if=/dev/zero of=/tmp/swapfree bs=1024K count=8192
8192+0 records in 8192+0 records out 8589934592 bytes (8.6 GB) copied, 111.247 seconds, 77.2 MB/s
8192+0 records in 8192+0 records out 8589934592 bytes (8.6 GB) copied, 111.247 seconds, 77.2 MB/s
[root@youke2 log]# mkswap /tmp/swapfree
Setting up swapspace version 1, size = 8589930 kB
[root@youke2 log]# swapon /tmp/swapfree
Re-examine swap partition:
[root@youke2 log]# cat /proc/swaps
Filename Type Size Used Priority
/tmp/swapfree file 8388600 0 -1
USE top TO CHECK
Tasks: 145 total, 1 running, 144 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.1%us, 0.2%sy, 0.0%ni, 94.4%id, 5.3%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 4138172k total, 3834908k used, 303264k free, 28220k buffers
Swap: 8388600k total, 0k used, 8388600k free, 3605544k cached
Cpu(s): 0.1%us, 0.2%sy, 0.0%ni, 94.4%id, 5.3%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 4138172k total, 3834908k used, 303264k free, 28220k buffers
Swap: 8388600k total, 0k used, 8388600k free, 3605544k cached
OK! write this to fstab file,so it can valid at system start time !
/tmp/swapfree swap swap defaults 0 0
a simple oracle rman backup script
[ 2010/03/05 16:17 | by askwan ]
2010/03/05 16:17 | by askwan ]
Note:this backup script is suitable for db size < 200G,
and for backup file safety ,may be you should use an independent disk to store backup files
1 configuration target database to archive log mode
2 configuration or check log_archive_dest and db_recovery_file_dest or log_archive_dest_n
3 write a rman script
oracle@dbtest:~$ vim backup.rman
4 write backup shell script
oracle@dbtest:~$ vim backup.sh
5 set cronjob for user oracle
and for backup file safety ,may be you should use an independent disk to store backup files
1 configuration target database to archive log mode
2 configuration or check log_archive_dest and db_recovery_file_dest or log_archive_dest_n
3 write a rman script
oracle@dbtest:~$ vim backup.rman
run{
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 15 DAYS;
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/opt/oracle/orabak/ctfile_%F';
ALLOCATE CHANNEL C1 DEVICE TYPE DISK FORMAT '/opt/oracle/orabak/DBFULL_%U';
BACKUP DATABASE SKIP INACCESSIBLE PLUS ARCHIVELOG FILESPERSET 20 DELETE ALL INPUT;
DELETE OBSOLETE;
RELEASE CHANNEL C1;
}
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 15 DAYS;
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/opt/oracle/orabak/ctfile_%F';
ALLOCATE CHANNEL C1 DEVICE TYPE DISK FORMAT '/opt/oracle/orabak/DBFULL_%U';
BACKUP DATABASE SKIP INACCESSIBLE PLUS ARCHIVELOG FILESPERSET 20 DELETE ALL INPUT;
DELETE OBSOLETE;
RELEASE CHANNEL C1;
}
4 write backup shell script
oracle@dbtest:~$ vim backup.sh
#!/bin/bash
export ORACLE_BASE=/opt/oracle
export ORACLE_SID=capitalv
export ORACLE_HOME=$ORACLE_BASE/oracle/product/10.2.0/db_1
PATH=/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:/bin:/sbin:$PATH;
export PATH=$ORACLE_HOME/bin:$PATH
rman TARGET / log='/opt/oracle/orabak/rman.log' cmdfile='/opt/oracle/backup.rman'
export ORACLE_BASE=/opt/oracle
export ORACLE_SID=capitalv
export ORACLE_HOME=$ORACLE_BASE/oracle/product/10.2.0/db_1
PATH=/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:/bin:/sbin:$PATH;
export PATH=$ORACLE_HOME/bin:$PATH
rman TARGET / log='/opt/oracle/orabak/rman.log' cmdfile='/opt/oracle/backup.rman'
5 set cronjob for user oracle
30 02 * * 0,3 bash /opt/oracle/backup.sh
