Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Corrupted dbf file... help!!

Re: Corrupted dbf file... help!!

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 11 Sep 2007 21:38:52 +0200
Message-ID: <fc6qs9$lcr$1@news5.zwoll1.ov.home.nl>


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Kaka wrote:

> controlfile' (when it asked for archive log, it put in the current
> redo log on it.); afterward i just did a 'alter database resetlogs
> open;'
>
> whew, that was scary... but i made it.
>

No - you not done.
You did an alter database open resetlogs - a sure sign to do a shutdown normal, and make a full backup.

It takes just a few keystrokes:
rman target /
shutdown;
startup mount;
backup database;
alter database open;

Configuring RMAN for control file automatic backups would be a good idea. ;)
- --
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFG5u7MLw8L4IAs830RAqPUAKCW6MkP7VQM4drpjIeC5YL1RyXaYQCZAZLi FYYB1akKkTPCehc3tbRApq0=
=Bgy4
-----END PGP SIGNATURE----- Received on Tue Sep 11 2007 - 14:38:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US