Dinesh DBA

Recover The Table space From Flashback Database Backup was taken of both controlfile and datafile at 10 am. At 11 am Tablespace was created and at 1pm tablespace was dropped. How to Recover the tablespace using cold backup. Solution - If you actually DROPPED the tablespace, the controlfile you're trying to use will have no record of the tablespace. You can recover with Flash database or You will need to do a point in time recovery using a backup controlfile from a time when the tablespace existed, then recover up to the point before the drop. Using Flashback database :- 1. Configure the Oracle Database for Flashback SQL> shutdown immediate; SQL> startup mount SQL> ALTER DATABASE FLASHBACK ON; SQL> ALTER DATABASE OPEN; SQL> create tablespace test_restore datafile 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST5\MYTEST08.DBF' size 5m; Tablespace created. SQL> create table test tablespace test_restore as select level a1 from dual...

Database Clone Using RMAN on same server with connection to Target and Catalog DB. My Environment Operating System : RHEL 6.4 64 Bit DB Version : 12CR1 [12.1.0.1.0] Primary DB Name : ORCL Primary DB Mount Point : /PRIM Clone DB Name : ORATEST Clone DB Mount Point : /TEST Creating Directory Structures: First need to create directory structure for the clone db. Easy way to create the directory structure is copy the source filesystem and change the path according to the clone db requirement and delete the content of the source at clone db side. Copy ORACLE_BASE and ORACLE_HOME from source to clone db. Create directory structure for control files, fast_recovery_area. Create directory structure for audit files. Establishing Connection: Edit listener.ora, tnsnames.ora and pfile copied from source db and change according to clone db. Below is the content of my clone db listener, tnsnames file and pfile. Once everything is changed, copy the clo...