ORACLE RMAN操作手册
- 格式：docx
- 大小：24.80 KB
- 文档页数：14
ORACLE RMAN操作手册RMAN可以用来备份和还原数据库文件、归档日志和控制文件。
它也可以用来执行完全或不完全的数据库恢复。
注意：RMAN不能用于备份初始化参数文件和口令文件。
RMAN启动数据库上的Oracle服务器进程来进行备份或还原。
备份、还原、恢复是由这些进程驱动的。
RMAN可以由OEM的Backup Manager GUI来控制DB1 (target db)IP:10.204.200.101SID: testDB2 （catalog db）IP:10.204.200.102SID:orcl一打开数据库归档查看SQL> archive log listDatabase log mode No Archive ModeAutomatic archival DisabledArchive destination /oracle10/app/oracle/product/10.2.0/dbs/archOldest online log sequence 1Current log sequence 2设置alter system set log_archive_dest_1="LOCATION=/oradata/archive MANDATORY REOPEN" scope=spfile;启动到mountSQL> startup mount;ORACLE instance started.Total System Global Area 167772160 bytesFixed Size 1218316 bytesVariable Size 83888372 bytesDatabase Buffers 79691776 bytesRedo Buffers 2973696 bytesDatabase mounted.SQL> archive log list;Database log mode No Archive ModeAutomatic archival DisabledArchive destination /oradata/archiveOldest online log sequence 1Current log sequence 2打开归档：SQL> alter database archivelog;Database altered.SQL> archive log list;Database log mode Archive ModeAutomatic archival EnabledArchive destination /oradata/archiveOldest online log sequence 1Next log sequence to archive 2Current log sequence 2SQL> alter database open;二FLASH BACK DB1配置FLASH BACK1.设置参数alter system set db_recovery_file_dest='/oradata/flash' scope=spfile;alter system set db_recovery_file_dest_size=2g scope=spfile;2.启动到mountstartup mount；3.检查Flashback 功能，缺省时功能是关闭的。
select name, current_scn, flashback_on from v$database;4.启动FLASHBACKSQL> alter database flashback on;SQL> select name, current_scn, flashback_on from v$database;NAME CURRENT_SCN FLASHBACK_ON--------- ----------- ------------------DBA 0 YES5.查询当前的scnSQL> SELECT CURRENT_SCN FROM V$DATABASE;查询当前的时间SQL> select to_char(sysdate,'yy-mm-dd hh24:mi:ss') time from dual;SQL> select table_name from dba_tables where owner='HR';TABLE_NAME------------------------------REGIONSLOCATIONSDEPARTMENTSJOBSEMPLOYEESJOB_HISTORYSKIP_TESTCOUNTRIES8 rows selected.SQL> select * from hr.jobs;JOB_ID JOB_TITLE MIN_SALARY MAX_SALARY---------- ----------------------------------- ---------- ----------AD_PRES President 20000 40000AD_VP Administration Vice President 15000 30000AD_ASST Administration Assistant 3000 6000FI_MGR Finance Manager 8200 16000FI_ACCOUNT Accountant 4200 9000AC_MGR Accounting Manager 8200 16000 AC_ACCOUNT Public Accountant 4200 9000SA_MAN Sales Manager 10000 20000 SA_REP Sales Representative 6000 12000PU_MAN Purchasing Manager 8000 15000 PU_CLERK Purchasing Clerk 2500 5500JOB_ID JOB_TITLE MIN_SALARY MAX_SALARY---------- ----------------------------------- ---------- ----------ST_MAN Stock Manager 5500 8500ST_CLERK Stock Clerk 2000 5000SH_CLERK Shipping Clerk 2500 5500IT_PROG Programmer 4000 10000MK_MAN Marketing Manager 9000 15000MK_REP Marketing Representative 4000 9000HR_REP Human Resources Representative 4000 9000PR_REP Public Relations Representative 4500 105006.备份DATABASERMAN> backup database;Starting backup at 16-AUG-10using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: sid=141 devtype=DISKchannel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetinput datafile fno=00001 name=/oradata/test/system01.dbfinput datafile fno=00003 name=/oradata/test/sysaux01.dbfinput datafile fno=00005 name=/oradata/test/example01.dbfinput datafile fno=00002 name=/oradata/test/undotbs01.dbfinput datafile fno=00004 name=/oradata/test/users01.dbfchannel ORA_DISK_1: starting piece 1 at 16-AUG-10channel ORA_DISK_1: finished piece 1 at 16-AUG-10piecehandle=/oradata/flash/TEST/backupset/2010_08_16/o1_mf_nnndf_TAG20100816T01164 8_66j880lj_.bkp tag=TAG20100816T011648 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:01:06channel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetincluding current control file in backupsetincluding current SPFILE in backupsetchannel ORA_DISK_1: starting piece 1 at 16-AUG-10channel ORA_DISK_1: finished piece 1 at 16-AUG-10piecehandle=/oradata/flash/TEST/backupset/2010_08_16/o1_mf_ncsnf_TAG20100816T01164 8_66j8b5f4_.bkp tag=TAG20100816T011648 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:06 Finished backup at 16-AUG-107.删除表empSQL>8.启动到mountSQL> startup mountORACLE 例程已经启动。
