oracle 拾遗

imp USERID=cisdba/babajula file=/u02/export_20090811_nocompressed.dmp  fromuser=cisdba touser=cisdba buffer=102400000 indexes=y grants=y ignore=y log=20090922imp.log

 

alter database force logging;

select FORCE_LOGGING from v$database;

alter system switch logfile;

select name from v$archived_log;

ALTER DATABASE REGISTER PHYSICAL LOGFILE '/u01/archive/log1_87_676393126.arc';

startup nomount

alter database mount standby database;

alter database recover managed standby database disconnect from session;

select switchover_status from v$database;

run{
allocate channel ch0 type disk maxpiecesize 800m;
allocate channel ch1 type disk maxpiecesize 800m;
backup format '/u01/rman/db_%U.bak' full database;
sql 'alter system switch logfile';
backup format '/u01/rman/control_%U.bak' current controlfile;
release channel ch0;
release channel ch1;
}

RMAN> run{
2> allocate channel ch0 type disk maxpiecesize 800m;
3> allocate channel ch1 type disk maxpiecesize 800m;
4> backup format '/u01/rman/db_%U.bak' full database;
5> sql 'alter system switch logfile';
6> backup format '/u01/rman/control_%U.bak' current controlfile;
7> release channel ch0;
8> release channel ch1;
9> }

 

 

SELECT se.username ,se.sid,se.serial#,se.sql_address,se.machine,se.program,su.tablespace,su.blocks*8192/1024/1024 "Used Space(M)",su.segtype,su.contents from v$session se,v$sort_usage su WHERE se.saddr=su.session_addr

select * from table(dbms_xplan.display);

 

select dbms_metadata.get_ddl('TABLE','DEPT','SCOTT') from dual;
select dbms_metadata.get_ddl('INDEX','DEPT_IDX','SCOTT') from dual;

 

 

dg：

 

http://www.cnscn.org/htm_data/589/0810/17203.html

http://www.oracle.com/technology/global/cn/deploy/availability/htdocs/DataGuardOverview.html

http://blog.chinaunix.net/u1/40226/showart_1869762.html

http://hi.baidu.com/edeed/blog/item/5e5590efb4f6bde8ce1b3e18.html

http://www.cnblogs.com/xinyuxin912/archive/2008/01/10/1033200.html

http://www.5ienet.com/note/html/dg/logical-standby-created-step-by-step.shtml

http://blog.chinaunix.net/u/6589/photo_11900.html

 

 

oracle 9i on linux (64bit)

 

#!/bin/sh
exec /usr/bin/g++32 -static-libgcc -B/usr/lib/gcc-lib/i386-redhat-linux/2.96/ "$@"

#!/bin/sh
exec /usr/bin/gcc32 -static-libgcc -B/usr/lib/gcc-lib/i386-redhat-linux/2.96/ "$@"

make -f /u01/app/oracle/product/9.2.0/db_1/rdbms/lib/ins_rdbms.mk /u01/app/oracle/product/9.2.0/db_1/rdbms/lib/extproc32 EXTPROC=/u01/app/oracle/product/9.2.0/db_1/rdbms/lib/extproc32 LIBDIR=lib32 LDFLAGS='-m32 -o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME) $(LDPATHFLAG)$(LIBHOME)stubs/'