- 论坛徽章:
- 0
|
多谢二位的回复,问题还是没有解决,下面我把恢复过程贴出来,请指正。
[oracle@xdbbak ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Mon Feb 10 11:48:51 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> shutdown immediate
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup nomount pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/nxdbpfile.ora';
ORACLE instance started.
Total System Global Area 1.6034E+11 bytes
Fixed Size 2236968 bytes
Variable Size 1.0630E+11 bytes
Database Buffers 5.3687E+10 bytes
Redo Buffers 352468992 bytes
SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@xdbbak ~]$ rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Mon Feb 10 11:51:32 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: NXDB (not mounted)
RMAN> connect catalog rman/rman@rman;
connected to recovery catalog database
RMAN> run{
2> allocate channel c1 device type 'sbt'
3> parms="ENV=(NB_ORA_CLIENT=xdb148,NB_ORA_SERV=szt-nbu)";
4> restore controlfile;
5> release channel c1;
6> }
allocated channel: c1
channel c1: SID=755 device type=SBT_TAPE
channel c1: Veritas NetBackup for Oracle - Release 7.1 (2011120719)
Starting restore at 10-FEB-14
channel c1: starting datafile backup set restore
channel c1: restoring control file
channel c1: reading from backup piece c-1819409807-20140210-06
channel c1: piece handle=c-1819409807-20140210-06 tag=TAG20140210T112049
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:00:25
output file name=+DATA1/nxdb/controlfile/current.256.839159539
Finished restore at 10-FEB-14
released channel: c1
RMAN> alter database mount;
database mounted
RMAN> run{
2> allocate channel c1 device type 'sbt'
3> parms="ENV=(NB_ORA_CLIENT=xdb148,NB_ORA_SERV=szt-nbu)";
4> allocate channel c2 device type 'sbt'
5> parms="ENV=(NB_ORA_CLIENT=xdb148,NB_ORA_SERV=szt-nbu)";
6> allocate channel c3 device type 'sbt'
parms="ENV=(NB_ORA_CLIENT=xdb148,NB_ORA_SERV=szt-nbu)";
7> 8> allocate channel c4 device type 'sbt'
9> parms="ENV=(NB_ORA_CLIENT=xdb148,NB_ORA_SERV=szt-nbu)";
restore database;
10> 11> recover database;
12> release channel c1;
13> release channel c2;
14> release channel c3;
release channel c4;
15> 16> }
allocated channel: c1
channel c1: SID=504 device type=SBT_TAPE
channel c1: Veritas NetBackup for Oracle - Release 7.1 (2011120719)
allocated channel: c2
channel c2: SID=1257 device type=SBT_TAPE
channel c2: Veritas NetBackup for Oracle - Release 7.1 (2011120719)
allocated channel: c3
channel c3: SID=1508 device type=SBT_TAPE
channel c3: Veritas NetBackup for Oracle - Release 7.1 (2011120719)
allocated channel: c4
channel c4: SID=1759 device type=SBT_TAPE
channel c4: Veritas NetBackup for Oracle - Release 7.1 (2011120719)
Starting restore at 10-FEB-14
creating datafile file number=421 name=+DATA1/nxdb/datafile/info.361.839147347
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00003 to +DATA/nxdb/datafile/undotbs1.520.810404497
channel c1: reading from backup piece bk_116631_1_839066496
channel c2: starting datafile backup set restore
channel c2: specifying datafile(s) to restore from backup set
channel c2: restoring datafile 00387 to +DATA/nxdb/datafile/centerdbt.554.813839913
channel c2: reading from backup piece bk_116633_1_839066496
channel c3: starting datafile backup set restore
channel c3: specifying datafile(s) to restore from backup set
channel c3: restoring datafile 00388 to +DATA/nxdb/datafile/centerdbt.555.813840015
channel c3: reading from backup piece bk_116634_1_839066496
channel c4: starting datafile backup set restore
channel c4: specifying datafile(s) to restore from backup set
channel c4: restoring datafile 00384 to +DATA/nxdb/datafile/centerdbt.550.811592521
channel c4: reading from backup piece bk_116632_1_839066496
channel c1: piece handle=bk_116631_1_839066496 tag=HOT_DB_BK_LEVEL0
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:08:36
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00398 to +DATA1/nxdb/datafile/tab_2013.354.822731241
channel c1: reading from backup piece bk_116637_1_839067145
channel c2: piece handle=bk_116633_1_839066496 tag=HOT_DB_BK_LEVEL0
channel c2: restored backup piece 1
channel c2: restore complete, elapsed time: 00:15:01
channel c2: starting datafile backup set restore
channel c2: specifying datafile(s) to restore from backup set
channel c2: restoring datafile 00397 to +DATA1/nxdb/datafile/tab_2013.353.822646653
channel c2: reading from backup piece bk_116636_1_839067142
channel c3: piece handle=bk_116634_1_839066496 tag=HOT_DB_BK_LEVEL0
channel c3: restored backup piece 1
channel c3: restore complete, elapsed time: 00:15:01
channel c3: starting datafile backup set restore
channel c3: specifying datafile(s) to restore from backup set
channel c3: restoring datafile 00391 to +DATA1/nxdb/datafile/tab_2013.351.816164479
channel c3: reading from backup piece bk_116635_1_839067142
channel c4: piece handle=bk_116632_1_839066496 tag=HOT_DB_BK_LEVEL0
启动数据库的参数文件是从生产环境拷贝过来的,删除了rac的相关内容。从恢复的日志上看是有文件恢复到DATA1上的,比如restoring datafile 00391 to +DATA1/nxdb/datafile/tab_2013.351.816164479,但是进到磁盘组中查看,这个文件并没有恢复到DATA1上,而是恢复到了DATA上,这是为什么那? |
|