When a database has Oracle Managed Files data files, restarting a clone database from an 'instant checkpoint' deletes these data files from the primary database.

Document ID: 275816
http://support.veritas.com/docs/275816

E-Mail this document to a colleague

Details:

Note: This does not happen when using an online or offline checkpoint to create a clone database.

This issue occurs in VERITAS Storage Foundation for Oracle (tm) 4.0 on AIX. The affected Oracle versions are:
- 10gR1 (10.1.0.2 and 10.1.0.3)
- 9iR2 ( 9.2.0.6 and 9.2.0.6 )

For 9iR2, versions 9.2.0.1 - 9.2.0.4, creation of a clone database from an instant checkpoint fails with the following error:
ORA-01511: error in renaming log/data files

Note: When using 9.2.0.6, there is a known Oracle bug (4047527, 2902077) which causes 'alter database open resetlogs' to fail when creating a clone database. The operation fails with the following error:
ORA-00344: unable to re-create online log <file-name>
.
Workaround :

- If your database has Oracle Managed Files (OMF) data files, create a clone database always using online or offline checkpoints

- If your database has OMF data files, and you would like to create a clone database using an instant checkpoint, make sure you use Oracle Disk Manager (ODM). Using ODM protects you from losing OMF data files from the primary database when creating a clone database from an instant checkpoint.

Products Applied:
Storage Foundation for Oracle 4.0 MP1 (AIX)

Last Updated: March 22 2005 10:07 PM GMT
Expires on: 365 days from publish date

Subscribe to receive critical updates about this document

Subjects:
Storage Foundation for Oracle
Application: How To, Informational

Languages:
English (US)

Operating Systems:
AIX

5.1, 5.2, 5.3

Symantec World Headquarters:
20330 Stevens Creek Blvd. Cupertino, CA 95014
World Wide Web: http://www.symantec.com,
Tech Support Web: http://entsupport.symantec.com,
E-Mail Support: http://seer.entsupport.symantec.com/email_forms,
FTP: ftp://ftp.entsupport.symantec.com or http://ftp.entsupport.symantec.com

THE INFORMATION PROVIDED IN THE SYMANTEC SOFTWARE KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. SYMANTEC SOFTWARE DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL SYMANTEC SOFTWARE OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES,EVEN IF SYMANTEC SOFTWARE OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.