Recover tablespace from RMAN backup.
I have a new Oracle 11g r2 database in archivelog mode. My recovery catalog exist on another node. I am testing out my restore tablespace script but hit error below. Appreciate some help on this.
My test plan as below:
- Create a xxapp tablespace.
- Create a table in xxapp tablespace.
- Run my rman backup tablespace script.
- Drop xxapp tablespace.
- Recover tablespace xxapp from rman backup.
Error message:
Starting restore at 19-NOV-13
released channel: d1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/19/2013 17:00:19
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20202: Tablespace
not found in the recovery catalog