Y de ahí ya no pude abrir la base de datos, hasta que hice los pasos que hago abajo :(
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of alter db command at 05/31/2012 20:40:47 ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00600: internal error code, arguments: [2898], [6], [12], [], [], [], [], [], [], [], [], [] Process ID: 17480 Session ID: 443 Serial number: 3
Aquí no voy a entrar a detalle de como sucedió el error, si no mas bien como lo puedes solucionar si se te llega a presentar.
RMAN-06246: List of Database Incarnations RMAN-06247: DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time RMAN-06248: ------- ------- -------- ---------------- --- ---------- ---------- RMAN-06249: 1 1 TESTDB 3889289065 PARENT 12296983831137 16-APR-2012 23:58:59 RMAN-06249: 2 2 TESTDB 3889289065 PARENT 12462184333086 09-MAY-2012 22:50:31 RMAN-06249: 3 3 TESTDB 3889289065 ORPHAN 12462184341387 10-MAY-2012 20:16:41 RMAN-06249: 5 5 TESTDB 3889289065 PARENT 12462184341387 11-MAY-2012 02:57:04 RMAN-06249: 4 4 TESTDB 3889289065 ORPHAN 12462184344923 10-MAY-2012 22:11:55 RMAN-06249: 6 6 TESTDB 3889289065 CURRENT 12462187527879 28-MAY-2012 22:20:17 RMAN-08066: database reset to incarnation 5 RMAN-06246: List of Database Incarnations RMAN-06247: DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time RMAN-06248: ------- ------- -------- ---------------- --- ---------- ---------- RMAN-06249: 1 1 TESTDB 3889289065 PARENT 12296983831137 16-APR-2012 23:58:59 RMAN-06249: 2 2 TESTDB 3889289065 PARENT 12462184333086 09-MAY-2012 22:50:31 RMAN-06249: 3 3 TESTDB 3889289065 ORPHAN 12462184341387 10-MAY-2012 20:16:41 RMAN-06249: 5 5 TESTDB 3889289065 CURRENT 12462184341387 11-MAY-2012 02:57:04 RMAN-06249: 4 4 TESTDB 3889289065 ORPHAN 12462184344923 10-MAY-2012 22:11:55 RMAN-06249: 6 6 TESTDB 3889289065 ORPHAN 12462187527879 28-MAY-2012 22:20:17
No se te olvide antes de iniciar con RMAN tener la variable de ambiente de UNIX NLS_DATE_FORMAT puesta,
export NLS_DATE_FORMAT='DD-MON-YYYY HH24:MI:SS'
De igual manera, te va a servir esta variable
export ORA_RMAN_SGA_TARGET=1000
- Restaurara el archivo de parametros del respaldo.
- Reiniciar la Base de datos después de restaurar el archive de parametros para que tomara el spfile que acabo de restablecer.
- Cambiar el parámetro cluster_database a FALSE (Solamente RAC)
- Restaurar el controlfile del respaldo
- Reiniciar la base de datos para que el parámetro de cluster_database se tome en cuenta, ya que no es un parametro dinamico.
- Cambiar a la Quinta encarnación de la Base de Datos, ya que ahi es donde es a donde quiero llegar
- Restaurar la Base de Datos al punto en el tiempo que quiero llegar
Recovery Manager: Release 11.2.0.3.0 - Production on Sat Jun 2 20:43:25 2012 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. RMAN-06193: connected to target database (not started) RMAN> run 2> { 3> set dbid 3889289065; 4> startup nomount ; 5> restore spfile from '/mount/copy01/TESTDB/oracle/TESTDB/control/c-3889289065-20120528-02'; 6> shutdown immediate; 7> startup nomount ; 8> sql "alter system set cluster_database = FALSE scope = spfile"; 9> restore controlfile from '/mount/copy01/TESTDB/oracle/TESTDB/control/c-3889289065-20120528-02'; 10> alter database mount; 11> shutdown immediate; 12> startup mount; 13> } 14> 15> list incarnation; 16> reset database to incarnation 5; 17> list incarnation; 18> list backup summary; 19> crosscheck backup device type disk; 20> 21> 22> RUN 23> { 24> sql "alter session set max_dump_file_size=''UNLIMITED''"; 25> sql "alter session set events ''10046 trace name context forever, level 12''"; 26> set until time "to_date('28-MAY-2012 20:46:43','dd-MON-yyyy hh24:mi:ss')"; 27> ALLOCATE CHANNEL CH1 DEVICE TYPE DISK ; 28> ALLOCATE CHANNEL CH2 DEVICE TYPE DISK ; 29> ALLOCATE CHANNEL CH3 DEVICE TYPE DISK ; 30> ALLOCATE CHANNEL CH4 DEVICE TYPE DISK ; 31> ALLOCATE CHANNEL CH5 DEVICE TYPE DISK ; 32> RESTORE DATABASE; 33> } 34> RMAN-03023: executing command: SET DBID RMAN-04014: startup failed: ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+GBS_HRMS_DATA/TESTDB/PARAMETERFILE/spfileTESTDB.ora' ORA-17503: ksfdopn:2 Failed to open file +GBS_HRMS_DATA/TESTDB/PARAMETERFILE/spfileTESTDB.ora ORA-15056: additional error message ORA-17503: ksfdopn:2 Failed to open file +GBS_HRMS_DATA/TESTDB/parameterfile/spfileTESTDB.ora ORA-15173: entry 'spfileTESTDB.ora' does not exist in directory 'parameterfile' ORA-06512: at line 4 RMAN-04024: starting Oracle instance without parameter file for retrieval of spfile RMAN-06196: Oracle instance started Total System Global Area 1043886080 bytes Fixed Size 2234960 bytes Variable Size 452986288 bytes Database Buffers 566231040 bytes Redo Buffers 22433792 bytes RMAN-03090: Starting restore at 02-JUN-2012 20:43:44 RMAN-06009: using target database control file instead of recovery catalog RMAN-08030: allocated channel: ORA_DISK_1 RMAN-08500: channel ORA_DISK_1: SID=1861 device type=DISK RMAN-08554: channel ORA_DISK_1: restoring spfile from AUTOBACKUP /mount/copy01/TESTDB/oracle/TESTDB/control/c-3889289065-20120528-02 RMAN-08541: channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete RMAN-03091: Finished restore at 02-JUN-2012 20:43:47 RMAN-06402: Oracle instance shut down RMAN-06193: connected to target database (not started) RMAN-06196: Oracle instance started Total System Global Area 2622255104 bytes Fixed Size 2231232 bytes Variable Size 1409287232 bytes Database Buffers 1174405120 bytes Redo Buffers 36331520 bytes RMAN-06162: sql statement: alter system set cluster_database = FALSE scope = spfile RMAN-03090: Starting restore at 02-JUN-2012 20:44:14 RMAN-08030: allocated channel: ORA_DISK_1 RMAN-08605: channel ORA_DISK_1: SID=521 instance=TESTDB1 device type=DISK RMAN-08021: channel ORA_DISK_1: restoring control file RMAN-08180: channel ORA_DISK_1: restore complete, elapsed time: 00:00:03 RMAN-08505: output file name=+GBS_HRMS_DATA/TESTDB/controlfile/control01.ctl RMAN-08505: output file name=+GBS_HRMS_DATA/TESTDB/controlfile/control02.ctl RMAN-03091: Finished restore at 02-JUN-2012 20:44:17 RMAN-06199: database mounted RMAN-08031: released channel: ORA_DISK_1 RMAN-06404: database dismounted RMAN-06402: Oracle instance shut down RMAN-06193: connected to target database (not started) RMAN-06196: Oracle instance started RMAN-06199: database mounted Total System Global Area 2622255104 bytes Fixed Size 2231232 bytes Variable Size 1409287232 bytes Database Buffers 1174405120 bytes Redo Buffers 36331520 bytes RMAN-06246: List of Database Incarnations RMAN-06247: DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time RMAN-06248: ------- ------- -------- ---------------- --- ---------- ---------- RMAN-06249: 1 1 TESTDB 3889289065 PARENT 12296983831137 16-APR-2012 23:58:59 RMAN-06249: 2 2 TESTDB 3889289065 PARENT 12462184333086 09-MAY-2012 22:50:31 RMAN-06249: 3 3 TESTDB 3889289065 ORPHAN 12462184341387 10-MAY-2012 20:16:41 RMAN-06249: 5 5 TESTDB 3889289065 PARENT 12462184341387 11-MAY-2012 02:57:04 RMAN-06249: 4 4 TESTDB 3889289065 ORPHAN 12462184344923 10-MAY-2012 22:11:55 RMAN-06249: 6 6 TESTDB 3889289065 CURRENT 12462187527879 28-MAY-2012 22:20:17 RMAN-08066: database reset to incarnation 5 RMAN-06246: List of Database Incarnations RMAN-06247: DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time RMAN-06248: ------- ------- -------- ---------------- --- ---------- ---------- RMAN-06249: 1 1 TESTDB 3889289065 PARENT 12296983831137 16-APR-2012 23:58:59 RMAN-06249: 2 2 TESTDB 3889289065 PARENT 12462184333086 09-MAY-2012 22:50:31 RMAN-06249: 3 3 TESTDB 3889289065 ORPHAN 12462184341387 10-MAY-2012 20:16:41 RMAN-06249: 5 5 TESTDB 3889289065 CURRENT 12462184341387 11-MAY-2012 02:57:04 RMAN-06249: 4 4 TESTDB 3889289065 ORPHAN 12462184344923 10-MAY-2012 22:11:55 RMAN-06249: 6 6 TESTDB 3889289065 ORPHAN 12462187527879 28-MAY-2012 22:20:17 RMAN-03090: Starting implicit crosscheck backup at 02-JUN-2012 20:45:05 RMAN-08030: allocated channel: ORA_DISK_1 RMAN-08500: channel ORA_DISK_1: SID=456 device type=DISK RMAN-08030: allocated channel: ORA_DISK_2 RMAN-08500: channel ORA_DISK_2: SID=469 device type=DISK RMAN-06206: Crosschecked 25 objects RMAN-03091: Finished implicit crosscheck backup at 02-JUN-2012 20:45:13 RMAN-03090: Starting implicit crosscheck copy at 02-JUN-2012 20:45:13 RMAN-12016: using channel ORA_DISK_1 RMAN-12016: using channel ORA_DISK_2 RMAN-03091: Finished implicit crosscheck copy at 02-JUN-2012 20:45:14 RMAN-07501: searching for all files in the recovery area RMAN-07507: cataloging files... RMAN-07512: no files cataloged RMAN-08031: released channel: ORA_DISK_1 RMAN-08031: released channel: ORA_DISK_2 RMAN-08030: allocated channel: CH1 RMAN-08500: channel CH1: SID=456 device type=DISK RMAN-08030: allocated channel: CH2 RMAN-08500: channel CH2: SID=469 device type=DISK RMAN-08030: allocated channel: CH3 RMAN-08500: channel CH3: SID=482 device type=DISK RMAN-08030: allocated channel: CH4 RMAN-08500: channel CH4: SID=495 device type=DISK RMAN-08030: allocated channel: CH5 RMAN-08500: channel CH5: SID=508 device type=DISK RMAN-03090: Starting restore at 02-JUN-2012 20:45:26 RMAN-08016: channel CH1: starting datafile backup set restore . . . RMAN-08180: channel CH3: restore complete, elapsed time: 00:03:45 RMAN-03091: Finished restore at 03-JUN-2012 20:53:01 RMAN-08031: released channel: CH1 RMAN-08031: released channel: CH2 RMAN-08031: released channel: CH3 RMAN-08031: released channel: CH4 RMAN-08031: released channel: CH5 Recovery Manager complete.
Ya cuando haya finalizado la restauración de los datafiles, lo que tenemos que hacer es recrear el control file tomando un respaldo hacia un archivo plano. Aquí es una parte muy delicada que yo te recomendaría hacer un listado de tus respaldos en RMAN (list backup) y guardar un log, ya que al recrear el controlfile, vas a perder esta información si es que estas usando tu controlfile para respaldos.
oracle@servidor1.oracleenespanol.blogspot.com [TESTDB1] /mount/dba01/oracle/TESTDB/scripts oracle $ sqlplus SQL*Plus: Release 11.2.0.3.0 Production on Sat Jun 2 21:03:24 2012 Copyright (c) 1982, 2011, Oracle. All rights reserved. Enter user-name: /as sysdba Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options TESTDB1 >ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS '/mount/dba01/oracle/TESTDB/scripts/control_TESTDB.sql' RESETLOGS; Database altered. TESTDB1 >shutdown immediate ORA-01109: database not open Database dismounted. ORACLE instance shut down.
Yo lo que hago en lugar de borrar el controlfile actual lo renombro ,si no estas usando ASM, seria con el comando mv, si estas usando ASM seria de la siguiente manera con el usuario grid y entrando a la instancia de ASM
ALTER DISKGROUP GBS_HRMS_DATA RENAME ALIAS '+GBS_HRMS_DATA/DBATEST/CONTROLFILE/control02.ctl' TO '+GBS_HRMS_DATA/DBATEST/CONTROLFILE/control02.ctl.old';
Una vez que moviste los controlfiles , modifica el archivo plano del conrolfile que creamos arriba, y corre el script en sqlplus
oracle@servidor1.oracleenespanol.blogspot.com [TESTDB1] /mount/dba01/oracle/TESTDB/scripts oracle $ sqlplus SQL*Plus: Release 11.2.0.3.0 Production on Sat Jun 2 21:06:39 2012 Copyright (c) 1982, 2011, Oracle. All rights reserved. Enter user-name: /as sysdba Connected to an idle instance. TESTDB1 >@control_TESTDB.sql ORACLE instance started. Total System Global Area 2622255104 bytes Fixed Size 2231232 bytes Variable Size 1409287232 bytes Database Buffers 1174405120 bytes Redo Buffers 36331520 bytes Control file created. TESTDB1 >exit
oracle@servidor1.oracleenespanol.blogspot.com [TESTDB1] /mount/dba01/oracle/TESTDB/scripts oracle $ rman target / Recovery Manager: Release 11.2.0.3.0 - Production on Sat Jun 2 21:13:10 2012 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: TESTDB (DBID=3889289065, not open) RMAN> catalog start with '/mount/copy01/TESTDB/oracle/TESTDB' noprompt; using target database control file instead of recovery catalog searching for all files that match the pattern /mount/copy01/TESTDB/oracle/TESTDB List of Files Unknown to the Database ===================================== File Name: /mount/copy01/TESTDB/oracle/TESTDB/arch/TESTDB_ARCH_05282012_1_64_784500419 File Name: /mount/copy01/TESTDB/oracle/TESTDB/arch/TESTDB_ARCH_05282012_1_65_784500419 File Name: /mount/copy01/TESTDB/oracle/TESTDB/arch/TESTDB_ARCH_05282012_1_66_784500419 File Name: /mount/copy01/TESTDB/oracle/TESTDB/arch/TESTDB_ARCH_05282012_1_67_784500419 File Name: /mount/copy01/TESTDB/oracle/TESTDB/arch/TESTDB_ARCH_05282012_1_68_784500420 File Name: /mount/copy01/TESTDB/oracle/TESTDB/arch/TESTDB_ARCH_05282012_1_69_784500421 File Name: /mount/copy01/TESTDB/oracle/TESTDB/arch/TESTDB_ARCH_05282012_1_70_784500437 File Name: /mount/copy01/TESTDB/oracle/TESTDB/arch/TESTDB_ARCH_05282012_1_71_784500437 File Name: /mount/copy01/TESTDB/oracle/TESTDB/arch/TESTDB_ARCH_05282012_1_72_784500494 File Name: /mount/copy01/TESTDB/oracle/TESTDB/arch/TESTDB_ARCH_05282012_1_73_784500510 File Name: /mount/copy01/TESTDB/oracle/TESTDB/control/TESTDB_05_28_2012_784500375.ctl File Name: /mount/copy01/TESTDB/oracle/TESTDB/control/c-3889289065-20120528-00 File Name: /mount/copy01/TESTDB/oracle/TESTDB/control/c-3889289065-20120528-01 File Name: /mount/copy01/TESTDB/oracle/TESTDB/control/c-3889289065-20120510-04 File Name: /mount/copy01/TESTDB/oracle/TESTDB/control/c-3889289065-20120510-00 File Name: /mount/copy01/TESTDB/oracle/TESTDB/control/c-3889289065-20120511-00 File Name: /mount/copy01/TESTDB/oracle/TESTDB/control/c-3889289065-20120528-02 File Name: /mount/copy01/TESTDB/oracle/TESTDB/control/c-3889289065-20120531-00 File Name: /mount/copy01/TESTDB/oracle/TESTDB/incr/TESTDB_HOT_05282012_1_52_784500223 File Name: /mount/copy01/TESTDB/oracle/TESTDB/incr/TESTDB_HOT_05282012_1_53_784500224 File Name: /mount/copy01/TESTDB/oracle/TESTDB/incr/TESTDB_HOT_05282012_1_54_784500224 File Name: /mount/copy01/TESTDB/oracle/TESTDB/incr/TESTDB_HOT_05282012_1_55_784500225 File Name: /mount/copy01/TESTDB/oracle/TESTDB/incr/TESTDB_HOT_05282012_1_56_784500226 File Name: /mount/copy01/TESTDB/oracle/TESTDB/incr/TESTDB_HOT_05282012_1_57_784500226 File Name: /mount/copy01/TESTDB/oracle/TESTDB/incr/TESTDB_HOT_05282012_1_58_784500228 File Name: /mount/copy01/TESTDB/oracle/TESTDB/incr/TESTDB_HOT_05282012_1_59_784500230 File Name: /mount/copy01/TESTDB/oracle/TESTDB/incr/TESTDB_HOT_05282012_1_60_784500231 File Name: /mount/copy01/TESTDB/oracle/TESTDB/incr/TESTDB_HOT_05282012_1_61_784500232 cataloging files... cataloging done List of Cataloged Files ======================= File Name: /mount/copy01/TESTDB/oracle/TESTDB/arch/TESTDB_ARCH_05282012_1_64_784500419 File Name: /mount/copy01/TESTDB/oracle/TESTDB/arch/TESTDB_ARCH_05282012_1_65_784500419 File Name: /mount/copy01/TESTDB/oracle/TESTDB/arch/TESTDB_ARCH_05282012_1_66_784500419 File Name: /mount/copy01/TESTDB/oracle/TESTDB/arch/TESTDB_ARCH_05282012_1_67_784500419 File Name: /mount/copy01/TESTDB/oracle/TESTDB/arch/TESTDB_ARCH_05282012_1_68_784500420 File Name: /mount/copy01/TESTDB/oracle/TESTDB/arch/TESTDB_ARCH_05282012_1_69_784500421 File Name: /mount/copy01/TESTDB/oracle/TESTDB/arch/TESTDB_ARCH_05282012_1_70_784500437 File Name: /mount/copy01/TESTDB/oracle/TESTDB/arch/TESTDB_ARCH_05282012_1_71_784500437 File Name: /mount/copy01/TESTDB/oracle/TESTDB/arch/TESTDB_ARCH_05282012_1_72_784500494 File Name: /mount/copy01/TESTDB/oracle/TESTDB/arch/TESTDB_ARCH_05282012_1_73_784500510 File Name: /mount/copy01/TESTDB/oracle/TESTDB/control/TESTDB_05_28_2012_784500375.ctl File Name: /mount/copy01/TESTDB/oracle/TESTDB/control/c-3889289065-20120528-00 File Name: /mount/copy01/TESTDB/oracle/TESTDB/control/c-3889289065-20120528-01 File Name: /mount/copy01/TESTDB/oracle/TESTDB/control/c-3889289065-20120510-04 File Name: /mount/copy01/TESTDB/oracle/TESTDB/control/c-3889289065-20120510-00 File Name: /mount/copy01/TESTDB/oracle/TESTDB/control/c-3889289065-20120511-00 File Name: /mount/copy01/TESTDB/oracle/TESTDB/control/c-3889289065-20120528-02 File Name: /mount/copy01/TESTDB/oracle/TESTDB/control/c-3889289065-20120531-00 File Name: /mount/copy01/TESTDB/oracle/TESTDB/incr/TESTDB_HOT_05282012_1_52_784500223 File Name: /mount/copy01/TESTDB/oracle/TESTDB/incr/TESTDB_HOT_05282012_1_53_784500224 File Name: /mount/copy01/TESTDB/oracle/TESTDB/incr/TESTDB_HOT_05282012_1_54_784500224 File Name: /mount/copy01/TESTDB/oracle/TESTDB/incr/TESTDB_HOT_05282012_1_55_784500225 File Name: /mount/copy01/TESTDB/oracle/TESTDB/incr/TESTDB_HOT_05282012_1_56_784500226 File Name: /mount/copy01/TESTDB/oracle/TESTDB/incr/TESTDB_HOT_05282012_1_57_784500226 File Name: /mount/copy01/TESTDB/oracle/TESTDB/incr/TESTDB_HOT_05282012_1_58_784500228 File Name: /mount/copy01/TESTDB/oracle/TESTDB/incr/TESTDB_HOT_05282012_1_59_784500230 File Name: /mount/copy01/TESTDB/oracle/TESTDB/incr/TESTDB_HOT_05282012_1_60_784500231 File Name: /mount/copy01/TESTDB/oracle/TESTDB/incr/TESTDB_HOT_05282012_1_61_784500232
Y por ultimo, lo que tenemos que hacer es recuperar la base de datos al mismo punto en tiempo que restauramos los datafiles y como ves marcado en rojo abajo, pudimos abrir la base de datos y regresamos a un estado de paz y tranquilidad :)
RMAN> RUN 2> { 3> set until time "to_date('28-MAY-2012 20:46:43','dd-MON-yyyy hh24:mi:ss')"; 4> ALLOCATE CHANNEL CH1 DEVICE TYPE DISK ; 5> ALLOCATE CHANNEL CH2 DEVICE TYPE DISK ; 6> ALLOCATE CHANNEL CH3 DEVICE TYPE DISK ; 7> ALLOCATE CHANNEL CH4 DEVICE TYPE DISK ; 8> ALLOCATE CHANNEL CH5 DEVICE TYPE DISK ; 9> RECOVER DATABASE; 10> ALTER DATABASE OPEN RESETLOGS; 11> } archived log file name=+GBS_HRMS_DATA/TESTDB/archivelog/1_32_782967424.dbf thread=1 sequence=0 archived log file name=+GBS_HRMS_DATA/TESTDB/archivelog/2_16_782967424.dbf thread=2 sequence=16 archived log file name=+GBS_HRMS_DATA/TESTDB/archivelog/1_33_782967424.dbf thread=1 sequence=33 media recovery complete, elapsed time Finished recover at 02-JUN-2012 21:18:49 database opened released channel released channel released channel released channel released channel Recovery Manager complete.
No hay comentarios.:
Publicar un comentario