RE: recovery database!!
Hi, If you have all datafiles (system at least) you can use them to make a clone using the create controlfile command. I suggest you look up the documentation on cloning databases. example: we clone w/o the temporary tablespace (very big in production not needed in test) * export ORACLE_SID=PT21 svrmgrl EOF connect internal shutdown immediate exit EOF rm /oracle/app/oracle/product/8.0.5/database/oradata/PT21/control01.ctl svrmgrl EOF connect internal startup nomount CREATE CONTROLFILE SET DATABASE PT21 RESETLOGS NOARCHIVELOG MAXLOGFILES 32 MAXLOGMEMBERS 5 MAXDATAFILES 220 MAXINSTANCES 8 MAXLOGHISTORY 800 LOGFILE '/data/PT21/redoPT2101.log' size 5M, '/data/PT21/redoPT2102.log' size 5M, '/data/PT21/redoPT2103.log' size 5M DATAFILE '/data/PT21/dataPT2101.dbf', '/data/PT21/dataPT2102.dbf', '/data/PT21/dataPT2103.dbf', '/data/PT21/dataPT2104.dbf', '/data/PT21/dataPT2105.dbf', '/data/PT21/dataPT2106.dbf', '/data/PT21/dataPT2107.dbf', '/data/PT21/dataPT2108.dbf', '/data/PT21/dataPT2109.dbf', '/data/PT21/dataPT2110.dbf', '/data/PT21/dataPT2111.dbf', '/data/PT21/dataPT2112.dbf', '/data/PT21/dataPT2113.dbf', '/data/PT21/dataPT2114.dbf', '/data/PT21/dataPT2115.dbf', '/data/PT21/dataPT2116.dbf', '/data/PT21/indexPT2101.dbf', '/data/PT21/indexPT2102.dbf', '/data/PT21/indexPT2103.dbf', '/data/PT21/rbsPT2101.dbf', '/data/PT21/rbsPT2102.dbf', '/data/PT21/rbsPT212.dbf', '/data/PT21/rbsPT2122.dbf', '/data/PT21/rbsPT2123.dbf', '/data/PT21/system01.dbf', '/data/PT21/toolsPT2101.dbf', '/data/PT21/userPT2101.dbf' ; alter database PT21 open resetlogs; drop tablespace temp2 including contents; drop tablespace temporary_ts including contents; create tablespace temporary_ts datafile '/data/PT21/tempPT2101.dbf' size 1000M reuse temporary; alter tablespace temporary_ts add datafile '/data/PT21/tempPT2102.dbf' size 1000M reuse; alter tablespace temporary_ts default storage (initial 1M next 1M pctincrease 0); alter user cabs temporary tablespace temporary_ts; alter database rename global_name to PT21; exit EOF ** Jack Alexander Ordonez [EMAIL PROTECTED]@fatcity.com on 30-10-2001 17:35:19 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) ok i need know is possible recover the database with only the datafile. If only have a datafiles the any database i can recreate a new db and use this datafiles... @lex Lic. Alexander Ordóñez Arroyo Caja Costarricense del Seguro Social Soporte Técnico - División de Informática Telefono: 295-2004, San José, Costa Rica [EMAIL PROTECTED]Icq# 30173325 The true is out there in WWW -Mensaje original- De: Richard Ji [SMTP:[EMAIL PROTECTED]] Enviado el:Martes 30 de Octubre de 2001 09:57 AM Para: Multiple recipients of list ORACLE-L Asunto: Re: recovery database!! Hmmm, sorry but I will have to say depends on the situation. Can you be a little more specific? Otherwise I would recommend the Oracle Backup and Recovery Handbook. Richard [EMAIL PROTECTED] 10/30/01 10:30AM Hi gurus, question?? I can recovery any database with only datafiles??? @lex Lic. Alexander Ordóñez Arroyo Caja Costarricense del Seguro Social Soporte Técnico - División de Informática Telefono: 295-2004, San José, Costa Rica [EMAIL PROTECTED]Icq# 30173325 The true is out there in WWW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexander Ordonez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling
Re: recovery database!!
Hmmm, sorry but I will have to say depends on the situation. Can you be a little more specific? Otherwise I would recommend the Oracle Backup and Recovery Handbook. Richard [EMAIL PROTECTED] 10/30/01 10:30AM Hi gurus, question?? I can recovery any database with only datafiles??? @lex Lic. Alexander Ordóñez Arroyo Caja Costarricense del Seguro Social Soporte Técnico - División de Informática Telefono: 295-2004, San José, Costa Rica [EMAIL PROTECTED]Icq# 30173325 The true is out there in WWW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexander Ordonez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: recovery database!!
ok i need know is possible recover the database with only the datafile. If only have a datafiles the any database i can recreate a new db and use this datafiles... @lex Lic. Alexander Ordóñez Arroyo Caja Costarricense del Seguro Social Soporte Técnico - División de Informática Telefono: 295-2004, San José, Costa Rica [EMAIL PROTECTED]Icq# 30173325 The true is out there in WWW -Mensaje original- De: Richard Ji [SMTP:[EMAIL PROTECTED]] Enviado el: Martes 30 de Octubre de 2001 09:57 AM Para: Multiple recipients of list ORACLE-L Asunto: Re: recovery database!! Hmmm, sorry but I will have to say depends on the situation. Can you be a little more specific? Otherwise I would recommend the Oracle Backup and Recovery Handbook. Richard [EMAIL PROTECTED] 10/30/01 10:30AM Hi gurus, question?? I can recovery any database with only datafiles??? @lex Lic. Alexander Ordóñez Arroyo Caja Costarricense del Seguro Social Soporte Técnico - División de Informática Telefono: 295-2004, San José, Costa Rica [EMAIL PROTECTED]Icq# 30173325 The true is out there in WWW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexander Ordonez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexander Ordonez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).