达梦作业管理

su - dmdba
[dmdba@NODE01 ~ 2023-08-01 09:09:55]
# xhost +
access control disabled, clients can connect from any host
# echo $DISPLAY
:1.0
# su - dmdba
[dmdba@NODE01 ~ 2023-08-01 09:10:22]
$ export DISPLAy=:1.0
[dmdba@NODE01 ~ 2023-08-01 09:10:52]
$ cd $DM_HOME
[dmdba@NODE01 /data/dmdbms 2023-08-01 09:11:06]
$ cd tool/
[dmdba@NODE01 /data/dmdbms/tool 2023-08-01 09:11:09]
$ ./manager

!

!

创建定时增量备份作业

SQL> select username from dba_users;

    USERNAME  
---------- ----------
1          SYS
2          HRTEST
3          TEST
4          SYSDBA
5          SYSAUDITOR
6          SYSSSO

6 rows got


SQL> alter user test identified by "dameng123" ;

SQL> conn TEST/dameng123;

SQL> select table_name from user_tables;

    TABLE_NAME
---------- ----------
1          TB_TEST


SQL> select count(1) from TB_TEST;

    COUNT(1)            
---------- --------------------
1          0

SQL> desc tb_test;  

    NAME TYPE$   NULLABLE
---------- ---- ------- --------
1          ID   INTEGER Y


SQL> insert into tb_test values(1);
SQL> insert into tb_test values(2);
SQL> insert into tb_test values(3);

SQL> select * from tb_test;

     ID         
---------- -----------
1          1
2          2
3          3

SQL> conn test/dameng123;

SQL> select table_name from user_tables;

   TABLE_NAME
---------- ----------
1          TB_TEST

SQL> select * from TB_TEST;

            ID         
---------- -----------
1          1
2          2
3          3

达梦社区技术https://eco.dameng.com