****DCS-10045:Validation error encountered: Backup type is invalid.****
CONSOLE ERROR:
Status: The database restore operation failed. Run 'dbcli list-jobs' on all hosts in the DB system to check for problems and fix them before rerunning the operation.
[root@testbackupdb ~]# dbcli list-jobs
ID Description Created Status
---------------------------------------- --------------------------------------------------------------------------- ----------------------------------- ----------
7182911b-1733-4805-b351-081f6be6605b Authentication key update for DCS_ADMIN May 5, 2019 4:09:58 PM UTC Success
ce8f602b-84c7-4295-982a-49098dca465d Provisioning service creation May 5, 2019 4:11:41 PM UTC Success
47876bcb-50a5-42ac-9648-52221a12a974 SSH keys update May 5, 2019 5:03:22 PM UTC Success
9d01bc5f-0831-48ed-a1fc-f0982e54feaa SSH key delete May 5, 2019 5:05:14 PM UTC Success
80f9b24e-1061-4906-88d1-78f6b824b454 create object store:b9a7iawWuBfGYFaNH7MC May 6, 2019 3:14:45 AM UTC Success
25845fda-ea88-40b0-bb54-3be86ec265f6 create backup config:b9a7iawWuBfGYFaNH7MC_BC May 6, 2019 3:15:31 AM UTC Success
64903937-7519-415b-b658-186cc6bebbdd update database : BKUPDB May 6, 2019 3:16:23 AM UTC Success
f3d0309f-3bf0-4ec2-b3d7-2d2fcde8599f Server Patching May 6, 2019 3:19:53 AM UTC Success
4fa3b016-8448-4535-b901-a5edd6dc2c1c Create Regular-L0 Backup with TAG-DBTRegular-L01557111640379VSL for Db:BKUPDB in OSS:b9a7iawWuBfGYFaNH7MC May 6, 2019 3:19:56 AM UTC Success
5e902ca8-f332-4c7f-86ca-afca1590e4b9 Delete Backup for Database name: BKUPDB_fra1k8 May 6, 2019 3:26:48 AM UTC Success
251ba542-234e-40f6-a7a9-f3a1ef281cb8 DB Home Prechecks May 6, 2019 5:05:43 AM UTC Success
bc5eb7cd-b320-453f-8dea-e296e645df58 Create Longterm Backup with TAG-DBTLongterm1557125463725Zmf for Db:BKUPDB in OSS:b9a7iawWuBfGYFaNH7MC May 6, 2019 6:52:12 AM UTC Success
43a924a2-6e16-43e0-a2e9-cc4cd1d6b53f Delete Backup for Database name: BKUPDB_fra1k8 May 6, 2019 7:05:18 AM UTC Success
eefab9b7-2b32-4327-9eff-bf55d99ca7eb Create recovery-pitr : time '05/06/2019 07:10:08' for db : BKUPDB May 6, 2019 7:10:57 AM UTC Failure
[root@testbackupdb ~]# dbcli describe-job --jobid eefab9b7-2b32-4327-9eff-bf55d99ca7eb
Job details
----------------------------------------------------------------
ID: eefab9b7-2b32-4327-9eff-bf55d99ca7eb
Description: Create recovery-pitr : time '05/06/2019 07:10:08' for db : BKUPDB
Status: Failure
Created: May 6, 2019 7:10:57 AM UTC
Message: DCS-10001:Internal error encountered: Failed to run RMAN command. Please refer log at location : testbackupdb: /opt/oracle/dcs/log/testbackupdb/rman/bkup/BKUPDB_fra1k8/rman_restore_2019-05-06_07-12-23-4741329873884168661.log.Failed to do restore validati
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
task:TaskZLockWrapper_7173 May 6, 2019 7:11:07 AM UTC May 6, 2019 7:12:37 AM UTC Failure
task:TaskSequential_7174 May 6, 2019 7:11:07 AM UTC May 6, 2019 7:12:37 AM UTC Failure
Database recovery validation May 6, 2019 7:11:08 AM UTC May 6, 2019 7:12:37 AM UTC Failure
[
ISSUE is #####rman log error#showing inorder recovery of scn#####
validation succeeded for archived log
recovery will be done up to SCN 1761481
Media recovery start SCN is 1760987
Recovery must be done beyond SCN 1761012 to clear datafile fuzziness
could not locate pieces of backup set key 20
validation succeeded for backup piece
Finished restore at 2019/05/06 07:12:36
Recovery Manager complete.
we have used until time "05/06/2019 07:10:08"
SQL> select sequence#,first_change#,next_change# from v$log order by 1;
SEQUENCE# FIRST_CHANGE# NEXT_CHANGE#
---------- ------------- ------------
18 1761147 1761155
19 1761155 1761444
20 1761444 2.8147E+14
FIX :so i restored using until scn 1761444
[root@testbackupdb ~]# dbcli list-jobs
ID Description Created Status
---------------------------------------- --------------------------------------------------------------------------- ----------------------------------- ----------
7182911b-1733-4805-b351-081f6be6605b Authentication key update for DCS_ADMIN May 5, 2019 4:09:58 PM UTC Success
ce8f602b-84c7-4295-982a-49098dca465d Provisioning service creation May 5, 2019 4:11:41 PM UTC Success
47876bcb-50a5-42ac-9648-52221a12a974 SSH keys update May 5, 2019 5:03:22 PM UTC Success
9d01bc5f-0831-48ed-a1fc-f0982e54feaa SSH key delete May 5, 2019 5:05:14 PM UTC Success
80f9b24e-1061-4906-88d1-78f6b824b454 create object store:b9a7iawWuBfGYFaNH7MC May 6, 2019 3:14:45 AM UTC Success
25845fda-ea88-40b0-bb54-3be86ec265f6 create backup config:b9a7iawWuBfGYFaNH7MC_BC May 6, 2019 3:15:31 AM UTC Success
64903937-7519-415b-b658-186cc6bebbdd update database : BKUPDB May 6, 2019 3:16:23 AM UTC Success
f3d0309f-3bf0-4ec2-b3d7-2d2fcde8599f Server Patching May 6, 2019 3:19:53 AM UTC Success
4fa3b016-8448-4535-b901-a5edd6dc2c1c Create Regular-L0 Backup with TAG-DBTRegular-L01557111640379VSL for Db:BKUPDB in OSS:b9a7iawWuBfGYFaNH7MC May 6, 2019 3:19:56 AM UTC Success
5e902ca8-f332-4c7f-86ca-afca1590e4b9 Delete Backup for Database name: BKUPDB_fra1k8 May 6, 2019 3:26:48 AM UTC Success
251ba542-234e-40f6-a7a9-f3a1ef281cb8 DB Home Prechecks May 6, 2019 5:05:43 AM UTC Success
bc5eb7cd-b320-453f-8dea-e296e645df58 Create Longterm Backup with TAG-DBTLongterm1557125463725Zmf for Db:BKUPDB in OSS:b9a7iawWuBfGYFaNH7MC May 6, 2019 6:52:12 AM UTC Success
43a924a2-6e16-43e0-a2e9-cc4cd1d6b53f Delete Backup for Database name: BKUPDB_fra1k8 May 6, 2019 7:05:18 AM UTC Success
eefab9b7-2b32-4327-9eff-bf55d99ca7eb Create recovery-pitr : time '05/06/2019 07:10:08' for db : BKUPDB May 6, 2019 7:10:57 AM UTC Failure
eab18e5c-ea75-41dd-a4ed-98aa209f2132 Create detailed Backup Report May 7, 2019 2:16:37 AM UTC Success
f22341d1-d835-4828-8bf3-b1d8f0158c9b Create recovery-latest for db : BKUPDB May 7, 2019 2:45:07 AM UTC Failure
65f2fcf5-776c-4630-ab8f-76975ab0b935 Create recovery-scn : scn 1761444 for db : BKUPDB May 7, 2019 2:57:46 AM UTC Success
[root@testbackupdb ~]# dbcli describe-job --jobid 65f2fcf5-776c-4630-ab8f-76975ab0b935
Job details
----------------------------------------------------------------
ID: 65f2fcf5-776c-4630-ab8f-76975ab0b935
Description: Create recovery-scn : scn 1761444 for db : BKUPDB
Status: Running
Created: May 7, 2019 2:57:46 AM UTC
Message:
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Database recovery validation May 7, 2019 2:57:58 AM UTC May 7, 2019 2:59:37 AM UTC Success
Database recovery May 7, 2019 2:59:38 AM UTC May 7, 2019 2:59:38 AM UTC Running
[root@testbackupdb ~]# dbcli describe-job --jobid 65f2fcf5-776c-4630-ab8f-76975ab0b935
Job details
----------------------------------------------------------------
ID: 65f2fcf5-776c-4630-ab8f-76975ab0b935
Description: Create recovery-scn : scn 1761444 for db : BKUPDB
Status: Success
Created: May 7, 2019 2:57:46 AM UTC
Message:
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Database recovery validation May 7, 2019 2:57:58 AM UTC May 7, 2019 2:59:37 AM UTC Success
Database recovery May 7, 2019 2:59:38 AM UTC May 7, 2019 3:02:47 AM UTC Success
Enable block change tracking May 7, 2019 3:02:47 AM UTC May 7, 2019 3:02:50 AM UTC Success
Database opening May 7, 2019 3:02:50 AM UTC May 7, 2019 3:03:44 AM UTC Success
Database restart May 7, 2019 3:03:44 AM UTC May 7, 2019 3:05:06 AM UTC Success
Recovery metadata persistance May 7, 2019 3:05:06 AM UTC May 7, 2019 3:05:06 AM UTC Success
[root@testbackupdb ~]#
CONSOLE ERROR:
Status: The database restore operation failed. Run 'dbcli list-jobs' on all hosts in the DB system to check for problems and fix them before rerunning the operation.
[root@testbackupdb ~]# dbcli list-jobs
ID Description Created Status
---------------------------------------- --------------------------------------------------------------------------- ----------------------------------- ----------
7182911b-1733-4805-b351-081f6be6605b Authentication key update for DCS_ADMIN May 5, 2019 4:09:58 PM UTC Success
ce8f602b-84c7-4295-982a-49098dca465d Provisioning service creation May 5, 2019 4:11:41 PM UTC Success
47876bcb-50a5-42ac-9648-52221a12a974 SSH keys update May 5, 2019 5:03:22 PM UTC Success
9d01bc5f-0831-48ed-a1fc-f0982e54feaa SSH key delete May 5, 2019 5:05:14 PM UTC Success
80f9b24e-1061-4906-88d1-78f6b824b454 create object store:b9a7iawWuBfGYFaNH7MC May 6, 2019 3:14:45 AM UTC Success
25845fda-ea88-40b0-bb54-3be86ec265f6 create backup config:b9a7iawWuBfGYFaNH7MC_BC May 6, 2019 3:15:31 AM UTC Success
64903937-7519-415b-b658-186cc6bebbdd update database : BKUPDB May 6, 2019 3:16:23 AM UTC Success
f3d0309f-3bf0-4ec2-b3d7-2d2fcde8599f Server Patching May 6, 2019 3:19:53 AM UTC Success
4fa3b016-8448-4535-b901-a5edd6dc2c1c Create Regular-L0 Backup with TAG-DBTRegular-L01557111640379VSL for Db:BKUPDB in OSS:b9a7iawWuBfGYFaNH7MC May 6, 2019 3:19:56 AM UTC Success
5e902ca8-f332-4c7f-86ca-afca1590e4b9 Delete Backup for Database name: BKUPDB_fra1k8 May 6, 2019 3:26:48 AM UTC Success
251ba542-234e-40f6-a7a9-f3a1ef281cb8 DB Home Prechecks May 6, 2019 5:05:43 AM UTC Success
bc5eb7cd-b320-453f-8dea-e296e645df58 Create Longterm Backup with TAG-DBTLongterm1557125463725Zmf for Db:BKUPDB in OSS:b9a7iawWuBfGYFaNH7MC May 6, 2019 6:52:12 AM UTC Success
43a924a2-6e16-43e0-a2e9-cc4cd1d6b53f Delete Backup for Database name: BKUPDB_fra1k8 May 6, 2019 7:05:18 AM UTC Success
eefab9b7-2b32-4327-9eff-bf55d99ca7eb Create recovery-pitr : time '05/06/2019 07:10:08' for db : BKUPDB May 6, 2019 7:10:57 AM UTC Failure
[root@testbackupdb ~]# dbcli describe-job --jobid eefab9b7-2b32-4327-9eff-bf55d99ca7eb
Job details
----------------------------------------------------------------
ID: eefab9b7-2b32-4327-9eff-bf55d99ca7eb
Description: Create recovery-pitr : time '05/06/2019 07:10:08' for db : BKUPDB
Status: Failure
Created: May 6, 2019 7:10:57 AM UTC
Message: DCS-10001:Internal error encountered: Failed to run RMAN command. Please refer log at location : testbackupdb: /opt/oracle/dcs/log/testbackupdb/rman/bkup/BKUPDB_fra1k8/rman_restore_2019-05-06_07-12-23-4741329873884168661.log.Failed to do restore validati
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
task:TaskZLockWrapper_7173 May 6, 2019 7:11:07 AM UTC May 6, 2019 7:12:37 AM UTC Failure
task:TaskSequential_7174 May 6, 2019 7:11:07 AM UTC May 6, 2019 7:12:37 AM UTC Failure
Database recovery validation May 6, 2019 7:11:08 AM UTC May 6, 2019 7:12:37 AM UTC Failure
[
ISSUE is #####rman log error#showing inorder recovery of scn#####
validation succeeded for archived log
recovery will be done up to SCN 1761481
Media recovery start SCN is 1760987
Recovery must be done beyond SCN 1761012 to clear datafile fuzziness
could not locate pieces of backup set key 20
validation succeeded for backup piece
Finished restore at 2019/05/06 07:12:36
Recovery Manager complete.
we have used until time "05/06/2019 07:10:08"
SQL> select sequence#,first_change#,next_change# from v$log order by 1;
SEQUENCE# FIRST_CHANGE# NEXT_CHANGE#
---------- ------------- ------------
18 1761147 1761155
19 1761155 1761444
20 1761444 2.8147E+14
FIX :so i restored using until scn 1761444
[root@testbackupdb ~]# dbcli list-jobs
ID Description Created Status
---------------------------------------- --------------------------------------------------------------------------- ----------------------------------- ----------
7182911b-1733-4805-b351-081f6be6605b Authentication key update for DCS_ADMIN May 5, 2019 4:09:58 PM UTC Success
ce8f602b-84c7-4295-982a-49098dca465d Provisioning service creation May 5, 2019 4:11:41 PM UTC Success
47876bcb-50a5-42ac-9648-52221a12a974 SSH keys update May 5, 2019 5:03:22 PM UTC Success
9d01bc5f-0831-48ed-a1fc-f0982e54feaa SSH key delete May 5, 2019 5:05:14 PM UTC Success
80f9b24e-1061-4906-88d1-78f6b824b454 create object store:b9a7iawWuBfGYFaNH7MC May 6, 2019 3:14:45 AM UTC Success
25845fda-ea88-40b0-bb54-3be86ec265f6 create backup config:b9a7iawWuBfGYFaNH7MC_BC May 6, 2019 3:15:31 AM UTC Success
64903937-7519-415b-b658-186cc6bebbdd update database : BKUPDB May 6, 2019 3:16:23 AM UTC Success
f3d0309f-3bf0-4ec2-b3d7-2d2fcde8599f Server Patching May 6, 2019 3:19:53 AM UTC Success
4fa3b016-8448-4535-b901-a5edd6dc2c1c Create Regular-L0 Backup with TAG-DBTRegular-L01557111640379VSL for Db:BKUPDB in OSS:b9a7iawWuBfGYFaNH7MC May 6, 2019 3:19:56 AM UTC Success
5e902ca8-f332-4c7f-86ca-afca1590e4b9 Delete Backup for Database name: BKUPDB_fra1k8 May 6, 2019 3:26:48 AM UTC Success
251ba542-234e-40f6-a7a9-f3a1ef281cb8 DB Home Prechecks May 6, 2019 5:05:43 AM UTC Success
bc5eb7cd-b320-453f-8dea-e296e645df58 Create Longterm Backup with TAG-DBTLongterm1557125463725Zmf for Db:BKUPDB in OSS:b9a7iawWuBfGYFaNH7MC May 6, 2019 6:52:12 AM UTC Success
43a924a2-6e16-43e0-a2e9-cc4cd1d6b53f Delete Backup for Database name: BKUPDB_fra1k8 May 6, 2019 7:05:18 AM UTC Success
eefab9b7-2b32-4327-9eff-bf55d99ca7eb Create recovery-pitr : time '05/06/2019 07:10:08' for db : BKUPDB May 6, 2019 7:10:57 AM UTC Failure
eab18e5c-ea75-41dd-a4ed-98aa209f2132 Create detailed Backup Report May 7, 2019 2:16:37 AM UTC Success
f22341d1-d835-4828-8bf3-b1d8f0158c9b Create recovery-latest for db : BKUPDB May 7, 2019 2:45:07 AM UTC Failure
65f2fcf5-776c-4630-ab8f-76975ab0b935 Create recovery-scn : scn 1761444 for db : BKUPDB May 7, 2019 2:57:46 AM UTC Success
[root@testbackupdb ~]# dbcli describe-job --jobid 65f2fcf5-776c-4630-ab8f-76975ab0b935
Job details
----------------------------------------------------------------
ID: 65f2fcf5-776c-4630-ab8f-76975ab0b935
Description: Create recovery-scn : scn 1761444 for db : BKUPDB
Status: Running
Created: May 7, 2019 2:57:46 AM UTC
Message:
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Database recovery validation May 7, 2019 2:57:58 AM UTC May 7, 2019 2:59:37 AM UTC Success
Database recovery May 7, 2019 2:59:38 AM UTC May 7, 2019 2:59:38 AM UTC Running
[root@testbackupdb ~]# dbcli describe-job --jobid 65f2fcf5-776c-4630-ab8f-76975ab0b935
Job details
----------------------------------------------------------------
ID: 65f2fcf5-776c-4630-ab8f-76975ab0b935
Description: Create recovery-scn : scn 1761444 for db : BKUPDB
Status: Success
Created: May 7, 2019 2:57:46 AM UTC
Message:
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Database recovery validation May 7, 2019 2:57:58 AM UTC May 7, 2019 2:59:37 AM UTC Success
Database recovery May 7, 2019 2:59:38 AM UTC May 7, 2019 3:02:47 AM UTC Success
Enable block change tracking May 7, 2019 3:02:47 AM UTC May 7, 2019 3:02:50 AM UTC Success
Database opening May 7, 2019 3:02:50 AM UTC May 7, 2019 3:03:44 AM UTC Success
Database restart May 7, 2019 3:03:44 AM UTC May 7, 2019 3:05:06 AM UTC Success
Recovery metadata persistance May 7, 2019 3:05:06 AM UTC May 7, 2019 3:05:06 AM UTC Success
[root@testbackupdb ~]#
No comments:
Post a Comment