Database Backup and Recovery (MOSC)

MOSC Banner

Duplicate from active database skip tablespace RMAN-06019

edited Dec 9, 2016 12:31PM in Database Backup and Recovery (MOSC) 8 commentsAnswered ✓

Hi

This is Oracle RAC 11.2.0.3 on Oracle Linux 6.  The target database is a snapshot standby database named dbp08, and the auxiliary is named dbd08.  They are on different clusters, we use ASM, so OMF.  The target disk group names are different from the auxiliary, and I set db_create_file_dest='+DATA_DBD18', and db_recovery_file_dest='+FRA_DBD18' on the pfile I used to nomount the auxiliary. 

The command "duplicate target database to dbd18 from active database;" worked, and created dbd08 as I hoped.  The database files were in the disk groups I set in the pfile, and the database was usable.  Because the the target is large, I wanted to skip two tablespaces, but when I  tried the skip tablespace option, the command failed.  Here is the command I issued, and the log file follows.   

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