OraFAQ Forum: Server Utilities » beginner..how to back up my database

Home » RDBMS Server » Server Utilities » beginner..how to back up my database

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

beginner..how to back up my database [message #70681]

Sat, 13 July 2002 17:09

ismi
Messages: 1
Registered: July 2002

Junior Member

I'm beginner. Can anyone help me how to back up my database.I'm using Oracle 8i.
Please help me.

Report message to a moderator

Re: beginner..how to back up my database [message #70696 is a reply to message #70681]

Mon, 15 July 2002 11:36

christopher
Messages: 25
Registered: September 2000

Junior Member

--For a cold backup
--Need to know which files to backup:
Select name from v$datafile;
Select name from v$controlfile;
Select member from v$logfile;

Shutdown immediate;
go to OS and copy the files
Startup;

and you are done.

Report message to a moderator

Re: beginner..how to back up my database [message #70720 is a reply to message #70681]

Wed, 17 July 2002 08:02

André ALIMBA
Messages: 16
Registered: April 2002

Junior Member

Oracle 8i Documentation :

doc/server.817/a76993/backupst.htm#431746
doc/server.817/a76993/osbackup.htm

Andr� ALIMBA
Chef de Projet BEAC

Report message to a moderator

Re: beginner..how to back up my database [message #70770 is a reply to message #70681]

Mon, 22 July 2002 03:14

sunil bhola
Messages: 58
Registered: July 2002

Member

There are methods to back up the database

1)HOT BACKUP
if you are using archive mode (hot backup)than

c:>svrmgrl
svrmgrl>connect sys/sys as sysdba
svrmgrl>alter tablespace <<tname>> begin backup;
svrmgrl>host
use os copy command to copy the datafiles that belongs to that tablespace
c:>copy c:oracleoradatasunilsunilwork.dbf d:backup

c:>exit
svrmgrl>alter tablespace <<tname>> end backup;

repeat these steps to copy all the tablespace of db

then
copy controlfile, archive log by using just os copy command.

2) COLD BACKUP

shutdown the database
backup datafiles, control file, redo log, using os command

Report message to a moderator

Re: beginner..how to back up my database [message #71094 is a reply to message #70770]

Sat, 07 September 2002 21:42

dipin ojha
Messages: 6
Registered: September 2002

Junior Member

fine, that you have taken a hot back up.
you got .dbf files in your back.
suddenly the database is crashed and you need to put that .dbf file into another database, what would you do now?

Report message to a moderator

Previous Topic:	Database crashed
Next Topic:	Full Database Export

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 08 16:26:44 CST 2025