oracle bbed 跳过归档恢复数据库.docx

SQL select * from v$version;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64biPL/SQL Release 10.2.0.5.0 - ProductionCORE10.2.0.5.0ProductionTNS for Linux: Version 10.2.0.5.0 - ProductionNLSRTL Version 10.2.0.5.0 – ProductionSQL create tablespacewillsondatafile /u01/oracle/oradata/orcl/willson1.dbf size 50m;altertablespacewillson add datafile /u01/oracle/oradata/orcl/willson2.dbf size 50m;altertablespacewillson add datafile /u01/oracle/oradata/orcl/willson3.dbf size 50m;Tablespace created.SQL Tablespace altered.SQL Tablespace altered.select HXFIL File_num,substr(HXFNM,1,40) File_name, FHSCN SCN, FHSTA status ,FHRBA_SEQ Sequence from X$KCVFH;FILE_NUM FILE_NAME SCN STATUS SEQUENCE---------- --------------------------------------------- ---------------- ---------- ---------- 1 /u01/oracle/oradata/orcl/system01.dbf 948761 8196 57 2 /u01/oracle/oradata/orcl/undotbs01.dbf 948761 4 57 3 /u01/oracle/oradata/orcl/sysaux01.dbf 948761 4 57 4 /u01/oracle/oradata/orcl/users01.dbf 948761 4 57 5 /u01/oracle/oradata/orcl/willson1.dbf 949022 4 57 6 /u01/oracle/oradata/orcl/willson2.dbf 949052 4 57 7 /u01/oracle/oradata/orcl/willson3.dbf 949078 4 577 rows selected.SQL create user willson identified by willson default tablespacewillson;User created.SQL grant dba to willson;Grant succeeded.SQL create table test (id number,name varchar2(50));Table created.SQL beginfori in 1 .. 500 loopinsert into test values(i,willson);commit;end loop;end; 2 3 4 5 6 7 /PL/SQL procedure successfully completed.SQLSQL select count(*) from test;COUNT(*)---------- 500SQL alter system switch logfile;System altered.SQL /System altered.SQL /System altered.SQL /System altered.SQL /System altered.SQL /System altered.[oracle@db1 archive]$ ls -ltotal 2420-rw-r----- 1 oracle oinstall 2041344 Feb 5 17:05 1_57_769085431.dbf-rw-r----- 1 oracle oinstall 10