OraFAQ Forum: Backup & Recovery » Backup & Recovery Question

Home » RDBMS Server » Backup & Recovery » Backup & Recovery Question

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Backup & Recovery Question [message #62043]

Mon, 21 June 2004 22:20

IA
Messages: 91
Registered: March 2004

Member

Hi Everyone,

�

I am running an Oracle 9i database on Sun 2.9.

I am running in ArchiveLog Mode.

I backup my controlfile to trace, my archive logs and database files.

�

IF, I lost my UNDO tablespace datafiles, is there any way I am able to recover my database to a consistent state?

�

Thanks ... IA

Report message to a moderator

Re: Backup & Recovery Question [message #62048 is a reply to message #62043]

Tue, 22 June 2004 03:41

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

backup controlfile to trace, generates only a ddl of create database which is used if you want to recreate the database somewhere else.
IT IS NOT A BACKUP for entire database.
did u backup ur database with RMAN or any other utilities?

Report message to a moderator

Re: Backup & Recovery Question [message #62055 is a reply to message #62048]

Tue, 22 June 2004 18:13

IA
Messages: 91
Registered: March 2004

Member

Hi Mahesh,

I am not using rman.

Thanks.

Report message to a moderator

Previous Topic:	Not able to connect RMAN
Next Topic:	Hot Backup issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 19:56:09 CST 2024