Database Cloning without RMAN on windows

CREATE INITSRDB.ORA PFILE IN D:\DATABASE\APP FOLDER

2. CREATE DESTINATION FOLDER DATAFILES FOLDER ONLINE REDOLOGS FOLDER CONTROLFILE FOLDER 3. CREATE SERVICE USING ORADIM

NOTE: CHECK WHETHER THE SERVICE IS RUNNING OR NOT. 4. COPY ALL THE DATAFILES, REDOLOGS TO DESTINATION FOLDER AS IT IS THE CASE OF DATABASE CLONING WITHOUT RMAN 5. GO TO […]

Read More

Connecting PDB in Oracle 12c

To connect as sys or other elevated local users, use the same methods as below, but use ‘as sysdba‘ where necessary Method 1:

Method 2:For other methods, you need to know the service-name for the PDB: Get the service name for the PDB:

or by doing “lsnrctl services LISTENER” and locating service for […]

Read More