OraFAQ Forum: Backup & Recovery » dont want rman to backup controlfile and spfile auto

Home » RDBMS Server » Backup & Recovery » dont want rman to backup controlfile and spfile auto

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

dont want rman to backup controlfile and spfile auto [message #234904]

Thu, 03 May 2007 07:45

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 backupsetchannel 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

Report message to a moderator

Re: dont want rman to backup controlfile and spfile auto [message #234909 is a reply to message #234904]

Thu, 03 May 2007 07:54

Mahesh Rajendran
Messages: 10708
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?

Report message to a moderator

Re: dont want rman to backup controlfile and spfile auto [message #234912 is a reply to message #234904]

Thu, 03 May 2007 08:04

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

Report message to a moderator

Re: dont want rman to backup controlfile and spfile auto [message #234913 is a reply to message #234912]

Thu, 03 May 2007 08:06

Mahesh Rajendran
Messages: 10708
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

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.

Report message to a moderator

Re: dont want rman to backup controlfile and spfile auto [message #235196 is a reply to message #234918]

Fri, 04 May 2007 05:14

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.

Report message to a moderator

Re: dont want rman to backup controlfile and spfile auto [message #235200 is a reply to message #235196]

Fri, 04 May 2007 05:39

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

Report message to a moderator

Re: dont want rman to backup controlfile and spfile auto [message #235208 is a reply to message #235200]

Fri, 04 May 2007 06:05

Mahesh Rajendran
Messages: 10708
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

Report message to a moderator

Re: dont want rman to backup controlfile and spfile auto [message #235221 is a reply to message #235208]

Fri, 04 May 2007 06:53

sriram717
Messages: 48
Registered: February 2007
Location: UNITED KINGDOM

Member

Yes !!

I was mentioning the same here ..sorry if i confused with my statements

Report message to a moderator

Re: dont want rman to backup controlfile and spfile auto [message #235227 is a reply to message #235208]

Fri, 04 May 2007 07:18

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

Report message to a moderator

Re: dont want rman to backup controlfile and spfile auto [message #235229 is a reply to message #235227]

Fri, 04 May 2007 07:21

Mahesh Rajendran
Messages: 10708
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

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

Report message to a moderator

Previous Topic:	Discoverer in /opendb format
Next Topic:	how to take backup from LAN client with EXP (9i)?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 10:27:09 CDT 2025