Home » RDBMS Server » Backup & Recovery » backup and recovery
backup and recovery [message #208261] Fri, 08 December 2006 21:54 Go to next message
born2acheive
Messages: 4
Registered: August 2006
Junior Member
hi any one can help me,i found the following example;
for back up:

rman target sys/*** nocatalog
run {
allocate channel t1 type disk;
backup
format '/app/oracle/backup/%d_t%t_s%s_p%p'
(database);
release channel t1;
}

i couldn't undertsand this,actually i want the databse which has the
username:scott
password:jetora
host string:jetora

i want to take the database backup in c:/databasebackup.
here databasebackup is one folder which is in c:(c directory)
wil the above mentioned exapmle work? what are the things i have to modify in that examploe to accomplich my need.please help me and please modify that example and show me please
Re: backup and recovery [message #208278 is a reply to message #208261] Sat, 09 December 2006 00:51 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi,

this example based on *nix platform.

you can also take backup through below cmd.

on cmd prompt
cmd>rman target sys/*** nocatalog
#here nocatalog means user sys connect to database with nocatalog.

RMAN>run {
# run is rman command you can create script or many other command execute with run.(inside)
allocate channel t1 type disk;
# allocate channel t1 type disk mean t1 is name of channel and type "disk". where rman write ur backup "here two option 1."DISK" or another one is "TAPE"
backup
#backup is command of rman take complete backup of ur database when you specify only backup;
format '/app/oracle/backup/%d_t%t_s%s_p%p'
#format command is used for file_name_of_rman_bkp_file.

release channel t1;
#we starting on script specify "channel to disk" now we release above channel through below command.

}

just take eg:

C:\>rman target=sys nocatalog

Recovery Manager: Release 10.1.0.2.0 - Production

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

target database Password:
connected to target database: ORCL (DBID=1136183406)
using target database controlfile instead of recovery catalog

RMAN> run
2> {
3> allocate channel t1 type disk;
4> backup
5> format 'c:\bkp_%u'(database);
6> release channel t1;
7> }

allocated channel: t1
channel t1: sid=161 devtype=DISK

Starting backup at 09-DEC-06
channel t1: starting full datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00004 name=D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\USERS01.DBF
input datafile fno=00001 name=D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SYSTEM01.DBF

input datafile fno=00003 name=D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SYSAUX01.DBF

input datafile fno=00005 name=D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\EXAMPLE01.DB
F
input datafile fno=00007 name=D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\USER02.DBF
input datafile fno=00002 name=D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\UNDOTBS01.DB
F
input datafile fno=00006 name=D:\TEST.DBF
channel t1: starting piece 1 at 09-DEC-06
channel t1: finished piece 1 at 09-DEC-06
piece handle=C:\BKP_01I4GRF8 comment=NONE
channel t1: backup set complete, elapsed time: 00:08:00
channel t1: starting full datafile backupset
channel t1: specifying datafile(s) in backupset
including current controlfile in backupset
including current SPFILE in backupset
channel t1: starting piece 1 at 09-DEC-06
channel t1: finished piece 1 at 09-DEC-06
piece handle=C:\BKP_02I4GRU9 comment=NONE
channel t1: backup set complete, elapsed time: 00:00:09
Finished backup at 09-DEC-06

released channel: t1



regards
Taj
Previous Topic: ARCHIVELOG BACKUP DIFFERENT LOCATION
Next Topic: script to take online backup of database
Goto Forum:
  


Current Time: Wed Dec 07 10:55:40 CST 2016

Total time taken to generate the page: 0.17378 seconds