|
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
|
|
|
|
|
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.
|
|
|
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.
|
|
|
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
|
|
|
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
|
|
|