-
learning RMAN
I have been doing some reading and try to learn RMAN. Any, I did create catalog and register the database I want to backup to RMAN. So I used RMAN to connect to the target database and everything is ok. When I issue the command: BACKUP DATABASE.
I got:
Starting backup at 12-FEB-04
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=11 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current controlfile in backupset
input datafile fno=00004 name=D:\ORADATA\TEST\LIS_DATA_02.DBF
input datafile fno=00003 name=D:\ORADATA\TEST\LIS_DATA_01.DBF
input datafile fno=00006 name=D:\ORADATA\TEST\LIS_INDX_01.DBF
input datafile fno=00005 name=D:\ORADATA\TEST\LIS_INDX_02.DBF
input datafile fno=00007 name=D:\ORADATA\TEST\LOG_DATA_01.DBF
input datafile fno=00001 name=E:\ORADATA\TEST\SYSTEM01.DBF
input datafile fno=00011 name=D:\ORADATA\TEST\QSAA_DATA_01.DBF
input datafile fno=00016 name=E:\ORADATA\TEST\RBS1TEST.ORA
input datafile fno=00008 name=D:\ORADATA\TEST\LOG_INDX_01.DBF
input datafile fno=00002 name=F:\ORADATA\TEST\UNDO01.DBF
input datafile fno=00009 name=D:\ORADATA\TEST\LOK_DATA_01.DBF
input datafile fno=00010 name=D:\ORADATA\TEST\LOK_INDX_01.DBF
input datafile fno=00014 name=D:\ORADATA\TEST\USR_DATA_01.DBF
input datafile fno=00012 name=D:\ORADATA\TEST\QSAA_INDX_01.DBF
input datafile fno=00013 name=D:\ORADATA\TEST\TOOLS_01.DBF
input datafile fno=00015 name=D:\ORADATA\TEST\USR_INDX_01.DBF
channel ORA_DISK_1: starting piece 1 at 12-FEB-04
channel ORA_DISK_1: finished piece 1 at 12-FEB-04
piece handle=C:\ORACLE\ORA920\DATABASE\09FDTGO4_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:36
Finished backup at 12-FEB-04
when I go to C:\ORACLE\ORA920\DATABASE\, nothing related to 09fdtgo4_1_1.
the question is: where is my backup the TEST database. what is 09FDTGO4_1_1????
thanks
-
can somone give me advise, please????
-
Re: learning RMAN
09FDTGO4_1_1 IS your backup.
Is the file in C:\ORACLE\ORA920\DATABASE or not?
-
no, there is nothing in there that's why I am confused.
-
what about $ORACLE_HOME/dbs ??
also,
log in to target and catalog, then type:
SHOW ALL;
please post what the output is.
-
there is nothing in dbs
and below is what I have when I typed:RMAN> show all
2> ;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\ORACLE\ORA920\DATABASE\SNCFTEST.O
RA'; # default
RMAN configuration has no stored or default parameters
RMAN>
thanks
-
how about setting some of those?
try this code which will send everything to 'C:\ORACLE\ORA920\DATABASE\'
run this in RMAN after you connect to target and catalog:
Code:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'C:\ORACLE\ORA920\DATABASE\control_%F';
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT 'C:\ORACLE\ORA920\DATABASE\backup_%U';
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT 'C:\ORACLE\ORA920\DATABASE\backup_%U';
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\ORACLE\ORA920\DATABASE\snap_controlf';
then issue: backup database;
let's see if that generates anything.
-
thanks cookie,
again I follow your adivses and run the backup database again, and it created the backup file again. but when I go to $ORACLE_HOME\database\, I can't find any file under that name and matter of fact I did a search on my entire computer, I still couldn't find anything.
Sorry, you have any other advises????
thnaks
-
wait, is the database located on your machine
or somewhere else?
send me the output from when you log into rman and
what exactly you run and what the output is.
example of what I am looking for:
rman
connect target /
connect catalog x/y@xyz
RMAN> backup database
etc. etc.
-
the target database located on different server and rman is running on my computer:
from my computer which is running rman, I have:
c:\rman catalog rman/rman@rman(my local database running rman) target sys/manager@test(the target database running on different machine)
C:\>rman catalog rman/rman@rman target sys/vms700@test
Recovery Manager: Release 9.2.0.4.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: TEST (DBID=688097787)
connected to recovery catalog database
RMAN>
-
there is your problem.
it is a common misconception that your backups will be written to the
machine you are running rman from. This is incorrect.
Backups can only be written to disks on the HOST server.
In your case: sys/vms700@test <-- that server
It's a pain in the ass that I wish Oracle would fix somehow, but
if you consider Network bandwidth I guess it could be a problem.
-
GEEZZZ,
for all of the trouble you have to go through trying to help me out so that is the problem. Let me try on that machine.
thanks
-
COOKIES,
seem likes it's working now. question for you???
on your previous post,
1. why did you configure 2 channel: channel 1,2???
2. what's the differences between 'CONFIGURE CONTROL AUTOBACKUP FORMAT' and 'CONFIGURE SNAPSHOT CONTROLFILE'
thanks
-
Any advises on this questions????
thanks all
-
configure snapshot controlfile name to
New syntax to replace 'set snapshot controlfile to ...'
configure controlfile autobackup on
Backup control file
Latyr
-
allocating more channels, use that to backed up your database parallely, more backupsets in each time, so it may be faster, of course it depends on backup media type, when you backed up to a tape with sequentional access, there is no reason to allocate more than 1 channel. When you start backup, rman create enough backupset to use all allocated channels.
