ORACLE RMAN操作手册
RMAN可以用来备份和还原数据库文件、归档日志和控制文件。它也可以用来执行完全或不完全的数据库恢复。
注意：RMAN不能用于备份初始化参数文件和口令文件。
RMAN启动数据库上的Oracle服务器进程来进行备份或还原。备份、还原、恢复是由这些进程驱动的。
RMAN可以由OEM的Backup Manager GUI来控制
DB1 (target db)
IP:10.204.200.101
SID: test
DB2 （catalog db）
IP:10.204.200.102
SID:orcl
一打开数据库归档
查看
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /oracle10/app/oracle/product/10.2.0/dbs/arch
Oldest online log sequence 1
Current log sequence 2
设置
alter system set log_archive_dest_1="LOCATION=/oradata/archive MANDATORY REOPEN" scope=spfile;
启动到mount
SQL> startup mount;
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 83888372 bytes
Database Buffers 79691776 bytes
Redo Buffers 2973696 bytes
Database mounted.
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /oradata/archive
Oldest online log sequence 1
Current log sequence 2
打开归档：
SQL> alter database archivelog;
Database altered.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oradata/archive
Oldest online log sequence 1
Next log sequence to archive 2
Current log sequence 2
SQL> alter database open;
二FLASH BACK DB1
配置FLASH BACK
1.设置参数
alter system set db_recovery_file_dest='/oradata/flash' scope=spfile;
alter system set db_recovery_file_dest_size=2g scope=spfile;
2.启动到mount
startup mount；
3.检查Flashback 功能，缺省时功能是关闭的。
select name, current_scn, flashback_on from v$database;
4.启动FLASHBACK
SQL> alter database flashback on;
SQL> select name, current_scn, flashback_on from v$database;
NAME CURRENT_SCN FLASHBACK_ON
--------- ----------- ------------------
DBA 0 YES
5.查询当前的scn
SQL> 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
------------------------------
REGIONS
LOCATIONS
DEPARTMENTS
JOBS
EMPLOYEES
JOB_HISTORY
SKIP_TEST
COUNTRIES
8 rows selected.
SQL> select * from hr.jobs;
JOB_ID JOB_TITLE MIN_SALARY MAX_SALARY
---------- ----------------------------------- ---------- ----------
AD_PRES President 20000 40000
AD_VP Administration Vice President 15000 30000
AD_ASST Administration Assistant 3000 6000
FI_MGR Finance Manager 8200 16000
FI_ACCOUNT Accountant 4200 9000
AC_MGR Accounting Manager 8200 16000 AC_ACCOUNT Public Accountant 4200 9000
SA_MAN Sales Manager 10000 20000 SA_REP Sales Representative 6000 12000
PU_MAN Purchasing Manager 8000 15000 PU_CLERK Purchasing Clerk 2500 5500
JOB_ID JOB_TITLE MIN_SALARY MAX_SALARY
---------- ----------------------------------- ---------- ----------
