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