Oracle管理记录

1,创建表空间
CREATE SMALLFILE TABLESPACE "DATA" DATAFILE'+DGROUP1/danghj/datafile/data1' SIZE 2G AUTOEXTEND ON NEXT 50M MAXSIZE 50G LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO

CREATE SMALLFILE TABLESPACE "DATA" DATAFILE'+DGROUP1/danghj/datafile/data1' SIZE 2G AUTOEXTEND ON NEXT 50M MAXSIZE 10G LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO

2,RMAN
backup incremental level 0 cumulative device type disk tag '%TAG' database include current controlfile;
backup database format '/opt/oradata/danghj/rman_%U.dat' plus archivelog;
原文地址:https://www.cnblogs.com/danghuijian/p/4400389.html