Note: Check the logfile, datafiles & instance status GROUP 3 '/U01/oradata/stgsrv/redo03.log' SIZE 200M GROUP 2 '/U01/oradata/stgsrv/redo02.log' SIZE 200M, GROUP 1 '/U01/oradata/stgsrv/redo01.log' SIZE 200M, Using backup controlfile trace to generate the create controlfile scripts.Ĭhange the Database name & files path, also change 'REUSE' needs to be changed to 'SET'.ĬREATE CONTROLFILE SET DATABASE "stgsrv" RESETLOGS FORCE LOGGING NOARCHIVELOG (Database in windows we need to create the service id using oradim utility)ĥ.Create the control file for cloning database. If database running in pfile using os command to copy the pfile and placed in backup path.Īlter database backup controlfile to trace as ‘/u01/backup/control01.ora’ ĥ.Copy all the data files/log files using os command & placed in backup path.ġ.Create the appropriate folder in corresponding path & placed the backup files in corresponding folder.(bdump,udump,create,pfile,cdump,oradata)Ģ.Change the init.ora parameter like control file path, dbname, instance name etc.ģ.Create the password file using orapwd utility.
Get the file path information using below queryĬreate pfile=’/u01/backup/initstgsrv.ora’ from spfile Friday, octoCloning Oracle Database - Cold Cloning, Hot CloningĬlone an Oracle Database using Cold Physical Backupġ.
0 kommentar(er)
