OraFAQ Forum: Backup & Recovery » how to configure RMAN

Home » RDBMS Server » Backup & Recovery » how to configure RMAN

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

how to configure RMAN [message #261140]

Tue, 21 August 2007 23:59

anamika_025
Messages: 81
Registered: July 2007
Location: Indore

Member

hi,

my question is

how to configure RMAN.

thanks and regards

Report message to a moderator

Re: how to configure RMAN [message #261153 is a reply to message #261140]

Wed, 22 August 2007 01:08

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Use

show all

and then see you will understand.

Report message to a moderator

Re: how to configure RMAN [message #261158 is a reply to message #261153]

Wed, 22 August 2007 01:14

anamika_025
Messages: 81
Registered: July 2007
Location: Indore

Member

using target database control file instead of recovery catalog
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 'E:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\S
NCFRND.ORA'; # default

this is the output..
but i do not understand this..

Report message to a moderator

Re: how to configure RMAN [message #261160 is a reply to message #261140]

Wed, 22 August 2007 01:19

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

List all List all displays the configuration parameter used in RMAN. Now you can see here which parameter you will configure. Suppose if you want backup optimization on then use following command.

RMAN> CONFIGURE BACKUP OPTIMIZATION on;

new RMAN configuration parameters:
CONFIGURE BACKUP OPTIMIZATION ON;
new RMAN configuration parameters are successfully stored

Report message to a moderator

Re: how to configure RMAN [message #261163 is a reply to message #261160]

Wed, 22 August 2007 01:21

anamika_025
Messages: 81
Registered: July 2007
Location: Indore

Member

ok..thanks

Report message to a moderator

Re: how to configure RMAN [message #261286 is a reply to message #261163]

Wed, 22 August 2007 04:56

ebrian
Messages: 2794
Registered: April 2006

Senior Member

SHOW ALL doesn't necessary provide all the options available. Check the docs for the full set of options (CONFIGURE).

Report message to a moderator

Re: how to configure RMAN [message #261451 is a reply to message #261286]

Wed, 22 August 2007 11:35

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

I will recommend you this parameter Wink

Quote:

CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default

Report message to a moderator

Re: how to configure RMAN [message #261477 is a reply to message #261451]

Wed, 22 August 2007 13:56

ebrian
Messages: 2794
Registered: April 2006

Senior Member

DreamzZ wrote on Wed, 22 August 2007 12:35

I will recommend you this parameter Wink

Quote:

CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default

No doubt. It amazes me that the default for this parameter is OFF.

Report message to a moderator

Re: how to configure RMAN [message #261479 is a reply to message #261477]

Wed, 22 August 2007 14:09

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Even if it is set to OFF control file is (auto)backed up when datafile 1 is backed up (and thus when whole database is backed up).

D:\>rman target /

Recovery Manager: Release 10.2.0.3.0 - Production on Mer. Ao�t 22 21:04:15 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: MIKA (DBID=1492747861)

RMAN> show all
2> ;

using target database control file instead of recovery catalog
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 'D:\ORACLE\ORA102\DATABASE\SNCFMIKA.ORA'; # default

RMAN> backup datafile 1;

Starting backup at 22/08/2007 21:04:53
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=142 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
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
...

Regards
Michel

Report message to a moderator

Re: how to configure RMAN [message #261485 is a reply to message #261479]

Wed, 22 August 2007 14:54

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

In this case we can't use

RMAN>restore controlfile from autobackup;

Report message to a moderator

Re: how to configure RMAN [message #261502 is a reply to message #261479]

Wed, 22 August 2007 16:31

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Michel Cadot wrote on Wed, 22 August 2007 15:09

Even if it is set to OFF control file is (auto)backed up when datafile 1 is backed up (and thus when whole database is backed up).

Exactly, I demonstrated that last week here.

Report message to a moderator

Re: how to configure RMAN [message #261532 is a reply to message #261502]

Wed, 22 August 2007 23:55

anamika_025
Messages: 81
Registered: July 2007
Location: Indore

Member

thanks to all,

but i have one confusion

if i m doing
E:\>rman target=dev

Recovery Manager: Release 10.2.0.1.0 - Production on Thu Aug 23 10:19:37 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

target database Password:
connected to target database: RND (DBID=1249640031, not open)

here
connected to target database: RND (DBID=1249640031, not open)

this is show "not open"

any problem here...

Report message to a moderator

Re: how to configure RMAN [message #261538 is a reply to message #261532]

Thu, 23 August 2007 00:10

anamika_025
Messages: 81
Registered: July 2007
Location: Indore

Member

solve my problem..
actually my database is corrupt, so i recoverd it

Report message to a moderator

Previous Topic:	while taking hotback .. instance got shutdown.. how to bring it backup
Next Topic:	DBMS_RCVCAT

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Aug 09 04:05:32 CDT 2025