oracle中对UNNAMEDnnnnn文件的处理-mysql教程

一：构造一个UNNAMEDnnnnn文件其中nnnnn为数据文件绝对文件号1控制文件备份时当前联机日志状态如下selectgroup#,archived,sequence#,statusfromv$logGROUP#ARCSE

一：构造一个UNNAMEDnnnnn文件

其中nnnnn为数据文件绝对文件号

1 控制文件备份时当前联机日志状态如下

select group#,archived,sequence#,status from v$log

GROUP# ARC SEQUENCE# STATUS

---------- --- ---------- ----------------

1 YES 2 ACTIVE

2 YES 1 ACTIVE

3 YES 3 ACTIVE

4 YES 4 ACTIVE

5 YES 5 ACTIVE

6 NO 6 CURRENT

2 当前控制控制文件备份如下

RMAN> list backup of controlfile;

List of Backup Sets

===================

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

5 Full 7.11M DISK 00:00:03 14-DEC-12

BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20121214T062943

Piece Name: /oracle/app/db1/dbs/0fnsqnsl_1_1

Control File Included: Ckp SCN: 2779647876 Ckp time: 14-DEC-12

3 创建表空间及测试数据时日志状态如下：

SQL> select group#,archived,sequence#,status from v$Log;

GROUP# ARC SEQUENCE# STATUS

---------- --- ---------- ----------------

1 YES 14 INACTIVE

2 YES 13 INACTIVE

3 NO 15 CURRENT

4 YES 10 INACTIVE

5 YES 11 INACTIVE

6 YES 12 INACTIVE

4 此时创建表空间

SQL> create tablespace jiujian datafile '/oracle/test/jiujian.dbf' size 1m;

Tablespace created.

SQL> select file#,name from v$datafile;

FILE# NAME

---------- ----------------------------------------

1 /oracle/test/system1.dbf

2 /oracle/test/zxb.dbf

3 /oracle/test/sysaux01.dbf

4 /oracle/test/users01.dbf

5 /oracle/test/zxa.dbf

6 /oracle/test/test1.dbf

7 /oracle/test/zxc.dbf

8 /oracle/test/undotbs1.dbf

9 /oracle/test/zxbig.dbf

10 /oracle/test2.dbf

11 /oracle/test/jiujian.dbf

5 插入测试数据：

SQL> create table t3(x int) tablespace jiujian1;

Table created.

SQL> begin

2 for i in 1..20 loop

3 insert into t3 values(i);

4 end loop;

5 commit;

6 end;

7 /

PL/SQL procedure successfully completed.

SQL> select * from t3;

X

----------

1

2

3

4

5

6

7

8

9

10

11

X

----------

12

13

14

15

16

17

18

19

20

6 6到14号归档的scn范围