Friday, December 30, 2016

RMAN-20020: database incarnation not set

I have one PT env using storage sync for database sync.

Thought need to re-register DB after DB refresh, so unregister and register again.

RMAN> register database;
starting full resync of recovery catalog
full resync complete
database registered in recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03008: error while performing automatic resync of recovery catalog
RMAN-20020: database incarnation not set


However, this is the error.

Disconnected RMAN connection, and attempted to re- register , and finally succeed.

RMAN>   unregister database;



Do you really want to unregister the database (enter YES or NO)? yes
database unregistered from the recovery catalog

RMAN> register database;

database registered in recovery catalog
starting full resync of recovery catalog
 full resync complete


Another way to overcome this , is to issue RESET DATABASE command, e.g in http://www.dbaref.com/home/rman/rman-20020databaseincarnationnotset

But I don't want to change DBID explicitly.




One more thought, in fact I don't need to unregister  & register again, as there is no change to DBID.



As such, what I need to do is just configure RMAN setting directly.


CONFIGURE DEFAULT DEVICE TYPE TO disk;
starting full resync of recovery catalog
full resync complete
new RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

RMAN> #parallelism 2 for EE only
2> #CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO compressed backupset;
3>
4> #parallelism 1 for SE only
5> CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO compressed backupset;
old RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COMPRESSED BACKUPSET;
new RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COMPRESSED BACKUPSET;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

RMAN> show all;
RMAN configuration parameters for database with db_unique_name PSCRMP are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 3;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COMPRESSED BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/software/oraps/product/11.2.0/dbs/snapcf_PSCRMP.f'; # default

RMAN>
RMAN> #To ensure the control file is backed up by default, type the following at the RMAN prompt:
2> CONFIGURE CONTROLFILE AUTOBACKUP ON;
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

RMAN>
RMAN> CONFIGURE BACKUP OPTIMIZATION ON;
old RMAN configuration parameters:
CONFIGURE BACKUP OPTIMIZATION ON;
new RMAN configuration parameters:
CONFIGURE BACKUP OPTIMIZATION ON;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

RMAN>
RMAN> #To change how many backup sets you would like to retain, type the following at the RMAN prompt:
2> CONFIGURE RETENTION POLICY TO REDUNDANCY 3;
old RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 3;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 3;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

RMAN>
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;
old RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
new RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete



In the end, I even get back backupsets before refresh listed in catalog DB in few seconds.


RMAN> list backup summary;


