完整的oraclerman备份恢复的例子.doc

完整的oracle rman备份恢复的例子 　　1、 建rman库作为repository　　$more createrman_db1.sh　　set echo on　　spool makedb1.log　　create database rman　　datafile /export/home/oracle/oradata/rman_data/system.dbf size 50m autoextend　　on next 640K　　logfile /export/home/oracle/oradata/rman_data/redo0101.log SIZE 10M,　　/export/home/oracle/oradata/rman_data/redo0201.log SIZE 10M　　maxdatafiles 30　　maxinstances 8　　maxlogfiles 64　　character set US7ASCII　　national character set US7ASCII　　;　　disconnect　　spool off　　exit　　　　@/export/home/oracle/8.1.6/rdbms/admin/catalog.sql;　　　　REM ********** ALTER SYSTEM TABLESPACE *********　　ALTER TABLESPACE SYSTEM　　DEFAULT STORAGE ( INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCR　　EASE 50);　　ALTER TABLESPACE SYSTEM　　MINIMUM EXTENT 64K;　　　　REM ********** TABLESPACE FOR ROLLBACK **********　　CREATE TABLESPACE RBS DATAFILE /export/home/oracle/oradata/rman_data/rbs.dbf s　　ize 50m　　AUTOEXTEND ON NEXT 512K　　MINIMUM EXTENT 512K　　DEFAULT STORAGE ( INITIAL 512K NEXT 512K MINEXTENTS 10 MAXEXTENTS UNLIMITED PC　　TINCREASE 0 );　　　　REM ********** TABLESPACE FOR TEMPORARY **********　　CREATE TABLESPACE TEMP DATAFILE /export/home/oracle/oradata/rman_data/temp.dbf　　size 50m　　AUTOEXTEND ON NEXT 64K　　MINIMUM EXTENT 64K　　DEFAULT STORAGE ( INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCR　　EASE 0) TEMPORARY;　　　　REM **** Creating four rollback segments ****************　　CREATE PUBLIC ROLLBACK SEGMENT RBS_0 TABLESPACE RBS　　STORAGE ( OPTIMAL 64000K );　　ALTER ROLLBACK SEGMENT RBS_0 ONLINE;　　　　　　REM **** SYS and SYSTEM users ****************　　alter user sys temporary tablespace TEMP;　　alter user system temporary tablespace TEMP;　　disconnect　　spool off　　exit　　　　$more createrman_db3.sh　　spool crdb3.log　　@/export/home/oracle/8.1.6/rdbms/admin/catproc.sql　　@/export/home/oracle/8.1.6/rdbms/admin/caths.sql　　@/export/home/oracle/8.1.6/rdbms/admin/otrcsvr.sql　　connect system/manager　　@/export/home/oracle/8.1.6/sqlp