恢复问题

pulf

删除一个文件后，恢复的时候还是把备份的文件拷贝回来。但是起来后还是没有/

hxhy

如果是测试的话，
把所有文件都用原先的备份文件覆盖，再测试．

我上面有人

当然没有了，你要恢复到删除表的时间前才行。

anycall2010

恩 ，这个问题 以前也困扰过我

pulf

时间点没有问题。


我在做增加表和删除表之前作了一个数据文件的冷备份。这样就可以了。

我还是有个疑问：

既然我是archive模式，所有的日至和archive文件都在，为啥还有把备份的文件恢复出来？

棉花糖ONE

以后你没有一个恢复的起点,需要表删除之前的数据文件备份就行

paulyibinyi

你那失败的原因是要备份后+归档日志或(在线日志实现不完全恢复)以下是例子

SQL> create table test(a int);

Table created.

SQL> insert into test values(1);

1 row created.

SQL> commit;

Commit complete.


Cocuments and SettingsPaul Yi>rman target /

Recovery Manager: Release 9.2.0.4.0 - Production

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

connected to target database: PUBTEST (DBID=792660220)

RMAN> run{allocate channel c1 type disk;
2> backup full tag 'dbfull' format 'd:ackupfull%u_%s_%p' database
3> include current controlfile;
4> sql 'alter system archive log current';
5> release channel c1;
6> }

using target database controlfile instead of recovery catalog
allocated channel: c1
channel c1: sid=12 devtype=DISK

Starting backup at 08-APR-08
channel c1: starting full datafile backupset
channel c1: specifying datafile(s) in backupset
including current SPFILE in backupset
including current controlfile in backupset
input datafile fno=00001 name=D:ORACLEORADATAPUBTESTSYSTEM01.DBF
input datafile fno=00002 name=D:ORACLEORADATAPUBTESTUNDOTBS01.DBF
input datafile fno=00003 name=D:ORACLEORADATAPUBTESTINDX01.DBF
input datafile fno=00005 name=D:ORACLEORADATAPUBTESTUSERS01.DBF
channel c1: starting piece 1 at 08-APR-08
channel c1: finished piece 1 at 08-APR-08
piece handle=D:BACKUPFULL01JDAN3K_1_1 comment=NONE
channel c1: backup set complete, elapsed time: 00:01:59
Finished backup at 08-APR-08

sql statement: alter system archive log current

released channel: c1

RMAN> exit


Recovery Manager complete.

Cocuments and SettingsPaul Yi>sqlplus "/as sysdba"

SQL*Plus: Release 9.2.0.4.0 - Production on Tue Apr 8 16:59:38 2008

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


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

SQL> insert into test values(2);

1 row created.

SQL> commit;

Commit complete.


SQL> select * from test;

         A
----------
         1
         2

SQL> alter system switch logfile;

System altered.

SQL> alter system switch logfile;

System altered.

SQL> select max(ktuxescnw * power(2, 32) + ktuxescnb) scn from x$ktuxe;

       SCN
----------
   1195547

SQL> drop table test;

Table dropped.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area  546382300 bytes
Fixed Size                   455132 bytes
Variable Size             520093696 bytes
Database Buffers           25165824 bytes
Redo Buffers                 667648 bytes
Database mounted.
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

Cocuments and SettingsPaul Yi>rman target /

Recovery Manager: Release 9.2.0.4.0 - Production

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

connected to target database: PUBTEST (DBID=792660220)

RMAN> run{
2> allocate channel c1 type disk;
3> restore database;
4> recover database until scn 1195547;
5> sql 'alter database open resetlogs';
6> release channel c1;
7> }

using target database controlfile instead of recovery catalog
allocated channel: c1
channel c1: sid=11 devtype=DISK

Starting restore at 08-APR-08

datafile 3 not processed because file is read-only
channel c1: starting datafile backupset restore
channel c1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to D:ORACLEORADATAPUBTESTSYSTEM01.DBF
restoring datafile 00002 to D:ORACLEORADATAPUBTESTUNDOTBS01.DBF
restoring datafile 00005 to D:ORACLEORADATAPUBTESTUSERS01.DBF
channel c1: restored backup piece 1
piece handle=D:BACKUPFULL01JDAN3K_1_1 tag=DBFULL params=NULL
channel c1: restore complete
Finished restore at 08-APR-08

Starting recover at 08-APR-08
datafile 3 not processed because file is read-only

starting media recovery

archive log thread 1 sequence 1 is already on disk as file D:ORACLEORA92RDBMS
ARC00001.001
archive log thread 1 sequence 2 is already on disk as file D:ORACLEORA92RDBMS
ARC00002.001
archive log filename=D:ORACLEORA92RDBMSARC00001.001 thread=1 sequence=1
media recovery complete
Finished recover at 08-APR-08

sql statement: alter database open resetlogs

released channel: c1

RMAN> exit


Recovery Manager complete.

Cocuments and SettingsPaul Yi>sqlplus "/as sysdba"

SQL*Plus: Release 9.2.0.4.0 - Production on Tue Apr 8 17:05:03 2008

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


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

SQL> select * from test;

         A
----------
         1

SQL>

[ 本帖最后由 paulyibinyi 于 2008-4-8 17:07 编辑 ]

wobenkl

你没有归档

wobenkl

1、create table test as select * from v$logfile;
2、commit;
3、select  current_scn from v$database;
      纪录下来scn
4、alter system switch logfile;
5、drop table test;
6、shutdown immediate
7、startup mount
8、recover database until change xxxx
9、alter database open resetlogs;
10、select * from test;