测试rman duplicate选项---skip readonly,skip tablespace
1,在target上,构建一个测试以上相关选项的表空间
-bash-3.00$ hostname
capitek1
-bash-3.00$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Nov 29 22:53:22 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> create tablespace test datafile '/orainstall/oradata/target/test01.dbf' size 10m;
Tablespace created.
SQL> select name,status,file#,enabled from v$datafile;
NAME
--------------------------------------------------------------------------------
STATUS FILE# ENABLED
------- ---------- ----------
/orainstall/oradata/target/system01.dbf
SYSTEM 1 READ WRITE
/orainstall/oradata/target/undotbs01.dbf
ONLINE 2 READ WRITE
/orainstall/oradata/target/sysaux01.dbf
ONLINE 3 READ WRITE
NAME
--------------------------------------------------------------------------------
STATUS FILE# ENABLED
------- ---------- ----------
/orainstall/oradata/target/users01.dbf
ONLINE 4 READ WRITE
/orainstall/oradata/target/test01.dbf
ONLINE 5 READ WRITE
SQL> alter tablespace test read only;
Tablespace altered.
SQL> select name,status,file#,enabled from v$datafile;
NAME
--------------------------------------------------------------------------------
STATUS FILE# ENABLED
------- ---------- ----------
/orainstall/oradata/target/system01.dbf
SYSTEM 1 READ WRITE
/orainstall/oradata/target/undotbs01.dbf
ONLINE 2 READ WRITE
/orainstall/oradata/target/sysaux01.dbf
ONLINE 3 READ WRITE
NAME
--------------------------------------------------------------------------------
STATUS FILE# ENABLED
------- ---------- ----------
/orainstall/oradata/target/users01.dbf
ONLINE 4 READ WRITE
1,在target上,构建一个测试以上相关选项的表空间
-bash-3.00$ hostname
capitek1
-bash-3.00$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Nov 29 22:53:22 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> create tablespace test datafile '/orainstall/oradata/target/test01.dbf' size 10m;
Tablespace created.
SQL> select name,status,file#,enabled from v$datafile;
NAME
--------------------------------------------------------------------------------
STATUS FILE# ENABLED
------- ---------- ----------
/orainstall/oradata/target/system01.dbf
SYSTEM 1 READ WRITE
/orainstall/oradata/target/undotbs01.dbf
ONLINE 2 READ WRITE
/orainstall/oradata/target/sysaux01.dbf
ONLINE 3 READ WRITE
NAME
--------------------------------------------------------------------------------
STATUS FILE# ENABLED
------- ---------- ----------
/orainstall/oradata/target/users01.dbf
ONLINE 4 READ WRITE
/orainstall/oradata/target/test01.dbf
ONLINE 5 READ WRITE
SQL> alter tablespace test read only;
Tablespace altered.
SQL> select name,status,file#,enabled from v$datafile;
NAME
--------------------------------------------------------------------------------
STATUS FILE# ENABLED
------- ---------- ----------
/orainstall/oradata/target/system01.dbf
SYSTEM 1 READ WRITE
/orainstall/oradata/target/undotbs01.dbf
ONLINE 2 READ WRITE
/orainstall/oradata/target/sysaux01.dbf
ONLINE 3 READ WRITE
NAME
--------------------------------------------------------------------------------
STATUS FILE# ENABLED
------- ---------- ----------
/orainstall/oradata/target/users01.dbf
ONLINE 4 READ WRITE
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9240380/viewspace-620973/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9240380/viewspace-620973/