Upgrade from Exadata X4-2 11g (184.108.40.206) to Exadata X7-2 12CR1 (220.127.116.11.0) : ASM to ASM Oracle Database 18.104.22.168and 22.214.171.124 to Oracle 126.96.36.199 Direct upgrade is supported by Oracle. If you have Database lower than those version than you have to upgrade to 188.8.131.52 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
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
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
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
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?
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
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