By default, when you restore database tables to a target instance, the system automatically duplicates the source database to an auxiliary instance in a temporary staging location specified during the restore operation. The database will be automatically imported from this auxiliary instance after the restore.
Use the following steps to set up a specific database as an auxiliary instance. This is useful when you want to restore a table to a specific failure point.
-
Copy the init<SID>.ora file from the source database to the auxiliary database instance.
-
Update the database name and the database file locations in the init<SID>.ora file for the auxiliary database instance.
-
Add the DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT parameters in the init<SID>.ora file. These parameters will redirect the datafiles, temp files, and log files to the auxiliary instance.