Restore and Upgrade Oracle Database from 11gR2 to 12c from Exadata X4-2 to X7-2

Upgrade from Exadata X4-2 11g (11.2.0.4) to Exadata X7-2 12CR1 (12.1.0.2.0) : ASM to ASM Oracle Database 11.2.0.3and 11.2.0.4 to Oracle 12.2.0.1 Direct upgrade is supported by Oracle. If you have Database lower than those version than you have to upgrade to 11.2.0.4 first and you can upgrade to 12cR2 In our Scenario We will … Continue reading Restore and Upgrade Oracle Database from 11gR2 to 12c from Exadata X4-2 to X7-2

ORA-00245 control file backup failed target is likely on a local file system

Solution: This happens when you havea RAC setup and you are backing up the Snapshot of the controlfile to a local disk instead of a shared disk. In our setup we setup an ACFS file system on both nodes of RAC and changed RMAN parameter as below RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/ACFS/snapcf_mw1.f'; new … Continue reading ORA-00245 control file backup failed target is likely on a local file system

RMAN database restore until time

I had a block corruption of my primary database, though we had a standby build we wanted to recover the Primary instead of failover to the Standby. This recovery is possible when you have say a full backup made of the database till 9th May and all archivelogs from 9th May till 12th MAY are … Continue reading RMAN database restore until time

A Ballad For a DBA

Dedicated to Gwen Shapira It’s a tale of woe and malice, a tale of a DBA That the users learned to fear and to get out of his way He would drop production tables when complaints had grown to loud He would smile and feign surprise and then suggested “use the cloud” He would backup … Continue reading A Ballad For a DBA

I've lost an archived/online REDO LOG file, can I get my DB back?

The following INIT.ORA/SPFILE parameter can be used if your current redologs are corrupted or blown away. It may also be handy if you do database recovery and one of the archived log files are missing and cannot be restored. NOTE: Caution is advised when enabling this parameter as you might end-up losing your entire database. … Continue reading I've lost an archived/online REDO LOG file, can I get my DB back?

ORA-38701: Flashback database log seq thread

The database does not startup, and gives errors like: ORA-38737: Expected sequence number 2483 doesn't match 2304 ORA-38701: Flashback database log 143 seq 2483 thread 1: These errors can be seen in the Alert.log file. These errors occur and prevent the database from starting up because, at some point prior, we were not able to … Continue reading ORA-38701: Flashback database log seq thread

Backup Controlfile to Trace

How to backup the Oracle Control File? There are two approaches: you either generate a binary image of the Control File, or you generate a text file script which will re-generate a Control File when run as a SQL script. To create the binary image, issue the command ALTER DATABASE BACKUP CONTROLFILE TO 'C:\SOMEWHERE\CONTROL01.BKP'; (obviously … Continue reading Backup Controlfile to Trace

RMAN-06059: expected archived log not found. ORA-19625:

Whenever you are trying to backup Archivelogs from RMAN you might get the following error. Starting backup at 25-FEB-10 current log archived archived log /u2/archivelogs/1_12241_642439782.dbf not found or out of sync with catalog trying alternate file for archivelog thread 1, sequence 12241 released channel: ch1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: … Continue reading RMAN-06059: expected archived log not found. ORA-19625:

Backup and Recovery Best Practices RMAN Oracle 10g

1. Turn on block checking REASON: The aim is to detect, very early the presence of corrupt blocks in the database. This has a slight performance overhead, but Checksums allow Oracle to detect early corruption caused by underlying disk, storage system, or I/O system problems. SQL> alter system set db_block_checking = true scope=both; 2. Turn … Continue reading Backup and Recovery Best Practices RMAN Oracle 10g