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
Category Archives: Recovery Manager
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
ANS1017E (RC-50) Session rejected: TCP/IP connection failure
A client received the following trace stack. RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on t1 channel at 06/10/2011 06:20:28 ORA-19502: write error on file “d_SRAORA_srmegs8t_1_1″, blockno 474113 (blocksize=512) ORA-27030: skgfwrt: … Continue reading
Posted in Recovery Manager, TSM
Tagged ANS1017E, ORA-27030, sbtwrite2 returned error, Session rejected, skgfwrt, TCP/IP connection failure, TSM
1 Comment
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.
Using DBMS_REPAIR to check for corruption.
dbms_repair can be used to check for corruption in the database. Here’s what to do when corruption is reported in the alert log.
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
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.
RMAN-06553 DB_CREATE_FILE_DEST must be set for SET NEWNAME … TO NEW
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 02/25/2011 13:06:27 RMAN-06553: DB_CREATE_FILE_DEST must be set for SET NEWNAME … TO NEW
Posted in Configuration., Oracle, Recovery Manager
Tagged DB_CREATE_FILE_DEST, RMAN-00569, RMAN-00571, RMAN-03002, RMAN-06553, SET NEWNAME, TO NEW
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 active, archivelog, backup, cannot~backup, COPY, noarchivelog, ORA-19602, Rman, shutdown, STARTUP~MOUNT
Comments Off
