rman远程nfs备份不完全回复

最新推荐文章于 2024-04-07 22:22:09 发布

我心无悔dcw

最新推荐文章于 2024-04-07 22:22:09 发布

阅读量735

点赞数

分类专栏： OracleRman 文章标签： oracle rman nfs 数据库备份

本文链接：https://blog.csdn.net/dcwnb1/article/details/17419279

版权

OracleRman 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

192.168.0.47是测试机，192.168.0.45回复数据库，以下47代表192.168.0.47，45代表192.168.0.45
rman在47备份然后用nfs共享47的目录到45上。尝试用45回复数据

47：rman备份
vim /oradata/backup/rman/scripts/rmanbackup.sh
umask 022
export PATH
export ORACLE_BASE=/opt
export ORACLE_HOME=$ORACLE_BASE/oracle/product
export ORACLE_SID=orcl
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib
export LANG=EN

t1=`date +%a`

if [ $t1 = "Wed" ];then
rman target / nocatalog <<EOF
RUN
{
ALLOCATE CHANNEL 'DEV1' TYPE DISK;
ALLOCATE CHANNEL 'DEV2' TYPE DISK;
ALLOCATE CHANNEL 'DEV3' TYPE DISK;
BACKUP INCREMENTAL LEVEL 0 TAG 'LV0' FORMAT '/oradata/backup/rman/LV0/orclLV0_%T_db+%s_%p_%t' DATABASE PLUS ARCHIVELOG DELETE ALL INPUT;
DELETE NOPROMPT OBSOLETE;
RELEASE CHANNEL DEV1;
RELEASE CHANNEL DEV2;
RELEASE CHANNEL DEV3;
}
exit
EOF

else
rman target / nocatalog <<EOF
RUN
{
ALLOCATE CHANnEL 'DEV1' TYPE DISK;
ALLOCATE CHANNEL 'DEV2' TYPE DISK;
ALLOCATE CHANNEL 'DEV3' TYPE DISK;
BACKUP INCREMENTAL LEVEL 1 TAG 'LV1' FORMAT '/oradata/backup/rman/LV1/orclLV1_%T_db_%s_%p_%t' DATABASE PLUS ARCHIVELOG DELETE ALL INPUT;
DELETE NOPROMPT OBSOLETE;
RELEASE CHANNEL DEV1;
RELEASE CHANNEL DEV2;
RELEASE CHANNEL DEV3;
}
exit
EOF
fi

执行备份：
[oracle@localhost ~]$ /oradata/backup/rman/scripts/rmanbackup.sh

一、配置nfs共享目录
47：
安装nfs软件
yum install nfs

启动服务
[root@localhost scripts]# service nfs start
启动 NFS 服务： [确定]
关掉 NFS 配额： [确定]
启动 NFS 守护进程： [确定]
启动 NFS mountd： [确定]
[root@localhost oradata]# service portmap restart
停止 portmap： [确定]
启动 portmap： [确定]

配置文件
[root@localhost oradata]# cat /etc/exports
/oradata/backup 192.168.0.45(rw,no_root_squash)

加载配置文件
[root@localhost oradata]# exportfs -r

查看共享目录
[root@localhost oradata]# showmount -e 192.168.0.47
Export list for 192.168.0.47:
/oradata/backup 192.168.0.45

45：
看看共享目录：
[root@localhost oracle_rpm]# showmount -e 192.168.0.47
Export list for 192.168.0.47:
/oradata/backup 192.168.0.45

挂在到指定文件目录
[root@localhost /]# mount -o rw,bg,intr,hard,timeo=600,wsize=32768,rsize=32768 -t nfs 192.168.0.47:/oradata/backup /oradata/backup/

可以看见挂账的备份文件了
[root@localhost /]# ls /oradata/backup/
arch/ rman/
[root@localhost /]# ls /oradata/backup/rman/
controlfile/ logs/ LV0/ LV1/ scripts/
[root@localhost /]# ls /oradata/backup/rman/LV
LV0/ LV1/
[root@localhost /]# ls /oradata/backup/rman/LV0/
20131216_834342313 orclLV0_20131216_db+7_1_834333628 orclLV0_20131218_db+21_1_834506757
orclLV0_20131216_db+3_1_834333626 orclLV0_20131216_db+8_1_834333654 orclLV0_20131218_db+22_1_834506760
orclLV0_20131216_db+4_1_834333626 orclLV0_20131218_db+18_1_834506756 orclLV0_20131218_db+23_1_834506760
orclLV0_20131216_db+5_1_834333628 orclLV0_20131218_db+19_1_834506756 orclLV0_20131218_db+24_1_834506760
orclLV0_20131216_db+6_1_834333628 orclLV0_20131218_db+20_1_834506756 orclLV0_20131218_db+25_1_834506775

rman回复：
前提：需要安装oracle数据库软件，不需要安装数据库

由于是直接挂在的所以不需要创建备份目录

创建数据文件目录和47的要一样:mkdir -p /oradata/orcl

从47拷贝参数文件：scp dcw.ora 192.168.0.45:/home/oracle/ ------这个是文本文件便于修改

vim dcw.ora 修改此文件，参数要与45本机的相对应
orcl.__db_cache_size=1291845632
orcl.__java_pool_size=33554432
orcl.__large_pool_size=16777216
orcl.__oracle_base='/opt'#ORACLE_BASE set from environment
orcl.__pga_aggregate_target=1174405120
orcl.__sga_target=2181038080
orcl.__shared_io_pool_size=0
orcl.__shared_pool_size=771751936
orcl.__streams_pool_size=33554432
*.aq_tm_processes=0
*.audit_file_dest='/opt/admin/orcl/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_file_record_keep_time=30
*.control_files='/oradata/orcl/control01.ctl','/opt/flash_recovery_area/orcl/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='orcl'
*.db_recovery_file_dest='/opt/flash_recovery_area'
*.db_recovery_file_dest_size=4070572032
*.deferred_segment_creation=FALSE
*.diagnostic_dest='/opt'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.job_queue_processes=0
#*.local_listener='LISTENER_ORCL'
*.log_archive_dest_1='location=/oradata/backup/arch'
*.memory_target=3343908864
*.open_cursors=300
*.processes=3000
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'

