oracle数据库创建表空间示例以及开启数据库闪回

1.创建表空间TBS_512

CREATE TABLESPACE TBS_512

DATAFILE'd:\ora11g\D124451\disk6\D0AEF.DDD'

SIZE 120M

AUTOEXTEND ONNEXT 5M MAXSIZE 650M

ONLINE

PERMANENT

EXTENTMANAGEMENT LOCAL UNIFORM SIZE 58K

SEGMENT SPACEMANAGEMENT AUTO;

2.创建临时表空间（使用OMF）

1)       修改db_create_file_dest为c:\ora11g\D1244511
ALTER SYSTEM SET db_create_file_dest ='c:\ora11g\D1244511';

2)       使用OMF机制创建临时表空间TBST_BBD
CREATE TEMPORARY TABLESPACE TBST_BBD
TEMPFILE SIZE 900M
AUTOEXTEND ON NEXT 3552k MAXSIZE 1350M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 320k;

3.创建还原表空间（使用OMF）

1)       修改db_create_file_dest为d:\ora11g\D124451\disk6
ALTER SYSTEM SET db_create_file_dest = 'd:\ora11g\D124451\disk6';

2)       使用OMF机制创建还原表空间TBSU_DCG
CREATE UNDO TABLESPACE TBSU_DCG
DATAFILE SIZE 800M AUTOEXTEND OFF;

4.开启数据库闪回

1)       修改db_recovery_file_dest_size为4G
alter system set db_recovery_file_dest_size=4G;

2)       建立文件夹d:\ora11g\D124451\disk6\recovery
$mkdir d:\ora11g\D124451\disk6\recovery

3)       修改闪回日志存放位置为“d:\ora11g\D124451\disk6\recovery”
alter system set db_recovery_file_dest='d:\ora11g\D124451\disk6\recovery';

4)       关闭数据库并启动到mount状态
shutdown immediate
startup mount

5)       开启数据库归档模式
alter database archivelog;

6)       开启数据库闪回
alter database flashback on;

7)       启动数据库到open状态
alter database open;

8)       新开一个cmd窗口，在cmd窗口中
rman target system/124451@d124451启动RMAN并连接到目标数据库:D124451
backup database;进行完全数据库备份