Posts Tagged ‘RMAN’

Oracle Physical Standby Archive Log Gap Resolution

+28 Getting below in Alert log: ——————————————————————————————————- SUCCESS: diskgroup VOL10 was dismounted Media Recovery Waiting for thread 1 sequence 4709 Fetching gap sequence in thread 1, gap sequence 4709-4711 Fri Aug 22 13:00:33 2014 FAL[client]: Failed to request gap sequence  GAP – thread 1 sequence 4709-4711  DBID 238289769 branch 788617304 FAL[client]: All defined FAL servers […]

ORA-16038 ORA-19809 ORA-00312

+9 ORA-16038 ORA-19809 ORA-00312 Got below error during open database: ORA-16038: log 4 sequence# 1 cannot be archived ORA-19809: limit exceeded for recovery files ORA-00312: online log 4 thread 1: '/u01/oradata/cobra/redo01.log' got below error in alert log at same time during troubleshooting problem: Errors in file /export/home/oracle/admin/cobra/udump/cobra_ora_9485.trc: ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 100.00% […]


+12 RESTORE RMAN BACKUP FROM ONE SERVER TO ANOTHER SERVER ON DIFFERENT LOCATION:   Lets take two servers as: SERVER1 SERVER2 ON SERVER1: DB Name: nsndb –Take backup of nsndb with archivelog,controlfile and spfile. –Copy all backupsets from SERVER1(Location: /data1/bak/nsndb/) to SERVER2(Location:/u01/backup/nsndb/) ON SERVER2: –Create pfile for database nsndb. DB Name: nsndb #export ORACLE_SID=nsndb #rman […]

RMAN Recovery Catalog Creation in Oracle 10g

+10 Creating Recovery catalog (RMAN in Oracle 10g) Follow following Steps: STEP1: Create a new database(catdb) for RMAN Recovery catalog databaseAnd also Create a new tablespace in the new database (CATDB). $ sqlplus /nologCONNECT SYS/passwd@catdb AS SYSDBA;CREATE TABLESPACE rmanDATAFILE ‘/u02/app/oradata/rman/rman01.dbf’ size 100m; STEP2:Create the Recovery Catalog Owner in the new database (CATDB): CREATE USER rman […]