Home » RDBMS Server » Backup & Recovery » how to configure RMAN
how to configure RMAN [message #261140] Tue, 21 August 2007 23:59 Go to next message
anamika_025
Messages: 81
Registered: July 2007
Location: Indore
Member
hi,

my question is

how to configure RMAN.

thanks and regards
Re: how to configure RMAN [message #261153 is a reply to message #261140] Wed, 22 August 2007 01:08 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Use
show all


and then see you will understand.
Re: how to configure RMAN [message #261158 is a reply to message #261153] Wed, 22 August 2007 01:14 Go to previous messageGo to next message
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..
Re: how to configure RMAN [message #261160 is a reply to message #261140] Wed, 22 August 2007 01:19 Go to previous messageGo to next message
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


Re: how to configure RMAN [message #261163 is a reply to message #261160] Wed, 22 August 2007 01:21 Go to previous messageGo to next message
anamika_025
Messages: 81
Registered: July 2007
Location: Indore
Member
ok..thanks
Re: how to configure RMAN [message #261286 is a reply to message #261163] Wed, 22 August 2007 04:56 Go to previous messageGo to next message
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).
Re: how to configure RMAN [message #261451 is a reply to message #261286] Wed, 22 August 2007 11:35 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
I will recommend you this parameter Wink
Quote:
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
Re: how to configure RMAN [message #261477 is a reply to message #261451] Wed, 22 August 2007 13:56 Go to previous messageGo to next message
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.
Re: how to configure RMAN [message #261479 is a reply to message #261477] Wed, 22 August 2007 14:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: how to configure RMAN [message #261485 is a reply to message #261479] Wed, 22 August 2007 14:54 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
In this case we can't use

RMAN>restore controlfile from autobackup;
Re: how to configure RMAN [message #261502 is a reply to message #261479] Wed, 22 August 2007 16:31 Go to previous messageGo to next message
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.
Re: how to configure RMAN [message #261532 is a reply to message #261502] Wed, 22 August 2007 23:55 Go to previous messageGo to next message
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...
Re: how to configure RMAN [message #261538 is a reply to message #261532] Thu, 23 August 2007 00:10 Go to previous message
anamika_025
Messages: 81
Registered: July 2007
Location: Indore
Member
solve my problem..
actually my database is corrupt, so i recoverd it
Previous Topic: while taking hotback .. instance got shutdown.. how to bring it backup
Next Topic: DBMS_RCVCAT
Goto Forum:
  


Current Time: Fri Dec 09 06:04:16 CST 2016

Total time taken to generate the page: 0.09524 seconds