{"id":2375,"date":"2024-07-16T15:33:34","date_gmt":"2024-07-16T13:33:34","guid":{"rendered":"http:\/\/clemente.pamplona.name\/dba\/?p=2375"},"modified":"2024-07-16T15:35:05","modified_gmt":"2024-07-16T13:35:05","slug":"errores-rman-07540-cleanup-is-required-for-the-vpc-user-schema","status":"publish","type":"post","link":"http:\/\/clemente.pamplona.name\/dba\/errores-rman-07540-cleanup-is-required-for-the-vpc-user-schema\/","title":{"rendered":"Errores RMAN-07540: Cleanup is required for the VPC user schema"},"content":{"rendered":"

Hoy vamos a volver con una entrada rapida sobre un error basante sencillo.
\nEs posible que conectando a vuestro VPC rman catalog user encontreis el error <\/p>\n

\r\n-bash-4.1$ rman catalog rmanvc3\/vcpass3@TEST2\r\nRecovery Manager: Release 19.0.0.0.0 - Production on Tue Jul 16 15:27:12 2024\r\nVersion 19.22.0.0.0\r\nCopyright (c) 1982, 2019, Oracle and\/or its affiliates.  All rights reserved.\r\nconnected to target database: TEST2(DBID=3270)\r\nconnected to recovery catalog database\r\nrecovery catalog schema version 19.23.00.00. is newer than RMAN version\r\nRMAN-07540: Cleanup is required for the VPC user schema \r\nRecovery Manager complete.\r\n<\/pre>\n
 Que puedo hacer pasa solucionarlo? <\/h1>\n
Desde a version 12.x la configuracion del VPC cambio causando a los usuarios algun que otro quebradero de cabeza con los permis0s.<\/p>\n
Afortunadamente, oracle nos dio el script  dbmsrmanvpc.sql  <\/b> que lo soluciona.<\/p>\n
Aunque se puede ejecutar para cada VPC, mi consejo es usarlo con todos  de golpe con la opcion  -all <\/i>, nos conectamos como sysdba a la base de datos que contiene el catalogo<\/p>\n
\r\nsqlplus @\/as sysdba\"\r\nConnected to:\r\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\r\nVersion 19.23.0.0.0\r\nSQL> @?\/rdbms\/admin\/dbmsrmanvpc.sql -all\r\nChecking the operating user... Passed\r\n========================================\r\nUpgrading the VPC user schemas registered in the base catalog of RMAN_CAT\r\n----------------------------------------\r\nUpgrading: RMANVC01\r\nSynonyms...\r\nViews...\r\nCleanup of privileges...\r\nGrant of privileges...\r\n========================================\r\nUpgrading the VPC user schemas registered in the base catalog of RMAN_CAT\r\n----------------------------------------\r\nUpgrading: RMANVC02\r\nSynonyms...\r\nViews...\r\nCleanup of privileges...\r\nGrant of privileges...\r\n========================================\r\n========================================\r\nUpgrading the VPC user schemas registered in the base catalog of RMAN_CAT\r\n----------------------------------------\r\nUpgrading: RMANVC03\r\nSynonyms...\r\nViews...\r\nCleanup of privileges...\r\nGrant of privileges...\r\n----------------------------------------\r\nRemoving old VPC views in the base catalog of RMAN_CAT...\r\n----------------------------------------\r\nRemoving old VPC views in the base catalog of RMANVC03... \r\n<\/pre>\n
Y arreglado!<\/p>\n","protected":false},"excerpt":{"rendered":"
Hoy vamos a volver con una entrada rapida sobre un error basante sencillo. Es posible que conectando a vuestro VPC rman catalog user encontreis el error -bash-4.1$ rman catalog rmanvc3\/vcpass3@TEST2 Recovery Manager: Release 19.0.0.0.0 – Production on Tue Jul 16 … Sigue leyendo →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,66,1010],"tags":[24,23,1042],"class_list":["post-2375","post","type-post","status-publish","format-standard","hentry","category-backup","category-errores-ora","category-rman","tag-catalogo","tag-rman","tag-rman-07540"],"_links":{"self":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/2375","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/comments?post=2375"}],"version-history":[{"count":3,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/2375\/revisions"}],"predecessor-version":[{"id":2378,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/2375\/revisions\/2378"}],"wp:attachment":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/media?parent=2375"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/categories?post=2375"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/tags?post=2375"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}