Home » RDBMS Server » Backup & Recovery » how to backup database
icon14.gif  how to backup database [message #188579] Sun, 20 August 2006 01:38 Go to next message
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
Re: how to backup database [message #188584 is a reply to message #188579] Sun, 20 August 2006 04:09 Go to previous messageGo to next message
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

Re: how to backup database [message #188636 is a reply to message #188584] Mon, 21 August 2006 02:01 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member



http://orafaq.com/faq/backup_recovery
Re: how to backup database [message #188909 is a reply to message #188579] Tue, 22 August 2006 06:21 Go to previous messageGo to next message
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..
Re: how to backup database [message #189093 is a reply to message #188579] Wed, 23 August 2006 03:21 Go to previous messageGo to next message
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.
Re: how to backup database [message #189124 is a reply to message #189093] Wed, 23 August 2006 05:04 Go to previous messageGo to next message
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.
Re: how to backup database [message #189633 is a reply to message #189124] Fri, 25 August 2006 05:51 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: how to backup database [message #190409 is a reply to message #188579] Wed, 30 August 2006 10:07 Go to previous message
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

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


Current Time: Fri Dec 09 06:16:08 CST 2016

Total time taken to generate the page: 0.12684 seconds