实验8_Orace数据库备份与恢复.doc

实验8 Oracle 数据库备份与恢复实验 理解数据库备份工作的重要性 将备份与恢复策略的理论和实践相结合，熟练掌握逻辑备份和恢复工具。 能根据实际情况确定备份和恢复策略。（4）本实验主要包含以下内容。 （）（） （）练习使用。—设置—控制面版—管理工具 ((本地策略—用户权利指派—单击“作为批处理作业登录”--”添加用户或组”(”高级”(”立即查找”—”user”(单击“确定”. 逻辑备份工具方式备份：以创建的用户jsj111_20或sys登录 em 利用Oracle提供的em备份工具，选择oracle建议的备份，并恢复数据库. （1）创建用户jsj111—20 （2）sys登录em 3、逻辑备份工具方式备份：以创建的用户jsj111_20或sys登录 em 利用Oracle提供的em备份工具，选择定制的备份，并恢复数据库 RMAN技术方式备份与恢复：以用户sys登录sql*plus将数据库设置成归档模式，创建恢复目录所用的表空间，表空间的名字为rman_20,路径默认（实验室）， 5、RMAN技术方式备份与恢复：以用户sys登录sql*plus创建rman_20用户并授权（备份和恢复的相应权限），创建恢复目录rman_20 6、RMAN技术方式备份与恢复：注册目标数据库，执行全数据库备份，并恢复。 解：目标数据库口令：oracle 7、练习使用。 conferences, learned superiors policies; reports, you can learn to deal with problems, art, just wanted to learn, to learn at any time. To continuously expand the scope of the study. The complexity and comprehensiveness of our work, decided to not only do we want to be professionals, or if generalists, to dabble in different areas of knowledge. Mastery of knowledge not only to have knowledge to rational analysis. This on requirements we, not only to learning national of route, and approach, and policy, also to learning national of legal, and regulations; not only to with political theory armed mind, also to with economic theory guide work; not only to read history, also to read history; not only to absorption SM of mirror, also to gets is of road; not only to from local learn, also to to outside learn; not only to to books learn, also to field study learn. 　　Therefore, I would encourage you, and more to the outside world when I have time to take a look at, take a stroll, outside developments, learn other peoples development approach, and then come back to guide our work. Second, we must think. Learning without thought to overshadow, thinking without learning is perilous. We want to foster the character of advancing with the times, forge ahead, often reflect themselves in adapting to the new situation on whether the