Database Backup and Recovery (MOSC)

MOSC Banner

Recovering READ ONLY tablespace in RMAN when the tablespace was not backed up using RMAN

edited May 28, 2011 10:41PM in Database Backup and Recovery (MOSC) 7 commentsAnswered
Hi,

We have a 10.2.0.4 Database with following tablespaces

UNDO 
SYSTEM
SYSAUX
APPS_DATA
APPS_INDEX
ARC_DATA  --> READ ONLY

Conventional hot backups are in place (not using RMAN)

3 months ago, ARC_DATA was made READ ONLY and a backup of datafiles was made. After that, this table space is not part of any backup

Let us suppose that today we start using RMAN for backups and perform a "backup database plus archive log"
and EXCLUDE "ARC_DATA".  Remember that it is READ ONLY and we DO HAVE the backup of all its data files AFTER we made it read only

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center