2008年1月14日星期一

Oracle学习笔记20080111

Example on UNIX
$ ORACLE_SID=db01; export ORACLE_SID
$ rman target /
RMAN> connect catalog rman_db01/rman_db01@catdb
Example on Windows NT
C:\> set ORACLE_SID=db01
C:\> rman target /
RMAN> connect catalog rman_db01/rman_db01@catdb

同步回复目录
自动的使用backup和copy手动的使用resync catalog
假如要使用resync catlog你必须增加或删除一个表空间,数据文件,或者移动了数据库文件
$ rman target / catalog rman/rman@catdb
RMAN> RESYNC CATALOG;

从新修改数据库incarnation用reset database命令,直接将RMAN用来建一个新的incarnation数据库记录,To distinguish(区别) between opening with RESETLOGS and an accidental restore operation of an old control file在用RESET DATABASE以后用RESETLOGS
数据字典
RC_DATABASE
RC_DATAFILE
RC_STORED_SCRIPT
RC_STORED_SCRIPT_LINE
RC_TABLESPACE

Script Examples
Use CREATE SCRIPT to store a script.
RMAN> create script Level0Backup {
backup incremental level 0 format '/u01/db01/backup/%d_%s_%p'
fileperset 5 (database include current controlfile);
sql 'alter database archive log current';
}

Use EXECUTE SCRIPT to run a script.
RMAN > run {execute script Level0Backup;}

管理脚本Use REPLACE SCRIPT to rewrite a script
RMAN> REPLACE SCRIPT Level0Backup { ..... fileperset 3 .... }

Use DELETE SCRIPT to remove a script
RMAN> DELETE SCRIPT Level0Backup;
Use PRINT SCRIPT to display a script
RMAN> PRINT SCRIPT Level0Backup;
备份恢复目录整个数据库和表空间备份的时候都已经备份了恢复目录,导出如果不大,导出数据库,如果大到处schema
恢复恢复日志建立一个数据库从先前的恢复日志数据库备份,重移目录到别的数据库和导入进来的数据,导入全部数据从导出
Transporting Data Between Databases输入输出工具
Command-line interfaceAn interactive dialog
Parameter files
Oracle Enterprise Manager

Invoking Export
Syntax:
exp keyword = value, value2, ... ,valun

Examples:
exp hr/hr TABLES=employees,departments rows=y file=exp1.dmp
exp
system/manager OWNER=hr direct=y file=expdat.dmp
exp \'username/password AS
SYSDBA\' TRANSPORT_TABLESPACE=y TABLESPACES=ts_emp log=ts_emp.log

Specifying Direct-Path Export As command line argument to the Export command:
exp userid=hr/hr full=y direct=y

As a keyword in a parameter file:
exp parfile=Parameter file ...(Other Parameters)DIRECT = Y...(Other
Parameters)

Invoking Import Syntax:
imp keyword = value or keyword = value, value2, ... value Examples:imp hr/hr TABLES=employees,departments rows=y file=exp1.dmpimp system/manager FROMUSER=hr file=exp2.dmpimp \'username/password AS SYSDBA\' TRANSPORT_TABLESPACE=y TABLESPACES=ts_employees

Invoking Import as SYSDBA
imp \'username/password AS SYSDBA\'
Import Process Sequence
1. New tables are created
2. Data is imported
3. Indexes are built
4. Triggers are imported
5. Integrity constraints are enabled on the new tables
6. Any bitmap, functional, and/or domain indexes are built

WorkshopEnable TracingOracle Net ManagerEdit sqlnet.
ora fileTRACE_DIRECTORY_CLIENT= /u01/user01/NETWORK/LOGNAMES.DEFAULT_DOMAIN = us.oracle.comTRACE_UNIQUE_CLIENT = onTRACE_FILE_CLIENT = client.trcTRACE_LEVEL_CLIENT = SUPPORTNAMES.DIRECTORY_PATH= (TNSNAMES)
sqlnet.ora的位置还是在$ORACLE_HOME/product/9.2/network/admin

使用trace fileThe flow of packets between network nodes Which component of Oracle Net is failing Pertinent error codes
Loading Data into a Database数据加载的动作Direct-Load INSERTNormal (serially) or in parallelInto partitioned tables, nonpartitioned tables, or single partitions of a tableWith or without logging of redo data
Serial Direct-Load INSERTINSERT /*+ APPEND */ INTO emp NOLOGGINGSELECT * FROM t_employees;COMMIT;
Parallel Direct-Load INSERTALTER SESSION ENABLE PARALLEL DML;INSERT /*+PARALLEL(hr.employees,2) */ INTO hr.employees NOLOGGINGSELECT * FROM hr.old_employees;
到此2张已经都看完了,下面应该更多的实践和练习

没有评论: