Tag: RMAN

RMAN-05158: WARNING: Auxiliary (datafile / tempfile) file name conflicts with a file used by the target database

When use RMAN duplicate command to create a copy of source database on a different host or a physical standby database, usually we specify the option "NOFILENAMECHECK" to avoid error messages. However an interesting thing is that starting from Oracle 19c - 19.2.0.0.0, you will see a warning message RMAN-05158: WARNING: auxiliary (datafile) file name … Continue reading RMAN-05158: WARNING: Auxiliary (datafile / tempfile) file name conflicts with a file used by the target database

ORA-26040: Data block was loaded using the NOLOGGING option

I ran into an interesting issue today with ORA-26040. I was using Data Pump to export/import from one database to another database. The export/import scripts (using parameter files) were developed by another team. After import there were some issues so I decided to restore/recover. But when doing recover, I changed my mind and just recovered … Continue reading ORA-26040: Data block was loaded using the NOLOGGING option

ORA-01244: unnamed datafile(s) added to control file by media recovery

Using Point in Time Recovery to migrate a database from one server to another is a common method: you take an RMAN backup from the old server while it's running and restore it on the new server, then you keep copying archive logs from the old system to the new system and recover the database … Continue reading ORA-01244: unnamed datafile(s) added to control file by media recovery

ORA-01623: log xx is current log for instance xxxx (thread 1) – cannot drop

When using RMAN to duplicate/TSPITR a database on a different server with a different disk layout, the parameters db_file_name_convert and log_file_name_convert can be used. However, when using RMAN restore, they cannot be used. Instead, "set newname for datafile" & "switch datafile" are needed for each data file to be restored with a new path and … Continue reading ORA-01623: log xx is current log for instance xxxx (thread 1) – cannot drop

Interesting case with ORA-00245

Today I was checking a new configured RMAN backup job on an ODG standby server in an ODA (X7-2-HA) RAC environment and noticed there was a failure (see below error messages) when doing the autobackup of controlfile and spfile. RMAN-03009: failure of Control File and SPFILE Autobackup command on ORA_DISK_1 channel at 06/23/2020 13:54:27ORA-00245: control … Continue reading Interesting case with ORA-00245

RMAN doesn’t mark control file/spfile backup obsolete with retention policy set to redundancy

With RMAN configure controlfile autobackup set to ON, RMAN automatically creates a control file and an SPFILE backup after you run the BACKUP or COPY commands. If you have a daily backup task, you will see autobackup of control file and spfile created every day after your main backup. That is good, huh! They are … Continue reading RMAN doesn’t mark control file/spfile backup obsolete with retention policy set to redundancy

RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece

Quite often we run into “RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece” when restoring a controlfile from autobackup, especially when trying to restore the backup from a differnt machine and a recovery catalog -- a database schema that contains the RMAN repository data for one or more target … Continue reading RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece