Hi Mark,
No problem here, I pasted the text below:
Problem:
Performing a recovery from a hot (online) backup of the database can result
in the logical corruption of data after recovery if you are using any of the
BMC SQL-BackTrack for Oracle products with Oracle Database 10g and have
enabled the recycle bin.
Solution Description:
By default SQL-Backtrack for Oracle issues the query
SELECT BLOCK_ID,BLOCKS from SYS.DBA_FREE_SPACE WHERE FILE_ID=<file id of
datafile>;
in order to determine the NULL blocks or free space of a datafile.
Unfortunately because of Oracle bug 5083393 this query doesn't return the
correct NULL blocks. This can happen under the following conditions:
- Oracle version is 10.1.0.4 or higher
- recyclebin is enabled
- there are one or more dropped tables which were not purged from recyclebin
Workarounds:
1.)
a) Locate the BMC SQL-BackTrack parameters file in the following directory:
- For UNIX systems: $DTBASE/obacktrack/ctl
- For Microsoft Windows systems: %DTBASE%\obacktrack\ctl
b) Add following line to (optional) parameters file:
skip_null_block_query=true
2.) disable Recycle Bin
a) for Oracle version 10.1
SQL> CONN sys AS sysdba
SQL> SELECT a.ksppinm, b.ksppstvl, b.ksppstdf
FROM x$ksppi a, x$ksppcv b
WHERE a.indx = b.indx
AND a.ksppinm LIKE '%recycle%'
ORDER BY a.ksppinm;
SQL> ALTER SYSTEM SET "_recyclebin" = FALSE;
b) for Oracle version 10.2
SQL> SHOW PARAMETER recyclebin
SQL> ALTER SESSION SET recyclebin = OFF;
or
SQL> ALTER SYSTEM SET recyclebin = OFF;
Below, is the entire content of the BMC SQL-BackTrack for Oracle Flash,
dated September 15, 2006, regarding this issue:
=======================================================================================
This flash describes a workaround for the products listed above to prevent
the problem from occurring. If you have any questions about the problem or
the solution, contact BMC Software Customer Support at 800 537 1813 (United
States or Canada) or call your local support center.
Problem
Performing a recovery from a hot (online) backup of the database can result
in the logical corruption of data after recovery if you are using any of the
BMC SQL-BackTrack for Oracle products with Oracle Database 10g and have
enabled the recycle bin.
Cause
The Oracle bug 5510991 (base bug 5083393) affects an Oracle query (referred
to as the NULL BLOCK query in this flash). The BMC SQL-BackTrack for Oracle
products use this query during a hot (online) backup of the database to
identify and then skip the free blocks in a data file. By default, the BMC
SQL-BackTrack products use the Oracle standard view SYS.DBA_FREE_SPACE to
query free blocks, also known as NULL blocks.
During a hot database backup for Oracle Database 10g with the recycle bin
enabled, this bug can cause Oracle (SYS.DBA_FREE_SPACE view) to incorrectly
identify blocks that contain data as NULL blocks. This, in turn, causes the
data in these mis-identified blocks to be ignored during a backup with BMC
SQL-BackTrack.
Does this problem affect my database backup?
Perform the following checks, to determine if this problem affects your
database backup.
1 Use SQLPLUS to run the appropriate query to determine if the recycle bin
is enabled on your database.
For Oracle version 10.1.xxx, use
Show parameter _recyclebin
If the value of the parameter is TRUE, then the recycle bin is enabled on
your database.
For Oracle 10.2.xxx, use
Show parameter recyclebin
If the value of parameter is on, then the recycle bin is enabled on your
database.
If recycle bin is not enabled, it is unlikely that your database backup is
affected. If the recycle bin is enabled, then continue and run the queries
shown in next two steps.
2 Run the following query:
Select block_id, count(*) from dba_free_space group by block_id having
count(*) > 1;
If the above query returns any row, then your database backup is potentially
affected.
3 Run the following query
Select count(*) from dba_free_space where file_id != relative_fno;
If the above query returns a value greater than zero, then your database
backup is potentially affected.
Workaround
BMC Software has developed a workaround for this Oracle bug. If you are
using Oracle 10.2.0.2 on a Solaris 64-bit platform, you can either use the
following workaround to disable the NULL BLOCK query or install an Oracle
patch designated in "Alternative Oracle patch".
Disable the NULL BLOCK query
Use the following procedure to disable the standard NULL BLOCK query used by
the BMC SQL-BackTrack for Oracle products during hot backups.
1 Locate the BMC SQL-BackTrack parameters file in the following directory:
For UNIX systems: $DTBASE/obacktrack/ctl
For Microsoft Windows systems: %DTBASE%\obacktrack\ctl
2 Add following parameter to the BMC SQL-BackTrack parameters file:
skip_null_block_query=true
3 If you do not find the parameters file, use a text editor to create the
file in the ctl directory identified in Step 1 and add the parameter.
These steps ensure that the BMC SQL-BackTrack for Oracle products do not use
the NULL BLOCK query to identify null blocks. Instead, the products read
each individual block in the database during backups to correctly identify
and skip the NULL blocks. Disabling the standard NULL BLOCK query results in
additional I/O.
--------------------------------------------------------------------------------
Even if (1) the recycle bin is disabled or (2) the recycle bin is
enabled but neither query indicated that your database backup is affected,
BMC Software recommends that you do the following:
1. Use this workaround and disable the NULL BLOCK query for future backups.
2. Take a full backup immediately after disabling the NULL BLOCK query.
NOTE:
--------------------------------------------------------------------------------
Alternative Oracle patch
If your are using Oracle 10.2.0.2 on a Solaris 64-bit platform, you can
install the Oracle patch 5083393, or use the workaround from BMC Software to
fix the 5083393 bug. If you are using any other version of Oracle 10g on any
other platform, you must use the workaround on page 3 to disable the NULL
BLOCK query.
Where to get the latest product information
To view the latest BMC Software documents, visit the Customer Support page
at http://www.bmc.com/support_home. BMC Software distributes printed copies
of flashes, technical bulletins, and release notes with most product
shipments, as indicated on your shipping list. In addition, all notices are
available on the Customer Support page, including any notices that BMC
Software issues after you receive your product shipment. You will not
receive new notices by mail. However, by subscribing to proactive
notification, you can receive e-mail messages that direct you to those
notices. For more information about proactive notification, refer to the
Customer Support page.
To obtain the latest version of these products, contact your BMC Software
sales representative or contact BMC Software Sales at 800 793 4262.
2008/8/11, Mark Milke <[EMAIL PROTECTED]>:
>
> Hello Listers,
>
> I was wondering if you guys have more luck searching Remedy's
> Knowledge Base. Trying to view the SLN000000226633 I'm getting this:
>
>
> Caught exception
> http://support.bmc.com/arsys/resources/javascript/ClientCore.js:8542
> - TypeError:
>
> fi is undefined... AT:
>
> Field_Defaults(0,1,0)@http://support.bmc.com/arsys/resources/
> javascript/ClientCore.js:8542
> EventWindowOpen([object Object])@http://support.bmc.com/arsys/
> resources/javascript/ClientCore.js:9775
> ([object Object])@http://support.bmc.com/arsys/resources/javascript/
> ClientCore.js:2333
> SetupState()@http://support.bmc.com/arsys/resources/javascript/
> ClientCore.js:1184
> ([object Object])@http://support.bmc.com/arsys/resources/javascript/
> ClientCore.js:2334
> WorkflowContext([object Object])@http://support.bmc.com/arsys/
> resources/javascript/ClientCore.js:2292
> ARSystemInit()@http://support.bmc.com/arsys/resources/javascript/
> ClientCore.js:951
> ScriptLoaded()@http://support.bmc.com/arsys/apps/remcspenu.bmc.com/SSP/
> SHARE%3ASolution/KM/?mode=4&eid=SLN000000226633&cacheid=97078374:5
> onload([object Event])@http://support.bmc.com/arsys/apps/
> remcspenu.bmc.com/SSP/SHARE%3ASolution/KM/?
> mode=4&eid=SLN000000226633&cacheid=97078374:1
>
>
> Mark
>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
