Home » RDBMS Server » Backup & Recovery » remove RMAN contents
remove RMAN contents [message #144663] Thu, 27 October 2005 10:56 Go to next message
hannah00
Messages: 37
Registered: March 2005
Member
HI all,

Below is what I have in the catalog:

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_CONTROLF';
RMAN configuration has no stored or default parameters

RMAN>


1. How can I remove "CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\BACKUP\FULL\TEST\SNAP_CONTROL
F';" since I already had AUTOBACKUP CONTROLFILE ON.

2. For incremental backup, how can I change the "'D:\BACKUP\FULL\TEST\control_%F'" Since I have seperate folder for incrmental. let's say like "'D:\BACKUP\INCREMENTAL\TEST\control_%F'"


thanks,
Re: remove RMAN contents [message #144745 is a reply to message #144663] Fri, 28 October 2005 00:34 Go to previous message
vatsjai
Messages: 23
Registered: May 2005
Location: delhi
Junior Member

Hi,

for first problem, why u do not use change command to mark it unavailable and then delete it permanantly. try this.

change 'D:\BACKUP\FULL\TEST\SNAP_CONTROL F' unavailable;

when u use list command then it will show it U under status heading. then delete it.


2. Change the enviormental variable. set this where u want to save your files.

God bless u
bye

Previous Topic: Redo log sizing
Next Topic: Oracle in Starting (9i)
Goto Forum:
  


Current Time: Sat Apr 20 07:25:33 CDT 2024