List of Backups
===============
Key     TY LV S Device Type Completion Time      #Pieces #Copies Compressed Tag
------- -- -- - ----------- -------------------- ------- ------- ---------- ---
10519659 B     U SBT_TAPE    2016-JUL-13 18:31:25 1       1       NO         DLPX2015052818345511D6F7437298
10519660 B     U SBT_TAPE    2016-JUL-13 18:32:35 1       1       NO         DLPX2015052818345511D6F7437298
10519661 B     U SBT_TAPE    2016-JUL-13 18:34:04 1       1       NO         DLPX2015052818345511D6F7437298
...
10520973 B  F  A DISK        2016-DEC-21 16:38:15 1       1       YES        TAG20161221T163047
10520974 B  F  A DISK        2016-DEC-21 16:47:00 1       1       YES        TAG20161221T163047
10520975 B  F  A DISK        2016-DEC-21 16:53:40 1       1       YES        TAG20161221T163047
10520976 B  F  A DISK        2016-DEC-21 16:58:26 1       1       YES        TAG20161221T163047
10520977 B  F  A DISK        2016-DEC-21 17:00:34 1       1       YES        TAG20161221T163047
10520978 B  F  A DISK        2016-DEC-21 17:03:35 1       1       YES        TAG20161221T163047
10520979 B  F  A DISK        2016-DEC-21 17:04:23 1       1       YES        TAG20161221T163047
10520980 B  F  A DISK        2016-DEC-21 17:05:07 1       1       YES        TAG20161221T163047
10520981 B  F  A DISK        2016-DEC-21 17:07:17 1       1       YES        TAG20161221T163047
10520982 B  F  A DISK        2016-DEC-21 17:09:28 1       1       YES        TAG20161221T163047
10520983 B  F  A DISK        2016-DEC-21 17:12:34 1       1       YES        TAG20161221T163047
10520984 B  F  A DISK        2016-DEC-21 17:13:47 1       1       YES        TAG20161221T163047
10520985 B  F  A DISK        2016-DEC-21 17:14:44 1       1       YES        TAG20161221T163047
10520986 B  F  A DISK        2016-DEC-21 17:15:01 1       1       YES        TAG20161221T163047
10520987 B  F  A DISK        2016-DEC-21 17:15:33 1       1       YES        TAG20161221T163047
10520988 B  F  A DISK        2016-DEC-21 17:15:50 1       1       YES        TAG20161221T163047
10520989 B  F  A DISK        2016-DEC-21 17:16:47 1       1       YES        TAG20161221T163047
10520990 B  F  A DISK        2016-DEC-21 17:18:01 1       1       YES        TAG20161221T163047
10520991 B  F  A DISK        2016-DEC-21 17:18:26 1       1       YES        TAG20161221T163047
10520992 B  F  A DISK        2016-DEC-21 17:20:53 1       1       YES        TAG20161221T163047
10520993 B  F  A DISK        2016-DEC-21 17:22:16 1       1       YES        TAG20161221T163047
10520994 B  F  A DISK        2016-DEC-21 17:23:05 1       1       YES        TAG20161221T163047
10520995 B  F  A DISK        2016-DEC-21 17:24:21 1       1       YES        TAG20161221T163047
10520996 B  F  A DISK        2016-DEC-21 17:25:24 1       1       YES        TAG20161221T163047
10520997 B  F  A DISK        2016-DEC-21 17:26:13 1       1       YES        TAG20161221T163047
10520998 B  F  A DISK        2016-DEC-21 17:27:57 1       1       YES        TAG20161221T163047
10520999 B  F  A DISK        2016-DEC-21 17:28:30 1       1       YES        TAG20161221T163047
10521000 B  F  A DISK        2016-DEC-21 17:29:31 1       1       YES        TAG20161221T163047
10521092 B  F  A DISK        2016-DEC-21 17:29:34 1       1       NO         TAG20161221T172934
10568384 B  F  A DISK        2016-DEC-22 12:41:04 1       1       NO         TAG20161222T124104
10568391 B  F  A DISK        2016-DEC-22 11:42:06 1       1       YES        TAG20161222T114206
10568401 B  F  A DISK        2016-DEC-22 11:49:41 1       1       YES        TAG20161222T114206
10568413 B  F  A DISK        2016-DEC-22 11:58:26 1       1       YES        TAG20161222T114206
10568426 B  F  A DISK        2016-DEC-22 12:05:12 1       1       YES        TAG20161222T114206
10568440 B  F  A DISK        2016-DEC-22 12:09:57 1       1       YES        TAG20161222T114206
10568455 B  F  A DISK        2016-DEC-22 12:12:02 1       1       YES        TAG20161222T114206
10568471 B  F  A DISK        2016-DEC-22 12:14:57 1       1       YES        TAG20161222T114206
10568488 B  F  A DISK        2016-DEC-22 12:15:43 1       1       YES        TAG20161222T114206
10568506 B  F  A DISK        2016-DEC-22 12:16:28 1       1       YES        TAG20161222T114206
10568525 B  F  A DISK        2016-DEC-22 12:18:43 1       1       YES        TAG20161222T114206
10568545 B  F  A DISK        2016-DEC-22 12:20:48 1       1       YES        TAG20161222T114206
10568566 B  F  A DISK        2016-DEC-22 12:23:54 1       1       YES        TAG20161222T114206
10568588 B  F  A DISK        2016-DEC-22 12:25:09 1       1       YES        TAG20161222T114206
10568611 B  F  A DISK        2016-DEC-22 12:26:14 1       1       YES        TAG20161222T114206
10568635 B  F  A DISK        2016-DEC-22 12:26:39 1       1       YES        TAG20161222T114206
10568660 B  F  A DISK        2016-DEC-22 12:27:04 1       1       YES        TAG20161222T114206
10568686 B  F  A DISK        2016-DEC-22 12:27:20 1       1       YES        TAG20161222T114206
10568713 B  F  A DISK        2016-DEC-22 12:28:25 1       1       YES        TAG20161222T114206
10568741 B  F  A DISK        2016-DEC-22 12:29:40 1       1       YES        TAG20161222T114206
10568770 B  F  A DISK        2016-DEC-22 12:30:05 1       1       YES        TAG20161222T114206
10568800 B  F  A DISK        2016-DEC-22 12:32:30 1       1       YES        TAG20161222T114206
10568831 B  F  A DISK        2016-DEC-22 12:33:56 1       1       YES        TAG20161222T114206
10568863 B  F  A DISK        2016-DEC-22 12:34:41 1       1       YES        TAG20161222T114206
10568896 B  F  A DISK        2016-DEC-22 12:35:56 1       1       YES        TAG20161222T114206
10568930 B  F  A DISK        2016-DEC-22 12:37:01 1       1       YES        TAG20161222T114206
10568965 B  F  A DISK        2016-DEC-22 12:37:47 1       1       YES        TAG20161222T114206
10569001 B  F  A DISK        2016-DEC-22 12:39:32 1       1       YES        TAG20161222T114206
10569038 B  F  A DISK        2016-DEC-22 12:40:07 1       1       YES        TAG20161222T114206