Obrigado meu camarada, apesar de eu não enteder muito..mas irei dar uma olhada aqui obrigado mesmo pela força..
ESTUDO <[EMAIL PROTECTED]> escreveu: Olá Luiz Tirei do metalink: Rolling Back To An Earlier Oracle9i Release 2 Database Server Patch Set 9.2.0.7 To Original Patchset a.. Section-I Rollingback a patchset to 9.2.0.4 or Onwards b.. Section-II RollingBack a Patchset to 9.2.0.3 or Below Section-I Perform the following steps for backing out from the 9207 patch release: 1.. Rollback Dictionary Upgrade Before restoring the Oracle home to the original release, perform the following steps: $ sqlplus /nolog SQL> connect / AS SYSDBA SQL> SHUTDOWN SQL> STARTUP MIGRATE SQL> SPOOL catbkout.out SQL> @?/rdbms/admin/catbkout.sql SQL> SPOOL OFF SQL> SHUTDOWN IMMEDIATE 2.. Restore The Oracle Binary. Restore the Oracle9i installation and Central Inventory (see /etc/oraInst.loc) that you backed up before applying the patch set. The backup of Oracle installation and Central Inventory can be taken using OS utility "tar " If there is no backup available before patchset applied , then reinstallation of Oracle software till earlier patchset level is required. This can be done in the same home after removing 9207 installation or can be installed in separate Oracle_Home 3.. Update Dictionary with Older Release (like 9.2.0.6) with catpatch.sql After restoring the original Oracle home, perform the following steps: $ sqlplus /nolog SQL> connect / AS SYSDBA SQL> STARTUP MIGRATE SQL> SPOOL catpatch.out SQL> @?/rdbms/admin/catpatch.sql 4.. If Oracle Spatial is installed with the database, perform the following steps: SQL> alter session set current_schema = mdsys;SQL> @?/md/admin/prvtsidx.plbSQL> a.. Shut down the database: SQL> SHUTDOWN IMMEDIATE a.. Compile All objects. Start the database and recompile the remaining invalid objects: SQL> STARTUP SQL> @?/rdbms/admin/utlrp.sql a.. Review catbkout.out and catpatch.out for errors Section-II 1.. Restore The Oracle Binary. Restore the Oracle9i installation and Central Inventory (see /etc/oraInst.loc) that you backed up before applying the patch set. The backup of Oracle installation and Central Inventory can be taken using OS utility "tar " If there is no backup available before patchset applied , then reinstallation of Oracle software till earlier patchset level is required. This can be done in the same home after removing 9207 installation or can be installed in separate Oracle_Home 2.. There are two ways to solve this problem a) Use a point-in-time or full database backup and recovery to restore the database to its condition before you upgraded the database. b) Export, rebuild, and import the database. @ Downgrade Downgrade Downgrade Downgrade Downgrade Downgrade Downgrade Downgrade Downgrade Downgrade Downgrade @ Downgrade Downgrade Downgrade Downgrade Downgrade Downgrade Downgrade Downgrade Downgrade Downgrade Downgrade @ Downgrade Downgrade Downgrade Downgrade Downgrade Downgrade Downgrade Downgrade Downgrade Downgrade Downgrade @ Patchset Patchset Patchset Patchset Patchset Patchset Patchset Patchset Patchset Patchset Patchset Patchset Patchset Patchset @ Patchset Patchset Patchset Patchset Patchset Patchset Patchset Patchset Patchset Patchset Patchset Patchset Patchset Patchset @ Patchset Patchset Patchset Patchset Patchset Patchset Patchset Patchset Patchset Patchset Patchset Patchset Patchset Patchset @ Patchset Patchset Patchset Patchset Patchset Patchset Patchset Patchset Patchset Patchset Patchset Patchset Patchset Patchset @ Rollback Rollback Rollback Rollback Rollback Rollback Rollback Rollback Rollback Rollback Rollback Rollback Rollback Rollback @ Rollback Rollback Rollback Rollback Rollback Rollback Rollback Rollback Rollback Rollback Rollback Rollback Rollback Rollback @ Rollback Rollback Rollback Rollback Rollback Rollback Rollback Rollback Rollback Rollback Rollback Rollback Rollback Rollback Cris ----- Original Message ----- From: Luiz Claudio Felicio To: oracle_br@yahoogrupos.com.br Sent: Wednesday, March 15, 2006 11:12 AM Subject: [oracle_br] Voltar realese Bom dia a todos!! tenho um banco 9i realease 9.2.0.7.0, sendo que eu gostaria de voltar essa realese para 9.2.0.4.0 é possivel?? Como faço? Obrigado, Luiz Claudio --------------------------------- Yahoo! Acesso Grátis Internet rápida e grátis. Instale o discador agora! [As partes desta mensagem que não continham texto foram removidas] -------------------------------------------------------------------------------------------------------------------------- Atenção! As mensagens deste grupo são de acesso público e de inteira responsabilidade de seus remetentes. Acesse: http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/ --------------------------------------------------------------------------------------------------------------------------__________________________________________________________________ Este Grupo recebe o apoio da SQL Magazine - www.devmedia.com.br/sqlmagazine __________________________________________________________________ Yahoo! Grupos, um serviço oferecido por: PUBLICIDADE ------------------------------------------------------------------------------ Links do Yahoo! Grupos a.. Para visitar o site do seu grupo na web, acesse: http://br.groups.yahoo.com/group/oracle_br/ b.. Para sair deste grupo, envie um e-mail para: [EMAIL PROTECTED] c.. O uso que você faz do Yahoo! Grupos está sujeito aos Termos do Serviço do Yahoo!. [As partes desta mensagem que não continham texto foram removidas] -------------------------------------------------------------------------------------------------------------------------- Atenção! As mensagens deste grupo são de acesso público e de inteira responsabilidade de seus remetentes. Acesse: http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/ --------------------------------------------------------------------------------------------------------------------------__________________________________________________________________ Este Grupo recebe o apoio da SQL Magazine - www.devmedia.com.br/sqlmagazine __________________________________________________________________ Links do Yahoo! Grupos --------------------------------- Yahoo! Acesso Grátis Internet rápida e grátis. Instale o discador agora! [As partes desta mensagem que não continham texto foram removidas] -------------------------------------------------------------------------------------------------------------------------- Atenção! As mensagens deste grupo são de acesso público e de inteira responsabilidade de seus remetentes. Acesse: http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/ --------------------------------------------------------------------------------------------------------------------------__________________________________________________________________ Este Grupo recebe o apoio da SQL Magazine - www.devmedia.com.br/sqlmagazine __________________________________________________________________ Links do Yahoo! Grupos <*> Para visitar o site do seu grupo na web, acesse: http://br.groups.yahoo.com/group/oracle_br/ <*> Para sair deste grupo, envie um e-mail para: [EMAIL PROTECTED] <*> O uso que você faz do Yahoo! Grupos está sujeito aos: http://br.yahoo.com/info/utos.html
