英方培训认证

早上先开虚机，在虚机上安装英方contrl和node软件。下午容灾备份实战。

##SQL> select name from v$datafile;

NAME

/oradata/orcl/system01.dbf /oradata/orcl/sysaux01.dbf /oradata/orcl/undotbs01.dbf /oradata/orcl/users01.dbf

##SQL> select name from v$controlfile;

/oradata/orcl/control01.ctl /u01/app/oracle/fast_recovery_area/orcl/control02.ctl

##SQL> select member from v$logfile;查找地址

/oradata/orcl/redo03.log /oradata/orcl/redo02.log /oradata/orcl/redo01.log

##SQL> create table test(id number);新建数据表

Table created.

##SQL> begin （写自动创建数据表并填充） 2 for i in 1..10000 loop 3 insert into test values(i); 4 commit; 5 end loop; 6 end; 7 /

PL/SQL procedure successfully completed.

##SQL> select count(*) from test;查询数据表行数