Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can I recover some tablespace(only current tbs) - RMAN

764417Jun 6 2010 — edited Jun 7 2010
Hello, I have ang question about RMAN.

If I have full backup database, and next time database is failed.
Can I recover especially tablespace current data?

this below is my step recovery but it's not pass.
I'm not sure, this are correct or not.



bash-2.05$ rman target / catalog user/password@rcat

RMAN> set dbid=1707756540

RMAN> startup nomount
+RMAN> run{+
+2> ALLocate channel ch00 type 'SBT_TAPE';+
+3> Allocate channel ch01 type 'SBT_TAPE';+
+4> SEND 'NB_ORA_CLIENT=holtuv1';+
+5> SEND 'NB_ORA_SERV=holtbk11';+
+6> SEND 'NB_ORA_POLICY=test_orabk_holtuv1';+
+7> restore controlfile ;+
+8> }+

+RMAN> run{+
+2> ALLocate channel ch00 type 'SBT_TAPE';+
+3> Allocate channel ch01 type 'SBT_TAPE';+
+4> SEND 'NB_ORA_CLIENT=holtuv1';+
+5> SEND 'NB_ORA_SERV=holtbk11';+
+6> SEND 'NB_ORA_POLICY=test_orabk_holtuv1';+
+7> restore database skip tablespace 'PERFSTAT', 'YEAR2009';+
+8> }+

RMAN> alter database mount;

+RMAN> run{+
+2> ALLocate channel ch00 type 'SBT_TAPE';+
+3> Allocate channel ch01 type 'SBT_TAPE';+
+4> SEND 'NB_ORA_CLIENT=holtuv1';+
+5> SEND 'NB_ORA_SERV=holtbk11';+
+6> SEND 'NB_ORA_POLICY=test_orabk_holtuv1';+
+7> recover database skip tablespace 'PERFSTAT', 'YEAR2009';+
+8> }+

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/04/2010 15:30:41
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '/data/db01/ORABK_ARCH/ORABK/archivelog/2010_06_03/o1_mf_1_5_60h9p9z0_.arc'
ORA-00283: recovery session canceled due to errors
ORA-16067: activation identifier mismatch in archive log /data/db01/ORABK_ARCH/ORABK/archivelog/2010_06_03/o1_mf_1_5_60h9p9z0_.arc

RMAN> alter database open resetlogs;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 06/04/2010 15:41:43
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: '/data/db01/ORABK/perfstat.dbf'







any sugess please.
thank you
Suradech
This post has been answered by Chinar on Jun 7 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 5 2010
Added on Jun 6 2010
6 comments
1,171 views