Re: rman

From: toto <parag9i_at_gmail.com>
Date: 19 Mar 2006 23:05:57 -0800
Message-ID: <1142838357.327037.10010@e56g2000cwe.googlegroups.com>

Hi Frank,

Sorry for my late reply. When I do configure controlfile autobackup off, it does not take backup of controlfile though I have include controlfile in backupdatabase command

RMAN> startup mount;

database is already started
database mounted

RMAN> backup database format='d:\dbbackups1\toto.bkp' include current controlfil
e;

Starting backup at 20-MAR-06
using channel ORA_DISK_1
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=00001 name=D:\ORACLE\ORADATA\TOTO\SYSTEM01.DBF
input datafile fno=00002 name=D:\ORACLE\ORADATA\TOTO\UNDOTBS01.DBF
input datafile fno=00011 name=D:\ORACLE\ORADATA\TOTO\BNP\BNP_D01.ORA
input datafile fno=00012 name=D:\ORACLE\ORADATA\TOTO\CCR\CCR_D01.ORA
input datafile fno=00013 name=D:\ORACLE\ORADATA\TOTO\COPS\COPS_D01.ORA
input datafile fno=00014

name=D:\ORACLE\ORADATA\TOTO\MUMBAI\MUMBAI_D01.ORA input datafile fno=00015
name=D:\ORACLE\ORADATA\TOTO\DELHI\DELHI_D01.ORA input datafile fno=00016
name=D:\ORACLE\ORADATA\TOTO\CHENNAI\CHENNAI_D01.ORA

input datafile fno=00017 name=D:\ORACLE\ORADATA\TOTO\MIS\MIS_D01.ORA
input datafile fno=00018 name=D:\ORACLE\ORADATA\TOTO\MIS1\MIS1_D01.ORA
input datafile fno=00019 name=D:\ORACLE\ORADATA\TOTO\MIS2\MIS2_D01.ORA
input datafile fno=00020

name=D:\ORACLE\ORADATA\TOTO\FINCON\FINCON_D01.ORA input datafile fno=00021
name=D:\ORACLE\ORADATA\TOTO\FINCON2\FINCON2_D01.ORA input datafile fno=00022
name=D:\ORACLE\ORADATA\TOTO\DIN36\DIN36_D01.ORA input datafile fno=00023
name=D:\ORACLE\ORADATA\TOTO\DINREPO\DINREPO_D01.ORA

input datafile fno=00024 name=D:\ORACLE\ORADATA\TOTO\DIN36\TESTUNV1.ORA
input datafile fno=00005 name=D:\ORACLE\ORADATA\TOTO\EXAMPLE01.DBF
input datafile fno=00010 name=D:\ORACLE\ORADATA\TOTO\XDB01.DBF
input datafile fno=00006 name=D:\ORACLE\ORADATA\TOTO\INDX01.DBF
input datafile fno=00009 name=D:\ORACLE\ORADATA\TOTO\USERS01.DBF
input datafile fno=00003 name=D:\ORACLE\ORADATA\TOTO\CWMLITE01.DBF
input datafile fno=00004 name=D:\ORACLE\ORADATA\TOTO\DRSYS01.DBF
input datafile fno=00007 name=D:\ORACLE\ORADATA\TOTO\ODM01.DBF
input datafile fno=00008 name=D:\ORACLE\ORADATA\TOTO\TOOLS01.DBF

channel ORA_DISK_1: starting piece 1 at 20-MAR-06 channel ORA_DISK_1: finished piece 1 at 20-MAR-06 piece handle=D:\DBBACKUPS1\TOTO.BKP comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:01:16 Finished backup at 20-MAR-06

RMAN> Kindly suggest.

best regards & thanks
pjp

Frank van Bortel wrote:

> toto wrote:
> > Hi Frank,
> >
> > Sorry for my late reply. When I tried with "autobackup off" backup does
> > not show be last backup portion of controlfile. For e.g. backup does
> > not show me
> > Starting Control File and SPFILE Autobackup at 14-MAR-06
> > piece handle=D:\DBBACKUPS\CTRLBKPC-3094695375-20060314-00 comment=NONE
> > Finished Control File and SPFILE Autobackup at 14-MAR-06
> >
>
> But it does show you something like:
>
> 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 SPFILE in backupset
> including current controlfile in backupset
>
> Show me what you tried, and what the errors were.
>
> --
> Regards,
> Frank van Bortel
>
> Top-posting is one way to shut me up...
Received on Mon Mar 20 2006 - 01:05:57 CST