发布时间:2020-09-28 15:28:51
原数据库磁盘空间不足,计划把数据库迁移至新的存储盘/dm8/data2。先对数据库进行全备份,将数据库还原至新磁盘/dm8/data2, 同时将数据库名更改为testdb。1、 备份数据库 1.1运行 ./manage打开管理工具,并新建备份。1.2数据库备份至/dm8/backup2、 还原数据库2.1运行./co.........【阅读全文】
发布时间:2015-07-17 15:28:51
SQL> conn test/test
Connected.
SQL> create table lgx as select * from dba_objects;
SQL> create index ind_lgx_objid on lgx(object_id) tablespace users;
Index created.
SQL> set autot trace exp
SQL> select object_name from lgx wher.........【阅读全文】
发布时间:2015-07-15 16:04:54
SQL> select * from v$version;<br /><br />BANNER<br />--------------------------------------------------------------------------------<br />Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production<br />PL/SQL Release 11.2.0.4.0 - Production<br />CORE 11..........【阅读全文】
发布时间:2015-07-10 15:08:57
https://www.percona.com/downloads/XtraBackup/<br /><br />[root@timesten mysqlbin]# rpm -ivh percona-xtrabackup-2.2.9-5067.el5.x86_64.rpm<br />warning: percona-xtrabackup-2.2.9-5067.el5.x86_64.rpm: Header V4 DSA signature: NOKEY, key ID cd2efd2a<br />error: Failed dependencies:<br /> .........【阅读全文】