Home » RDBMS Server » Backup & Recovery » RMAN incremental
RMAN incremental [message #144272] Tue, 25 October 2005 15:19 Go to next message
hannah00
Messages: 37
Registered: March 2005
Member
Hi all,

below is what I have predefine in RMAN:

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'D:\BACKUP\FULL\TEST\control_%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'D:\BACKUP\FULL\TEST\%d_DB_%
u_%s_%p';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\BACKUP\FULL\TEST\SNAP_CONTROL
F';
RMAN configuration has no stored or default parameters

RMAN>


the question is since I already predefined as above, when I do incremntal backup level=1 , I only need to backup the datafiles and archived log as oppose to everything including controlfiles.

1. How can I do incremental backup ONLY datafiles and archviedlog???

2. how can I change the backup on incremental to 'D:\BACKUP\INCREMENTAL\TEST\%d_DB_%u_%s_%p' AS opposed to above ('D:\BACKUP\FULL\TEST\%d_DB_%
u_%s_%p'Wink


Re: RMAN incremental [message #144276 is a reply to message #144272] Tue, 25 October 2005 15:33 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
1.)
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmbackp.htm#447156
2.)
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmconfg.htm#445220
You configure do it auotmatic as in

RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT = '?/bkup_%U';
or
RMAN> run
{
your stuff;
}
Re: RMAN incremental [message #144283 is a reply to message #144272] Tue, 25 October 2005 15:49 Go to previous messageGo to next message
hannah00
Messages: 37
Registered: March 2005
Member
thank you


but I think you misread my question
Re: RMAN incremental [message #144350 is a reply to message #144283] Wed, 26 October 2005 03:44 Go to previous message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
@hannah00

Did you went thru the given links?
What was it that got unanswered in your case?

--Girish
Previous Topic: recover a table from an rman backup
Next Topic: Redo log sizing
Goto Forum:
  


Current Time: Thu Mar 28 14:25:17 CDT 2024