备份与恢复:用rman方式基于scn的不完全恢复

SQL> create table test(a int);

Table created.

SQL> insert into test values(1);

1 row created.

SQL> commit;

Commit complete.

Cundefinedocuments 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.

Cundefinedocuments 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

Cundefinedocuments 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.

Cundefinedocuments 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>