Category: Rman

Data Guard today

Today had noticed that redo logs were not being applied to standby. Checking live database alert log showed errors like:

Posted in Rman

Clone a database

The below SQL generates a SQL script that can be used to clone a database, putting tablespaces into hot backup mode one at a time. Run it on the source database, and edit the output to specify new target file

Posted in Rman, Scripts

NID to fix RMAN-20035: invalid high recid

For errors like: RMAN-03014: implicit resync of recovery catalog failed RMAN-06004: ORACLE error from recovery catalog database: RMAN-20035: invalid high recid You can switch the catalog over to a previous incarnation (before an open resetlogs): RMAN> list incarnation of database

Posted in Rman

rman crosscheck archivelog all

If archived redo logs are (wrongly) deleted/moved/compressed from disk without being backed up, the rman catalog will not know this has happened, and will keep attempting to backup the missing archived redo logs. That will cause rman archived redo log

Posted in Rman, Scripts