Database Reference
In-Depth Information
RUN {
ALLOCATE CHANNEL ch1 TYPE DISK;
COPY
DATAFILE 1 TO '/bkup/system01.dbf',
DATAFILE 2 TO '/ bkup /undotbs01.dbf',
DATAFILE 3 TO '/ bkup /cwmlite01.dbf',
DATAFILE 4 TO '/ bkup /drsys01.dbf',
DATAFILE 5 TO '/ bkup /example01.dbf',
DATAFILE 6 TO '/ bkup /indx01.dbf',
DATAFILE 7 TO '/ bkup /tools01.dbf',
DATAFILE 8 TO '/ bkup /users01.dbf',
CURRENT CONTROLFILE TO '/tmp/control01.ctl';
RELEASE CHANNEL ch1;
}
To copy archived redo log files use the following command. We
can also merge the ARCHIVELOG clause mentioned in the
RUN command below, in the RUN command mentioned above.
RUN {
ALLOCATE CHANNEL ch1 TYPE DISK;
COPY
ARCHIVELOG '/oradata/test/arch/archive1_1.dbf' TO '/bkup/archive1_1.dbf',
ARCHIVELOG '/oradata/test/arch/archive1_2.dbf' TO '/bkup/archive1_2.dbf'',
CURRENT CONTROLFILE TO '/tmp/control01.ctl';
RELEASE CHANNEL ch1;
}
Image copies generated using RMAN COPY command are
similar to images copies generated using operating system
commands like copy in Windows Server2004/XP/NT and no
recovery is needed after restoring the files back from the backed
up location.
RMAN based Complete Recovery
There are two types of recoveries that are possible with RMAN.
Recovery of Database running under NOARCHIVELOG mode
and the other one is the Recovery of Database running under
ARCIVELOG mode.
Search WWH ::
Custom Search