Character.AI

PMS

 192.168.0.18--> connect...>reason [a] log on to 192.168.0.18...>connect

Edit .bat file
pms_weekly_backup_script.bat

cls
@ECHO OFF
exp PMS_OWNER/PmsOwnerpa$$ file=PMS_12_11_2024.dmp log=PMS_12_11_2024.log fully =y
cls
exit

WinSCP

192.18.0150

hostname:

username:

password:

log on

 

d:PMS_12_11_2024.dmp

d:PMS_12_11_2024.log

copy and paste to 

/share/backup/PMS/

 

 f:
set ORACLE_SID=ORCL
exp melmilap/milmilap786 file=melmilap_10_11_2024.dmp log=melmilap_10_11_2024.log fully=y

command prompt:
f:\>
winscp
login to 192.168.0.150
username:
password:
f: melmilap_10_11_2024.log
melmilap_10_11_2024.dmp
 copy and paste to /share/backup/melmilap 

Problem

Solution:

Unlock the Account: If you have administrative access (as a user with DBA privileges), you can unlock the account using the following SQL command:

ALTER USER your_username ACCOUNT UNLOCK;

 

 Ehajari

192.168.0.41...Reason [ehajari41]>connect 

winscp

Taskmanager...> MSSQLMSSQLSERVER2017.....stop

C:\program files\Microsoft SQL SERVER\MSSQL14.MSSQLSERVER2017\MSSQL\

DATA

New site...

hostname

username

password

192.168.0.150---------------------------à/share/backup/ehajari41

Create new document

Remane new docyument with todays date [e.g. 06-Nov-2024)

Copy DATA   to new directory

 

then 

Taskmanager...> MSSQLMSSQLSERVER2017.....start

 

 

scp -r  /share/backup/LIC/expdp_lic_fullbackup_20241029.log root@1.190.x.x:/dump/LIC

scp -r  /share/backup/LIC/expdp_lic_fullbackup_20241029.dmp root@1.190.x.x:/dump/LIC

 

To check DR

[root@localhost ~] #  cd /share/backup 

[root@localhost backup] # ls

Ehajari Ehajari41 LIC PMS Melmilap 

[root@localhost backup] # cd LIC

 [root@localhost LIC ] # ls 

expdp_lic_fullbackup_20241125.dmp
expdp_lic_fullbackup_20241125.log