Talip Hakan Ozturk's ORACLE BLOG

Hello Friends, Your RMAN restore operation may fail if you try to restore RMAN full backup on the server that was previously restored and then opened with resetlogs. In this blog post, I will describe, how to resolve this issues. Problem: I tried to restore RMAN full backup on the server that was previously restored …

Hello Friends, A few days ago, something happened to my friend. His database running on windows is suddenly crashed and called me immediately 🙂 When I tried to open it, I saw that all control files had corrupted. And to make matters worse, the database was running in NOARCHIVELOG mode 😦 and there was no …

Hello Friends, The multitenant option brings with it a number of changes to the way we approach backup and recovery. In this blog post I will describe backup and recovery methods If you type rman target / command, it connects to CDB. When connecting to a PDB to perform backup and recovery operations, you must …

Hello Friends, In this blog post, I will write about necessary steps to transport an entire database from one platform to another: Firstly We need ensure that the prerequisites required to perform cross-platform database transport are OK. 1- The COMPATIBLE parameter of the source database and the destination database must be set to 12.0.0 or …

Hello Friends, In my previous blog post, we performed a database upgrade from 11g to 19c. In this blog post, I will explain how to convert a single instance 19c Oracle database to a RAC database. Firstly, let me create undo tablespaces Drop the log groups 1,2,3,4,5,6 and recreate log groups 1,2,3,4,5,6 with THREAD 1 …