没有的要对应上
mkdir -p /opt/admin/orcl/adump
mkdir -p /opt/flash_recovery_area/orcl

指定文本参数文件并创建二进制参数文件：
SQL>startup nomount pfile='/home/oracle/dcw.ora';
SQL> create spfile from pfile='/home/oracle/dcw.ora';

47：备份后我又在scott下创建表，看是否可以回复
SQL> conn scott/tiger
Connected.
SQL> select * from tab;

TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
BONUS TABLE
DEPT TABLE
E3 TABLE
EMP TABLE
MENU TABLE
SALGRADE TABLE

6 rows selected.

SQL> create table t(id number(2));

Table created.

SQL> insert into t values(1);

1 row created.

SQL> insert into t values(2);

1 row created.

SQL> insert into t values(3);

1 row created.

SQL> commit;

Commit complete.
SQL> alter system switch logfile;

System altered.

SQL> alter system switch logfile;

System altered.

SQL> alter system switch logfile;

System altered.

45：
[oracle@localhost arch]$ ls
1_6_834369688.dbf 1_7_834369688.dbf 1_8_834369688.dbf

回复控制文件和数据文件：
rman target /
RMAN>restore controlfile from ' /oradata/backup/rman/controlc-1331001293-20131218-01'; ----------产生控制文件（[root@localhost orcl]# ls ----》control01.ctl）

Starting restore at 19-DEC-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1135 device type=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/oradata/orcl/control01.ctl
output file name=/opt/flash_recovery_area/orcl/control02.ctl
Finished restore at 19-DEC-13

RMAN> alter database mount; 加载到mount状态

database mounted
released channel: ORA_DISK_1

RMAN>restore database; --------------产生数据文件

Starting restore at 19-DEC-13
Starting implicit crosscheck backup at 19-DEC-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1135 device type=DISK
Crosschecked 21 objects
Finished implicit crosscheck backup at 19-DEC-13

Starting implicit crosscheck copy at 19-DEC-13
using channel ORA_DISK_1
Finished implicit crosscheck copy at 19-DEC-13

searching for all files in the recovery area
cataloging files...
no files cataloged

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00004 to /oradata/orcl/user01.dbf
channel ORA_DISK_1: restoring datafile 00006 to /oradata/orcl/test01.dbf
channel ORA_DISK_1: restoring datafile 00007 to /oradata/orcl/sms01.dbf
channel ORA_DISK_1: reading from backup piece /oradata/backup/rman/LV0/orclLV0_20131218_db+24_1_834506760
channel ORA_DISK_1: piece handle=/oradata/backup/rman/LV0/orclLV0_20131218_db+24_1_834506760 tag=LV0
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /oradata/orcl/system01.dbf
channel ORA_DISK_1: restoring datafile 00010 to /oradata/orcl/ziwei.dbf
channel ORA_DISK_1: reading from backup piece /oradata/backup/rman/LV0/orclLV0_20131218_db+23_1_834506760
channel ORA_DISK_1: piece handle=/oradata/backup/rman/LV0/orclLV0_20131218_db+23_1_834506760 tag=LV0
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:05
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00002 to /oradata/orcl/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /oradata/orcl/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /oradata/orcl/example01.dbf
channel ORA_DISK_1: reading from backup piece /oradata/backup/rman/LV0/orclLV0_20131218_db+22_1_834506760
channel ORA_DISK_1: piece handle=/oradata/backup/rman/LV0/orclLV0_20131218_db+22_1_834506760 tag=LV0
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:05
Finished restore at 19-DEC-13

（
[root@localhost orcl]# ls
control01.ctl example01.dbf sms01.dbf sysaux01.dbf system01.dbf test01.dbf undotbs01.dbf user01.dbf ziwei.dbf
）

RMAN> recover database; 可能会出错但是这可能是因为日志不全的原因，事实上是没问题的

Starting recover at 19-DEC-13
using channel ORA_DISK_1

starting media recovery

channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=5
channel ORA_DISK_1: reading from backup piece /oradata/backup/rman/LV0/orclLV0_20131218_db+25_1_834506775
channel ORA_DISK_1: piece handle=/oradata/backup/rman/LV0/orclLV0_20131218_db+25_1_834506775 tag=LV0
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/oradata/backup/arch/1_5_834369688.dbf thread=1 sequence=5
archived log file name=/oradata/backup/arch/1_6_834369688.dbf thread=1 sequence=6
archived log file name=/oradata/backup/arch/1_7_834369688.dbf thread=1 sequence=7
archived log file name=/oradata/backup/arch/1_8_834369688.dbf thread=1 sequence=8
unable to find archived log
archived log thread=1 sequence=9
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 12/19/2013 02:48:59
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 9 and starting SCN of 10799816364801

开一个session执行：缺少1_9_834369688.dbf

RMAN>alter database open resetlogs; -------------------产生redo文件

45：
验证
[oracle@localhost controlfile]$ sqlplus scott/tiger

SQL*Plus: Release 11.2.0.1.0 Production on Thu Dec 19 02:58:29 2013

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

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

SQL> select * from t;

ID
----------
1
2
3