Recover table in oracle 12c

Oracle 12.2 came with a new feature , we can simply recover a single table in a database. In below example we will see how we can restore a table of pluggable database. Step 1 : Connect to RMAN Step 2 : Use following command to recover table I.E. here I have table TEST which […]

Read More

MUST_RENAME_THIS_DATAFILE on RAC Standby

Few days ago i got the activity to create the 2 NODE RAC DR on EXADATA for 2 NODE RAC Production. Here I am listing few issues that made this activity perfect case for Data Guard beginners Environment:Production Database Name: Financedb_unique_name : finance Standby Database Name : Finstandbydb_unique_name : finstandby Production OS Node: agoracledba1 agoracledba2Standby […]

Read More