Database Backup and Recovery (MOSC)

MOSC Banner

In a DataGuard Configuration: Is possible to execute the backup of a RAC primary from a single-node

edited Nov 30, 2011 2:18AM in Database Backup and Recovery (MOSC) 7 commentsAnswered ✓
Hi,

I am trying to setup the backup over the Dataguard node. I execute the backup with the command:

RMAN> run {
   RESYNC CATALOG FROM DB_UNIQUE_NAME ALL;
   CROSSCHECK BACKUP OF DATABASE;
   ALLOCATE CHANNEL c1 DEVICE TYPE DISK MAXPIECESIZE 1 G FORMAT '/orafiles/backup/hot/%d_HOT1_%t_%U.bak';
   ALLOCATE CHANNEL c2 DEVICE TYPE DISK MAXPIECESIZE 1 G FORMAT '/orafiles/backup/hot/%d_HOT2_%t_%U.bak';
   BACKUP INCREMENTAL LEVEL 0 CUMULATIVE
   AS COMPRESSED BACKUPSET
   DATABASE PLUS ARCHIVELOG;
   RELEASE CHANNEL c1;
   RELEASE CHANNEL c2;
}

The backup restore work propertly, but the restore fails with:

RMAN> run {
set until sequence 7337 thread 1;

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