Oracle rman每次backup只能restore一次吗？

xswj77

我用rman做了数据库backup。
Recovery Manager: Release 9.2.0.7.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: FRWK (DBID=2290337575)
connected to recovery catalog database

RMAN> resync catalog;
2> change archivelog all validate;
3> run
4> {
5>   allocate channel d1 type disk;
6>   setlimit channel d1 kbytes 2097150 maxopenfiles 32 readrate 200;
7>   backup
8>     filesperset 20
9>     format '/database/backup_data/al_t%t_s%s_p%p'
10>     archivelog all
11>     delete input
12>     skip inaccessible;
13>   sql 'alter system archive log current';
14>   backup
15>     full
16>     skip inaccessible
17>     tag b_db_full
18>     filesperset 6
19>     format '/database/backup_data/df_t%t_s%s_p%p'
20>     database
21>     include current controlfile
22>     plus archivelog format '/database/backup_data/al_t%t_s%s_p%p';
23>   release channel d1;
24> }
25>

restore的脚本是：
5> run
6> {
7> allocate channel d1 device type disk;
8> allocate channel d2 device type disk;
9> allocate channel d3 device type disk;
10> allocate channel d4 device type disk;
11> set until scn 5084664;
12> restore database check readonly;
13> recover database noredo;
14> recover database;
15> release channel d4;
16> release channel d3;
17> release channel d2;
18> release channel d1;
19> }

备份成功后，第一次restore都能 成功，但是第二次总是失败log如下：
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/24/2006 23:17:28
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20003: target database incarnation not found in recovery catalog

Recovery Manager complete.
Rebuild temporary tablespace
CREATE TEMPORARY TABLESPACE "TEMPDBA" TEMPFILE '/database/oradata2/GCOTA/TEMPDBA.dbf' SIZE 10M
*
ERROR at line 1:
ORA-01109: database not open


ALTER DATABASE DEFAULT TEMPORARY TABLESPACE "TEMPDBA"
*
ERROR at line 1:
ORA-01109: database not open
请问是什么原因。难道rman的backup只能恢复一次吗？

[ 本帖最后由 xswj77 于 2006-7-25 17:15 编辑 ]

xswj77

自己顶一下，有人知道吗？

123ok

两次备份中间有做过resetlogs open吗

如果没有，在reset database试一下

[ 本帖最后由 123ok 于 2006-7-26 09:59 编辑 ]

imtj

RMAN-20003: target database incarnation not found in recovery catalog
你要从新注册一下数据库
reset database

jieyancai

楼主第一次恢复后resetlogs open过了吧？

xswj77

多些几位大侠指教。明天马上试验一下。我没有做resetlogs open

xswj77

我发现有resetlog open啊。
现在的错误又是：
Recovery Manager: Release 9.2.0.4.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: RCA (not mounted)
connected to recovery catalog database

RMAN> shutdown immediate;
2> startup nomount;
3> restore controlfile;
4> alter database mount;
5> run
6> {
7> allocate channel d1 device type disk;
8> allocate channel d2 device type disk;
9> allocate channel d3 device type disk;
10> allocate channel d4 device type disk;
11> set until scn 5176195;
12> restore database check readonly;
13> recover database noredo;
14> recover database;
15> release channel d4;
16> release channel d3;
17> release channel d2;
18> release channel d1;
19> }
20> alter database open resetlogs;
21>
Oracle instance shut down

connected to target database (not started)
Oracle instance started

Total System Global Area     875108188 bytes

Fixed Size                      452444 bytes
Variable Size                201326592 bytes
Database Buffers             671088640 bytes
Redo Buffers                   2240512 bytes

Starting restore at 27-JUL-06

allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=13 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/27/2006 09:58:53
RMAN-06026: some targets not found - aborting restore
RMAN-06024: no backup or copy of the controlfile found to restore

Recovery Manager complete.
Rebuild temporary tablespace
CREATE TEMPORARY TABLESPACE "TEMPDBA" TEMPFILE '/data2/oradata2/GCOTA/TEMPDBA.dbf' SIZE 10M
*
ERROR at line 1:
ORA-01109: database not open

请问resetlog是重置redo log吗？

xswj77

reset database主要是做什么工作呢？
RMAN> reset database;

starting full resync of recovery catalog
full resync complete
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of reset command on default channel at 07/27/2006 10:29:53
RMAN-20009: database incarnation already registered

RMAN> list incarnation of database;


List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            CUR Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       2       FRWK     2172095461       NO  1          21-AUG-02
1       1210    FRWK     2172095461       YES 2242851    26-JUL-06
16      17      RCA      2335250016       NO  1          21-AUG-02
16      2264    RCA      2335250016       YES 5176197    27-JUL-06
51      52      SAS      2877756827       NO  1          21-AUG-02
51      1870    SAS      2877756827       YES 2226974    26-JUL-06

johndoe

有意思..没试过用catalog来用rman呢

imtj

没有发现你原来数据库
DBID:2290337575
只有其他的数据库，所以你没有办法恢复起来， 你还是先
select * from db
然后重新注册同步数据库！