| Neeraj |
Posted: Mar 13, 2008 01:32:43 AM |
Total Post: 228
Joined: Jan, 2007
|
hi,
i want to know wt does
alter database force logging
& does it work in oracle 9.0
if not then wts the alternate to run this command on 9.0
to set up stand by server.
thxs
|
|
|
 Gitesh |
| Posted: Mar 13, 2008 02:19:56 AM |  |
|
Total Post: 322
Joined: May, 2005
|
This feature restricts NOLOGGING and UNRECOVER clause in DML or DDL command. It is very useful feature when ever we are using standby or remote standby databases or makes daily clone databases for reporting purpose.
When ever any DDL/DML command is being executed with NOLOGGING clause that time minimum redo will be generating and it is only for system level changes. No change of DML/DDL will be recorded in redo means there is no change will be apply to standby or report dtabase which is made by standby database. Due to this reason LOGICAL corruption may be occurred. To protect of this situation FORCE LOGGING feature is useful.
This feature doesn't available in Oracle8i. It is available with Oracle 9i only.
For using this feature there are 2 options available those are 1) Put full database in FORCE LOGGING or 2) Put tablespace level FORCE LOGGING.
Check DBA_TABLESPACES also contains column FORCE_LOGGING.
I think this will clear now.
|
|
|
|
|
| Neeraj |
| Posted: Mar 13, 2008 02:51:54 AM | |
|
Total Post: 228
Joined: Jan, 2007
|
hi,
thxs for yr solution but tell me i cant run this command on oracle 9.0
version
alter database force logging.
it says invalid alter command
i chacked all my tablespace r on logging so can i skip this command to set up stand by database.
|
|
|
|
|
| Gitesh |
| Posted: Mar 13, 2008 05:19:42 AM | |
|
Total Post: 322
Joined: May, 2005
|
Simple way to find out said feature is enabled or not
If feature enables in database level then you will get result from following query. Otherwise will get error.
select force_logging from v$database;
If feature enables in tablespace level then you will get result from following query. Otherwise will get error.
select tablespace_name,force_logging from dba_tablespaces;
|
|
|
|
|
| Neeraj |
| Posted: Mar 13, 2008 08:09:11 AM | |
|
Total Post: 228
Joined: Jan, 2007
|
i m getting error when i run this query.
\so tell me can i skip this command
alter database force logging;
or its nacessary or i hav any alternate to run this command on 9.0.1.0.1
or i can skipp it bcoz all my tablespace r logging bydefault.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
