ORACLE表备份恢复测试用例

1.准备工作在ORACLE中创建表

SQL> create table test(name char(8),age int);

Table created.

SQL> select * from test;

no rows selected

SQL> insert into test values('aaa',22);

1 row created.

SQL> commit;

Commit complete.

SQL> select * from test;

NAME AGE

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

aaa 22

2.准备工作在安腾普管理控制台创建Oracle备份应用

添加ORACLE相关参数，包括ORACLE_HOME、ORALE_SID软件库文件等

◆如果填写的各项参数都正确，点ORACLE应用图标右键还原和归档管理器就能展开ORACLE数据库

结构如下

◆定义ORACLE备份的介质池

◆在作用管理器中可以查看ORACLE备份结果

3.进行ORACLE表备份恢复测试

◆恢复前将数据库的表drop

SQL> drop table test;

Table dropped.

SQL> conn /as sysdba

Connected.

SQL> shutdown immediate; Database closed.

Database dismounted.

ORACLE instance shut down.

SQL>

进入还原和归档管理器，启动还原操作

数据库还原后，对数据库进行recover

SQL> startup mount;

ORACLE instance started.

Total System Global Area 5010685952 bytes

Fixed Size 2212936 bytes

Variable Size 3221228472 bytes

Database Buffers 1744830464 bytes

Redo Buffers 42414080 bytes

Database mounted.

SQL> recover database using backup controlfile until cancel;

ORA-00279: change 1040140 generated at 03/04/2015 02:54:36 needed for thread 1 ORA-00289: suggestion : /u01/app/11.2.0/arch/1_11_873425412.dbf

ORA-00280: change 1040140 for thread 1 is in sequence #11

Specify log: {=suggested | filename | AUTO | CANCEL}

ORA-00279: change 1040340 generated at 03/04/2015 02:55:15 needed for thread 1 ORA-00289: suggestion : /u01/app/11.2.0/arch/1_12_873425412.dbf

ORA-00280: change 1040340 for thread 1 is in sequence #12

ORA-00278: log file '/u01/app/11.2.0/arch/1_11_873425412.dbf' no longer needed for this recovery

Specify log: {=suggested | filename | AUTO | CANCEL}

Log applied.

Media recovery complete.

SQL>

SQL> alter database open resetlogs;

Database altered.

4.检查还原的数据

SQL> conn zwh/zwh Connected.

SQL> select * from test; NAME AGE

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

aaa 22

SQL>