oracle实验报告及答案 备份与恢复.doc

实验实验目的 实验设备 一台机，实验实验Create user school identified by school default tablespace users quota unlimited on users; Grant EXP_FULL_DATABASE, IMP_FULL_DATABASE,CONNECT,RESOURCE TO SCHOOL; CONNECT SCHOOL/SCHOOL; CREATE TABLE STUDENT(X NUMBER,A NUMBER) TABLESPACE USERS; INSERT INTO STUDENT VALUES(1,2); INSERT INTO STUDENT VALUEs(3,4); COMMIT; 1.逻辑备份及恢复 Exit退出到dos状态 1）Exp school/school file=d:\myback.dmp tables=(student);(将表导出) Exp school/school file=d:\myback.dmp owner= school??;(将用户所拥有的对象都导出) Exp school/school file= d:\myback.dmp；（全库导出） 2）以管理员身份登录到ORACLE数据库DELETE SCHOOL.STUDENT; 查看select * from SCHOOL.STUDENT; 3）Exit退出到dos状态Imp school/school ignore=y full=y file= d:\myback.dmp 4）以管理员身份登录到ORACLE数据库查看select * from SCHOOL.STUDENT; 2.冷备份及恢复 1)以管理员身份登录 connect system/password as sysdba; 2)关闭数据库 shutdown immediate; 3）将数据库中所有文件拷贝到d:\backup 4)模拟误删除 操作系统下将数据库中users01.dbf删除 5）将d:\backup目录中的所有文件拷回数据库目录 6）以管理员身份登录 connect system/password as sysdba; 7）打开数据库 Startup 3、热备份及完全恢复 1）connect system/password as sysdba; 2）shutdown immediate; 3）设置参数LOG_ARCHIVE_START=TRUE; 5）alter database archivelog; 6）alter database open; 7）archive log list; 8）alter tablespace users begin backup; 9) 拷贝所有的数据文件。Shutdown immediate 操作系统中删除users01.dbf 13)将d:\backup2目录中的所有文件拷回数据库目录 14）以管理员身份登录 connect system/password as sysdba; 15) 启动数据库到mount状态 Startup mount; 16)恢复数据库 Recover database; 17)打开数据库 Alter database open; 4、热备份及基于时间的不完全恢复 1）connect system/password as sysdba; 2）shutdown immediate; 3）设置参数LOG_ARCHIVE_START=TRUE; 4）starup mount; 5）alter database archivelog; 6）alter database open; 7）archive log list; 8）alter tablespace users begin backup; 9) 拷贝所有的数据文件。select to_char(sysdate,DD-MONTH-YYYY HH24:MI:SS) FROM DUAL; 12）模拟误删除表内容并提交 DELETE from SCHOOL.STUDENT; COMMIT 13)归档当前的日志信息 alter system switch logfile; alter system switch logfile;(确保归档) alter system switch logfile; 14）shutdown immediate; 15) startup mount; 16）复制备份的文件到数据库目录 17) 基于时间的不完全恢复 recover database until time ` 24-6月 -2008 08:25: