OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » backup off-line

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

backup off-line [message #154481]

Sun, 08 January 2006 22:44

quytc
Messages: 81
Registered: November 2005
Location: Viet Nam

Member

I want backup my database offline by this way.

I copies Control, relo log, datafile file to a directory. When I need backup database, I will copies files from directory to database'location. Then I run command "recover database".

I don't known what is bdump,cdump, Do I copies two files to a directory?
Can anybody help me?

Report message to a moderator

Re: backup off-line [message #154509 is a reply to message #154481]

Mon, 09 January 2006 03:23

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

You don't need to backup your BDUMP, UDUMP, CDUMP, etc directories. However, also include things like the parameter file (INIT.ORA), password file, etc.

This might help: http://www.orafaq.com/faq/user_managed_backups

Report message to a moderator

Re: backup off-line [message #154516 is a reply to message #154509]

Mon, 09 January 2006 03:59

quytc
Messages: 81
Registered: November 2005
Location: Viet Nam

Member

I have a database.
1. My database is TEST
2. I backup offline TEST at Monday
3. I recover my database at Monday and my database is fail at friday and.
4. after Recovering. My database includes infomation which is into database before Monday. therefore I have lost data form Monday to Friday.
5. Can you tell me to get back datas which is into Database from Monday to Friday

Report message to a moderator

Previous Topic:	Oracle error 19502
Next Topic:	RMAN 8i (space used)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 03:51:25 CST 2024