Re: How to delete Tablespace when datafile is missing ?
From: Peng Hu <hup_at_nms.otc.com.au>
Date: 1995/04/18
Message-ID: <3mv3os$d8o_at_deagol.pad.otc.com.au>#1/1
| International Network Systems | Mid Range Group |
| Telstra OTC Australia | IBM Australia |
| 363 Oxford Street | PO Box 400 |
| Paddington, NSW 2012 | Pennant Hills, NSW 2120 |
| Australia | Australia |
| Tel: +61-2-3393886 | Tel: +61-2-3547749 |
| Fax: +61-2-3393985 | Fax: +61-2-3547766 |
Date: 1995/04/18
Message-ID: <3mv3os$d8o_at_deagol.pad.otc.com.au>#1/1
cracraft_at_rice-chex.ai.mit.edu (Stuart Cracraft) writes:
>Restore the datafile from backup tape. Then proceed normally. >I wouldn't recommend any "hackish" solutions to this one. >This is what your backups are meant to help avoid!
Oracle v6 hackish solusions will be less used since starting from Oracle7, the RDBMS allows you to recover a damaged or missing datafile without terminating the operations in order to restore database from the backup even if it is available.
This new feature should really be remembered by DBAs The syntax to recover a missing datafile is:
ALTER DATABASE CREATE DATAFILE 'file1' AS 'file2';
where, file1 - old datafile
file2 - new datafile
Once the datafile is recovered, the tablespace can then be dropped. Everything is nicely done ON-LINE.
Regards.
Peng Hu
Database Consultant
| International Network Systems | Mid Range Group |
| Telstra OTC Australia | IBM Australia |
| 363 Oxford Street | PO Box 400 |
| Paddington, NSW 2012 | Pennant Hills, NSW 2120 |
| Australia | Australia |
| Tel: +61-2-3393886 | Tel: +61-2-3547749 |
| Fax: +61-2-3393985 | Fax: +61-2-3547766 |
|-------------------------------------------------------------------------|Received on Tue Apr 18 1995 - 00:00:00 CEST
| Email: Peng.Hu_at_pad.otc.com.au |
| Pager: 016 020 quoting 267 675 |
-------------------------------------------------------------------------