Home » RDBMS Server » Backup & Recovery » rman problem-------- help
rman problem-------- help [message #265448] Thu, 06 September 2007 06:02 Go to next message
aboodlardy
Messages: 80
Registered: November 2006
Location: India
Member
hello friends

I have backup my database using rman, and retention policy to redundancy was set to 1. i have backup my database using rman.

rman> backup database;

database was backed up.

now again I took backup of datafile 1

rman> backup datafile 1 tag 'test';

backup was completed;
then

rman> delete backup tag 'test';
deleted.

now when I trying to restore my whole database.

rman> restore database;

it is asking me that backup taken with tag 'test' is missing.
and it is not taking datafile from full database backup.
and it is unable to restore my database.

Please help

Re: rman problem-------- help [message #265454 is a reply to message #265448] Thu, 06 September 2007 06:23 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

crosscheck backup
delete expired

then restore
Re: rman problem-------- help [message #265460 is a reply to message #265454] Thu, 06 September 2007 06:42 Go to previous messageGo to next message
aboodlardy
Messages: 80
Registered: November 2006
Location: India
Member
Arju,

I want to remind u one more time that retention policy to redundancy 1.

Please Help.
Re: rman problem-------- help [message #265461 is a reply to message #265448] Thu, 06 September 2007 06:45 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Use list backup. and see tag and from tag restore.

However , my previous commands would not delete any files from your OS though you set redundancy 1.

Re: rman problem-------- help [message #265463 is a reply to message #265448] Thu, 06 September 2007 06:50 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

@aboodlardy,
Before posting read at least once about Forum Guide. Manual covers the aspects that you need. Read it first.


By the way delete expired is always safe.
Re: rman problem-------- help [message #265471 is a reply to message #265463] Thu, 06 September 2007 07:05 Go to previous messageGo to next message
aboodlardy
Messages: 80
Registered: November 2006
Location: India
Member

I am extremely sorry, arju, if u find anything which hurt u or not to be posted in my post.It would be a pleasure for me , if u correct me.

Thanks for ur reply
Re: rman problem-------- help [message #265479 is a reply to message #265471] Thu, 06 September 2007 07:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
It would be a pleasure for me , if u correct me.

"u" is not registered here.

Regards
Michel
Re: rman problem-------- help [message #265553 is a reply to message #265479] Thu, 06 September 2007 11:30 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
Used to control how long RMAN will keep backups. This can be configured by the "number" of backups taken, or by the numbers of "days" to keep. Here is an example of both:

CONFIGURE RETENTION POLICY TO REDUNDANCY 2;

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS;

Note that when configuring a retention policy, RMAN will not cause backups to be automatically deleted. The retention policy will, however, mark backups as OBSOLETE that have fallen outside the retention period. RMAN commands like "REPORT OBSOLETE" and "DELETE OBSOLETE" will work with these obsolete backups.

If back up your database infrequently, you probably will prefer a redundancy policy that is stated in terms of number of backups rather than backups later than n days old. In this case, you would use the redundancy parameter as follows:

RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 3;

Finally, if you do not want to use a retention policy, simply use:

RMAN> CONFIGURE RETENTION POLICY TO NONE;
Re: rman problem-------- help [message #265661 is a reply to message #265448] Thu, 06 September 2007 17:19 Go to previous messageGo to next message
oracleo
Messages: 2
Registered: September 2007
Location: hyderabad
Junior Member

while you have taken the backup of datafile 1 i.e sytem datafile
you might have configured 'controlfile auto backup ON',in this case while taking the backup of datafile 1 your controlfile is also present in the same backp set you have lost the current controlfile backup.

i m a student plz sorry if i m wrong
Re: rman problem-------- help [message #265668 is a reply to message #265661] Thu, 06 September 2007 21:42 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
oracleo wrote on Thu, 06 September 2007 18:19
while you have taken the backup of datafile 1 i.e sytem datafile
you might have configured 'controlfile auto backup ON',in this case while taking the backup of datafile 1 your controlfile is also present in the same backp set you have lost the current controlfile backup.


It's actually the opposite of what you indicated. If CONTROLFILE AUTOBACKUP is ON and the backup includes datafile 1, then RMAN will generate a separate backuppiece.

RMAN configuration parameters are:
CONFIGURE CONTROLFILE AUTOBACKUP ON;

RMAN> backup datafile 1 format 'e:\dbbackups\%U.bkp';

Starting backup at 06-SEP-07
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=15 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=E:\ORACLE\ORADATA\WIN9I\SYSTEM01.DBF
channel ORA_DISK_1: starting piece 1 at 06-SEP-07
channel ORA_DISK_1: finished piece 1 at 06-SEP-07
piece handle=E:\DBBACKUPS\06IR9SQ3_1_1.BKP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
Finished backup at 06-SEP-07

Starting Control File and SPFILE Autobackup at 06-SEP-07
piece handle=E:\ORACLE\ORA92\DATABASE\C-1566817526-20070906-00 comment=NONE
Finished Control File and SPFILE Autobackup at 06-SEP-07


If the CONTROLFILE AUTOBACKUP is OFF, then the controlfile will be included in the datafile backupset.

RMAN> configure controlfile autobackup off;

old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
new RMAN configuration parameters are successfully stored

RMAN> backup datafile 1 format 'e:\dbbackups\%U.bkp';

Starting backup at 06-SEP-07
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current SPFILE in backupset
including current controlfile in backupset
input datafile fno=00001 name=E:\ORACLE\ORADATA\WIN9I\SYSTEM01.DBF
channel ORA_DISK_1: starting piece 1 at 06-SEP-07
channel ORA_DISK_1: finished piece 1 at 06-SEP-07
piece handle=E:\DBBACKUPS\08IR9SV2_1_1.BKP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:57
Finished backup at 06-SEP-07

RMAN>

Re: rman problem-------- help [message #265962 is a reply to message #265668] Sat, 08 September 2007 01:22 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
but ebrian we not able to restore controlfile from autobackup when "controlfile autobackup is set to OFF".

Regards
Taj
Re: rman problem-------- help [message #265986 is a reply to message #265962] Sat, 08 September 2007 08:55 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
oracleo wrote on Thu, 06 September 2007 18:19
while you have taken the backup of datafile 1 i.e sytem datafile you might have configured 'controlfile auto backup ON',in this case while taking the backup of datafile 1 your controlfile is also present in the same backp set you have lost the current controlfile backup.

I was addressing oracleo's comment above.
Previous Topic: rman
Next Topic: RMAN error
Goto Forum:
  


Current Time: Sat Dec 10 09:18:56 CST 2016

Total time taken to generate the page: 0.07647 seconds