What is auxiliary Instance in RMAN?
AUXILIARY DATABASE – An Auxiliary Database is a standby database that will be created as a result of the duplication of the target database. In RMAN’s terminology, Auxiliary instance identifies an instance which RMAN connects in order to execute the duplicate command.
What is Log_file_name_convert?
LOG_FILE_NAME_CONVERT converts the filename of a new log file on the primary database to the filename of a log file on the standby database. The first string is the pattern found in the log file names on the primary database. The second string is the pattern found in the log file names on the standby database.
What is auxiliary destination?
The auxiliary destination, an optional location on disk which can be used to store any of the auxiliary set datafiles, control files and online logs of the auxiliary instance during TSPITR. Files stored here can be deleted after TSPITR is complete.
What is use of duplicate command?
Use the DUPLICATE command to create a copy of a source database. RMAN can create either of the following types of databases: A duplicate database, which is a copy of the source database (or a subset of the source database) with a unique DBID.
Do you need to back up tablespace after tspitr?
You cannot run TSPITR again on this tablespace to recover it to any time less than or equal to time t, nor can you use the current control file to recover the database to any time less than or equal to t. Therefore, you must back up the recovered tablespace as soon as TSPITR is complete.
Can a tspitr be performed on an earlier SCN?
If you try to perform a TSPITR to an SCN earlier than the rename operation, RMAN cannot find the new tablespace name in the repository as of that earlier SCN (because the tablespace did not have that name at that SCN). In this situation, you must recover the entire database to a point in time before the tablespace was renamed.
How does RMAN tablespace point in time ( tspitr ) work?
This section explains the basic concepts, preparatory tasks, and modes of running RMAN TSPITR. Recovery Manager (RMAN) TSPITR enables quick recovery of one or more tablespaces in a database to an earlier time without affecting the rest of the tablespaces and objects in the database.
How to identify the target time for tspitr?
To investigate past states of your data to identify the target time for TSPITR, you can use features of Oracle such as Oracle Flashback Query, Oracle Transaction Query and Oracle Flashback Version Query to find the point in time when unwanted database changes occurred.