www.Orasql.Com
 
用户名: 密码:  验证码: 注册|找回密码 oracleawen's blog  
 
         当前位置 >> 技术论坛  发表帖子     论坛版块     查找帖子
关于rman备份表空间的疑惑-技术论坛||Oracle高手之路—Orasql.Com!
            关于rman备份表空间的疑惑
 
发贴人:oracle_awen
oracleawen@gmail.com448315233127.0.0.1
用户级别:管理员
发贴总数:1245
注册时间:2011-05-05 09:23:03
2011-06-01 08:15:45
关于rman备份表空间的疑惑 我设置好了rman参数如下 rman> show all; using target database control file instead of recovery catalog rman configuration parameters are configure retention policy to recovery window of 7 days; configure backup optimization off; # default configure default device type to disk; # default configure controlfile autobackup on; configure controlfile autobackup format for device type disk to '/opt/oracle/oradata/rmanbak/crl/%f'; configure device type disk parallelism 1 backup type to backupset; # default configure datafile backup copies for device type disk to 1; # default configure archivelog backup copies for device type disk to 1; # default configure channel device type disk format '/opt/oracle/oradata/rmanbak/dbf/%u'; configure maxsetsize to unlimited; # default configure encryption for database off; # default configure encryption algorithm 'aes128'; # default configure archivelog deletion policy to none; # default configure snapshot controlfile name to '/opt/oracle/product/10.2.0/db_1/dbs/snapcf_wade.f'; # default 红字为改变的地方 然后小弟做了以下操作,建立一个表空间,再建立了一个用户,把用户的默认表空间设置为uuu,然后在用户里面建立了一张表,再着备份了 这个表空间,然后删除表,然后在恢复表空间,恢复回来后表确不存在了。 sql> create tablespace uuu datafile '/tmp/uuu.dbf' size 10m; sql> create user wade identified by wade default tablespace uuu; sql> grant connect,resource to wade; sql> grant select on scott.emp to wade; sql> conn wade/wade; sql> create table a as select from scott.emp; rman> backup tablespace uuu; sql> drop table a purge; 下面是小弟进行恢复的步骤 sql> alter tablespace uuu offline immediate; rman> restore tablespace uuu; rman> recover tablespace uuu; sql> alter tablespace uuu online; sql> conn wade/wade; connected. sql> select from tab; no rows selected 在这之前我做过一次backup database的全库的备份,但是我看了我在恢复的时候strore的备份集是我备份表空间的那个,我不知道 为什么恢复后表不存在了,请各位大侠帮我看看

      
 
  
 Orasql.Com|E-Mail:oracleawen@gmail.com|Phone:15271942915|Copyright © 2011|All Rights Reserved|