Oracle Database Change and backup database step tutorial, oracle backup tutorial

Oracle Database Change and backup database step tutorial, oracle backup tutorial
Oracle Database Change

1. Stop the Application Middleware involved/lock the oracle user alter user GWM_BL_UAT account lock

View select username, account_status from dba_users where username = 'gwm _ BL_UAT ';

2. use plsql tool-session kill all connected users (if kill fails, you can modify the user password as needed, shutdown abort is forcibly disabled, and then start at startup, the dorp user can be executed)

3. Copy the backup to the specified path and decompress it (oracle user)

4. Delete the user drop user user_name cascade;

5. import database impdp system/password directory = DATA_PUMP_DIR (this path runs create directory data_pump_dirname as "path" in the oracle statement to create a new file path) dumpfile = logfile = schemas = transform = OID: y keep the original object type/transform = OID: n consistent with the new object (ensure that the object can be compiled)

6. Change the user Password alter user (name) identified by password (you can also keep the default value) account unlock to unlock

Backup database:

1. Stop the Application Middleware involved/lock the oracle user alter user GWM_BL_UAT account lock

View select username, account_status from dba_users where username = 'gwm _ BL_UAT ';

2. Export expdp system/oracle456 directory = DATA_PUMP_DIR dumpfile = yingnanbk. dmp logfile = yingnanbk. log schemas = GWM_BL_UAT

3. unlock alter user gwm_bl_uat account unlock & select username, account_status from dba_users where username = 'gwm _ BL_UAT ';