Home » RDBMS Server » Server Administration » Complete Backup Procedure for Oracle 9i
Complete Backup Procedure for Oracle 9i [message #208858] Tue, 12 December 2006 06:33 Go to next message
braimi
Messages: 18
Registered: December 2006
Location: Muscat
Junior Member
How to Schedule Complete Backup Procedure for Oracle 9i using the windows built-in backup utility NTBACKUP.


Note: the procedure should follow for the online backups.
Re: Complete Backup Procedure for Oracle 9i [message #208862 is a reply to message #208858] Tue, 12 December 2006 06:35 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You do NOT want to use NTBACKUP for doing Oracle online backups. You should search this site for online backup scripts.
Re: Complete Backup Procedure for Oracle 9i [message #208872 is a reply to message #208858] Tue, 12 December 2006 06:57 Go to previous messageGo to next message
braimi
Messages: 18
Registered: December 2006
Location: Muscat
Junior Member
ebrian can you please tell me any site to get these scripts?
Re: Complete Backup Procedure for Oracle 9i [message #208874 is a reply to message #208872] Tue, 12 December 2006 07:00 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
An example of a user-managed version would be:

http://www.orafaq.com/scripts/back_rec/backup.txt
Re: Complete Backup Procedure for Oracle 9i [message #208875 is a reply to message #208872] Tue, 12 December 2006 07:05 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi,
before go for any script.

1. Backup procedure always depand on recovery and database.

Database >>>> In archive log mode or non archive log mode ( in ur case you go for online bkp means ur database is archive log mode).

Database type >>>> ( OLTP OR DSS)


Two method for Backup
1.User managed Backup
2. RMAN


you should go for RMAN backup.

http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96566/toc.htm


go through above link i will help to understand how RMAN works.

hope this helps
Taj
Re: Complete Backup Procedure for Oracle 9i [message #208910 is a reply to message #208875] Tue, 12 December 2006 09:49 Go to previous messageGo to next message
braimi
Messages: 18
Registered: December 2006
Location: Muscat
Junior Member
it sounds good and a proper way to get the backups for the databases but where can i get RMAN software?


Re: Complete Backup Procedure for Oracle 9i [message #208918 is a reply to message #208910] Tue, 12 December 2006 10:02 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hello,

RMAN is not software it is tools for backup and recovery operation.
and it is inbuild with Oracle Software.

How can use RMAN ( Recovery Manager)

first tell me something


You database is running on ARCHIVELOG MODE OR NON-ARCHIVE LOG MODE.

If non archive log mode ---- take cold backup of ur database.

Condition : database must be close.

if archive log mode ----- take online backup of ur database.
condition : database running in open mode...

now how can used.

if non archive log ...
C:\>rman target=sys

Recovery Manager: Release 10.1.0.2.0 - Production

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

target database Password:
connected to target database: ORACLE (DBID=1481667076)

RMAN> shutdown immediate;

using target database controlfile instead of recovery catalog
database closed
database dismounted
Oracle instance shut down

RMAN> startup mount

connected to target database (not started)
Oracle instance started
database mounted

Total System Global Area     171966464 bytes

Fixed Size                      787988 bytes
Variable Size                145488364 bytes
Database Buffers              25165824 bytes
Redo Buffers                    524288 bytes

RMAN> configure controlfile autobackup on;

new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored

RMAN> run
2> {
3> backup database;
4> }

Starting backup at 12-DEC-06
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=160 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORACLE\SYSTEM01.D
BF
input datafile fno=00003 name=D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORACLE\SYSAUX01.D
BF
input datafile fno=00007 name=C:\TEST03.DBF
input datafile fno=00004 name=D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORACLE\USERS01.DB
F
input datafile fno=00002 name=D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORACLE\UNDOTBS01.
DBF
input datafile fno=00005 name=C:\TEST.DBF
input datafile fno=00006 name=C:\TEST1.DBF
channel ORA_DISK_1: starting piece 1 at 12-DEC-06
channel ORA_DISK_1: finished piece 1 at 12-DEC-06
piece handle=C:\WINDOWS\SYSTEM32\01I4PP9F_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:06
Finished backup at 12-DEC-06

Starting Control File and SPFILE Autobackup at 12-DEC-06
piece handle=C:\WINDOWS\SYSTEM32\C-1481667076-20061212-00 comment=NONE
Finished Control File and SPFILE Autobackup at 12-DEC-06

RMAN>



it is just small example. you must read documentation before create ur backup procedure.
go through above posted link


hope this helps
Taj
Re: Complete Backup Procedure for Oracle 9i [message #208934 is a reply to message #208918] Tue, 12 December 2006 11:32 Go to previous message
braimi
Messages: 18
Registered: December 2006
Location: Muscat
Junior Member

Dear Taj database is in archive mode.
Previous Topic: System Table DUAL
Next Topic: connection error
Goto Forum:
  


Current Time: Fri Sep 20 05:48:05 CDT 2024