| backup and recovery [message #208261] |
Fri, 08 December 2006 21:54  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
