Home » RDBMS Server » Backup & Recovery » explain about backup and recovery(very urgent)
explain about backup and recovery(very urgent) [message #211889] Tue, 02 January 2007 23:43 Go to next message
vinatha
Messages: 7
Registered: January 2007
Junior Member
I am the begginer of oracle.Please Explain About backup and recovery with example.plz help me.
Re: explain about backup and recovery(very urgent) [message #211891 is a reply to message #211889] Tue, 02 January 2007 23:55 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,

Backup and Recovery is Very important part of database.
it will depand on Database.

Two types of backup method.
1.RMAN ( server managed )
2.User Managed

-----------------------------------
Two types of backup
1.Cold Backup

If your able to shutdown database complete ( downtime) then you can take complete database backup with all database files , password files, server parameter files.

In Cold backup your not able to perform point in time recovery.
----------------------------------------------------------
2.Hotbackup

If you have no downtime ( your not able to shutdown your database) database running 24x7 then you have to choose hotbackup method.

-----------------------------------
Database running in two mode.
1.Archive log
In archive log mode your able to perform point in time recovery through .arc files.


2.No Archive log mode.
Point in time recovery not possible.
---------------------------------------------------------
Backup and recovery

http://download-uk.oracle.com/docs/cd/B14117_01/server.101/b10735/toc.htm


regards
Taj

Re: explain about backup and recovery(very urgent) [message #211904 is a reply to message #211891] Wed, 03 January 2007 01:05 Go to previous messageGo to next message
vinatha
Messages: 7
Registered: January 2007
Junior Member
hi..please give me with example.plz help me.
Re: explain about backup and recovery(very urgent) [message #211905 is a reply to message #211904] Wed, 03 January 2007 01:10 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

can you provide more infomation about your database.

your database running in which mode. ( archivelog or noarchivelog)

which type of backup method you want to used
RMAN or USER MANAGED.

Taj
Re: explain about backup and recovery(very urgent) [message #211909 is a reply to message #211905] Wed, 03 January 2007 01:17 Go to previous messageGo to next message
vinatha
Messages: 7
Registered: January 2007
Junior Member
i want to use RMAN method.My database under no archive mode.
Actually i want to move all the data from test server to real server.I os is Windows2000 and oracle8i
Re: explain about backup and recovery(very urgent) [message #211912 is a reply to message #211909] Wed, 03 January 2007 01:34 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

1. take cold backup or ur database
sql>shutdown immediate;
sql>rem using OS copy cmd COPY all datafile files, redo log files, control files , spfile, password files,
transter ur backup to another machine.on another machine install oracle software without database.and fellow below procedure.
C:\>set oracle_sid=orcl
C:\>orapwd file=d:\oracle\product\10.1.0\db_2\database\pwdorcl.ora password=oracle
C:\>d:\oracle\product\10.1.0\db_2\bin\oradim.exe -new -sid ORCL -startmode manual -spfileInstance created.
C:\>d:\oracle\product\10.1.0\db_2\bin\oradim.exe -edit -sid ORCL -startmode auto
C:\>sqlplus/nologSQL*Plus: Release 10.1.0.2.0 - Production on Sat Dec 9 12:36:53 2006
Copyright (c) 1982, 2004, Oracle. All rights reserved.
SQL> conn sys as sysdba
Enter password:
Connected to an idle instance.
note 1.paste all datafile , redo log file, control file, or spfile<sid>.ora in there location.
create folder in oraclehome/admin---bdump or cdump or udumpand oraclehome/ordata--orcl (according to ur dbname)
SQL> startup
ORACLE instance started.
Total System Global Area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 145488364 bytes
Database Buffers 25165824 bytes
Redo Buffers 524288 bytes
Database mounted.
Database altered.
----------------------------------------------------------------

regards
Taj
Re: explain about backup and recovery(very urgent) [message #211934 is a reply to message #211889] Wed, 03 January 2007 02:46 Go to previous messageGo to next message
vinatha
Messages: 7
Registered: January 2007
Junior Member
I am very beginner.Plz. Tell me about cold backup.In my real server already database is there
Re: explain about backup and recovery(very urgent) [message #211944 is a reply to message #211934] Wed, 03 January 2007 03:11 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member


Cold backup Of Database.database in NO ARCHIVE LOG MODE.
through USER MANAGED BACKUP METHED.


1.conn sys as sysdba
sql>conn sys@tns_entry/pwd as sysdba
2.shutdown database with immediate option.
sql>shutdown immediate;
3.using OS copy utility copy all oracle database file to backup drive.
database files are      Location 
1.all control files >>>> oraclehome/<sid>/oradata    
2.all redo logs files >>>> oraclehome/<sid>/oradata
3.all data files.  >>>> oraclehome/<sid>/oradata
Non database files      Location
4.Spfile >>>>> oraclehome/database/
5.pfile  >>>>> oraclehome/database/
6.password file  >>>> oraclehome/database/

----------------------------------------------------------------

Through RMAN.
-------------
Target database in Mount mode and No archive log.


E:\>rman target=sys@orcl1

Recovery Manager: Release 10.1.0.2.0 - Production

Copyright (c) 1995, 2004, Oracle.  All rights reserved.

target database Password:
connected to target database: ORCL1 (DBID=995164284)

RMAN> configure controlfile autobackup on;

using target database controlfile instead of recovery catalog
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored

RMAN> backup database;

Starting backup at 03-JAN-07
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=325 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL1\SYSTEM01.DB
F
input datafile fno=00003 name=C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL1\SYSAUX01.DB
F
input datafile fno=00002 name=C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL1\UNDOTBS01.D
BF
input datafile fno=00004 name=C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL1\USERS01.DBF

channel ORA_DISK_1: starting piece 1 at 03-JAN-07
channel ORA_DISK_1: finished piece 1 at 03-JAN-07
piece handle=C:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\ORCL1\BACKUPSET\2007_0
1_03\O1_MF_NNNDF_TAG20070103T130741_2SPWLZ18_.BKP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:06
Finished backup at 03-JAN-07

Starting Control File and SPFILE Autobackup at 03-JAN-07
piece handle=C:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\ORCL1\AUTOBACKUP\2007_
01_03\O1_MF_S_610894811_2SPWO10L_.BKP comment=NONE
Finished Control File and SPFILE Autobackup at 03-JAN-07

regards
Taj
Re: explain about backup and recovery(very urgent) [message #211950 is a reply to message #211889] Wed, 03 January 2007 03:39 Go to previous messageGo to next message
vinatha
Messages: 7
Registered: January 2007
Junior Member
I am doing backup like this method
Alter tablespace users begin backup
copy datafiles
Alter tablespace users end backup

Shall i use that datafile recover in real database
Re: explain about backup and recovery(very urgent) [message #211959 is a reply to message #211950] Wed, 03 January 2007 04:19 Go to previous messageGo to next message
seema.taunk
Messages: 96
Registered: October 2006
Member
Hi,

You are taking hot backup of database.
>>Shall i use that datafile recover in real database
what do you mean by this?
You want to recover datafile??
Re: explain about backup and recovery(very urgent) [message #211965 is a reply to message #211889] Wed, 03 January 2007 04:59 Go to previous messageGo to next message
vinatha
Messages: 7
Registered: January 2007
Junior Member
Hi,
i mean Is it possible to recover that backup datafile in another database.

I am trying hot backup but i get this error .

C:\Documents and Settings\Vinatha>rman target=sys

Recovery Manager: Release 8.1.7.0.0 - Production

target database Password:
RMAN-06005: connected to target database: RAM (DBID=2773873450)

RMAN> configure controlfile autobackup on;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "controlfile": expecting one of: "compatible"
RMAN-01007: at line 1 column 11 file: standard input

RMAN> backup database;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "backup": expecting one of: "allocate, alter, be
ginline, catalog, change, connect, create, crosscheck, configure, debug, delete,
drop, exit, endinline, host, {, library, list, mount, open, print, register, re
lease, replace, report, renormalize, reset, resync, rman, rpct·?"
RMAN-01007: at line 1 column 1 file: standard input
Re: explain about backup and recovery(very urgent) [message #211968 is a reply to message #211965] Wed, 03 January 2007 05:02 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You have to start reading the documentation.
Get a complete picture, test and learn and then do it in real time.
If you cannot differentiate between hot/cold backup you are not supposed to it. THis is just a forum. We can help with specific issues but cannot teach you.

http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76990/toc.htm
Re: explain about backup and recovery(very urgent) [message #211983 is a reply to message #211950] Wed, 03 January 2007 06:11 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Alter tablespace users begin backup
copy datafiles
Alter tablespace users end backup

You cann't take hot backup because your database running in NO ARCHIVE LOG MODE.

you have to take cold backup.
see my previous post example in cold backup through USER MANAGED METHED.

Taj
Re: explain about backup and recovery(very urgent) [message #212131 is a reply to message #211889] Wed, 03 January 2007 22:34 Go to previous messageGo to next message
vinatha
Messages: 7
Registered: January 2007
Junior Member
Really thank u very much for every one. I want to take backup single tablespace only that file want to use in another database.Is it possible. Actaually it is very urgent for me.I felt very much tense.Plz. help to me.
Re: explain about backup and recovery(very urgent) [message #212134 is a reply to message #212131] Wed, 03 January 2007 23:14 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

You can use 'TRANPORT TABLESPACE Feature'

http://dbataj.blogspot.com/2007/01/transport-tablespace.html
regards
Taj

[Updated on: Thu, 04 January 2007 07:54]

Report message to a moderator

Previous Topic: How to apply archives to roll foward data changes in db?
Next Topic: recover data from 10g to 9i
Goto Forum:
  


Current Time: Fri Dec 02 22:41:16 CST 2016

Total time taken to generate the page: 0.11801 seconds