Database Cloning without RMAN on windows

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

*.db_name='srdb2'
*.control_files='D:\DATABASE\APP\SHRIRAM\REDOLOGS\srdb2\CONTROLFILE\O1_srdb2.CTL'

2. CREATE DESTINATION FOLDER

• DATAFILES FOLDER
• ONLINE REDOLOGS FOLDER
• CONTROLFILE FOLDER

3. CREATE SERVICE USING ORADIM

ORADIM -NEW -SID SRDB2

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 COMMAND PROMPT

SET ORACLE_SID =SRDB2

SQLPLUS / AS SYSDBA

STARTUP NOMOUNT PFILE= D:\database\app\ShriRam\product\11.2.0\dbhome_1\database\INITsrdb2.ORA

6. NOW CREATE THE CONTROLFILE AS WE COPIED FROM THE TRACE FOLDER OF THE PREVIOUS DATABASE CONTROLFILE

CREATE CONTROLFILE SET DATABASE "SRDB" RESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 'D:\DATABASE\APP\SHRIRAM\REDOLOGS\SRDB\ONLINELOG\01_MF_3_CMBQOPBX_.LOG' SIZE 50M BLOCKSIZE 512,
GROUP 2 'D:\DATABASE\APP\SHRIRAM\REDOLOGS\SRDB\ONLINELOG\O1_MF_2_CNLX5V65_.LOG' SIZE 50M BLOCKSIZE 512,
GROUP 3 'D:\DATABASE\APP\SHRIRAM\REDOLOGS\SRDB\ONLINELOG\O1_MF_3_CNLX5VO1_.LOG' SIZE 50M BLOCKSIZE 512
DATAFILE
'D:\DATABASE\APP\SHRIRAM\ORADATA\SRDB\DATAFILE\O1_MF_SYSTEM_CNLX20WS_.DBF',
'D:\DATABASE\APP\SHRIRAM\ORADATA\SRDB\DATAFILE\O1_MF_SYSAUX_CNLX20XR_.DBF',
'D:\DATABASE\APP\SHRIRAM\ORADATA\SRDB\DATAFILE\O1_MF_UNDOTBS1_CNLX20YT_.DBF',
'D:\DATABASE\APP\SHRIRAM\ORADATA\SRDB\DATAFILE\O1_MF_USERS_CNLX210T_.DBF',
'D:\DATABASE\APP\SHRIRAM\ORADATA\SRDB\DATAFILE\O1_MF_EXAMPLE_CNLX2102_.DBF',
'D:\DATABASE\APP\SHRIRAM\ORADATA\SRDB\DATAFILE\O1_MF_SRDBTBS_CNLX20YQ_.DBF',
'D:\DATABASE\APP\SHRIRAM\ORADATA\SRDB\DATAFILE\USER1.DBF'
CHARACTER SET AL32UTF8;

CONTROLFILE CREATED

ALTER DATABASE OPEN RESETLOGS

DATABASE OPENED

NOW WE CAN CHECK OUR DATABASE FILES like DATAFILES, REDOLOGS, CONTROLFILE AS PER THE GIVEN DESTINATION.

SO, THE DATABASE CLONING IS DONE WITHOUT RMAN HAS BEEN COMPLETED SUCESSFULLY.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

Anuradha’s LinkedIn: Anuradha’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp