Tag Archives: Rman

Backing up wrong.

A client has the backup defined to do the following: set parameters. Backup database. Backup archivelogs. Backup controlfile. Whilst this appears to be fine, in this case it resulted in an un-recoverable backup. Why ?

Posted in Oracle, Recovery Manager | Tagged , , , , , , , , | Comments Off

Performing Incremental Backups.

Oracle’s support for incremental backups allows larger database’s to be backed up incrementally over a longer period of time, whilst reducing the overhead and size required for the backup pieces.

Posted in Recovery Manager | Tagged , | Comments Off

Restoring a database from TSM.

If you require to restore a database from TSM, you will require some additional information than just your backup tape.

Posted in Oracle, Recovery Manager | Tagged , | Comments Off

RMAN-03002 and ORA-06510

RMAN-03002: failure of restore command at 05/14/2009 02:18:01 ORA-06510: PL/SQL: unhandled user-defined exception

Posted in Recovery Manager | Tagged , , , , | Comments Off

Configure Rman to Purge Application standby logs.

Configure RMAN to purge archivelogs after Application on standby.

Posted in Configuration., Recovery Manager | Tagged , , , | Comments Off

Create and schedule a rolling copy backup.

I needed to implement on windows a rolling backup on a database. This is how I’ve done it, oracle 11g R2.

Posted in Recovery Manager | Tagged , , , | Comments Off

ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode

I am trying to do a full RMAN cold backup and am getting the following : ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode What’s the cause ?

Posted in Oracle, Recovery Manager | Tagged , , , , , , , , , | Comments Off

Performing a Rolling copy Backup.

The following Rman script will perform a backup copy which is rolled forward.

Posted in Recovery Manager | Tagged , , , , | Comments Off

Dropping a database in SQL or RMAN.

Dropping a database in SQL or RMAN.

Posted in Recovery Manager | Tagged , , , | Comments Off

PL/SQL package SYS.DBMS_BACKUP_RESTORE version 10.02.00.02 in TARGET database is not current

Rman reported an interesting error. PL/SQL package SYS.DBMS_BACKUP_RESTORE version 10.02.00.02 in TARGET database is not current This occurs where the wrong rman version is used on a different version database. Here’s how it occured.

Posted in Enterprise Manager | Tagged , , , , , , , | Comments Off