May 29th, 2009 . by admin
With Oracle Validated RPM is the preparing of Linux is fast and simple. There is no need to know about all components, kernel parameters, which must be choice for install Oracle datbase or RAC on Linux. Oracle Validated RPM automatize the install and set the right parameter for a optimal Oracle installation later.
Step to install Oracle Validated RPM on OEL 5.3
- Download OLE5 from http://edelivery.oracle.com/linux
- Install Linux with the default configuration:
On the dialog selection additional package, don’t choice ‘Customize now’,
just acccept the default ‘Customize later’ and click next.
- Create a local yum repository.
- Down load Oracle Validated RPM from http://oss.oracle.com/el5/oracle-validated/
- And now install the Oracle Validated RPM
[root@pc1 Oracle_Validated]# yum install oracle-validated-1.0.0-5.el5.i386.rpm
Loaded plugins: security
OEL53 | 1.3 kB 00:00
Setting up Install Process
Parsing package install arguments
Examining oracle-validated-1.0.0-5.el5.i386.rpm: oracle-validated-1.0.0-5.el5.i386
Marking oracle-validated-1.0.0-5.el5.i386.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package oracle-validated.i386 0:1.0.0-5.el5 set to be updated
--> Processing Dependency: compat-db for package: oracle-validated
--> Processing Dependency: compat-gcc-34 for package: oracle-validated
--> Processing Dependency: compat-gcc-34-c++ for package: oracle-validated
--> Processing Dependency: elfutils-libelf-devel for package: oracle-validated
--> Processing Dependency: gcc for package: oracle-validated
--> Processing Dependency: gcc-c++ for package: oracle-validated
--> Processing Dependency: glibc-devel for package: oracle-validated
--> Processing Dependency: glibc-headers for package: oracle-validated
--> Processing Dependency: kernel-headers for package: oracle-validated
--> Processing Dependency: libXp for package: oracle-validated
--> Processing Dependency: libaio-devel for package: oracle-validated
--> Processing Dependency: libstdc++-devel for package: oracle-validated
--> Processing Dependency: sysstat for package: oracle-validated
--> Processing Dependency: unixODBC for package: oracle-validated
--> Processing Dependency: unixODBC-devel for package: oracle-validated
--> Running transaction check
---> Package glibc-headers.i386 0:2.5-34 set to be updated
---> Package elfutils-libelf-devel.i386 0:0.137-3.el5 set to be updated
--> Processing Dependency: elfutils-libelf-devel-static-i386 = 0.137-3.el5 for package: elfutils-libelf-devel
---> Package gcc-c++.i386 0:4.1.2-44.el5 set to be updated
---> Package compat-gcc-34-c++.i386 0:3.4.6-4 set to be updated
---> Package sysstat.i386 0:7.0.2-3.el5 set to be updated
---> Package compat-db.i386 0:4.2.52-5.1 set to be updated
---> Package unixODBC.i386 0:2.2.11-7.1 set to be updated
---> Package libstdc++-devel.i386 0:4.1.2-44.el5 set to be updated
---> Package compat-gcc-34.i386 0:3.4.6-4 set to be updated
---> Package unixODBC-devel.i386 0:2.2.11-7.1 set to be updated
---> Package libXp.i386 0:1.0.0-8.1.el5 set to be updated
---> Package libaio-devel.i386 0:0.3.106-3.2 set to be updated
---> Package gcc.i386 0:4.1.2-44.el5 set to be updated
--> Processing Dependency: libgomp >= 4.1.2-44.el5 for package: gcc
---> Package kernel-headers.i386 0:2.6.18-128.el5 set to be updated
---> Package glibc-devel.i386 0:2.5-34 set to be updated
--> Running transaction check
---> Package elfutils-libelf-devel-static.i386 0:0.137-3.el5 set to be updated
---> Package libgomp.i386 0:4.3.2-7.el5 set to be updated
--> Finished Dependency Resolution
Dependencies Resolved
============================================================================================================================================
Package Arch Version Repository Size
============================================================================================================================================
Installing:
oracle-validated i386 1.0.0-5.el5 oracle-validated-1.0.0-5.el5.i386.rpm 11 k
Installing for dependencies:
compat-db i386 4.2.52-5.1 OEL53 1.7 M
compat-gcc-34 i386 3.4.6-4 OEL53 4.1 M
compat-gcc-34-c++ i386 3.4.6-4 OEL53 11 M
elfutils-libelf-devel i386 0.137-3.el5 OEL53 24 k
elfutils-libelf-devel-static i386 0.137-3.el5 OEL53 66 k
gcc i386 4.1.2-44.el5 OEL53 5.2 M
gcc-c++ i386 4.1.2-44.el5 OEL53 3.4 M
glibc-devel i386 2.5-34 OEL53 2.0 M
glibc-headers i386 2.5-34 OEL53 612 k
kernel-headers i386 2.6.18-128.el5 OEL53 926 k
libXp i386 1.0.0-8.1.el5 OEL53 22 k
libaio-devel i386 0.3.106-3.2 OEL53 11 k
libgomp i386 4.3.2-7.el5 OEL53 67 k
libstdc++-devel i386 4.1.2-44.el5 OEL53 2.9 M
sysstat i386 7.0.2-3.el5 OEL53 170 k
unixODBC i386 2.2.11-7.1 OEL53 830 k
unixODBC-devel i386 2.2.11-7.1 OEL53 743 k
Transaction Summary
============================================================================================================================================
Install 18 Package(s)
Update 0 Package(s)
Remove 0 Package(s)
Total download size: 34 M
Is this ok [y/N]: y
Downloading Packages:
--------------------------------------------------------------------------------------------------------------------------------------------
Total 1.0 GB/s | 34 MB 00:00
warning: rpmts_HdrFromFdno: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Importing GPG key 0x1E5E0159 "Oracle OSS group (Open Source Software group) " from /mnt/OEL53/RPM-GPG-KEY-oracle
Is this ok [y/N]: y
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : kernel-headers [ 1/18]
Installing : glibc-headers [ 2/18]
Installing : glibc-devel [ 3/18]
Installing : libstdc++-devel [ 4/18]
Installing : compat-gcc-34 [ 5/18]
Installing : unixODBC [ 6/18]
Installing : compat-gcc-34-c++ [ 7/18]
Installing : sysstat [ 8/18]
Installing : libXp [ 9/18]
Installing : compat-db [10/18]
Installing : libgomp [11/18]
Installing : unixODBC-devel [12/18]
Installing : libaio-devel [13/18]
Installing : gcc [14/18]
Installing : gcc-c++ [15/18]
Installing : elfutils-libelf-devel [16/18]
Installing : elfutils-libelf-devel-static [17/18]
Installing : oracle-validated [18/18]
Installed: oracle-validated.i386 0:1.0.0-5.el5
Dependency Installed: compat-db.i386 0:4.2.52-5.1 compat-gcc-34.i386 0:3.4.6-4 compat-gcc-34-c++.i386 0:3.4.6-4 elfutils-libelf-devel.i386
0:0.137-3.el5 elfutils-libelf-devel-static.i386 0:0.137-3.el5 gcc.i386 0:4.1.2-44.el5 gcc-c++.i386 0:4.1.2-44.el5 glibc-devel.i386 0:2.5-34
glibc-headers.i386 0:2.5-34 kernel-headers.i386 0:2.6.18-128.el5 libXp.i386 0:1.0.0-8.1.el5 libaio-devel.i386 0:0.3.106-3.2 libgomp.i386
0:4.3.2-7.el5 libstdc++-devel.i386 0:4.1.2-44.el5 sysstat.i386 0:7.0.2-3.el5 unixODBC.i386 0:2.2.11-7.1 unixODBC-devel.i386 0:2.2.11-7.1
Complete!
[root@pc1 Oracle_Validated]#
and the log file, what oracle validated changed..
[root@pc1 Oracle_Validated]# cat /etc/sysconfig/oracle-validated/results/orakernel.log
Creating oracle user passed
Verifying kernel parameters as per Oracle recommendations...
fs.file-max 327679
kernel.msgmni 2878
kernel.msgmax 65536 8192
kernel.sem 250 32000 100 142
kernel.shmmni 4096
kernel.shmall 268435456 3279547
kernel.sysrq 0 1
net.core.rmem_default 262144
net.core.rmem_max 4194304
net.core.wmem_default 262144
net.core.wmem_max 262144
fs.aio-max-nr 3145728
net.ipv4.ip_local_port_range 1024 65000
Setting kernel parameters as per oracle recommendations...
Altered file /etc/sysctl.conf
Original file backed up at /etc/sysctl.conf.orabackup
Verifying & setting of kernel parameters passed
Verifying oracle user OS limits as per Oracle recommendations...
oracle soft nofile 131072
oracle hard nofile 131072
oracle soft nproc 131072
oracle hard nproc 131072
oracle soft core unlimited
oracle hard core unlimited
oracle soft memlock 3500000
oracle hard memlock 3500000
Setting oracle user OS limits as per Oracle recommendations...
Altered file /etc/security/limits.conf
Original file backed up at /etc/security/limits.conf.orabackup
Verifying & setting of user limits passed
Verifying kernel boot parameters as per Oracle recommendations...
Setting kernel boot parameters as per Oracle recommendations...
Boot parameters will be effected on next reboot
Altered file /boot/grub/grub.conf
Original file backed up at /boot/grub/grub.conf.orabackup
Verifying & setting of boot parameters passed
Verifying module parameters as per Oracle recommendations...
Setting module parameters as per Oracle recommendations...
Altered file /etc/modprobe.conf
Original file backed up at /etc/modprobe.conf.orabackup
Warning: e1000 module settings not modified
module is not installed or not in use
insmod /lib/modules/2.6.18-128.el5/kernel/drivers/char/hangcheck-timer.ko hangcheck_reboot=1
hangcheck-timer module settings modified to include hangcheck_reboot=1
May 29 00:27:06 pc1 yum: Installed: gcc-c++-4.1.2-44.el5.i386
May 29 00:27:06 pc1 yum: Installed: elfutils-libelf-devel-0.137-3.el5.i386
May 29 00:27:06 pc1 yum: Installed: elfutils-libelf-devel-static-0.137-3.el5.i386
May 29 00:27:12 pc1 kernel: Hangcheck: starting hangcheck timer 0.9.0 (tick is 180 seconds, margin is 60 seconds).
May 29 00:27:12 pc1 kernel: Hangcheck: Using get_cycles().
Verifying & setting of module parameters passed
Links:
Download RPM: http://oss.oracle.com/el5/oracle-validated/
Public Yum Server http://public-yum.oracle.com/
Note 728346.1
http://www.oracle.com/technology/tech/linux/validated-configurations/index.html
Posted in Linux |
5 Comments »
May 29th, 2009 . by admin
1. Mount the DVD iso
# mkdir /mnt/OEL53
# mount -o loop -t iso9660 /mnt/hgfs/OSource/OLinux/OEL53.iso /mnt/OEL53/
Note: You can download OEL with DVD format direct or
create a bootable DVD from Oracle Enterprise Linux CD iso images.
2. Create a file OEL53.repo
# cd /etc/yum.repos.d
# vi OEL53.repo
adding the following section:
[OEL53]
name = Oracle Enterprise Linux 5.3 DVD
baseurl=file:///mnt/OEL53/Server/
gpgcheck=0
enabled=1
or:
[OEL53]
name = Oracle Enterprise Linux 5.3 DVD
baseurl=file:///mnt/OEL53/Server/
gpgcheck=1
enabled=1
gpgkey=file:///mnt/OEL53/RPM-GPG-KEY-oracle
Clean database
# yum clean all
List installed RPMs
# yum list installed
List avalable RPMs
# yum list available
Posted in Linux |
4 Comments »
May 29th, 2009 . by admin
- Download script mkdvdiso.txt from www.certifried.com/files/mkdvdiso.txt
- Rename mkdvdiso.txt to mkdvdiso.sh
- Copy mkdvdiso.sh and the 5 CD iso images in a directory, for example:
/mnt/hgfs/OSource/OLinux/
# cd /mnt/hgfs/OSource/OLinux/
# ls
Enterprise-R5-U3-Server-i386-disc1.iso Enterprise-R5-U3-Server-i386-disc4.iso
Enterprise-R5-U3-Server-i386-disc2.iso Enterprise-R5-U3-Server-i386-disc5.iso
Enterprise-R5-U3-Server-i386-disc3.iso mkdvdiso.sh
Run this to make the DVD iso
# mkdvdiso.sh /mnt/hgfs/OSource/OLinux/ /mnt/hgfs/OSource/OLinux/OEL53.iso
->OEL53.iso is the result DVD!
more info see: http://www.certifried.com/?q=node/5
Posted in Linux |
3 Comments »
May 25th, 2009 . by admin
1. Create a new database using DBCA
DBNAME: catdb
PWD: oracle
2. Create user rman, owner of rman catalog on catalog database
Connect to catdb as sys and create user:
SQL> CREATE USER rman IDENTIFIED BY cat
TEMPORARY TABLESPACE temp
DEFAULT TABLESPACE users
QUOTA UNLIMITED ON users;
SQL> GRANT RECOVERY_CATALOG_OWNER TO rman;
3. Create catalog
C:\>rman catalog rman/cat@catdb
Recovery Manager: Release 10.2.0.4.0 - Production on Sun May 24 23:53:58 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to recovery catalog database
RMAN> create catalog;
recovery catalog created
4. Register database
C:\>rman TARGET sys/doan@prim CATALOG rman/cat@catdb
Recovery Manager: Release 10.2.0.4.0 - Production on Mon May 25 00:01:00 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: PRIM (DBID=3978960131)
connected to recovery catalog database
RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
5. Verify registration
RMAN> report schema;
Report of database schema
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 510 SYSTEM YES C:\ORACLE\PRODUCT\10.2.0\ORADATA\PRIM\SYSTEM01.DBF
2 355 UNDOTBS1 YES C:\ORACLE\PRODUCT\10.2.0\ORADATA\PRIM\UNDOTBS01.DBF
3 260 SYSAUX NO C:\ORACLE\PRODUCT\10.2.0\ORADATA\PRIM\SYSAUX01.DBF
4 20 USERS NO C:\ORACLE\PRODUCT\10.2.0\ORADATA\PRIM\USERS01.DBF
5 100 EXAMPLE NO C:\ORACLE\PRODUCT\10.2.0\ORADATA\PRIM\EXAMPLE01.DBF
6 100 ORABPEL NO C:\ORACLE\PRODUCT\10.2.0\ORADATA\PRIM\ORABPEL.DBF
7 20 TBS_NEW NO C:\ORACLE\PRODUCT\10.2.0\ORADATA\PRIM\TBS_NEW.DBF
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 29 TEMP 32767 C:\ORACLE\PRODUCT\10.2.0\ORADATA\PRIM\TEMP01.DBF
6. Create a script for example
RMAN> CREATE GLOBAL SCRIPT global_full_backup
COMMENT 'use only with ARCHIVELOG mode databases'
{
BACKUP DATABASE PLUS ARCHIVELOG;
DELETE OBSOLETE;
}
created global script global_full_backup
RMAN> LIST GLOBAL SCRIPT NAMES;
List of Stored Scripts in Recovery Catalog
Global Scripts
Script Name
Description
-----------------------------------------------------------------------
global_full_backup
use only with ARCHIVELOG mode databases
8. Run script
RMAN> RUN { EXECUTE SCRIPT global_full_backup; }
9. Export catalog for backup
C:> exp rman/cat@catdb file=c:\rman-catalog-export.dmp
Posted in Oracle |
No Comments »
May 25th, 2009 . by admin
Enable
SQL> alter database enable block change tracking
using file 'C:\oracle\product\10.2.0\oradata\prim\tracking.f';
Disable
SQL> alter database disable block change tracking;
Rename
SQL> startup mount
SQL> ALTER DATABASE RENAME FILE 'ora_home/dbs/change_trk.f' TO '/new_disk/change_trk.f';
View
V$BLOCK_CHANGE_TRACKING
SYS@prim> col filename format a50
SYS@prim> select * from V$BLOCK_CHANGE_TRACKING;
STATUS FILENAME BYTES
---------- -------------------------------------------------- ----------
ENABLED C:\ORACLE\PRODUCT\10.2.0\ORADATA\PRIM\TRACKING.F 11599872
Posted in Oracle |
No Comments »
May 18th, 2009 . by admin
Size of all schema
SYS@prim> select owner, sum(bytes)/1024/1024 as "Size(MB)"
from dba_segments group by owner;
SQL> select owner, sum(bytes)/1024/1024 as "Size(MB)"
from dba_segments where owner= 'SCOTT' group by owner;
OWNER Size(MB)
------------------------------ ----------
SCOTT .375
Size of table, index
SYS@orcl> select segment_name, segment_type, bytes
from dba_segments where owner='SCOTT' order by segment_type;
SEGMENT_NAME SEGMENT_TYPE BYTES
------------------------------ ------------------ ----------
PK_DEPT INDEX 65536
PK_EMP INDEX 65536
BONUS TABLE 65536
SALGRADE TABLE 65536
DEPT TABLE 65536
EMP TABLE 65536
6 rows selected.
Size of data files
SYS@orcl> select file_name, bytes/1024/1024 as "Size(MB)" from dba_data_files;
FILE_NAME Size(MB)
------------------------------------------------------------ ----------
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS01.DBF 5
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF 240
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF 30
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF 480
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\EXAMPLE01.DBF 100
SYS@orcl> select sum(bytes)/1024/1024 as "Data Files Size(MB)" from dba_data_files;
Data Files Size(MB)
-------------------
855
Size of redo log files
SYS@orcl> select sum(bytes)/1024/1024 as "Redo Log Size(MB)" from v$log;
Redo Log Size(MB)
-----------------
150
Size of control files
SYS@orcl> select sum((cffsz+1)*cfbsz)/1024/1024 "Control File Size(MB)" from x$kcccf;
Control File Size(MB)
---------------------
20.203125
Summary:
SYS@orcl> select DF.TOTAL/1048576 "DataFile Size Mb",
LOG.TOTAL/1048576 "Redo Log Size Mb",
CONTROL.TOTAL/1048576 "Control File Size Mb",
(DF.TOTAL + LOG.TOTAL + CONTROL.TOTAL)/1048576 "Total Size Mb"
from dual,
(select sum(a.bytes) TOTAL from dba_data_files a) DF,
(select sum(b.bytes) TOTAL from v$log b) LOG,
(select sum((cffsz+1)*cfbsz) TOTAL from x$kcccf c) CONTROL;
DataFile Size Mb Redo Log Size Mb Control File Size Mb Total Size Mb
---------------- ---------------- -------------------- -------------
855 150 20.203125 1025.20313
Posted in Oracle |
No Comments »
May 18th, 2009 . by admin
To get the currently executing SQL from a user or a session_id, do this:
..from a session_id
SQL> select s.sid, sq.sql_text
from v$session s, v$sqlarea sq
where s.sql_address = sq.address
and s.sql_hash_value=sq.hash_value
and s.sid=&SESSION_ID;
..from a user
SQL> select s.sid, sq.sql_text
from v$session s, v$sqlarea sq
where s.sql_address = sq.address
and s.sql_hash_value=sq.hash_value
and s.username='&USER_NAME';
Test:
-Start SQLPlus connect as SCOTT and do some select like
SQL> select * from all_objects;
-Start other session connect as SYS and do the execute on of the obove SQLs
SYS@orcl> select s.sid, sq.sql_text
2 from v$session s, v$sqlarea sq
3 where s.sql_address = sq.address
4 and s.sql_hash_value=sq.hash_value
5 and s.username='&USER_NAME';
Enter value for user_name: SCOTT
old 5: and s.username='&USER_NAME'
new 5: and s.username='SCOTT'
SID SQL_TEXT
---------- ---------------------------------------------------------------
158 select * from all_objects
Posted in Oracle |
No Comments »
May 13th, 2009 . by admin
After install SOA Suite 10.1.3.1.0, when starting and connecting database with SQLPlus you get a popup with errror:
The procedure entry point snlseFreeSecAttrib could not be located in the dynamic link library oral10.dll
Todo: change the path order %ORACLE_HOME%\bin before %ORACLE_AS_HOME%\bin
Right click My Computer -> Properties -> Advanced -> Environment Variables -> System variables -> Path ..
Before:
C:\product\10.1.3.1\OracleAS_1\jdk\bin;C:\product\10.1.3.1\OracleAS_1\ant\bin;C:\product\10.1.3.1\OracleAS_1\bin;C:\oracle\product\10.2.0\db_1\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem
After:
C:\product\10.1.3.1\OracleAS_1\jdk\bin;C:\oracle\product\10.2.0\db_1\bin;C:\product\10.1.3.1\OracleAS_1\ant\bin;C:\product\10.1.3.1\OracleAS_1\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem
Posted in Oracle |
1 Comment »
May 11th, 2009 . by admin
- First install Java J2EE
- Then download from http://www.oracle.com/technology/software/products/ias/htdocs/utilsoft.html
- Choice Oracle Containers for J2EE 10g (OC4J) Version 10.1.x
- Download file oc4j_extended.zip(sized variable from 36..88 MB)
- Extract the file to exm: c:\oc4j
- See file C:\oc4j\readme.txt for install instruction
- Open new CMD
Install OC4J
C:\>cd C:\oc4j\j2ee\home
C:\oc4j\j2ee\home>java -jar oc4j.jar -install
Auto-unpacking C:\oc4j\j2ee\home\applications\dms0.war... done.
To enable in-process JSP compilation (which can be faster in some cases),
please add the path to your tools.jar in application.xml
Example: <library path="../../../jdk/lib/tools.jar" />
Enter an admin password to use: your_password
Confirm admin password: your_password
If you are using J2SE 1.4 or higher, please ensure that all your imported classes are within packages, as required by the
Java Language Specification.
Installation done
Starting OC4J
C:\oc4j\j2ee\home>java -jar oc4j.jar
09/05/06 11:11:00 Auto-deploying file:/C:/oc4j/j2ee/home/default-web-app/ (New server version detected)...
09/05/06 11:11:01 Auto-deploying file:/C:/oc4j/j2ee/home/applications/dms0/ (New server version detected)...
09/05/06 11:11:05 Oracle Application Server Containers for J2EE 10g (10.1.2.0.2) initialized
09/05/06 11:11:05 !!! No valid java compiler found !!!
09/05/06 11:11:05 javac.exe not found under C:\Program Files\Java\jre6, please use a valid jdk or specify the location of
your java compiler in server.xml using the <java-compiler .../> tag
see Troubleshooting:
http://download-uk.oracle.com/docs/cd/B25221_04/web.1013/b14432/diagnosis.htm#CHDGAAEJ
Starting OC4J again
C:\oc4j\j2ee\home>C:\java\jdk\bin\java -jar oc4j.jar
09/05/06 11:20:02 Oracle Application Server Containers for J2EE 10g (10.1.2.0.2) initialized
Stopping OC4J
!Press Ctrl+C
Welcome Page:
http://localhost:8888/
JSP Sample Page:
http://localhost:8888/examples/jsp/
Posted in Oracle |
No Comments »
May 10th, 2009 . by admin
FORCE LOGGING overrides NOLOGGING
If the object for which you are specifying the logging attributes resides in a database or tablespace in FORCE LOGGING mode, then Oracle ignores any NOLOGGING or UNRECOVERABLE setting until the database or tablespace is taken out of FORCE LOGGING mode.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14229/strms_capture.htm#sthref76
When configure Data Guard, FORCE LOGGING must be setting, because FORCE LOGGING mode ensures that the standby database remains consistent with the production database.
http://download.oracle.com/docs/cd/B19306_01/server.102/b25159/configbp.htm#CHDDHBHC
..for load performance with NOLOGGING operations, then you must ensure that the corresponding physical standby datafiles are subsequently synchronized. The physical standby datafiles can be synchronized by either applying an incremental backup created from the primary database or by replacing the affected standby datafiles with a backup of the primary datafiles taken after the nologging operations Before the file transfer, the physical standby database must stop recovery.
http://download.oracle.com/docs/cd/B19306_01/server.102/b25159/configbp.htm#CHDDHBHC
Show:
SQL> select force_logging from v$database;
SQL> select force_logging from dba_tablespaces;
Set:
SQL> alter database force logging;
SQL> alter tablespace users force logging;
Unset:
SQL> alter database no force logging;
SQL> alter tablespace users no force logging;
Posted in Oracle |
No Comments »