OraFAQ Forum: Backup & Recovery » how to backup database

Home » RDBMS Server » Backup & Recovery » how to backup database

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

how to backup database [message #188579]

Sun, 20 August 2006 01:38

farahat
Messages: 14
Registered: August 2006
Location: sudan

Junior Member

i would like to answer my qu. how to make a backup file
in oracle

Report message to a moderator

Re: how to backup database [message #188584 is a reply to message #188579]

Sun, 20 August 2006 04:09

chinni_00
Messages: 30
Registered: October 2005

Member

Hi

For just taking a backup of the database you can use the Export Command and store the data in any of the Drive or Tape and import them when u need

you can also use the RMAN Option in Oracle if Version is Greater than 8i

You can use the NTBackup or some third Party Softwares for Taking the Backups

If you want to know more you can also search out in this Site where you can get more informations related to this

Thanks & Regards
Prem

Report message to a moderator

Re: how to backup database [message #188636 is a reply to message #188584]

Mon, 21 August 2006 02:01

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

http://orafaq.com/faq/backup_recovery

Report message to a moderator

Re: how to backup database [message #188909 is a reply to message #188579]

Tue, 22 August 2006 06:21

dinu_dba
Messages: 8
Registered: August 2006
Location: Hyderabad

Junior Member

hi shutdown the database take cold backup i mean copy all datafiles, controlfiles,redo files, parameter files to other disk..thats how u have to take backup
if u cant shutdown ur database take hotbackup
by begin backup mode then copy datafiles then end the backup mode..

Report message to a moderator

Re: how to backup database [message #189093 is a reply to message #188579]

Wed, 23 August 2006 03:21

youthsen
Messages: 45
Registered: August 2006

Member

hi dinu_dba

how to find which fiels are datafiles, and which files are control files, and which files are redo files, and which files are parameter files.

i am expecting your reply.

thanks a lot in advance.

Report message to a moderator

Re: how to backup database [message #189124 is a reply to message #189093]

Wed, 23 August 2006 05:04

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

@Youthsen

These are real fundamental questions.
Pls. refer the books/documentation to get the answer of your questions. Everything is explained there....

Or google whatever you want and you will find it easily.

Report message to a moderator

Re: how to backup database [message #189633 is a reply to message #189124]

Fri, 25 August 2006 05:51

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

BACKUP

 A copy of valid, current & existing data is called Backup.
 Before taking backup you must Make sure that you are taking backup of correct DB

 Logical backup: Object level backup is called as logical backup (By Export Utility)

 Physical backup: It is the backup of physical structure of DB that is done by cold Back or Hot Backup
o Cold backup: It will be taken after shutting down the DB
o Hot backup: It is backup, taken when DataBase is open and running

We have to take Backup of......
1. BACKUP OF INIT.ORA & SPFILE.. simply by copying at O/S level.
2. BACKUP OF PASSWORD FILE.. simply by copying at O/S Level
3. BACKUP OF CONTROL FILE.. by Multiplexing it or by Having it in text mode.
4. BACKUP OF ONLINE REDO LOG FILE by adding redo member in Redo group (No O/S backup)
5. BACKUP OF TABLE SPACE / DATA FILE (system and other datafile)
6. BACKUP OF ARCHIVED LOGFILE BACKUP by creating it at different location.

Well difficult to create over all backup here ... but whatever we have to do i had mention.

Regards
Sunilkumar

[Updated on: Fri, 25 August 2006 05:52]

Report message to a moderator

Re: how to backup database [message #190301 is a reply to message #189093]

Wed, 30 August 2006 02:17

ramkrishna_gosavi
Messages: 15
Registered: June 2006
Location: pune

Junior Member

hi u can use following cmd
log in database then sql

sql>select * from v$control_files;
sql>select * from v$datafile;
sql>select * from v$redologfile;

in this way u see the datafile controlfile, redologfile;

buy buy..........
Ramkrishna

Report message to a moderator

Re: how to backup database [message #190409 is a reply to message #188579]

Wed, 30 August 2006 10:07

youthsen
Messages: 45
Registered: August 2006

Member

hi ramkrishna_gosavi

the first two command are working but 3rd one is not working

SQL> connect system/manager;
Connected.

SQL> select * from v$datafile;

    FILE# CREATION_CHANGE# CREATION_       TS#    RFILE# STATUS  ENABLED    CHECKPOINT_CHANGE#
--------- ---------------- --------- --------- --------- ------- ---------- ------------------
CHECKPOIN UNRECOVERABLE_CHANGE# UNRECOVER LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
--------- --------------------- --------- ------------ --------- --------------- --------------
ONLINE_TI     BYTES    BLOCKS CREATE_BYTES BLOCK_SIZE
--------- --------- --------- ------------ ----------
NAME
-------------------------------------------------------------------------------------------------
        1                3 16-JUL-97         0         1 SYSTEM  READ WRITE             113887
31-AUG-06                     0                                            13456          13457
25-AUG-06  20971520     10240            0       2048
C:\ORAWIN95\DATABASE\SYS1ORCL.ORA

        2             2413 16-JUL-97         1         2 ONLINE  READ WRITE             113887
31-AUG-06                 73777 26-AUG-06                                  13456          13457
25-AUG-06   3145728      1536            0       2048
C:\ORAWIN95\DATABASE\USR1ORCL.ORA

        3             2419 16-JUL-97         2         3 ONLINE  READ WRITE             113887
31-AUG-06                     0                                            13456          13457
25-AUG-06   5242880      2560            0       2048
C:\ORAWIN95\DATABASE\RBS1ORCL.ORA


    FILE# CREATION_CHANGE# CREATION_       TS#    RFILE# STATUS  ENABLED    CHECKPOINT_CHANGE#
--------- ---------------- --------- --------- --------- ------- ---------- ------------------
CHECKPOIN UNRECOVERABLE_CHANGE# UNRECOVER LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
--------- --------------------- --------- ------------ --------- --------------- --------------
ONLINE_TI     BYTES    BLOCKS CREATE_BYTES BLOCK_SIZE
--------- --------- --------- ------------ ----------
NAME
-------------------------------------------------------------------------------------------------
        4             2425 16-JUL-97         3         4 ONLINE  READ WRITE             113887
31-AUG-06                     0                                            13456          13457
25-AUG-06   2097152      1024            0       2048
C:\ORAWIN95\DATABASE\TMP1ORCL.ORA

SQL> select * from v$controlfile;

STATUS
-------
NAME
-------------------------------------

C:\ORAWIN95\DATABASE\CTL1ORCL.ORA

so here the first two commands are worked. but the third command shows the following error messages.


SQL> select * from v$redologfile;
select * from v$redologfile
              *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> select * from v$redolog_file;
select * from v$redolog_file
              *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> select * from v$redolog_files;
select * from v$redolog_files
              *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> select * from v$redologfiles;
select * from v$redologfiles
              *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> select * from v$redofile;
select * from v$redofile
              *
ERROR at line 1:
ORA-00942: table or view does not exist

how to solve this problem

Report message to a moderator

Previous Topic:	Questions about failover
Next Topic:	how to restore the backuped files

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 30 19:39:57 CDT 2024