Q
Problem solve Get help with specific problems with your technologies, process and projects.

Recovering schema(user) using RMAN level 0 backup

Can we recover a schema(user) using the RMAN level 0 backup?

Can we recover a schema(user) using the RMAN level 0 backup?
RMAN does not let you recover all objects in a schema. There is no RECOVER SCHEMA or RECOVER USER command in RMAN. You can recover a datafile, tablespace or the entire database with RMAN. You may need to determine which tablespace(s) contain the user's segments and recover just that tablespace. This will not recover the schema's non-segment objects like sequences, procedures, etc. Those are stored in the SYSTEM tablespace.

Dig Deeper on Oracle database backup and recovery

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close