ORACLE表备份恢复测试用例

1、1. 预备工作在 oracle 中创建表sql> create table test(name char(8),age int); table created.sql> select * from test; no rows selectedsql> insert into test values(”aaa”,22); 1 row created.sql> commit;commit complete.sql> select * from test;nameageaaa222. 预备工作在安腾普治理把握台创建 oracle 备份应用添加 oracle 相关参数，包

2、括 oracle_home、orale_sid 软件库文件等u 假如填写的各项参数都正确，点 oracle 应用图标右键还原和归档治理器就能开放 oracle 数据库结构如下u 定义 oracle 备份的介质池u 在作用治理器中可以查看 oracle 备份结果3. 进行 oracle 表备份恢复测试u 恢复前将数据库的表 dropsql> drop table test;table dropped.sql> conn /as sysdba connected.sql> shutdown immediate;database closed.database dismounted

3、. oracle instance shut down. sql>进入还原和归档治理器，启动还原操作数据库还原后，对数据库进行 recoversql> startup mount;oracle instance started.total system global area 5010685952 bytes fixed size2212936 bytes variable size3221228472 bytes database buffers1744830464 bytes redo buffers42414080 bytes database mounted.sql>

4、 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.dbfora-00280: change 1040140 for thread 1 is in sequence #11 specify log: <ret>=suggested | filenam

5、e | auto | cancelora-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.dbfora-00280: change 1040340 for thread 1 is in sequence #12ora-00278: log file ”/u01/app/11.2.0/arch/1_11_873425412.dbf” no longer needed for this recoveryspecify log: <ret>=suggested | filename | auto | cancel log applied.media recovery complete.sql>sql> alter database open resetlogs; database altered