Comments
- Phil Dunn (@Phil_Oracle) on Oracle’s New T5 TPC-C: Where’s the SPARC?, Part II
- ODBC on Installing the Netezza ODBC Driver.
- ashish on View deleted data in Netezza with view_deleted_records.
- Gary on Installing the Netezza ODBC Driver.
- venkat on Installing the Netezza ODBC Driver.
- Gary on EMCA Fails With Error “Failed to allocate port(s) in the specified range(s) for the following proces
- arnab on EMCA Fails With Error “Failed to allocate port(s) in the specified range(s) for the following proces
- Hank Classe on ANS1017E (RC-50) Session rejected: TCP/IP connection failure
- Sean Robinson on Registering with Multiple listeners.
- Gary on Sending nzevent emails for system state changes.
Meta
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 all, archivelog, backup, database, missing archives, plus, recoverable, Rman, unrecoverable
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.
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.
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
Configure Rman to Purge Application standby logs.
Configure RMAN to purge archivelogs after Application on standby.
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.
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 active, archivelog, backup, cannot~backup, COPY, noarchivelog, ORA-19602, Rman, shutdown, STARTUP~MOUNT
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 backup incremental, copy of database, cumulative, recover copy of database, Rman
Comments Off
Dropping a database in SQL or RMAN.
Dropping a database in SQL or RMAN.
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 backup, BACKUP~DATABASE, NOT~CURRENT, Rman, SYS.DBMS_BACKUP_RESTORE, Target, TARGET~DATABASE, VERSION
Comments Off