Auxiliary oracle db

Posted on 2009-04-22
Last Modified: 2013-12-19
Hi all

I have a question in restore from user managed backups.
Recently a user made a wrong update to a prod table, the db does "user managed backups". So i am trying to do TSPITR manually to get teh table back following the steps provided in this link

we use oracle 9.2.06

When i try to do this part


I get the following error in sqlplus:

SQL> recover database until cancel using backup controlfile;
ORA-00283: recovery session canceled due to errors
ORA-01221: data file 1 is not the same file to a background process

alert log has this:
ORA-01186: file 1 failed verification tests
ORA-01221: data file 1 is not the same file to a background process

and the dbwr's trace has

ORA-01186: file 1 failed verification tests
ORA-01221: data file 1 is not the same file to a background process
ORA-01110: data file 1: 'orcl/aux/prod_system_01.dbf'
The path in V$datafile is the same place where the file exists. I have this specified in the init file using the db_filen_ame_convert.

Please let me know if you know how to get this working. Also if there are other ways to restore  from user managed bkups thats fine too.

Question by:san_jy
    LVL 47

    Accepted Solution

    But if you use user managed backup possibly it will be better
    to use a normal backup (without RMAN, that adds additional level of complexity).


    Do the 'oracle' user has access to the directory

    ORA-01186: file string failed verification tests
    Cause: The data file did not pass the checks to insure it is part of the database. See the accompanying error messages for the reason the verification failed.

    Action: Make the correct file available to the database. Then, either open the database, or execute ALTER SYSTEM CHECK DATAFILES.
    LVL 40

    Expert Comment

    What are the full paths? 'orcl/aux/' is a relative path, not a full path.

    What does your db_filename_convert line look like?

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
    Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now