Showing posts with label RMAN. Show all posts
Showing posts with label RMAN. Show all posts
Wednesday, October 9, 2024

Workaround for ORA-27069 attempt to do I/O beyond the range of the file during RMAN clone from active database

›
This is the message I received when starting an active database duplication using RMAN: RMAN-00571: =======================================...
Thursday, July 11, 2024

How to solve RMAN-08137: warning: archived log not deleted, needed for standby or upstream capture process

›
In one of my cloned databases, the FRA was filling up and pushing towards the limit of 2 TB. Since it was cloned from a production databas...
1 comment:
Tuesday, October 3, 2023

What to do if your flash recovery area is filled with "foreign archive logs"?

›
One of my databases came to a halt when the flash recovery area filled completely. It wasn't a problem with space preassure, but mer...
Thursday, February 3, 2022

Observation: rman saves files according to end date of backup

›
I noticed the following: An archivelog file backed up at 1.01.2022 23:57:18 will NOT be saved in the folder for 31.01.2022. Instead, it wi...
Tuesday, April 13, 2021

How to solve "RMAN-04014: startup failed: ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated" during cloning

›
During an attempt to clone for active database I had created pfile with my desired value for the parameter db_recovery_file_dest, which was...
Wednesday, December 16, 2020

How to fix error SYS.DBMS_BACKUP_RESTORE version 18.11.00.00 in TARGET database is not current

›
Even if you're not using a recovery catalog, you may encounter this issue if you have recently patched your database. Simply by connec...
2 comments:
Tuesday, July 21, 2020

How to fix RMAN-04006 when cloning from active database

›
Background: During an attempt to clone database using active duplication, I received an error when testing my connectivity to the target...
Friday, June 19, 2020

How to run RMAN with debug information

›
Tested with Oracle 12.2 For example, to trace a duplicate database session, I have put the following into a file called "run_duplica...
Friday, April 3, 2020

How to work around hung rman process when duplicating from active database

›
Applicable for Oracle 12.1. During a "clone from active database" operation, I had a seemingly stuck restore process. It used a...
1 comment:
Monday, August 5, 2019

How to work around RMAN-08120: warning: archived log not deleted, not yet applied by standby

›
Problem scenario: * You have a primary database with two standby databases. * One of them is functional, the other one is about to be...
Thursday, August 1, 2019

How to avoid RMAN-10015 when using sql-directives in an RMAN script

›
When attempting to use an sql directive in RMAN, you will sometimes be instructed to use the following syntax: sql "alter session se...
Wednesday, February 6, 2019

A workaround for RMAN-04014: startup failed: ORA-27069: attempt to do I/O beyond the range of the file after a clone from active database

›
My clone from active database failed at the very end of the procedure with RMAN-04014: startup failed: ORA-27069: attempt to do I/O beyon...
Monday, November 19, 2018

How to use rman to create a backup-based clone on a remote server

›
It has been a while since I needed to use this technique, since we rely on storage snapshot clones these days. Sometimes though, a good old...
Thursday, November 19, 2015

How to handle RMAN DUPLICATE: Errors in krbm_getDupCopy during duplicate

›
I recently cloned a 11.2.0.4 database using tape backups as source. The clone failed right before "open resetlogs". In other wor...
1 comment:
Tuesday, July 21, 2015

How to solve ORA-17628: Oracle error 19505 returned by remote Oracle server during clone from active database

›
After some time, my RMAN "duplicate from active database" script threw the error below: RMAN-03009: failure of backup command on...

How to solve ORA-17627: ORA-12154: TNS:could not resolve the connect identifier specified during clone from active database

›
During an attempt to clone from active database, the following error was thrown: RMAN-00571: =============================================...
4 comments:
Tuesday, February 17, 2015

How cloning from backup became a little more secure in Oracle 11g

›
From version 11, Oracle supplied another method to use during cloning, namely "Backup-based duplication without a target connection...
Wednesday, January 21, 2015

How to relocate the block change tracking file

›
To relocate the block change tracking file you have two options: 1) shutdown database, mount database, update control file, open database ...
Monday, December 15, 2014

How to solve "ORA-06502: PL/SQL: numeric or value error" when cloning a database

›
While attempting to clone an Oracle 11gR2 production database, Oracle returned "ORA-06502: PL/SQL: numeric or value error". The ...
4 comments:
Thursday, November 20, 2014

How to flash the database back to a guaranteed restore point

›
After a week of testing their new release, my customer wanted their database reset to the state it was previously in. Earlier this week, I...