Data Gurad物理备份方式下standby_file_management为manual时修改表空间的操作

STANDBY_FILE_MANAGEMENT设置为MANUAL，增加及删除表空间和数据文件SQL> show parameter standby_file_management
NAME TYPE VALUE------------------------------------ ----------- ------------------------------standby_file_management string AUTOSQL> alter system set standby_file_management="MANUAL" scope=both;
System altered.
SQL> show parameter standby_file_management
NAME TYPE VALUE------------------------------------ ----------- ------------------------------standby_file_management string MANUALSQL>
A）.增加新的表空间--primary 数据库操作SQL>CREATE TABLESPACE mytest DATAFILE "/u01/app/Oracle/oradata/jytest/mytest01.dbf" size 20M
SQL> select name from v$datafile;
NAME--------------------------------------------------------------------------------/u01/app/oracle/oradata/jytest/system01.dbf/u01/app/oracle/oradata/jytest/undotbs01.dbf/u01/app/oracle/oradata/jytest/sysaux01.dbf/u01/app/oracle/oradata/jytest/users01.dbf/u01/app/oracle/oradata/jytest/hygeia01.dbf/u01/app/oracle/oradata/jytest/mytest01.dbf
6 rows selected
切换日志SQL> alter system switch logfile;
System altered
SQL>
B）.验证standby 库--standby 数据库操作SQL> select name from v$datafile;
NAME--------------------------------------------------------------------------------/u01/app/oracle/oradata/jytest/system01.dbf/u01/app/oracle/oradata/jytest/undotbs01.dbf/u01/app/oracle/oradata/jytest/sysaux01.dbf/u01/app/oracle/oradata/jytest/users01.dbf/u01/app/oracle/oradata/jytest/hygeia01.dbf/u01/app/oracle/product/10.2.0/db/dbs/UNNAMED00006
6 rows selected.
SQL> SQL> select name from v$tablespace;
NAME------------------------------SYSTEMUNDOTBS1SYSAUXUSERSTEMPHYGEIAMYTEST
7 rows selected.
SQL>
可以看到，表空间已经自动创建，但是，数据文件却被起了个怪名字，手工修改其与primary数据库保持一致.SQL>alter database create datafile"/u01/app/oracle/product/10.2.0/db/dbs/UNNAMED00006"as "/u01/app/oracle/oradata/jytest/mytest01.dbf";
C）.删除表空间--primary 数据库操作SQL> drop tablespace mytest including contents and datafiles;
Tablespace dropped
SQL> select name from v$datafile;
NAME--------------------------------------------------------------------------------/u01/app/oracle/oradata/jytest/system01.dbf/u01/app/oracle/oradata/jytest/undotbs01.dbf/u01/app/oracle/oradata/jytest/sysaux01.dbf/u01/app/oracle/oradata/jytest/users01.dbf/u01/app/oracle/oradata/jytest/hygeia01.dbf
SQL> alter system switch logfile;
System altered
SQL>
D）.验证standby 数据库--standby 数据库操作
SQL> select name from v$datafile;
NAME--------------------------------------------------------------------------------/u01/app/oracle/oradata/jytest/system01.dbf/u01/app/oracle/oradata/jytest/undotbs01.dbf/u01/app/oracle/oradata/jytest/sysaux01.dbf/u01/app/oracle/oradata/jytest/users01.dbf/u01/app/oracle/oradata/jytest/hygeia01.dbf/u01/app/oracle/oradata/jytest/mytest01.dbf
6 rows selected.
SQL> select name from v$tablespace;
NAME------------------------------SYSTEMUNDOTBS1SYSAUXUSERSTEMPHYGEIAMYTEST
7 rows selected.
SQL>
数据还在啊。查看alertjytest.log 文件，发现如下MRP0: Background Media Recovery terminated with error 1274Mon Dec 3 17:03:34 2012重启redo 应用再来看看：SQL> alter database recover managed standby database disconnect from session;
Database altered.
SQL> select name from v$datafile;
NAME--------------------------------------------------------------------------------/u01/app/oracle/oradata/jytest/system01.dbf/u01/app/oracle/oradata/jytest/undotbs01.dbf/u01/app/oracle/oradata/jytest/sysaux01.dbf/u01/app/oracle/oradata/jytest/users01.dbf/u01/app/oracle/oradata/jytest/hygeia01.dbf
SQL> select name from v$tablespace;
NAME------------------------------SYSTEMUNDOTBS1SYSAUXUSERSTEMPHYGEIA
6 rows selected.
SQL>注意，既使你在primary 数据库执行删除时加上了including 子句，在standby 数据库仍然只会将表空间和数据文件从数据字典中删除，你还需要手工删除表空间涉及的数据文件。Data Gurad物理备份方式下standby_file_management为auto时修改表空间的操作SUSE Linux下安装Oracle 11g服务器相关资讯 Data Gurad Oracle物理备份

Data Gurad物理备份方式下standby_ （12/25/2012 13:15:09）
Data Gurad物理备份方式下重命名数（12/25/2012 13:11:24）

Data Gurad物理备份方式下以READ （12/25/2012 13:13:20）

本文评论查看全部评论（0）