Neste primeiro artigo iremos configurar um ambiente DG em dois sites, somente o banco ser\u00e1 replicado. Neste artigo n\u00e3o iremos ver a configura\u00e7\u00e3o do Broker nem failover, switchover e reinstate; isso ficar\u00e1 para pr\u00f3ximos artigos.<\/p>\n
<\/p>\n
AMBIENTE<\/strong><\/p>\n A primeira coisa a ser feita em qualquer ambiente MAA \u00e9 entender o ambiente que estamos trabalhando. Aqui, j\u00e1 partimos de um ambiente que chamamos inicialmente de primary <\/strong>com Oracle RAC 11.2.0.3 sobre 2 n\u00f3s. No ASM temos dois diskgroups DATA e FRA para hospedar o banco de dados. Tamb\u00e9m temos um banco de dados chamado \u201cmaa\u201d<\/strong>. Como dito acima, a inten\u00e7\u00e3o aqui n\u00e3o \u00e9 mostrar a instala\u00e7\u00e3o de um RAC, existem \u00f3timos artigos na internet sobre como fazer isso.<\/p>\n A imagem abaixo ilustra o ambiente, no servidor voc\u00ea pode descobrir isso atrav\u00e9s do comando \u201ccrsctl stat res \u2013t\u201d:<\/p>\n O segundo ambiente chamarei de standby <\/strong>onde temos um RAC instalado, mas sem nenhum banco de dados criado, somente o Grid Infrastricture est\u00e1 instalado e uma inst\u00e2ncia ASM est\u00e1 criada. O banco de dados ser\u00e1 criado aqui atrav\u00e9s da configura\u00e7\u00e3o do DG. A imagem abaixo demonstra este ambiente.<\/p>\n ARCHIVES, FLASHBACK E LOGMODE<\/strong><\/p>\n De forma bem resumida DG utiliza archivelogs para sincronizar o primary com o standby, enviando todo e qualquer archive gerado no primary para o standby. Para isso, precisamos que a base esteja em modo ARCHIVELOG. Basta verificar e configurar caso n\u00e3o esteja. Observe nos passos abaixo:<\/p>\n Como visto acima a base n\u00e3o est\u00e1 em modo archivelog e nem est\u00e1 com o flashback habilitado. Habilitar flashback \u00e9 fundamental, ele permite recuperar o banco de dados (fazer o reinstate) do primary em caso de failover de maneira muito (mas muito) mais r\u00e1pida. Isso ser\u00e1 t\u00f3pico de um pr\u00f3ximo artigo, mas no failover a troca entre os papeis entre primary e standby \u00e9 feita de maneira abrupta. Se voc\u00ea tiver habilitado flashback as suas noites ser\u00e3o mais tranquilas e as horas extras menores.<\/p>\n Para configurar tudo corretamente, verifique o par\u00e2metro de destino dos archives e o tamanho que ele pode usar. Dependendo da sua base de dados e da carga sobre ela, recomendo aumentar um pouco o limite da db_recovery_file_dest_size<\/em>. Voc\u00ea at\u00e9 pode configurar outro caminho para o destino dos archives, mas recomendo deixar tudo gerenciado pelo mesmo par\u00e2metro e apontando para o db_recovery_file_dest<\/em>. Caso queira ajustar algo, utilize:<\/p>\n Com tudo configurado, basta fazer um restart do banco e habilitar flashback e archivelog. Como estamos em um RAC, acostume-se com seus comandos:<\/p>\n Como disse, o pilar b\u00e1sico do DG s\u00e3o os archiveslogs, mas infelizmente muitas vezes temos tabelas em modo NOLOGGING. Acredito que voc\u00ea j\u00e1 percebeu que isso pode n\u00e3o ser ideal em um DG, mas temos uma forma de corrigir isso com o \u201cFORCE LOGGING\u201d. Habilitando o \u201cFORCE LOGGING\u201d far\u00e1 o banco de dados a gerar sempre archivelogs mesmo que a sua tabela esteja em NOLOGGING.<\/p>\n Dependendo o modo como voc\u00ea configura o seu DG existe a possibilidade de n\u00e3o usar o \u201cFORCE LOGGING\u201d. Basicamente uma informa\u00e7\u00e3o sobre a transa\u00e7\u00e3o \u00e9 escrita no redo mesmo a opera\u00e7\u00e3o sendo NOLOGGING, somente o seu archive n\u00e3o \u00e9 gerado. N\u00e3o uso assim e n\u00e3o recomendo deixar sem force logging. Configurar o FORCE LOGGING n\u00e3o custa nada e voc\u00ea ir\u00e1 agradecer no futuro.<\/p>\n A configura\u00e7\u00e3o \u00e9 simples, observe abaixo:<\/p>\n PREPARANDO PFILE E SPFILE<\/strong><\/p>\n Agora vamos come\u00e7ar a configurar o primary para o DG, deixando todos os par\u00e2metros corretamente definidos (at\u00e9 para passos e artigos futuros). Como vamos trabalhar com os par\u00e2metros eu recomendo come\u00e7ar com o um backup do spfile, nunca se sabe n\u00e3o \u00e9.<\/p>\n DB_NAME e DB_UNIQUE_NAME<\/strong><\/p>\n Estes dois par\u00e2metros s\u00e3o fundamentais em um ambiente DG. S\u00e3o eles que v\u00e3o definir o nome da base de dados e das inst\u00e2ncias standby. O primeiro par\u00e2metro \u00e9 o db_name<\/strong>, respons\u00e1vel por dar nome ao banco de dados. O valor definido aqui ser\u00e1 o mesmo utilizando tanto no primary quanto no standby.<\/p>\n O pr\u00f3ximo par\u00e2metro db_unique_name<\/em> \u00e9 utilizado para identificar qual o banco que voc\u00ea est\u00e1, primary ou standby. O valor deste par\u00e2metro ficar\u00e1 diferente entre o primary e o standy (ao contr\u00e1rio do db_name). No primary n\u00f3s n\u00e3o modificamos o seu valor, deixamos ele no valor default.<\/p>\n Al\u00e9m disso, a sua defini\u00e7\u00e3o \u00e9 utilizada em outros par\u00e2metros e configura\u00e7\u00f5es do DG, como por exemplo no redo transportation. Em alguns casos (como no 10G) era poss\u00edvel ter o mesmo valor em ambos os lados, com a vers\u00e3o 11 se isso estiver ocorrendo primary e standby n\u00e3o se comunicam. Essas informa\u00e7\u00f5es voc\u00ea pode ver neste documento (Oracle Data Guard Concepts and Administration<\/a>).<\/p>\n Um detalhe importante, o valor do db_unique_name quando n\u00e3o est\u00e1 configurado (fixo no spfile) deriva do db_name. Assim, \u00e9 fundamental garantir que ele esteja definido no spfile da primary. Veja abaixo:<\/p>\n LOG_ARCHIVE_CONFIG<\/strong><\/p>\n Este par\u00e2metro \u00e9 utilizado para definir quem participa do DG, quais as bases que ir\u00e3o trocar os archives. Se voc\u00ea tiver mais de um standby voc\u00ea definir\u00e1 todos eles aqui, se voc\u00ea adicionar mais um standby no futuro ter\u00e1 que modificar este par\u00e2metro.<\/p>\n A configura\u00e7\u00e3o deste par\u00e2metro \u00e9 simples, basta definir como no exemplo abaixo onde temos os dois bancos. Os valores aceitos para este par\u00e2metro s\u00e3o os definidos no par\u00e2metro db_unique_name. Desta forma, observe que j\u00e1 definimos como ficar\u00e1 para o nome para o standby (maastb):<\/p>\n LOG_ARCHIVE_DEST_XX<\/strong><\/p>\n Antes de alterarmos estes par\u00e2metros precisamos entender algumas informa\u00e7\u00f5es importantes do DG. Com as defini\u00e7\u00f5es que podem ser especificadas nestes par\u00e2metros definimos como o DG ir\u00e1 sincronizar os archives logs, quem ser\u00e1 respons\u00e1vel por fazer isso e quando fazer isso.<\/p>\n A primeira defini\u00e7\u00e3o importante a ser entendida \u00e9 como os archives s\u00e3o sincronizados, a forma como redo \u00e9 transportado (o que chamamos de redo transportation<\/em><\/strong>):<\/p>\n Al\u00e9m da forma s\u00edncrona ou n\u00e3o do envio do redo tamb\u00e9m \u00e9 necess\u00e1rio especificar uma \u201cgarantia\u201d de recebimento por parte do standby. Assim temos duas op\u00e7\u00f5es:<\/p>\n Depois de escolher a sincronia entre as bases \u00e9 necess\u00e1rio delimitar para o que o log_archive_dest ser\u00e1 v\u00e1lido. Esta defini\u00e7\u00e3o \u00e9 feita atrav\u00e9s do atributo VALID_FOR<\/strong> que \u00e9 dividido em duas partes:<\/p>\n Com estas defini\u00e7\u00f5es podemos montar o log_archive_dest corretamente, vou tomar como base o exemplo abaixo:<\/p>\n Vamos analisar em partes o que foi definido acima para deixar tudo claro:<\/p>\n Com as defini\u00e7\u00f5es acima temos que o LOG_ARCHIVE_DEST_1 ser\u00e1 utilizado quando qualquer archive for gerado neste banco de dados, independe da role (primary ou standby) e do tipo de onlinelog (redo ou standby). Basicamente defini o armazenamento local. Claro que voc\u00ea pode definir configura\u00e7\u00f5es mais espec\u00edficas, por exemplo, ter um local especifico para standby logs e redo logs. Voc\u00ea pode querer fazer isso para aliviar a carga sobre os discos por exemplo. Da forma como definido acima, tudo estar\u00e1 armazenando na flash_recovery_area<\/em>.<\/p>\n Como voc\u00ea deve ter percebido, n\u00e3o foi definido nenhum local ou banco remoto para enviar os archives, somente definimos o que fazer localmente. Para especificar o que e como enviar para o standby adicionamos mais um destino, observe o exemplo abaixo:<\/p>\n Novamente verificamos os detalhes:<\/p>\n Com a defini\u00e7\u00e3o acima garantimos o envio s\u00edncrono dos dados entre o primary e o standby. Tamb\u00e9m garantido o recebimento e aplica\u00e7\u00e3o dos mesmos pelo standby.<\/p>\n Antes de prosseguirmos, eu acredito que seja importante desligar temporariamente (ser\u00e1 ligado s\u00f3 no fim do processo) o log_archive_dest que aponta para o standby. Caso voc\u00ea tenha alguma inst\u00e2ncia reiniciada voc\u00ea n\u00e3o ver\u00e1 erro por erro de envio ao destino acima definido.<\/p>\n Se voc\u00ea quiser, defina um acr\u00f4nimo para seus archives, quando usamos OFA, o seu nome pode ficar confuso para quem ainda n\u00e3o tem dom\u00ednio:<\/p>\n DB_FILE_NAME_CONVERT, LOG_FILE_NAME_CONVERT e STANDBY_FILE_MANAGEMENT<\/strong><\/p>\n Os dois primeiros par\u00e2metros s\u00e3o importantes em ambientes primary e standby que diferem em sua estrutura de diret\u00f3rios para datafiles\/logfiles. Alguns passos acima voc\u00ea observou que intencionalmente o standby tem uma estrutura de diskgroups diferentes do primary. Esta diferen\u00e7a ser\u00e1 corrigida aqui.<\/p>\n Ambos os par\u00e2metros recebem conjunto (pares) de informa\u00e7\u00f5es, basicamente voc\u00ea informa o caminho de origem e qual o caminho que o substituir\u00e1. Isso \u00e9 importante, pois ao criarmos um novo datafile no primary ele ser\u00e1 criado corretamente no standby. Na documenta\u00e7\u00e3o da Oracle, existe a informa\u00e7\u00e3o de que ele \u00e9 considerado\/avaliado em pares, o primeiro \u00e9 substitu\u00eddo pelo segundo e assim sucessivamente (eles at\u00e9 comentam em express\u00f5es regulares para an\u00e1lise). Veja as defini\u00e7\u00f5es abaixo:<\/p>\n Observe que aqui, caso o banco receba alguma informa\u00e7\u00e3o quanto a cria\u00e7\u00e3o de um datafile o caminho ser\u00e1 substitu\u00eddo de \u2018+DG01\/maastb\u2019 para \u2018+DATA\/maa\u2019. Note que estamos definindo isso para a base atual que ser\u00e1 a primary, mas j\u00e1 estamos preparando ela para caso ela vire standby os par\u00e2metros j\u00e1 estejam corretos.<\/p>\n Fazemos a mesma coisa para os logfiles:<\/p>\n O par\u00e2metro standby_file_management garante uma seguran\u00e7a maior no gerenciamento dos dados. Definido ele como AUTO garantimos que todo e qualquer arquivo criado ou deletado no primary ser\u00e1 automaticamente replicado no standby. O detalhe \u00e9 que ele vem desabilitado por padr\u00e3o.<\/p>\n FAL_SERVER<\/strong><\/p>\n Este par\u00e2metro define onde que a inst\u00e2ncia ir\u00e1 buscar os archives caso ocorra algum gap de recebimento. Pense no seguinte caso, voc\u00ea precisa fazer uma manuten\u00e7\u00e3o no seu ambiente RAC standby e desliga ele por dois dias, na volta ele ter\u00e1 que buscar os archives em algum lugar (geralmente a primary), esse \u00e9 o par\u00e2metro que define isso. O valor deste par\u00e2metro deve ser igual ao que est\u00e1 no TNS, em RAC garanta que exista no TNS de ambas as inst\u00e2ncias:<\/p>\n Com isso, terminamos a prepara\u00e7\u00e3o do spfile da primary, agora vamos preparar o spfile da base standby.<\/p>\n TNSNAMES<\/strong><\/p>\n Antes de continuarmos temos que editar o TNSNAMES de todas as inst\u00e2ncias do RAC para criar entradas para o standby. Lembre de todos os par\u00e2metros que definimos previamente e que apontam para o TNS, ele deve casar com os valores que definimos nos par\u00e2metros anteriores. O TNS atual (de uma inst\u00e2ncia do primary):<\/p>\n Vamos editar ele e adicionar a entrada para o standby (observe que foi adicionado o MAASTB):<\/p>\n Como TNS foi editado em \u00fanico n\u00f3 para economizar tempo voc\u00ea copia ele (atrav\u00e9s do scp mesmo) entre todos os n\u00f3s do primary e para todos os n\u00f3s do standby:<\/p>\n PREPARANDO STANDBY, SPFILE e DIRET\u00d3RIOS<\/strong><\/p>\n Depois do SPFILE da primary e do TNS configurado podemos come\u00e7ar os ajustes do spfile da stanby. Tomamos como base o spfile da primary fazendo uma c\u00f3pia e enviando ela para o RAC standby:<\/p>\n Depois de copiado vamos editar os par\u00e2metros abaixo no spfile que foi copiado para o standby:<\/p>\n Observe como ficou o pfile editado:<\/p>\n Para terminar a configura\u00e7\u00e3o do standby precisamos ajustar dois detalhes: adump e pasword file. S\u00e3o dois passos simples, no primeiro s\u00e3o criados os diret\u00f3rios no standby e no segundo o arquivo de senhas do primary \u00e9 copiado para o standby (precisa ser o mesmo em todos os n\u00f3s):<\/p>\n BACKUP, RESTORE E CLONE<\/strong><\/p>\n Aqui vamos entrar em um ponto que necessita aten\u00e7\u00e3o e pode variar de caso a caso. Neste artigo tentarei cobrir 3 m\u00e9todos de clone. O primeiro \u00e9 atrav\u00e9s de backup e restore do banco de dados utilizando backup copiado (backupsets) do primary para o standby. O segundo modo \u00e9 atrav\u00e9s de clone com ACTIVE DATABASE. O terceiro \u00e9 um exemplo resumido de um clone com MML.<\/p>\n Clone com backup local<\/strong><\/p>\n O primeiro exemplo de clone \u00e9 criando o standby utilizando um backup do primary. Este backup \u00e9 copiado ao standby para que seja poss\u00edvel acess\u00e1-lo localmente a partir do standby. Isso as vezes fica complicado devido ao tamanho da base de dados, uma base de 2TB necessita que voc\u00ea tenha este espa\u00e7o dispon\u00edvel no filesystem do sistema operacional do standby. A t\u00edtulo de exemplo, vamos seguir com este exemplo.<\/p>\n O primeiro passo \u00e9 ir na primary e realizar um backup full da base de dados. Repare que n\u00e3o ser\u00e1 feito backup do controlfile. O backup do controlfile tem uma fun\u00e7\u00e3o (e comandos espec\u00edficos e eu prefiro fazer ele separado).<\/p>\n Observe abaixo os comandos executados (a sa\u00edda foi reduzida para ficar menor e caber no artigo)<\/p>\n Como disse e observado acima n\u00e3o temos backup do controlfile e ele \u00e9 fundamental para a cria\u00e7\u00e3o do standby. Observe que ele \u00e9 espec\u00edfico para criar o standby, FOR STANDBY<\/em>.<\/p>\n Eu prefiro fazer ele separado e para disco local. Se voc\u00ea estivesse usando MML, voc\u00ea poderia enviar seu backup para a fita e o controlfile ficaria local. \u00c9 uma prefer\u00eancia minha, se voc\u00ea quiser enviar tudo para a MML ou executar tudo no passo anterior, sem problema.<\/p>\n Com os backups em m\u00e3o, vamos copiar eles para o standby.<\/p>\n Com o backup copiado para o standby \u00e9 poss\u00edvel iniciar o banco. Iniciamos o standby em modo nomount com o pfile que editamos previamente e iniciamos o clone. Subindo o banco em NOMOUNT com o pfile editado:<\/p>\n Como \u00e9 a primeira vez que estamos iniciando a inst\u00e2ncia do standby \u00e9 interessante observar o alertlog para ver se todos os par\u00e2metros foram aceitos corretamente. Verifique os par\u00e2metros que modificamos previamente neste PFILE:<\/p>\n Como tudo \u201csubiu\u201d com sucesso, vamos clonar o banco. Observe a forma de conex\u00e3o ao RMAN e que os arquivos est\u00e3o locais no n\u00f3 desta inst\u00e2ncia.<\/p>\n Quanto a conex\u00e3o um detalhe importante no RAC. Se voc\u00ea especificar no \u201cauxiliary<\/em>\u201d, por exemplo \u201csys@maastb\u201d, poderia ter um problema com o listener. O problema reside no fato de que n\u00e3o tem como especificar em que n\u00f3 a conex\u00e3o ser\u00e1 feita, se tiver sorte ser\u00e1 no mesmo n\u00f3 que voc\u00ea est\u00e1. Assim, voc\u00ea pode deixar vazio que a conex\u00e3o ser\u00e1 no n\u00f3 local.<\/p>\n Ap\u00f3s a conex\u00e3o feita \u00e9 poss\u00edvel clonar o banco para o standby a partir do backup que est\u00e1 armazenado localmente.<\/p>\n Acredito que a sa\u00edda acima seja auto explicativa mas fazendo uma an\u00e1lise detalhada obervamos que os arquivos foram convertidos corretamente em seus destinos. +DATA do primary virou +DG01 no standby (ignore o warning que ele deu, o par\u00e2metro est\u00e1 correto).<\/p>\n Se voc\u00ea for ao ASM do standby ver\u00e1 que tudo est\u00e1 no seu devido lugar:<\/p>\n Clone com ACTIVE DATABASE<\/strong><\/p>\n No clone realizado atrav\u00e9s do ACTIVE DATABASE voc\u00ea vai clonar o banco primary para o standby sem realizar qualquer backup. Voc\u00ea se conecta no banco primary e \u201cmanda\u201d ele clonar um standby. Explicarei mais detalhes no decorrer dos pr\u00f3ximos passos, o clone utilizando este m\u00e9todo \u00e9 mais complicado do que o anterior.<\/p>\n Diferentemente do m\u00e9todo anterior, voc\u00ea precisa conectar no banco auxiliar utilizando tnsnames. Caso contr\u00e1rio, voc\u00ea ver\u00e1 o erro abaixo ao tentar clonar o banco:<\/p>\n Assim, o primeiro passo \u00e9 criar um m\u00e9todo de conectar diretamente na inst\u00e2ncia. Como estamos em um ambiente RAC fica um pouco mais complicado, voc\u00ea pode ter problemas de conex\u00e3o caso seja redirecionada para o n\u00f3 errado. Basicamente registramos manualmente a inst\u00e2ncia.<\/p>\n Particularmente eu prefiro criar manualmente um listener em um \u00fanico n\u00f3 e direcionar as conex\u00f5es do standby para ele. Este pode n\u00e3o ser o melhor m\u00e9todo, mas me sinto confort\u00e1vel com ele.<\/p>\n Para isso temos que criar um listener espec\u00edfico no standby para o clone em uma outra porta (observe o numero da porta, o hostname, GLOBAL_DBNAME e SID_NAME)<\/strong>:<\/p>\n Al\u00e9m disso, vamos ajustar o TNS do n\u00f3 standby em estamos conectados para apontar para o hostname e porta correta do listener. Neste caso, mudamos de 1521 para 1522<\/strong> e para o rac11stb01.<\/p>\n Depois de disso, podemos subir o novo listener e testar o tns (observe que a inst\u00e2ncia j\u00e1 fica registrada no listener \u2013 \u00e9 isso que queremos):<\/p>\n Como mudamos o listener e sua porta temporariamente precisamos que isso esteja refletido no pfile que iremos usar para subir a inst\u00e2ncia. Basta editar o pfile para apontar o par\u00e2metro \u201cremote_lister\u201dpara o endere\u00e7o correto (observe como era e como ficou o par\u00e2metro):<\/p>\n Devido a forma como o clone \u00e9 feito, a origem dos dados (mesmo que voc\u00ea inicie o procedimento da standby) ser\u00e1 do primary para o standby. Desta forma, o TNS do primary deve apontar para os endere\u00e7os configurados nos passos acima para o standby. Fa\u00e7a isso somente em uma inst\u00e2ncia da primary (na que voc\u00ea vai chamar o RMAN), modifique a porta da entrada para a 1522.<\/p>\n Depois desta configura\u00e7\u00e3o inicial, basta iniciar a inst\u00e2ncia o standby em modo nomount para iniciar o clone. Al\u00e9m disso, podemos testar o PFILE criado e modificado previamente quanto a falhas.<\/p>\n \u00a0Depois disso podemos conectar atrav\u00e9s do RMAN e realizar o clone do banco de dados. Observe na sa\u00edda do comando que basicamente ele realiza um backup e um restore do banco de dados. Obviamente que isso tem uma carga consider\u00e1vel e pode demorar tamb\u00e9m.<\/p>\n Se voc\u00ea comparar com o m\u00e9todo anterior a carga \u00e9 a mesma, mas aqui (caso o seu banco seja grande) poder\u00e1 acabar concorrendo com a sua carga de trabalho do dia a dia (voc\u00ea faz backup no meio do hor\u00e1rio de pico?). Outro detalhe, a origem da conex\u00e3o \u00e9 da primary e n\u00e3o \u00e9 especificada no comando do rman (observe a op\u00e7\u00e3o target).<\/p>\n Vamos analisar a sa\u00edda dos comandos acima, ele come\u00e7a com um backup do password file do primary para o standby. Depois temos um script executado na standby com:<\/p>\n Durante o backup e restore o input \u00e9 +DATA e o destino \u00e9 +DG01. Isso quer dizer que ele seguiu como base o que foi definido no pfile que fez o startup da standby (voc\u00ea tamb\u00e9m pode verificar isso no alert da standby).<\/p>\n Observe a quantidade de vezes que ocorreu shutdown e startup na standby, para que isso ocorra com sucesso voc\u00ea precisa de um registro direto no listener. Est\u00e1 ai o motivo para criarmos o listener e registrarmos manualmente a inst\u00e2ncia nele.<\/p>\n Depois do clone concluir com sucesso \u00e9 hora de colocar ordem na casa, corrigir os tnsnames e remover listener criado. No lado do primary (em ambos os n\u00f3s) corrija os tns para apontar para o endere\u00e7o correto (observe a defini\u00e7\u00e3o \u201cMAASTB\u201d):<\/p>\n Arrume o par\u00e2metro remote_listener do pfile da standby:<\/p>\n Removendo o listener utilizado no clone da standby:<\/p>\n E corrigindo o tns da standby<\/p>\n Pronto, depois destes passos voc\u00ea tem um standby criado atrav\u00e9s de um active database. O restart da inst\u00e2ncia fica para depois (j\u00e1 que ainda n\u00e3o terminamos o processo).<\/p>\n Clone atrav\u00e9s de MML<\/strong><\/p>\n O procedimento \u00e9 o mesmo do duplicate (sem active database), mas aqui especificando os canais para a fita. O detalhe \u00e9 que voc\u00ea tem que ter habilitado o standby na sua MML. Pe\u00e7o que observe como os canais foram configurados, temos um canal que aponta para a fita e um segundo canal para disco espec\u00edfico para o controlfile.<\/p>\n MONTANDO A BASE DE DADOS<\/strong><\/p>\n Depois de clonar o banco voc\u00ea pode montar o banco de dados. Eu recomento realizar um shutdown do standby e um startup com o pfile, principalmente pela necessidade de corrigir o par\u00e2metro que aponta para os controlfiles. Existe a necessidade de corre\u00e7\u00e3o, pois com OFA, no restore\/clone novos nomes s\u00e3o gerados.<\/p>\n Para verificar, basta ir no ASM identificar eles e corrigir o pfile:<\/p>\n Ap\u00f3s a edi\u00e7\u00e3o do pfile, a base standby pode ser montada (uma inst\u00e2ncia s\u00f3 at\u00e9 o momento).<\/p>\n Pronto, agora voc\u00ea tem uma inst\u00e2ncia standby criada e montada atrav\u00e9s de um clone da primary que j\u00e1 aponta para os controlfiles corretos.<\/p>\n STANDBY LOGS<\/strong><\/p>\n Voc\u00ea at\u00e9 poderia habilitar o DG, mas n\u00e3o estaria como desejamos, voc\u00ea n\u00e3o conseguiria abrir ela com um grau de prote\u00e7\u00e3o ideal para MAA. Para que isso seja poss\u00edvel, temos que criar o os standby redo logs.<\/p>\n Standby redo logs s\u00e3o id\u00eanticos aos redo logs. Eles s\u00e3o utilizados como destino das informa\u00e7\u00f5es (de redo) recebidas da primary. Quando ocorre um log switch na primary, existe um standby redo log switch na standby e este \u00e9 arquivado atrav\u00e9s de um processo ARCn (voc\u00ea pode ler isso no documento Oracle Data Guard Concepts and Administration<\/a>).<\/p>\n Na documenta\u00e7\u00e3o fica claro a necessidade de criar um standby redo log a mais do que os redo log groups existentes na primary. Existe uma f\u00f3rmula para calcular o n\u00famero correto em um ambiente RAC:<\/p>\n![\"Ambiente-Primary\"](\"http:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2014\/04\/Ambiente-Primary.png\")
<\/a><\/p>\n<\/a>Aqui temos uma mudan\u00e7a interessante, no ambiente standby n\u00e3o temos o diskgroup DATA e sim o DG01. Essa \u00e9 uma mudan\u00e7a intencional, deixei assim para que fosse poss\u00edvel explicar alguns detalhes na configura\u00e7\u00e3o do DG. Preferencialmente tenha os mesmos diskgroups em ambos os lados, primary e standby. Isso n\u00e3o ser\u00e1 um problema, vamos ver a frente como contornar.<\/p>\nSQL> SELECT instance_name FROM gv$instance;\r\n\r\nINSTANCE_NAME\r\n----------------\r\nmaa1\r\nmaa2\r\n\r\nSQL> SELECT log_mode, flashback_on FROM v$database;\r\n\r\nLOG_MODE FLASHBACK_ON\r\n------------ ------------------\r\nNOARCHIVELOG NO\r\n\r\nSQL> ARCHIVE LOG LIST;\r\nDatabase log mode No Archive Mode\r\nAutomatic archival Disabled\r\nArchive destination USE_DB_RECOVERY_FILE_DEST\r\nOldest online log sequence 13\r\nCurrent log sequence 14\r\nSQL>\r\n<\/pre>\n
ALTER SYSTEM SET db_recovery_file_dest='+FRA' SCOPE=SPFILE SID='*';\r\nALTER SYSTEM SET db_recovery_file_dest_size=4096M SCOPE=SPFILE SID='*'; \r\n<\/pre>\n
[oracle@rac11pri01 ~]$ srvctl stop database -d maa -o immediate\r\n[oracle@rac11pri01 ~]$ \r\n[oracle@rac11pri01 ~]$ srvctl start instance -d maa -i maa1 -o mount\r\n[oracle@rac11pri01 ~]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 11.2.0.3.0 Production on Sat Mar 29 12:15:01 2014\r\n\r\nCopyright (c) 1982, 2011, Oracle. All rights reserved.\r\n\r\n\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nWith the Partitioning, Real Application Clusters and Automatic Storage Management options\r\n\r\nSQL> ALTER DATABASE ARCHIVELOG;\r\n\r\nDatabase altered.\r\n\r\nSQL> ALTER DATABASE FLASHBACK ON;\r\n\r\nDatabase altered.\r\n\r\nSQL> ALTER DATABASE OPEN;\r\n\r\nDatabase altered.\r\n\r\nSQL> exit\r\nDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nWith the Partitioning, Real Application Clusters and Automatic Storage Management options\r\n[oracle@rac11pri01 ~]$\r\n[oracle@rac11pri01 ~]$ srvctl start instance -d maa -i maa2\r\n[oracle@rac11pri01 ~]$ srvctl status database -d maa\r\nInstance maa1 is running on node rac11pri01\r\nInstance maa2 is running on node rac11pri02\r\n[oracle@rac11pri01 ~]$\r\n<\/pre>\n
SQL> SELECT log_mode, flashback_on, force_logging FROM v$database;\r\n\r\nLOG_MODE FLASHBACK_ON FOR\r\n------------ ------------------ ---\r\nARCHIVELOG YES NO\r\n\r\nSQL> ALTER DATABASE FORCE LOGGING;\r\n\r\nDatabase altered.\r\n\r\nSQL> SELECT log_mode, flashback_on, force_logging FROM v$database;\r\n\r\nLOG_MODE FLASHBACK_ON FOR\r\n------------ ------------------ ---\r\nARCHIVELOG YES YES\r\n\r\nSQL>\r\n<\/pre>\n
SQL> CREATE PFILE = '\/tmp\/pfile-primary-bkp.ora' FROM spfile;\r\n\r\nFile created.\r\n\r\nSQL>\r\n<\/pre>\n
SQL> SHOW PARAMETER db_name\r\n\r\nNAME TYPE VALUE\r\n------------------------------------ ----------- ------------------------------\r\ndb_name string maa\r\nSQL>\r\n<\/pre>\n
SQL> SHOW PARAMETER db_unique_name\r\n\r\nNAME TYPE VALUE\r\n------------------------------------ ----------- ------------------------------\r\ndb_unique_name string maa\r\nSQL>\r\nSQL> ALTER SYSTEM SET db_unique_name='maa' SCOPE = spfile SID = '*';\r\n\r\nSystem altered.\r\n\r\nSQL>\r\n<\/pre>\n
SQL> SHOW PARAMETER log_archive_config\r\n\r\nNAME TYPE VALUE\r\n------------------------------------ ----------- ------------------------------\r\nlog_archive_config string\r\nSQL>\r\nSQL> ALTER SYSTEM SET log_archive_config='DG_CONFIG=(maa,maastb)' SCOPE = spfile SID = '*';\r\n\r\nSystem altered.\r\n\r\nSQL>\r\n<\/pre>\n
\n
\n
\n
\n
\n
\n
\n
SQL> SHOW PARAMETER log_archive_dest_1\r\n\r\nNAME TYPE VALUE\r\n------------------------------------ ----------- ------------------------------\r\nlog_archive_dest_1 string\r\n...\r\n...\r\nSQL> ALTER SYSTEM SET log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=maa' SCOPE=spfile SID='*';\r\n\r\nSystem altered.\r\n\r\nSQL>\r\n<\/pre>\n
\n
SQL> ALTER SYSTEM SET log_archive_dest_2='SERVICE=maastb SYNC AFFIRM LGWR VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=maastb' SCOPE=spfile SID='*';\r\n\r\nSystem altered.\r\n\r\nSQL>\r\n<\/pre>\n
\n
SQL> ALTER SYSTEM SET log_archive_dest_state_2=DEFER SCOPE=spfile SID='*';\r\nSystem altered.\r\n\r\nSQL\r\n<\/pre>\n
SQL> ALTER SYSTEM SET log_archive_format='arch_%t_%s_%r.arc' SCOPE=spfile SID='*';\r\n\r\nSystem altered.\r\n\r\nSQL> \r\n<\/pre>\n
SQL> ALTER SYSTEM SET db_file_name_convert='+DG01\/maastb','+DATA\/maa','+FRA\/maastb','+FRA\/maa' SCOPE=SPFILE SID='*';\r\n\r\nSystem altered.\r\n\r\nSQL>\r\n<\/pre>\n
SQL> ALTER SYSTEM SET log_file_name_convert='+DG01\/maastb','+DATA\/maa','+FRA\/maastb','+FRA\/maa' SCOPE=spfile SID='*';\r\n\r\nSystem altered.\r\n\r\nSQL>\r\n<\/pre>\n
SQL> SHOW PARAMETER standby_file_management;\r\n\r\nNAME TYPE VALUE\r\n------------------------------------ ----------- ------------------------------\r\nstandby_file_management string MANUAL\r\nSQL> ALTER SYSTEM SET standby_file_management=AUTO SCOPE=SPFILE SID='*';\r\n\r\nSystem altered.\r\n\r\nSQL>\r\n<\/pre>\n
SQL> ALTER SYSTEM SET fal_server=maastb SCOPE=spfile SID='*';\r\n\r\nSystem altered.\r\n\r\nSQL>\r\n<\/pre>\n
[oracle@rac11pri01 ~]$ cat \/u01\/app\/oracle\/product\/11.2.0.3\/db_1\/network\/admin\/tnsnames.ora\r\n# tnsnames.ora Network Configuration File: \/u01\/app\/oracle\/product\/11.2.0.3\/db_1\/network\/admin\/tnsnames.ora\r\n# Generated by Oracle configuration tools.\r\n\r\nMAA =\r\n (DESCRIPTION =\r\n (ADDRESS = (PROTOCOL = TCP)(HOST = rac11pri-scan.tjsc.jus.br)(PORT = 1521))\r\n (CONNECT_DATA =\r\n (SERVER = DEDICATED)\r\n (SERVICE_NAME = maa)\r\n )\r\n )\r\n\r\n[oracle@rac11pri01 ~]$\r\n<\/pre>\n
[oracle@rac11pri01 ~]$ cat \/u01\/app\/oracle\/product\/11.2.0.3\/db_1\/network\/admin\/tnsnames.ora\r\n# tnsnames.ora Network Configuration File: \/u01\/app\/oracle\/product\/11.2.0.3\/db_1\/network\/admin\/tnsnames.ora\r\n# Generated by Oracle configuration tools.\r\n\r\nMAA =\r\n (DESCRIPTION =\r\n (ADDRESS = (PROTOCOL = TCP)(HOST = rac11pri-scan.tjsc.jus.br)(PORT = 1521))\r\n (CONNECT_DATA =\r\n (SERVER = DEDICATED)\r\n (SERVICE_NAME = maa)\r\n )\r\n )\r\n\r\n[oracle@rac11pri01 ~]$\r\nVamos editar ele e adicionar a entrada para o standby (observe que foi adicionado o MAASTB):\r\n[oracle@rac11pri01 ~]$ vi \/u01\/app\/oracle\/product\/11.2.0.3\/db_1\/network\/admin\/tnsnames.ora\r\n[oracle@rac11pri01 ~]$\r\n[oracle@rac11pri01 ~]$\r\n[oracle@rac11pri01 ~]$ cat \/u01\/app\/oracle\/product\/11.2.0.3\/db_1\/network\/admin\/tnsnames.ora\r\n# tnsnames.ora Network Configuration File: \/u01\/app\/oracle\/product\/11.2.0.3\/db_1\/network\/admin\/tnsnames.ora\r\n# Generated by Oracle configuration tools.\r\n\r\nMAA =\r\n (DESCRIPTION =\r\n (ADDRESS = (PROTOCOL = TCP)(HOST = rac11pri-scan.tjsc.jus.br)(PORT = 1521))\r\n (CONNECT_DATA =\r\n (SERVER = DEDICATED)\r\n (SERVICE_NAME = maa)\r\n )\r\n )\r\n\r\nMAASTB =\r\n (DESCRIPTION =\r\n (ADDRESS = (PROTOCOL = TCP)(HOST = rac11stb-scan.tjsc.jus.br)(PORT = 1521))\r\n (CONNECT_DATA =\r\n (SERVER = DEDICATED)\r\n (SERVICE_NAME = maastb)\r\n )\r\n )\r\n\r\n[oracle@rac11pri01 ~]$\r\n[oracle@rac11pri01 ~]$ tnsping maastb\r\n\r\nTNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 30-MAR-2014 10:05:36\r\n\r\nCopyright (c) 1997, 2011, Oracle. All rights reserved.\r\n\r\nUsed parameter files:\r\n\r\n\r\nUsed TNSNAMES adapter to resolve the alias\r\nAttempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rac11stb-scan.tjsc.jus.br)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = maastb)))\r\nOK (10 msec)\r\n[oracle@rac11pri01 ~]$\r\n<\/pre>\n
[oracle@rac11pri01 ~]$ scp \/u01\/app\/oracle\/product\/11.2.0.3\/db_1\/network\/admin\/tnsnames.ora rac11pri02:\/u01\/app\/oracle\/product\/11.2.0.3\/db_1\/network\/admin\/tnsnames.ora\r\ntnsnames.ora 100% 534 0.5KB\/s 00:00\r\n[oracle@rac11pri01 ~]$ scp \/u01\/app\/oracle\/product\/11.2.0.3\/db_1\/network\/admin\/tnsnames.ora rac11stb01:\/u01\/app\/oracle\/product\/11.2.0.3\/db_1\/network\/admin\/tnsnames.ora\r\noracle@rac11stb01's password:\r\ntnsnames.ora 100% 534 0.5KB\/s 00:00\r\n[oracle@rac11pri01 ~]$ scp \/u01\/app\/oracle\/product\/11.2.0.3\/db_1\/network\/admin\/tnsnames.ora rac11stb02:\/u01\/app\/oracle\/product\/11.2.0.3\/db_1\/network\/admin\/tnsnames.ora\r\noracle@rac11stb02's password:\r\ntnsnames.ora 100% 534 0.5KB\/s 00:00\r\n[oracle@rac11pri01 ~]$\r\n<\/pre>\n
SQL> CREATE PFILE = '\/tmp\/pfile-primary.ora' FROM spfile;\r\n\r\nFile created.\r\n\r\nSQL> exit\r\nDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nWith the Partitioning, Real Application Clusters and Automatic Storage Management options\r\n[oracle@rac11pri01 ~]$\r\n[oracle@rac11pri01 ~]$ scp \/tmp\/pfile-primary.ora oracle@rac11stb01:\/tmp\/pfile-primary-standby.ora\r\noracle@rac11stb01's password:\r\npfile-primary.ora 100% 1854 1.8KB\/s 00:00\r\n[oracle@rac11pri01 ~]$ \r\n<\/pre>\n
\n
[oracle@rac11stb01 ~]$ vi \/tmp\/pfile-primary-standby.ora\r\n[oracle@rac11stb01 ~]$ \r\n[oracle@rac11stb01 ~]$ cat \/tmp\/pfile-primary-standby.ora\r\n*.audit_file_dest='\/u01\/app\/oracle\/admin\/maastb\/adump'\r\n*.audit_trail='db'\r\n*.cluster_database=true\r\n*.compatible='11.2.0.0.0'\r\n*.control_files='+DG01\/maastb\/controlfile\/current.273.843488553','+FRA\/maastb\/controlfile\/current.256.843488553'\r\n*.db_block_size=8192\r\n*.db_create_file_dest='+DG01'\r\n*.db_domain=''\r\n*.db_file_name_convert='+DATA\/maa','+DG01\/maastb','+FRA\/maa','+FRA\/maastb'\r\n*.db_name='maa'\r\n*.db_recovery_file_dest='+FRA'\r\n*.db_recovery_file_dest_size=10737418240\r\n*.db_unique_name='maastb'\r\n*.diagnostic_dest='\/u01\/app\/oracle'\r\n*.fal_server='MAA'\r\nmaastb1.instance_number=1\r\nmaastb2.instance_number=2\r\n*.log_archive_config='DG_CONFIG=(maa,maastb)'\r\n*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=maastb'\r\n*.log_archive_dest_2='SERVICE=maa SYNC AFFIRM LGWR VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=maa'\r\n*.log_archive_dest_state_2='DEFER'\r\n*.log_archive_format='arch_%t_%s_%r.arc'\r\n*.log_file_name_convert='+DATA\/maa','+DG01\/maastb','+FRA\/maa','+FRA\/maastb'\r\n*.open_cursors=300\r\n*.pga_aggregate_target=268435456\r\n*.processes=150\r\n*.remote_listener='rac11stb-scan.tjsc.jus.br:1521'\r\n*.remote_login_passwordfile='exclusive'\r\n*.sga_target=1073741824\r\n*.standby_file_management='AUTO'\r\nmaastb2.thread=2\r\nmaastb1.thread=1\r\nmaastb1.undo_tablespace='UNDOTBS1'\r\nmaastb2.undo_tablespace='UNDOTBS2'\r\n[oracle@rac11stb01 ~]$\r\n<\/pre>\n
No standby\r\n[oracle@rac11stb01 ~]$ mkdir -p \/u01\/app\/oracle\/admin\/maastb\/adump\r\n[oracle@rac11stb01 ~]$\r\nNo primary\r\n[oracle@rac11pri01 ~]$ cd $ORACLE_HOME\/dbs\r\n[oracle@rac11pri01 dbs]$ scp \/u01\/app\/oracle\/product\/11.2.0.3\/db_1\/dbs\/orapwmaa1 oracle@rac11stb01:\/u01\/app\/oracle\/product\/11.2.0.3\/db_1\/dbs\/orapwmaastb1\r\noracle@rac11stb01's password:\r\norapwmaa1 100% 1536 1.5KB\/s 00:00\r\n[oracle@rac11pri01 dbs]$ scp \/u01\/app\/oracle\/product\/11.2.0.3\/db_1\/dbs\/orapwmaa1 oracle@rac11stb02:\/u01\/app\/oracle\/product\/11.2.0.3\/db_1\/dbs\/orapwmaastb2\r\noracle@rac11stb02's password:\r\norapwmaa1 100% 1536 1.5KB\/s 00:00\r\n[oracle@rac11pri01 dbs]$\r\n<\/pre>\n
Comando executado:\r\n RUN {\r\n BACKUP FULL FORMAT '\/tmp\/bkpf-data-D-%d-DBID-%I-T-%T-NB-%s.bkp' DATABASE TAG 'BKP-FULL';\r\n SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';\r\n BACKUP FORMAT '\/tmp\/bkpf-arch-D-%d-DBID-%I-T-%T-NB-%s.bkp' ARCHIVELOG ALL TAG 'BKP-FULL-ARCH';\r\n BACKUP FORMAT '\/tmp\/bkp-spf-D-%d-DBID-%I-T-%T-NB-%s.bkp' SPFILE TAG 'BKP-FULL-SPFILE';\r\n }\r\n \r\n[oracle@rac11pri01 ~]$ rman target \/\r\n\r\nRecovery Manager: Release 11.2.0.3.0 - Production on Sun Mar 30 13:09:17 2014\r\n\r\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates. All rights reserved.\r\n\r\nconnected to target database: MAA (DBID=722024964)\r\n\r\nRMAN> RUN {\r\n2> BACKUP FULL FORMAT '\/tmp\/bkpf-data-D-%d-DBID-%I-T-%T-NB-%s.bkp' DATABASE TAG 'BKP-FULL';\r\n3> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';\r\n4> BACKUP FORMAT '\/tmp\/bkpf-arch-D-%d-DBID-%I-T-%T-NB-%s.bkp' ARCHIVELOG ALL TAG 'BKP-FULL-ARCH';\r\n5> BACKUP FORMAT '\/tmp\/bkp-spf-D-%d-DBID-%I-T-%T-NB-%s.bkp' SPFILE TAG 'BKP-FULL-SPFILE';\r\n6> }\r\n\r\nStarting backup at 30-MAR-14\r\nusing target database control file instead of recovery catalog\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: SID=32 instance=maa1 device type=DISK\r\nchannel ORA_DISK_1: starting full datafile backup set\r\nchannel ORA_DISK_1: specifying datafile(s) in backup set\r\ninput datafile file number=00001 name=+DATA\/maa\/datafile\/system.270.843488557\r\ninput datafile file number=00002 name=+DATA\/maa\/datafile\/sysaux.269.843488563\r\n...\r\n...\r\n...\r\nchannel ORA_DISK_1: starting piece 1 at 30-MAR-14\r\nchannel ORA_DISK_1: finished piece 1 at 30-MAR-14\r\npiece handle=\/tmp\/bkp-spf-D-MAA-DBID-722024964-T-20140330-NB-4.bkp tag=BKP-FULL-SPFILE comment=NONE\r\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\r\nFinished backup at 30-MAR-14\r\n\r\nRMAN>\r\n<\/pre>\nRUN {\r\n BACKUP FORMAT '\/tmp\/bkp-ctf-D-%d-DBID-%I-T-%T-NB-%s.bkp' CURRENT CONTROLFILE FOR STANDBY TAG 'BKP-FULL-CONTROL';\r\n}\r\n\r\nRMAN> RUN {\r\n BACKUP FORMAT '\/tmp\/bkp-ctf-D-%d-DBID-%I-T-%T-NB-%s.bkp' CURRENT CONTROLFILE FOR STANDBY TAG 'BKP-FULL-CONTROL';\r\n}2> 3>\r\n\r\nStarting backup at 30\/03\/2014 13:14:12\r\nusing channel ORA_DISK_1\r\nchannel ORA_DISK_1: starting full datafile backup set\r\nchannel ORA_DISK_1: specifying datafile(s) in backup set\r\nincluding standby control file in backup set\r\nchannel ORA_DISK_1: starting piece 1 at 30\/03\/2014 13:14:13\r\nchannel ORA_DISK_1: finished piece 1 at 30\/03\/2014 13:14:14\r\npiece handle=\/tmp\/bkp-ctf-D-MAA-DBID-722024964-T-20140330-NB-6.bkp tag=BKP-FULL-CONTROL comment=NONE\r\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\r\nFinished backup at 30\/03\/2014 13:14:14\r\n\r\nRMAN>\r\n<\/pre>\n[oracle@rac11pri01 ~]$ scp \/tmp\/bkp* oracle@rac11stb01:\/tmp\/\r\noracle@rac11stb01's password:\r\nbkp-ctf-D-MAA-DBID-722024964-T-20140330-NB-6.bkp 100% 18MB 8.8MB\/s 00:02\r\nbkpf-arch-D-MAA-DBID-722024964-T-20140330-NB-3.bkp 100% 144MB 12.0MB\/s 00:12\r\nbkpf-data-D-MAA-DBID-722024964-T-20140330-NB-1.bkp 100% 299MB 11.5MB\/s 00:26\r\nbkpf-data-D-MAA-DBID-722024964-T-20140330-NB-2.bkp 100% 18MB 8.9MB\/s 00:02\r\nbkp-spf-D-MAA-DBID-722024964-T-20140330-NB-4.bkp 100% 96KB 96.0KB\/s 00:00\r\n[oracle@rac11pri01 ~]$ \r\n<\/pre>\n
SQL> STARTUP PFILE='\/tmp\/pfile-primary-standby.ora' NOMOUNT;\r\nORACLE instance started.\r\n\r\nTotal System Global Area 1068937216 bytes\r\nFixed Size 2235208 bytes\r\nVariable Size 339739832 bytes\r\nDatabase Buffers 721420288 bytes\r\nRedo Buffers 5541888 bytes\r\nSQL>\r\n<\/pre>\n
[oracle@rac11stb01 ~]$ tail -1000f \/u01\/app\/oracle\/diag\/rdbms\/maastb\/maastb1\/trace\/alert_maastb1.log\r\nSun Mar 30 13:19:03 2014\r\nStarting ORACLE instance (normal)\r\n...\r\n... \r\nUsing parameter settings in client-side pfile \/tmp\/pfile-primary-standby.ora on machine rac11stb01.tjsc.jus.br\r\nSystem parameters with non-default values:\r\n processes = 150\r\n sga_target = 1G\r\n control_files = \"+DG01\/maastb\/controlfile\/current.273.843488553\"\r\n control_files = \"+FRA\/maastb\/controlfile\/current.256.843488553\"\r\n db_file_name_convert = \"+DATA\/maa\"\r\n db_file_name_convert = \"+DG01\/maastb\"\r\n db_file_name_convert = \"+FRA\/maa\"\r\n db_file_name_convert = \"+FRA\/maastb\"\r\n log_file_name_convert = \"+DATA\/maa\"\r\n log_file_name_convert = \"+DG01\/maastb\"\r\n log_file_name_convert = \"+FRA\/maa\"\r\n log_file_name_convert = \"+FRA\/maastb\"\r\n db_block_size = 8192\r\n compatible = \"11.2.0.0.0\"\r\n log_archive_dest_1 = \"LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=maastb\"\r\n log_archive_dest_2 = \"SERVICE=maa SYNC AFFIRM LGWR VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=maa\"\r\n log_archive_dest_state_2 = \"DEFER\"\r\n fal_server = \"MAA\"\r\n log_archive_config = \"DG_CONFIG=(maa,maastb)\"\r\n log_archive_format = \"arch_%t_%s_%r.arc\"\r\n cluster_database = TRUE\r\n db_create_file_dest = \"+DG01\"\r\n db_recovery_file_dest = \"+FRA\"\r\n db_recovery_file_dest_size= 10G\r\n standby_file_management = \"AUTO\"\r\n thread = 1\r\n undo_tablespace = \"UNDOTBS1\"\r\n instance_number = 1\r\n remote_login_passwordfile= \"EXCLUSIVE\"\r\n db_domain = \"\"\r\n remote_listener = \"rac11stb-scan.tjsc.jus.br:1521\"\r\n audit_file_dest = \"\/u01\/app\/oracle\/admin\/maastb\/adump\"\r\n audit_trail = \"DB\"\r\n db_name = \"maa\"\r\n db_unique_name = \"maastb\"\r\n open_cursors = 300\r\n pga_aggregate_target = 256M\r\n diagnostic_dest = \"\/u01\/app\/oracle\"\r\nCluster communication is configured to use the following interface(s) for this instance\r\n 169.254.172.112\r\ncluster interconnect IPC version:Oracle UDP\/IP (generic)\r\n...\r\n...\r\nList of instances:\r\n 1 (myinst: 1)\r\n Global Resource Directory frozen\r\n* allocate domain 0, invalid = TRUE\r\n Communication channels reestablished\r\n...\r\n...\r\n<\/pre>\n
[oracle@rac11stb01 tmp]$ rman target sys@maa auxiliary sys\r\n\r\nRecovery Manager: Release 11.2.0.3.0 - Production on Sun Mar 30 13:39:01 2014\r\n\r\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates. All rights reserved.\r\n\r\ntarget database Password:\r\nconnected to target database: MAA (DBID=722024964)\r\nauxiliary database Password:\r\nconnected to auxiliary database: MAA (not mounted)\r\n\r\nRMAN> RUN {\r\n ALLOCATE AUXILIARY CHANNEL d1 DEVICE TYPE DISK FORMAT = '\/tmp\/bkp-ctf-D-%d-DBID-%I-T-%T-NB-%s.bkp';\r\n DUPLICATE TARGET DATABASE FOR STANDBY NOFILENAMECHECK;\r\n}2> 3> 4>\r\n\r\nusing target database control file instead of recovery catalog\r\nallocated channel: d1\r\nchannel d1: SID=18 instance=maastb1 device type=DISK\r\n\r\nStarting Duplicate Db at 30-MAR-14\r\n\r\ncontents of Memory Script:\r\n{\r\n restore clone standby controlfile;\r\n}\r\nexecuting Memory Script\r\n\r\nStarting restore at 30-MAR-14\r\n\r\nchannel d1: starting datafile backup set restore\r\nchannel d1: restoring control file\r\nchannel d1: reading from backup piece \/tmp\/bkp-ctf-D-MAA-DBID-722024964-T-20140330-NB-6.bkp\r\nchannel d1: piece handle=\/tmp\/bkp-ctf-D-MAA-DBID-722024964-T-20140330-NB-6.bkp tag=BKP-FULL-CONTROL\r\nchannel d1: restored backup piece 1\r\nchannel d1: restore complete, elapsed time: 00:00:06\r\noutput file name=+DG01\/maastb\/controlfile\/current.265.843594121\r\noutput file name=+FRA\/maastb\/controlfile\/current.260.843594123\r\nFinished restore at 30-MAR-14\r\n\r\ncontents of Memory Script:\r\n{\r\n sql clone 'alter database mount standby database';\r\n}\r\nexecuting Memory Script\r\n\r\nsql statement: alter database mount standby database\r\nRMAN-05529: WARNING: DB_FILE_NAME_CONVERT resulted in invalid ASM names; names changed to disk group only.\r\n\r\ncontents of Memory Script:\r\n{\r\n set newname for tempfile 1 to\r\n \"+dg01\";\r\n switch clone tempfile all;\r\n set newname for datafile 1 to\r\n \"+dg01\";\r\n set newname for datafile 2 to\r\n \"+dg01\";\r\n set newname for datafile 3 to\r\n \"+dg01\";\r\n set newname for datafile 4 to\r\n \"+dg01\";\r\n set newname for datafile 5 to\r\n \"+dg01\";\r\n restore\r\n clone database\r\n ;\r\n}\r\nexecuting Memory Script\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nrenamed tempfile 1 to +dg01 in control file\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nStarting restore at 30-MAR-14\r\n\r\nchannel d1: starting datafile backup set restore\r\nchannel d1: specifying datafile(s) to restore from backup set\r\nchannel d1: restoring datafile 00001 to +dg01\r\nchannel d1: restoring datafile 00002 to +dg01\r\nchannel d1: restoring datafile 00003 to +dg01\r\nchannel d1: restoring datafile 00004 to +dg01\r\nchannel d1: restoring datafile 00005 to +dg01\r\nchannel d1: reading from backup piece \/tmp\/bkpf-data-D-MAA-DBID-722024964-T-20140330-NB-1.bkp\r\nchannel d1: piece handle=\/tmp\/bkpf-data-D-MAA-DBID-722024964-T-20140330-NB-1.bkp tag=BKP-FULL\r\nchannel d1: restored backup piece 1\r\nchannel d1: restore complete, elapsed time: 00:01:25\r\nFinished restore at 30-MAR-14\r\n\r\ncontents of Memory Script:\r\n{\r\n switch clone datafile all;\r\n}\r\nexecuting Memory Script\r\n\r\ndatafile 1 switched to datafile copy\r\ninput datafile copy RECID=6 STAMP=843572620 file name=+DG01\/maastb\/datafile\/system.257.843594135\r\ndatafile 2 switched to datafile copy\r\ninput datafile copy RECID=7 STAMP=843572620 file name=+DG01\/maastb\/datafile\/sysaux.256.843594135\r\ndatafile 3 switched to datafile copy\r\ninput datafile copy RECID=8 STAMP=843572620 file name=+DG01\/maastb\/datafile\/undotbs1.262.843594137\r\ndatafile 4 switched to datafile copy\r\ninput datafile copy RECID=9 STAMP=843572620 file name=+DG01\/maastb\/datafile\/undotbs2.263.843594137\r\ndatafile 5 switched to datafile copy\r\ninput datafile copy RECID=10 STAMP=843572620 file name=+DG01\/maastb\/datafile\/users.264.843594137\r\nFinished Duplicate Db at 30-MAR-14\r\nreleased channel: d1\r\n\r\nRMAN>\r\n<\/pre>\n[oracle@rac11stb01 tmp]$ export ORACLE_SID=+ASM1\r\n[oracle@rac11stb01 tmp]$ export ORACLE_HOME=\/u01\/app\/grid\/11.2.0.3\r\n[oracle@rac11stb01 tmp]$ asmcmd\r\nASMCMD> ls\r\nDG01\/\r\nFRA\/\r\nSYS01\/\r\nASMCMD> ls DG01\r\nMAASTB\/\r\nASMCMD> ls FRA\r\nMAASTB\/\r\nASMCMD> ls DG01\/MAASTB\/\r\nCONTROLFILE\/\r\nDATAFILE\/\r\nONLINELOG\/\r\nASMCMD> ls FRA\/MAASTB\/\r\nCONTROLFILE\/\r\nONLINELOG\/\r\nASMCMD>\r\nASMCMD> exit\r\n[oracle@rac11stb01 ~]$\r\n<\/pre>\n
[oracle@rac11stb01 ~]$ rman target sys@maa auxiliary sys\r\n\r\nRecovery Manager: Release 11.2.0.3.0 - Production on Sun Mar 30 14:47:40 2014\r\n\r\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates. All rights reserved.\r\n\r\ntarget database Password:\r\nconnected to target database: MAA (DBID=722024964)\r\nauxiliary database Password:\r\nconnected to auxiliary database: MAA (not mounted)\r\n\r\nRMAN> DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE DORECOVER NOFILENAMECHECK;\r\n\r\nStarting Duplicate Db at 30\/03\/2014 14:48:15\r\nRMAN-00571: ===========================================================\r\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\r\nRMAN-00571: ===========================================================\r\nRMAN-03002: failure of Duplicate Db command at 03\/30\/2014 14:48:16\r\nRMAN-05501: aborting duplication of target database\r\nRMAN-06217: not connected to auxiliary database with a net service name\r\n\r\nRMAN>\r\n<\/pre>\n
[oracle@rac11stb01 ~]$ vi \/u01\/app\/grid\/11.2.0.3\/network\/admin\/listener.ora\r\n[oracle@rac11stb01 ~]$ cat \/u01\/app\/grid\/11.2.0.3\/network\/admin\/listener.ora \r\nLISTENER_CLONE =\r\n (DESCRIPTION_LIST =\r\n (DESCRIPTION =\r\n (ADDRESS_LIST =\r\n (ADDRESS = (PROTOCOL = TCP)(HOST = rac11stb01-vip)(PORT = 1522)\r\n (IP = FIRST)\r\n )\r\n )\r\n (ADDRESS_LIST =\r\n (ADDRESS = (PROTOCOL = TCP)(HOST = rac11stb01)(PORT = 1522)\r\n (IP = FIRST)\r\n )\r\n )\r\n (ADDRESS_LIST =\r\n (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))\r\n )\r\n )\r\n )\r\n\r\n SID_LIST_LISTENER_CLONE =\r\n (SID_LIST =\r\n (SID_DESC =\r\n (GLOBAL_DBNAME = maastb)\r\n (ORACLE_HOME = \/u01\/app\/oracle\/product\/11.2.0.3\/db_1)\r\n (SID_NAME = maastb1)\r\n )\r\n ) \r\n<\/pre>\n
[oracle@rac11stb01 ~]$ vi \/u01\/app\/oracle\/product\/11.2.0.3\/db_1\/network\/admin\/tnsnames.ora\r\n[oracle@rac11stb01 ~]$ cat \/u01\/app\/oracle\/product\/11.2.0.3\/db_1\/network\/admin\/tnsnames.ora\r\nMAA =\r\n (DESCRIPTION =\r\n (ADDRESS = (PROTOCOL = TCP)(HOST = rac11pri-scan.tjsc.jus.br)(PORT = 1521))\r\n (CONNECT_DATA =\r\n (SERVER = DEDICATED)\r\n (SERVICE_NAME = maa)\r\n )\r\n )\r\n\r\nMAASTB =\r\n (DESCRIPTION =\r\n (ADDRESS = (PROTOCOL = TCP)(HOST = rac11stb01.tjsc.jus.br)(PORT = 1522))\r\n (CONNECT_DATA =\r\n (SERVER = DEDICATED)\r\n (SERVICE_NAME = maastb)\r\n )\r\n )\r\n\r\n[oracle@rac11stb01 ~]$\r\n<\/pre>\n
[oracle@rac11stb01 ~]$ export ORACLE_HOME=\/u01\/app\/grid\/11.2.0.3\r\n[oracle@rac11stb01 ~]$ \/u01\/app\/grid\/11.2.0.3\/bin\/lsnrctl start LISTENER_CLONE\r\n\r\nLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 30-MAR-2014 16:24:46\r\n\r\nCopyright (c) 1991, 2011, Oracle. All rights reserved.\r\n\r\nStarting \/u01\/app\/grid\/11.2.0.3\/bin\/tnslsnr: please wait...\r\n\r\nTNSLSNR for Linux: Version 11.2.0.3.0 - Production\r\nSystem parameter file is \/u01\/app\/grid\/11.2.0.3\/network\/admin\/listener.ora\r\nLog messages written to \/u01\/app\/oracle\/diag\/tnslsnr\/rac11stb01\/listener_clone\/alert\/log.xml\r\nListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.17.42.52)(PORT=1522)))\r\nListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.17.42.48)(PORT=1522)))\r\nListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))\r\n\r\nConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac11stb01-vip)(PORT=1522)(IP=FIRST)))\r\nSTATUS of the LISTENER\r\n------------------------\r\nAlias LISTENER_CLONE\r\nVersion TNSLSNR for Linux: Version 11.2.0.3.0 - Production\r\nStart Date 30-MAR-2014 16:24:46\r\nUptime 0 days 0 hr. 0 min. 0 sec\r\nTrace Level off\r\nSecurity ON: Local OS Authentication\r\nSNMP OFF\r\nListener Parameter File \/u01\/app\/grid\/11.2.0.3\/network\/admin\/listener.ora\r\nListener Log File \/u01\/app\/oracle\/diag\/tnslsnr\/rac11stb01\/listener_clone\/alert\/log.xml\r\nListening Endpoints Summary...\r\n (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.17.42.52)(PORT=1522)))\r\n (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.17.42.48)(PORT=1522)))\r\n (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))\r\nServices Summary...\r\nService \"tjdgstb\" has 1 instance(s).\r\n Instance \"maastb1\", status UNKNOWN, has 1 handler(s) for this service...\r\nThe command completed successfully\r\n[oracle@rac11stb01 ~]$\r\n[oracle@rac11stb01 ~]$ export ORACLE_HOME=\/u01\/app\/oracle\/product\/11.2.0.3\/db_1\r\n[oracle@rac11stb01 ~]$ tnsping maastb\r\n\r\nTNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 30-MAR-2014 16:27:09\r\n\r\nCopyright (c) 1997, 2011, Oracle. All rights reserved.\r\n\r\nUsed parameter files:\r\n\r\n\r\nUsed TNSNAMES adapter to resolve the alias\r\nAttempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rac11stb01.tjsc.jus.br)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = maastb)))\r\nOK (0 msec)\r\n[oracle@rac11stb01 ~]$\r\n<\/pre>\n
[oracle@rac11stb01 ~]$ cat \/tmp\/pfile-primary-standby.ora |grep remote_listener\r\n*.remote_listener='rac11stb-scan.tjsc.jus.br:1521'\r\n[oracle@rac11stb01 ~]$ \r\n[oracle@rac11stb01 ~]$ vi \/tmp\/pfile-primary-standby.ora\r\n[oracle@rac11stb01 ~]$ \r\n[oracle@rac11stb01 ~]$ cat \/tmp\/pfile-primary-standby.ora |grep remote_listener\r\n*.remote_listener='rac11stb01.tjsc.jus.br:1522'\r\n[oracle@rac11stb01 ~]$\r\n<\/pre>\n
SQL> STARTUP PFILE='\/tmp\/pfile-primary-standby.ora' NOMOUNT;\r\nORACLE instance started.\r\n\r\nTotal System Global Area 1068937216 bytes\r\nFixed Size 2235208 bytes\r\nVariable Size 343934136 bytes\r\nDatabase Buffers 717225984 bytes\r\nRedo Buffers 5541888 bytes\r\nSQL> exit\r\nDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nWith the Partitioning, Real Application Clusters and Real Application Testing options\r\n[oracle@rac11stb01 ~]$ \r\n<\/pre>\n
[oracle@rac11pri01 ~]$ rman target sys auxiliary sys@maastb\r\n\r\nRecovery Manager: Release 11.2.0.3.0 - Production on Sun Mar 30 17:17:00 2014\r\n\r\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates. All rights reserved.\r\n\r\ntarget database Password:\r\nconnected to target database: MAA (DBID=722024964)\r\nauxiliary database Password:\r\nconnected to auxiliary database: MAA (not mounted)\r\n\r\nRMAN> DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE DORECOVER NOFILENAMECHECK;\r\n\r\nStarting Duplicate Db at 30\/03\/2014 17:17:10\r\nusing target database control file instead of recovery catalog\r\nallocated channel: ORA_AUX_DISK_1\r\nchannel ORA_AUX_DISK_1: SID=19 instance=maastb1 device type=DISK\r\n\r\ncontents of Memory Script:\r\n{\r\n backup as copy reuse\r\n targetfile '\/u01\/app\/oracle\/product\/11.2.0.3\/db_1\/dbs\/orapwmaa1' auxiliary format\r\n '\/u01\/app\/oracle\/product\/11.2.0.3\/db_1\/dbs\/orapwmaastb1' ;\r\n}\r\nexecuting Memory Script\r\n\r\nStarting backup at 30\/03\/2014 17:17:11\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: SID=157 instance=maa1 device type=DISK\r\nFinished backup at 30\/03\/2014 17:17:12\r\n\r\ncontents of Memory Script:\r\n{\r\n backup as copy current controlfile for standby auxiliary format '+DG01\/maastb\/controlfile\/current.265.843606857';\r\n restore clone controlfile to '+FRA\/maastb\/controlfile\/current.260.843606857' from\r\n '+DG01\/maastb\/controlfile\/current.265.843606857';\r\n sql clone \"create spfile from memory\";\r\n shutdown clone immediate;\r\n startup clone nomount;\r\n sql clone \"alter system set control_files =\r\n ''+DG01\/maastb\/controlfile\/current.265.843606857'', ''+FRA\/maastb\/controlfile\/current.260.843606857'' comment=\r\n ''Set by RMAN'' scope=spfile\";\r\n shutdown clone immediate;\r\n startup clone nomount;\r\n}\r\nexecuting Memory Script\r\n\r\nStarting backup at 30\/03\/2014 17:17:14\r\nusing channel ORA_DISK_1\r\nchannel ORA_DISK_1: starting datafile copy\r\ncopying standby control file\r\noutput file name=\/u01\/app\/oracle\/product\/11.2.0.3\/db_1\/dbs\/snapcf_maa1.f tag=TAG20140330T171714 RECID=1 STAMP=843585435\r\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07\r\nFinished backup at 30\/03\/2014 17:17:21\r\n\r\nStarting restore at 30\/03\/2014 17:17:22\r\nusing channel ORA_AUX_DISK_1\r\n\r\nchannel ORA_AUX_DISK_1: copied control file copy\r\nFinished restore at 30\/03\/2014 17:17:26\r\n\r\nsql statement: create spfile from memory\r\n\r\nOracle instance shut down\r\n\r\nconnected to auxiliary database (not started)\r\nOracle instance started\r\n\r\nTotal System Global Area 1068937216 bytes\r\n\r\nFixed Size 2235208 bytes\r\nVariable Size 348128440 bytes\r\nDatabase Buffers 713031680 bytes\r\nRedo Buffers 5541888 bytes\r\n\r\nsql statement: alter system set control_files = ''+DG01\/maastb\/controlfile\/current.265.843606857'', ''+FRA\/maastb\/controlfile\/current.260.843606857'' comment= ''Set by RMAN'' scope=spfile\r\n\r\nOracle instance shut down\r\n\r\nconnected to auxiliary database (not started)\r\nOracle instance started\r\n\r\nTotal System Global Area 1068937216 bytes\r\n\r\nFixed Size 2235208 bytes\r\nVariable Size 348128440 bytes\r\nDatabase Buffers 713031680 bytes\r\nRedo Buffers 5541888 bytes\r\n\r\ncontents of Memory Script:\r\n{\r\n sql clone 'alter database mount standby database';\r\n}\r\nexecuting Memory Script\r\n\r\nsql statement: alter database mount standby database\r\nRMAN-05529: WARNING: DB_FILE_NAME_CONVERT resulted in invalid ASM names; names changed to disk group only.\r\n\r\ncontents of Memory Script:\r\n{\r\n set newname for tempfile 1 to\r\n \"+dg01\";\r\n switch clone tempfile all;\r\n set newname for datafile 1 to\r\n \"+dg01\";\r\n set newname for datafile 2 to\r\n \"+dg01\";\r\n set newname for datafile 3 to\r\n \"+dg01\";\r\n set newname for datafile 4 to\r\n \"+dg01\";\r\n set newname for datafile 5 to\r\n \"+dg01\";\r\n backup as copy reuse\r\n datafile 1 auxiliary format\r\n \"+dg01\" datafile\r\n 2 auxiliary format\r\n \"+dg01\" datafile\r\n 3 auxiliary format\r\n \"+dg01\" datafile\r\n 4 auxiliary format\r\n \"+dg01\" datafile\r\n 5 auxiliary format\r\n \"+dg01\" ;\r\n sql 'alter system archive log current';\r\n}\r\nexecuting Memory Script\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nrenamed tempfile 1 to +dg01 in control file\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nStarting backup at 30\/03\/2014 17:18:11\r\nusing channel ORA_DISK_1\r\nchannel ORA_DISK_1: starting datafile copy\r\ninput datafile file number=00001 name=+DATA\/maa\/datafile\/system.270.843488557\r\noutput file name=+DG01\/maastb\/datafile\/system.264.843606915 tag=TAG20140330T171811\r\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:05\r\nchannel ORA_DISK_1: starting datafile copy\r\ninput datafile file number=00002 name=+DATA\/maa\/datafile\/sysaux.269.843488563\r\noutput file name=+DG01\/maastb\/datafile\/sysaux.263.843606981 tag=TAG20140330T171811\r\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:55\r\nchannel ORA_DISK_1: starting datafile copy\r\ninput datafile file number=00003 name=+DATA\/maa\/datafile\/undotbs1.268.843488567\r\noutput file name=+DG01\/maastb\/datafile\/undotbs1.262.843607035 tag=TAG20140330T171811\r\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25\r\nchannel ORA_DISK_1: starting datafile copy\r\ninput datafile file number=00004 name=+DATA\/maa\/datafile\/undotbs2.265.843488579\r\noutput file name=+DG01\/maastb\/datafile\/undotbs2.256.843607061 tag=TAG20140330T171811\r\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25\r\nchannel ORA_DISK_1: starting datafile copy\r\ninput datafile file number=00005 name=+DATA\/maa\/datafile\/users.258.843488581\r\noutput file name=+DG01\/maastb\/datafile\/users.257.843607085 tag=TAG20140330T171811\r\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03\r\nFinished backup at 30\/03\/2014 17:21:05\r\n\r\nsql statement: alter system archive log current\r\n\r\ncontents of Memory Script:\r\n{\r\n backup as copy reuse\r\n archivelog like \"+FRA\/maa\/archivelog\/2014_03_30\/thread_2_seq_4.292.843592197\" auxiliary format\r\n \"+FRA\" archivelog like\r\n \"+FRA\/maa\/archivelog\/2014_03_30\/thread_1_seq_18.537.843607269\" auxiliary format\r\n \"+FRA\" archivelog like\r\n \"+FRA\/maa\/archivelog\/2014_03_30\/thread_2_seq_5.508.843607269\" auxiliary format\r\n \"+FRA\" ;\r\n catalog clone start with \"+FRA\";\r\n switch clone datafile all;\r\n}\r\nexecuting Memory Script\r\n\r\nStarting backup at 30\/03\/2014 17:21:11\r\nusing channel ORA_DISK_1\r\nchannel ORA_DISK_1: starting archived log copy\r\ninput archived log thread=2 sequence=4 RECID=8 STAMP=843592197\r\noutput file name=+FRA\/maastb\/archivelog\/2014_03_30\/thread_2_seq_4.571.843607095 RECID=0 STAMP=0\r\nchannel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01\r\nchannel ORA_DISK_1: starting archived log copy\r\ninput archived log thread=1 sequence=18 RECID=9 STAMP=843607269\r\noutput file name=+FRA\/maastb\/archivelog\/2014_03_30\/thread_1_seq_18.574.843607095 RECID=0 STAMP=0\r\nchannel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:03\r\nchannel ORA_DISK_1: starting archived log copy\r\ninput archived log thread=2 sequence=5 RECID=10 STAMP=843607270\r\noutput file name=+FRA\/maastb\/archivelog\/2014_03_30\/thread_2_seq_5.257.843607099 RECID=0 STAMP=0\r\nchannel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:03\r\nFinished backup at 30\/03\/2014 17:21:18\r\n\r\nsearching for all files that match the pattern +FRA\r\n\r\nList of Files Unknown to the Database\r\n=====================================\r\nFile Name: +fra\/MAASTB\/ARCHIVELOG\/2014_03_30\/thread_2_seq_4.571.843607095\r\nFile Name: +fra\/MAASTB\/ARCHIVELOG\/2014_03_30\/thread_1_seq_18.574.843607095\r\nFile Name: +fra\/MAASTB\/ARCHIVELOG\/2014_03_30\/thread_2_seq_5.257.843607099\r\ncataloging files...\r\ncataloging done\r\n\r\nList of Cataloged Files\r\n=======================\r\nFile Name: +fra\/MAASTB\/ARCHIVELOG\/2014_03_30\/thread_2_seq_4.571.843607095\r\nFile Name: +fra\/MAASTB\/ARCHIVELOG\/2014_03_30\/thread_1_seq_18.574.843607095\r\nFile Name: +fra\/MAASTB\/ARCHIVELOG\/2014_03_30\/thread_2_seq_5.257.843607099\r\n\r\ndatafile 1 switched to datafile copy\r\ninput datafile copy RECID=1 STAMP=843585503 file name=+DG01\/maastb\/datafile\/system.264.843606915\r\ndatafile 2 switched to datafile copy\r\ninput datafile copy RECID=2 STAMP=843585503 file name=+DG01\/maastb\/datafile\/sysaux.263.843606981\r\ndatafile 3 switched to datafile copy\r\ninput datafile copy RECID=3 STAMP=843585503 file name=+DG01\/maastb\/datafile\/undotbs1.262.843607035\r\ndatafile 4 switched to datafile copy\r\ninput datafile copy RECID=4 STAMP=843585503 file name=+DG01\/maastb\/datafile\/undotbs2.256.843607061\r\ndatafile 5 switched to datafile copy\r\ninput datafile copy RECID=5 STAMP=843585503 file name=+DG01\/maastb\/datafile\/users.257.843607085\r\n\r\ncontents of Memory Script:\r\n{\r\n set until scn 435603;\r\n recover\r\n standby\r\n clone database\r\n delete archivelog\r\n ;\r\n}\r\nexecuting Memory Script\r\n\r\nexecuting command: SET until clause\r\n\r\nStarting recover at 30\/03\/2014 17:21:21\r\nallocated channel: ORA_AUX_DISK_1\r\nchannel ORA_AUX_DISK_1: SID=145 instance=maastb1 device type=DISK\r\n\r\nstarting media recovery\r\n\r\narchived log for thread 1 with sequence 18 is already on disk as file +FRA\/maastb\/archivelog\/2014_03_30\/thread_1_seq_18.574.843607095\r\narchived log for thread 2 with sequence 5 is already on disk as file +FRA\/maastb\/archivelog\/2014_03_30\/thread_2_seq_5.257.843607099\r\narchived log file name=+FRA\/maastb\/archivelog\/2014_03_30\/thread_1_seq_18.574.843607095 thread=1 sequence=18\r\narchived log file name=+FRA\/maastb\/archivelog\/2014_03_30\/thread_2_seq_5.257.843607099 thread=2 sequence=5\r\nmedia recovery complete, elapsed time: 00:00:01\r\nFinished recover at 30\/03\/2014 17:21:25\r\nFinished Duplicate Db at 30\/03\/2014 17:21:48\r\n\r\nRMAN>\r\n<\/pre>\n\n
[oracle@rac11pri01 ~]$ cat \/u01\/app\/oracle\/product\/11.2.0.3\/db_1\/network\/admin\/tnsnames.ora\r\n# tnsnames.ora Network Configuration File: \/u01\/app\/oracle\/product\/11.2.0.3\/db_1\/network\/admin\/tnsnames.ora\r\n# Generated by Oracle configuration tools.\r\n\r\nMAA =\r\n (DESCRIPTION =\r\n (ADDRESS = (PROTOCOL = TCP)(HOST = rac11pri-scan.tjsc.jus.br)(PORT = 1521))\r\n (CONNECT_DATA =\r\n (SERVER = DEDICATED)\r\n (SERVICE_NAME = maa)\r\n )\r\n )\r\n\r\nMAASTB =\r\n (DESCRIPTION =\r\n (ADDRESS = (PROTOCOL = TCP)(HOST = rac11stb01.tjsc.jus.br)(PORT = 1522))\r\n (CONNECT_DATA =\r\n (SERVER = DEDICATED)\r\n (SERVICE_NAME = maastb)\r\n )\r\n )\r\n\r\n[oracle@rac11pri01 ~]$ vi \/u01\/app\/oracle\/product\/11.2.0.3\/db_1\/network\/admin\/tnsnames.ora\r\n[oracle@rac11pri01 ~]$ cat \/u01\/app\/oracle\/product\/11.2.0.3\/db_1\/network\/admin\/tnsnames.ora\r\n# tnsnames.ora Network Configuration File: \/u01\/app\/oracle\/product\/11.2.0.3\/db_1\/network\/admin\/tnsnames.ora\r\n# Generated by Oracle configuration tools.\r\n\r\nMAA =\r\n (DESCRIPTION =\r\n (ADDRESS = (PROTOCOL = TCP)(HOST = rac11pri-scan.tjsc.jus.br)(PORT = 1521))\r\n (CONNECT_DATA =\r\n (SERVER = DEDICATED)\r\n (SERVICE_NAME = maa)\r\n )\r\n )\r\n\r\nMAASTB =\r\n (DESCRIPTION =\r\n (ADDRESS = (PROTOCOL = TCP)(HOST = rac11stb-scan.tjsc.jus.br)(PORT = 1521))\r\n (CONNECT_DATA =\r\n (SERVER = DEDICATED)\r\n (SERVICE_NAME = maastb)\r\n )\r\n )\r\n\r\n[oracle@rac11pri01 ~]$\r\n<\/pre>\n
[oracle@rac11stb01 ~]$ cat \/tmp\/pfile-primary-standby.ora |grep remote_listener\r\n*.remote_listener='rac11stb01.tjsc.jus.br:1522'\r\n[oracle@rac11stb01 ~]$ vi \/tmp\/pfile-primary-standby.ora\r\n[oracle@rac11stb01 ~]$ cat \/tmp\/pfile-primary-standby.ora |grep remote_listener\r\n*.remote_listener='rac11stb-scan.tjsc.jus.br:1521'\r\n[oracle@rac11stb01 ~]$\r\n<\/pre>\n
[oracle@rac11stb01 ~]$ export ORACLE_HOME=\/u01\/app\/grid\/11.2.0.3\r\n[oracle@rac11stb01 ~]$ lsnrctl stop LISTENER_CLONE\r\n\r\nLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 30-MAR-2014 18:32:26\r\n\r\nCopyright (c) 1991, 2011, Oracle. All rights reserved.\r\n\r\nConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac11stb01-vip)(PORT=1522)(IP=FIRST)))\r\nThe command completed successfully\r\n[oracle@rac11stb01 ~]$\r\n[oracle@rac11stb01 ~]$\r\n[oracle@rac11stb01 ~]$ cat \/u01\/app\/grid\/11.2.0.3\/network\/admin\/listener.ora\r\nLISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent\r\nLISTENER_SCAN3=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3)))) # line added by Agent\r\nLISTENER_SCAN2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))) # line added by Agent\r\nLISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent\r\nENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent\r\nENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2=ON # line added by Agent\r\nENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN3=ON # line added by Agent\r\nENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent\r\n\r\n\r\nLISTENER_CLONE =\r\n (DESCRIPTION_LIST =\r\n (DESCRIPTION =\r\n (ADDRESS_LIST =\r\n (ADDRESS = (PROTOCOL = TCP)(HOST = rac11stb01-vip)(PORT = 1522)\r\n (IP = FIRST)\r\n )\r\n )\r\n (ADDRESS_LIST =\r\n (ADDRESS = (PROTOCOL = TCP)(HOST = rac11stb01)(PORT = 1522)\r\n (IP = FIRST)\r\n )\r\n )\r\n (ADDRESS_LIST =\r\n (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))\r\n )\r\n )\r\n )\r\n\r\nSID_LIST_LISTENER_CLONE =\r\n (SID_LIST =\r\n (SID_DESC =\r\n (GLOBAL_DBNAME = maastb)\r\n (ORACLE_HOME = \/u01\/app\/oracle\/product\/11.2.0.3\/db_1)\r\n (SID_NAME = maastb1)\r\n )\r\n)\r\n[oracle@rac11stb01 ~]$ vi \/u01\/app\/grid\/11.2.0.3\/network\/admin\/listener.ora\r\n[oracle@rac11stb01 ~]$ cat \/u01\/app\/grid\/11.2.0.3\/network\/admin\/listener.ora\r\nLISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent\r\nLISTENER_SCAN3=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3)))) # line added by Agent\r\nLISTENER_SCAN2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))) # line added by Agent\r\nLISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent\r\nENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent\r\nENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2=ON # line added by Agent\r\nENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN3=ON # line added by Agent\r\nENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent\r\n\r\n\r\n[oracle@rac11stb01 ~]$\r\n<\/pre>\n
[oracle@rac11stb01 ~]$ cat \/u01\/app\/oracle\/product\/11.2.0.3\/db_1\/network\/admin\/tnsnames.ora\r\nMAA =\r\n (DESCRIPTION =\r\n (ADDRESS = (PROTOCOL = TCP)(HOST = rac11pri-scan.tjsc.jus.br)(PORT = 1521))\r\n (CONNECT_DATA =\r\n (SERVER = DEDICATED)\r\n (SERVICE_NAME = maa)\r\n )\r\n )\r\n\r\nMAASTB =\r\n (DESCRIPTION =\r\n (ADDRESS = (PROTOCOL = TCP)(HOST = rac11stb01.tjsc.jus.br)(PORT = 1522))\r\n (CONNECT_DATA =\r\n (SERVER = DEDICATED)\r\n (SERVICE_NAME = maastb)\r\n )\r\n )\r\n\r\n[oracle@rac11stb01 ~]$ vi \/u01\/app\/oracle\/product\/11.2.0.3\/db_1\/network\/admin\/tnsnames.ora\r\n[oracle@rac11stb01 ~]$ cat \/u01\/app\/oracle\/product\/11.2.0.3\/db_1\/network\/admin\/tnsnames.ora\r\nMAA =\r\n (DESCRIPTION =\r\n (ADDRESS = (PROTOCOL = TCP)(HOST = rac11pri-scan.tjsc.jus.br)(PORT = 1521))\r\n (CONNECT_DATA =\r\n (SERVER = DEDICATED)\r\n (SERVICE_NAME = maa)\r\n )\r\n )\r\n\r\nMAASTB =\r\n (DESCRIPTION =\r\n (ADDRESS = (PROTOCOL = TCP)(HOST = rac11stb-scan.tjsc.jus.br)(PORT = 1521))\r\n (CONNECT_DATA =\r\n (SERVER = DEDICATED)\r\n (SERVICE_NAME = maastb)\r\n )\r\n )\r\n\r\n[oracle@rac11stb01 ~]$\r\n<\/pre>\n
Comando a ser executado:\r\n rman target sys\/XXXXXXXX@oselocpd auxiliary sys\/XXXXXX@oselo\r\n\r\n run {\r\n ALLOCATE AUXILIARY CHANNEL t1 DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(NSR_SERVER=mml-server,NSR_CLIENT=selodigital-st,NSR_DPRINTF=TRUE, NSR_DEBUG_FILE=\/tmp\/t1.log,NSR_DEBUG_LEVEL=2)';\r\n ALLOCATE AUXILIARY CHANNEL d1 DEVICE TYPE DISK FORMAT = '\/tmp\/bkp-ctf-D-%d-DBID-%I-T-%T-NB-%s.bkp';\r\n DUPLICATE TARGET DATABASE FOR STANDBY NOFILENAMECHECK;\r\n } \r\n\r\n-bash-3.00$ rman target sys\/XXXXXXX@oselocpd auxiliary sys\/XXXXXXX@oselo\r\n\r\nRecovery Manager: Release 10.2.0.5.0 - Production on Wed Aug 7 17:10:32 2013\r\n\r\nCopyright (c) 1982, 2007, Oracle. All rights reserved.\r\n\r\nconnected to target database: OSELO (DBID=2831035320)\r\nconnected to auxiliary database: OSELO (not mounted)\r\n\r\nRMAN> run {\r\nALLOCATE AUXILIARY CHANNEL t1 DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(NSR_SERVER=mml-server,NSR_CLIENT=selodigital-st,NSR_DPRINTF=TRUE, NSR_DEBUG_FILE=\/tmp\/t1.log,NSR_DEBUG_LEVEL=2)';\r\n2> 3> ALLOCATE AUXILIARY CHANNEL d1 DEVICE TYPE DISK FORMAT = '\/tmp\/bkp-ctf-D-%d-DBID-%I-T-%T-NB-%s.bkp';\r\nDUPLICATE TARGET DATABASE FOR STANDBY NOFILENAMECHECK;\r\n4> 5> }\r\n\r\nusing target database control file instead of recovery catalog\r\nallocated channel: t1\r\nchannel t1: sid=155 devtype=SBT_TAPE\r\nchannel t1: NMO v5.0.0.0\r\n\r\nallocated channel: d1\r\nchannel d1: sid=154 devtype=DISK\r\n\r\nStarting Duplicate Db at 07-AUG-13\r\n\r\ncontents of Memory Script:\r\n{\r\n restore clone standby controlfile;\r\n sql clone 'alter database mount standby database';\r\n}\r\nexecuting Memory Script\r\n\r\nStarting restore at 07-AUG-13\r\n\r\nchannel d1: starting datafile backupset restore\r\nchannel d1: restoring control file\r\nchannel d1: reading from backup piece \/tmp\/bkp-ctf-D-OSELO-DBID-2831035320-T-20130807-NB-6297.bkp\r\nchannel d1: restored backup piece 1\r\npiece handle=\/tmp\/bkp-ctf-D-OSELO-DBID-2831035320-T-20130807-NB-6297.bkp tag=BKP-FULL-CONTROL-STB\r\nchannel d1: restore complete, elapsed time: 00:00:11\r\noutput filename=+DATA\/oselo\/controlfile\/current.280.822849075\r\noutput filename=+DATA\/oselo\/controlfile\/current.279.822849075\r\nFinished restore at 07-AUG-13\r\n\r\nsql statement: alter database mount standby database\r\nWARNING: DB_FILE_NAME_CONVERT resulted in invalid ASM names; names changed to diskgroup only.\r\n\r\ncontents of Memory Script:\r\n{\r\n set newname for tempfile 1 to\r\n \"+data\";\r\n switch clone tempfile all;\r\n set newname for datafile 1 to\r\n \"+data\";\r\n set newname for datafile 2 to\r\n \"+data\";\r\n set newname for datafile 3 to\r\n \"+data\";\r\n set newname for datafile 4 to\r\n \"+data\";\r\n set newname for datafile 5 to\r\n \"+data\";\r\n set newname for datafile 6 to\r\n \"+data\";\r\n set newname for datafile 7 to\r\n \"+data\";\r\n set newname for datafile 8 to\r\n \"+data\";\r\n set newname for datafile 9 to\r\n \"+data\";\r\n restore\r\n check readonly\r\n clone database\r\n ;\r\n}\r\nexecuting Memory Script\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nrenamed temporary file 1 to +data in control file\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nStarting restore at 07-AUG-13\r\n\r\nchannel t1: starting datafile backupset restore\r\nchannel t1: specifying datafile(s) to restore from backup set\r\nrestoring datafile 00007 to +DATA\r\nrestoring datafile 00008 to +DATA\r\nchannel t1: reading from backup piece bkpi0-data-D-OSELO-DBID-2831035320-T-20130806-NB-6288.bkp\r\nchannel t1: restored backup piece 1\r\npiece handle=bkpi0-data-D-OSELO-DBID-2831035320-T-20130806-NB-6288.bkp tag=BKP-INCR0-DB\r\nchannel t1: restore complete, elapsed time: 01:09:16\r\nchannel t1: starting datafile backupset restore\r\nchannel t1: specifying datafile(s) to restore from backup set\r\nrestoring datafile 00001 to +DATA\r\nrestoring datafile 00002 to +DATA\r\nrestoring datafile 00003 to +DATA\r\nrestoring datafile 00004 to +DATA\r\nrestoring datafile 00005 to +DATA\r\nrestoring datafile 00006 to +DATA\r\nchannel t1: reading from backup piece bkpi0-data-D-OSELO-DBID-2831035320-T-20130806-NB-6289.bkp\r\nchannel t1: restored backup piece 1\r\npiece handle=bkpi0-data-D-OSELO-DBID-2831035320-T-20130806-NB-6289.bkp tag=BKP-INCR0-DB\r\nchannel t1: restore complete, elapsed time: 00:50:46\r\nchannel t1: starting datafile backupset restore\r\nchannel t1: specifying datafile(s) to restore from backup set\r\nrestoring datafile 00009 to +DATA\r\nchannel t1: reading from backup piece bkpi0-data-D-OSELO-DBID-2831035320-T-20130806-NB-6290.bkp\r\nchannel t1: restored backup piece 1\r\npiece handle=bkpi0-data-D-OSELO-DBID-2831035320-T-20130806-NB-6290.bkp tag=BKP-INCR0-DB\r\nchannel t1: restore complete, elapsed time: 00:04:45\r\nFinished restore at 07-AUG-13\r\n\r\ncontents of Memory Script:\r\n{\r\n switch clone datafile all;\r\n}\r\nexecuting Memory Script\r\n\r\ndatafile 1 switched to datafile copy\r\ninput datafile copy recid=220 stamp=822856580 filename=+DATA\/oselo\/datafile\/system.273.822853265\r\ndatafile 2 switched to datafile copy\r\ninput datafile copy recid=221 stamp=822856580 filename=+DATA\/oselo\/datafile\/undotbs1.274.822853263\r\ndatafile 3 switched to datafile copy\r\ninput datafile copy recid=222 stamp=822856580 filename=+DATA\/oselo\/datafile\/sysaux.1172.822853265\r\ndatafile 4 switched to datafile copy\r\ninput datafile copy recid=223 stamp=822856580 filename=+DATA\/oselo\/datafile\/users.263.822853265\r\ndatafile 5 switched to datafile copy\r\ninput datafile copy recid=224 stamp=822856581 filename=+DATA\/oselo\/datafile\/tsselodigdat.276.822853251\r\ndatafile 6 switched to datafile copy\r\ninput datafile copy recid=225 stamp=822856581 filename=+DATA\/oselo\/datafile\/tsselodigidx.275.822853259\r\ndatafile 7 switched to datafile copy\r\ninput datafile copy recid=226 stamp=822856581 filename=+DATA\/oselo\/datafile\/tsselodigarqprotarqlob4k.278.822849095\r\ndatafile 8 switched to datafile copy\r\ninput datafile copy recid=227 stamp=822856582 filename=+DATA\/oselo\/datafile\/tsselodigarqprotreclob4k.277.822849107\r\ndatafile 9 switched to datafile copy\r\ninput datafile copy recid=228 stamp=822856582 filename=+DATA\/oselo\/datafile\/tsselodigarqprotarqlob2k.1011.822856297\r\nFinished Duplicate Db at 07-AUG-13\r\nreleased channel: t1\r\nreleased channel: d1\r\n\r\nRMAN>\r\n<\/pre>\n[oracle@rac11stb01 ~]$ export ORACLE_HOME=\/u01\/app\/grid\/11.2.0.3\r\n[oracle@rac11stb01 ~]$ export ORACLE_SID=+ASM1\r\n[oracle@rac11stb01 ~]$ asmcmd\r\nASMCMD> ls +DG01\/MAASTB\/CONTROLFILE\/\r\nCurrent.265.843606857\r\nASMCMD> ls +FRA\/MAASTB\/CONTROLFILE\/\r\nCurrent.260.843606857\r\nASMCMD> exit\r\n[oracle@rac11stb01 ~]$ cat \/tmp\/pfile-primary-standby.ora |grep control\r\n*.control_files='+DG01\/maastb\/controlfile\/current.273.843488553','+FRA\/maastb\/controlfile\/current.256.843488553'\r\n[oracle@rac11stb01 ~]$\r\n[oracle@rac11stb01 ~]$ vi \/tmp\/pfile-primary-standby.ora\r\n[oracle@rac11stb01 ~]$ cat \/tmp\/pfile-primary-standby.ora |grep control\r\n*.control_files='+DG01\/maastb\/controlfile\/current.265.843606857','+FRA\/maastb\/controlfile\/current.260.843606857'\r\n[oracle@rac11stb01 ~]$\r\n<\/pre>\n
[oracle@rac11stb01 ~]$ export ORACLE_HOME=\/u01\/app\/oracle\/product\/11.2.0.3\/db_1\r\n[oracle@rac11stb01 ~]$ export ORACLE_SID=maastb1\r\n[oracle@rac11stb01 ~]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 11.2.0.3.0 Production on Sun Mar 30 19:01:38 2014\r\n\r\nCopyright (c) 1982, 2011, Oracle. All rights reserved.\r\n\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nWith the Partitioning, Real Application Clusters, Automatic Storage Management and Real Application Testing options\r\n\r\nSQL> shutdown immediate;\r\nORA-01109: database not open\r\n\r\n\r\nDatabase dismounted.\r\nORACLE instance shut down.\r\nSQL> STARTUP PFILE='\/tmp\/pfile-primary-standby.ora' MOUNT;\r\nORACLE instance started.\r\n\r\nTotal System Global Area 1068937216 bytes\r\nFixed Size 2235208 bytes\r\nVariable Size 343934136 bytes\r\nDatabase Buffers 717225984 bytes\r\nRedo Buffers 5541888 bytes\r\nDatabase mounted.\r\nSQL>\r\n<\/pre>\n