UNNAMEDnnnnn File Processing in oracle

I. Construct an UNNAMEDnnnnn file. nnnnn is the absolute file number of the data file. 1. The current online log status is as follows: selectgroup #, archived, sequence #, statusfromv $ logGROUP # ARCSE.

I. Construct an UNNAMEDnnnnn file. nnnnn is the absolute file number of the data file. 1. The current online log status is as follows: selectgroup #, archived, sequence #, statusfromv $ logGROUP # ARCSE.

1. Construct an UNNAMEDnnnnn File

Nnnnn indicates the absolute file number of the data file.

1. The current online log status during file backup is as follows:

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. The current control file backup is as follows:

RMAN> list backup of controlfile;

List of Backup Sets

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

BS Key Type LV Size Device Type Elapsed Time Completion Time

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

5 Full 7.11 m 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. The log status when creating tablespaces and test data is as follows:

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. Create a tablespace.

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

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. Insert test data:

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

The range of scn for archiving from 6 to 14