论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2011-04-11 18:06 |只看该作者 |倒序浏览

各位好，请问nbu oracle rac 备份成功后怎样恢复到单机环境，要怎样做？我恢复时老是一个数据文件不成功。

文库|博客

zhangmq

丰衣足食

论坛徽章:: 0

2楼 [报告]

发表于 2011-04-11 18:08 |只看该作者

本帖最后由 zhangmq 于 2011-04-13 17:13 编辑

回复 1# zhangmq

恢复脚本：

[oracle@rheloracle ~]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Apr 12 01:35:20 2011

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

connected to target database: RACDB (DBID=744895673, not open)

RMAN> run {
2> allocate channel ch1 device type 'SBT_TAPE' PARMS='ENV=(NB_ORA_CLIENT=node1),SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so';
3> set newname for datafile 1 to '/u01/oracle/oradata/orcl/system.dbf';
4> set newname for datafile 2 to '/u01/oracle/oradata/orcl/undotbs1.dbf';
5> set newname for datafile 3 to '/u01/oracle/oradata/orcl/sysaux.dbf';
6> set newname for datafile 4 to '/u01/oracle/oradata/orcl/undotbs2.dbf';
7> set newname for datafile 5 to '/u01/oracle/oradata/orcl/users.dbf';
8> SQL "ALTER DATABASE RENAME FILE ''+RAC_DISK/racdb/onlinelog/group_1.257.747278919'' TO ''/u01/oracle/oradata/orcl/redo01.log''";
9> SQL "ALTER DATABASE RENAME FILE ''+RAC_DISK/racdb/onlinelog/group_2.258.747278921'' TO ''/u01/oracle/oradata/orcl/redo02.log''";
10> SQL "ALTER DATABASE RENAME FILE ''+RAC_DISK/racdb/onlinelog/group_3.265.747284047'' TO ''/u01/oracle/oradata/orcl/redo03.log''";
11> SQL "ALTER DATABASE RENAME FILE ''+RAC_DISK/racdb/onlinelog/group_4.266.747284049'' TO ''/u01/oracle/oradata/orcl/redo04.log''";
12> RESTORE database;
13> switch datafile all;
14> recover database;
15> RELEASE CHANNEL c1;
16> }

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

zhangmq

丰衣足食

论坛徽章:: 0

3楼 [报告]

发表于 2011-04-11 18:10 |只看该作者

本帖最后由 zhangmq 于 2011-04-11 18:11 编辑

回复 2# zhangmq

输出报错：using target database control file instead of recovery catalog
allocated channel: ch1
channel ch1: sid=156 devtype=SBT_TAPE
channel ch1: Veritas NetBackup for Oracle - Release 6.5 (2007072323)

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

sql statement: ALTER DATABASE RENAME FILE ''+RAC_DISK/racdb/onlinelog/group_1.257.747278919'' TO ''/u01/oracle/oradata/orcl/redo01.log''

sql statement: ALTER DATABASE RENAME FILE ''+RAC_DISK/racdb/onlinelog/group_2.258.747278921'' TO ''/u01/oracle/oradata/orcl/redo02.log''

sql statement: ALTER DATABASE RENAME FILE ''+RAC_DISK/racdb/onlinelog/group_3.265.747284047'' TO ''/u01/oracle/oradata/orcl/redo03.log''

sql statement: ALTER DATABASE RENAME FILE ''+RAC_DISK/racdb/onlinelog/group_4.266.747284049'' TO ''/u01/oracle/oradata/orcl/redo04.log''

Starting restore at 12-APR-11

channel ch1: starting datafile backupset restore
channel ch1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u01/oracle/oradata/orcl/system.dbf
restoring datafile 00004 to /u01/oracle/oradata/orcl/undotbs2.dbf
channel ch1: reading from backup piece bk_41_1_747970869
channel ch1: restored backup piece 1
piece handle=bk_41_1_747970869 tag=HOT_DB_BK_LEVEL0
channel ch1: restore complete, elapsed time: 00:01:05
channel ch1: starting datafile backupset restore
channel ch1: specifying datafile(s) to restore from backup set
restoring datafile 00002 to /u01/oracle/oradata/orcl/undotbs1.dbf
restoring datafile 00003 to /u01/oracle/oradata/orcl/sysaux.dbf
restoring datafile 00005 to /u01/oracle/oradata/orcl/users.dbf
channel ch1: reading from backup piece bk_42_1_747970870
channel ch1: restored backup piece 1
piece handle=bk_42_1_747970870 tag=HOT_DB_BK_LEVEL0
channel ch1: restore complete, elapsed time: 00:01:05
Finished restore at 12-APR-11

Starting recover at 12-APR-11

starting media recovery
media recovery failed
released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 04/12/2011 01:38:33
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
start until cancel using backup controlfile
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 1: '/u01/oracle/oradata/orcl/sysaux.261.747278963'
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '/u01/oracle/oradata/orcl/sysaux.261.747278963'

RMAN> alter database open resetlogs;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 04/12/2011 01:39:53
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '/u01/oracle/oradata/orcl/sysaux.261.747278963'