内部新员工orace培训手册-RMAN增量备份全过程-linux5.4-oracle11.2.docVIP

2011-05-06 ORACLE RMAN 增量备份完整恢复测试 创建测试表空间： SQL create tablespace tablespace1 2 datafile /db/app/oracle/oradata/orcl/tablespace1.dbf 3 size 10m; Tablespace created. SQL 创建测试用户并指定为默认表空间： SQL create user user1 identified by oracle default tablespace tablespace1; User created. SQL 设置该测试用户权限： SQL grant create session,create table,unlimited tablespace to user1; Grant succeeded. SQL 用新创建的用户登录： SQL conn user1/ Enter password: Connected. SQL 建表并写入数据： SQL create table table1 (id int,name varchar2(30)); Table created. SQL insert into table1 values(0001,Tian); 1 row created. SQL i