1. Create the following files:
CheckForFileExists.sql
SET serveroutput ON
SET FEEDBACK OFF
begin
IF dbms_lob.FileExists(BFILENAME('&1','&2')) = 1 THEN
DBMS_OUTPUT.PUT_LINE('Backup File Exists');
ELSE
DBMS_OUTPUT.PUT_LINE('Backup File Does Not Exists');
END IF;
end;
/
exit;
CreateBackupDirectory.sql
set serveroutput on;
CREATE OR REPLACE DIRECTORY &1 AS '&3';
GRANT READ, WRITE ON DIRECTORY &1 to &2;
exit;
RecompileSchema.sql
DBMS_OUTPUT.ENABLE (buffer_size => NULL);
set serveroutput on;
DBMS_OUTPUT.PUT_LINE('Recompile schemas started: $2');
exec DBMS_UTILITY.compile_schema('&2');
commit;
DBMS_OUTPUT.PUT_LINE('Recompile schemas finished');
exit;
CreateBackup.cmd
set NLS_LANG=russian_cis.ru8pc866
rem %1 = Schema Name
rem %2 = Server Name
rem %3 = sqlplus.exe path
rem %4 = Backup directory alias
rem %5 = Exported dump name
rem %6 = Backup file directory(\\tscrm.com\dfs-ts\ReleaseBackups\For_7.10.2\)
rem %7 = Instance Port
%3 "SYSTEM/admin@%2:%7/orcle AS SYSDBA" @CreateBackupDirectory.sql %4 %1 %6
%3 "%1/%1@%2:%7/orcle" @RecompileSchema.sql "%1" "%1"
%3 -S "SYSTEM/admin@%2:%7/orcle" as sysdba @CheckForFileExists.sql %4 %5
expdp "%1/%1@//%2:%7/orcle" SCHEMAS=%1 DIRECTORY=%4 DUMPFILE=%5 NOLOGFILE=YES CONSISTENT=N VERSION=11.2.0.1.0 PARALLEL=2 COMPRESSION=ALL
exit /b %ERRORLEVEL%
rem sqlplus BPMONLINE520BANKSOFTKEY/BPMONLINE520BANKSOFTKEY@TSCOREBUILD_ORA11 @NoAuditSession.sql
rem exp BPMONLINE520BANKSOFTKEY/BPMONLINE520BANKSOFTKEY@TSCOREBUILD_ORA11 triggers=y indexes=y grants=y rows=y constraints=y consistent=y statistics=none file='C:\TEST.dmp'
pause;
2. Locate the files in the same folder. In my case, it's e:\ORACLE\temp\
3. Open the CreateBackup.cmd and edit it according to the server connection properties in the Oracle SQL Developer client.
CreateBackupModification.png
4. Run "Command prompt" and enter the folder with the files.
https://www.digitalcitizen.life/command-prompt-how-use-basic-commands
In my case, it looks like
command_dir.jpg
5. Adjust the command
CreateBackup.cmd SE_M_SE7140ENU localhost C:\app\Eugene\product\11.2.0\dbhome_1\BIN\sqlplus.exe BACKUPDIR SALESENTERPRISE_MARKETING_SERVICEENTERPRISEENUActual.DMP C:\OracleBackups 1521
where
SE_M_SE7140ENU - The name of the user (the database) that you want to backup. userName.jpg
localhost - the server IP.
C:\app\Eugene\product\11.2.0\dbhome_1\BIN\sqlplus.exe - the path to the sqlplus.exe file.
SALESENTERPRISE_MARKETING_SERVICEENTERPRISEENUActual.DMP - the name of the backup that will be created.
C:\OracleBackups - the location where the backup will be created. Please create the specified folder. It won't be created automatically.
6. Run the command in the command prompt.
RunTheCommand.jpg
7. Find the backup in the specified folder.
