Home » RDBMS Server » Backup & Recovery » dont want rman to backup controlfile and spfile auto
dont want rman to backup controlfile and spfile auto [message #234904] Thu, 03 May 2007 07:45 Go to next message
fozerol
Messages: 17
Registered: March 2007
Junior Member
RMAN> show all;

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 BACKUP TYPE TO BACKUPSET; # 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 ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/data/oracle/product/dbs/snapcf_kkbs2.f'; # default

when i issue command "backup database format '/home/oracle/%T-%U-kkbs2.rman'

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=708 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00005 name=/u01/oradata/kkbs2/u01/kkbs201.dbf
input datafile fno=00002 name=/u01/oradata/kkbs2/u01/undotbs01.dbf
input datafile fno=00006 name=/u01/oradata/kkbs2/u01/INDX01.dbf
input datafile fno=00001 name=/u01/oradata/kkbs2/u01/system01.dbf
input datafile fno=00003 name=/u01/oradata/kkbs2/u01/sysaux01.dbf
input datafile fno=00004 name=/u01/oradata/kkbs2/u01/users01.dbf
channel ORA_DISK_1: starting piece 1 at 03-MAY-07
channel ORA_DISK_1: finished piece 1 at 03-MAY-07
piece handle=/home/oracle/yedek/20070503-1rigq1bt_1_1-kkbs2.rman tag=TAG20070503T133245 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:07:56
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 03-MAY-07
channel ORA_DISK_1: finished piece 1 at 03-MAY-07
piece handle=/home/oracle/yedek/20070503-1sigq1qp_1_1-kkbs2.rman tag=TAG20070503T133245 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:05

as you can see it backs up spfile and controlfile

thanks for your replies
Re: dont want rman to backup controlfile and spfile auto [message #234909 is a reply to message #234904] Thu, 03 May 2007 07:54 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>dont want rman to backup controlfile and spfile auto
Do you have one valid reason for not wanting to do that?
Re: dont want rman to backup controlfile and spfile auto [message #234912 is a reply to message #234904] Thu, 03 May 2007 08:04 Go to previous messageGo to next message
saibal
Messages: 111
Registered: March 2007
Location: India
Senior Member
Don't backup datafile#1 and your controlfile and spfile won't be backed up, although I don't see why you don't want to back up your controlfile and spfile
Re: dont want rman to backup controlfile and spfile auto [message #234913 is a reply to message #234912] Thu, 03 May 2007 08:06 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>Don't backup datafile#1 and your controlfile and spfile won't be backed up,
COuld you explain how would that happen?
Espcially when the OP is issuing a "backup database"

[Updated on: Thu, 03 May 2007 08:06]

Report message to a moderator

Re: dont want rman to backup controlfile and spfile auto [message #234918 is a reply to message #234913] Thu, 03 May 2007 08:15 Go to previous messageGo to next message
saibal
Messages: 111
Registered: March 2007
Location: India
Senior Member
I mean out of say 100 files, if you back up 99 files, without including data file #1, then you can get away without backing up your spfile and controlfile.
You questioned the OP's reason for not wanting to back up the spfile and contriolfile, I did the same, but at the same time I gave him something to think about and work upon.
Re: dont want rman to backup controlfile and spfile auto [message #235196 is a reply to message #234918] Fri, 04 May 2007 05:14 Go to previous messageGo to next message
sriram717
Messages: 48
Registered: February 2007
Location: UNITED KINGDOM
Member
How about

CONFIGURE CONTROLFILE AUTOBACKUP OFF;

If CONFIGURE CONTROLFILE AUTOBACKUP is ON (by default it is OFF), then RMAN automatically backs up the control file and the current server parameter file after every BACKUP or COPY command issued at the RMAN prompt.
Re: dont want rman to backup controlfile and spfile auto [message #235200 is a reply to message #235196] Fri, 04 May 2007 05:39 Go to previous messageGo to next message
sriram717
Messages: 48
Registered: February 2007
Location: UNITED KINGDOM
Member
Clarified from RMAN reference:

configure controlfile autobackup off:
"Disables the autobackup feature (default). Note that when this command is OFF, any BACKUP command that includes datafile 1 (including BACKUP DATABASE) automatically includes the current control file and server parameter file in the backup set. Otherwise, RMAN does not include these files."

Supports what was posted by saibal

Thanks
Re: dont want rman to backup controlfile and spfile auto [message #235208 is a reply to message #235200] Fri, 04 May 2007 06:05 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> CONFIGURE CONTROLFILE AUTOBACKUP OFF;
>> Clarified from RMAN reference:

Did you read it in entirety?
CONTROLFILE AUTOBACKUP has nothing to do with this.
If it is ON, RMAN writes the control file and server parameter file to a separate autobackup piece.
If it is OFF,RMAN does not create a separate autobackup piece containing the control file and server parameter file. Instead
RMAN automatically includes the current control file and server parameter file in the datafile backup set
Re: dont want rman to backup controlfile and spfile auto [message #235221 is a reply to message #235208] Fri, 04 May 2007 06:53 Go to previous messageGo to next message
sriram717
Messages: 48
Registered: February 2007
Location: UNITED KINGDOM
Member
Yes !!

I was mentioning the same here ..sorry if i confused with my statements
Re: dont want rman to backup controlfile and spfile auto [message #235227 is a reply to message #235208] Fri, 04 May 2007 07:18 Go to previous messageGo to next message
saibal
Messages: 111
Registered: March 2007
Location: India
Senior Member
True, and you can also force RMAN to put the control file in the backup set of the database by using the include current controlfile clause in the backup database command. Of course, this is assuming you are not backing up datafile#1
Re: dont want rman to backup controlfile and spfile auto [message #235229 is a reply to message #235227] Fri, 04 May 2007 07:21 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
EDIT:
Wrong thread~!. Mixedup.

[Updated on: Fri, 04 May 2007 07:51]

Report message to a moderator

Re: dont want rman to backup controlfile and spfile auto [message #235234 is a reply to message #235229] Fri, 04 May 2007 07:29 Go to previous message
saibal
Messages: 111
Registered: March 2007
Location: India
Senior Member
Can you kindly elaborate on what you are trying to prove/disprove?
I see the controlfile and spfile being backed up when you are not backing up datafile#1. This can happen when you have autobackup switched on.
Regards
Previous Topic: Discoverer in /opendb format
Next Topic: how to take backup from LAN client with EXP (9i)?
Goto Forum:
  


Current Time: Tue Dec 06 00:18:41 CST 2016

Total time taken to generate the page: 0.06225 seconds