Disable DRM in 11g Release 1
alter system set “_gc_affinity_time”=0 scope=spfile sid=’*';
Disable DRM in 11g Release 1
alter system set “_gc_affinity_time”=0 scope=spfile sid=’*';
Create a golden image of your database and create a template of that database for future database provisioning
Create Seeded Database with dbca
With proper planning and infrastructure, you should be able to provision a new database in matter of minutes rather than days. You can create a template of a golden image of your database with all the corporate standards, auditing requirements and security compliance components.
Here’s what I think is an incredible piece of code to generate SQL*Loader control files for any table in the database.
</p>
<p>cat generate_control.sql def TAB='&1' set head off feed off pages 0 trims on serveroutput on size 1000000 lines 2000 ver off var v_tab VARCHAR2(100);</p>
<p>spool &TAB..control declare v_col VARCHAR2(255);</p>
<p>cursor c1 is select column_name, data_type from dba_tab_columns where table_name=upper('&TAB');</p>
<p>v_counter NUMBER := 0;</p>
<p>BEGIN :v_tab := '&TAB'; dbms_output.put_line('load data'); dbms_output.put_line('INFILE '||chr(39)||'data/'||:v_tab||'.txt'||chr(39)||' BADFILE '||chr(39)||:v_tab||'.bad'||chr(39)||' DISCARDFILE '|| chr(39)||:v_tab||'.dis'||chr(39)); dbms_output.put_line('INTO TABLE '||:v_tab); dbms_output.put_line('APPEND'); dbms_output.put_line('FIELDS TERMINATED BY '||chr(39)||'|'||chr(39)||' trailing nullcols ');</p>
<p>FOR r1 in c1 LOOP</p>
<p>IF v_counter = 0 THEN IF substr(r1.data_type,0,9) = 'TIMESTAMP' THEN v_col := '( '||r1.column_name||' timestamp '||chr(34)||'YYYY-MM-DD HH24:MI:SS.FF'||chr(34); dbms_output.put_line(v_col); ELSE v_col := '( '||r1.column_name; dbms_output.put_line(v_col); END IF; else IF substr(r1.data_type,0,9) = 'TIMESTAMP' THEN v_col := ','||r1.column_name||' timestamp '||chr(34)||'YYYY-MM-DD HH24:MI:SS.FF'||chr(34); dbms_output.put_line(v_col); ELSE v_col := ','||r1.column_name; dbms_output.put_line(v_col); END IF; END IF;</p>
<p>-- CREATETIMESTAMP timestamp "YYYY-MM-DD HH24:MI:SS.FF",</p>
<p>v_counter := v_counter + 1; END LOOP; dbms_output.put_line(')');</p>
<p>END; /</p>
<p>spool off set lines 66</p>
<p>
Posted by Charles Kim Oracle ACE Director
Oracle Real Application Cluster (RAC) is the successor to Oracle Parallel Server (OPS) and allows multiple instances to access the same database (storage) accessing and modifying the same data at the same time.
|
|
|
RAC provides fault tolerance, load balancing, and performance benefits by allowing the system to scale out, and at the same time since all nodes access the same database, the failure of one instance will not cause the loss of access to the database. At the heart of Oracle10g RAC is the OCR and Voting Disk. All the nodes in the cluster must be able to access all of the data, redo log files, control files and spfile. At each instance level exist redo log file(s) and UNDO tablespace. All the instances in the RAC cluster must be able to access the controlfiles, redo logs and UNDO tablespaces to recover a node in the event of a system failure. As of Oracle Database 10g RAC, data files, redo log files, control files, and archivelog files can reside on shared storage. Shared storage can be on raw-disk devices, NAS, ASM, or a clustered file system. At a minimum, a 1GB bandwidth for Oracle Interconnect and public network is required to successfully implement RAC. Typically, the networks cards (NICs) are aggregated to provide 2-4GBit bandwidth. Likewise, the network bandwidth for the public network is often aggregated to provide 2-4GBit bandwidth. With technologies such as Infiniband, the bandwidth can be amplified upto 10Gbit per second. We recommend having at a minimum: 3 voting disks and mirroring the OCR. The voting disks must have at least 50% survivability for the RAC cluster to stay up. For example, if you have two voting disks and lose one of the two voting disks, you will only have 50% of the voting disks. In this particular case, the entire RAC cluster will crash. |
Posted by: Charles Kim @ DBAExpert.com