OraFAQ Forum: Backup & Recovery » rman problem-------- help

Home » RDBMS Server » Backup & Recovery » rman problem-------- help

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

rman problem-------- help [message #265448]

Thu, 06 September 2007 06:02

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

Report message to a moderator

Re: rman problem-------- help [message #265454 is a reply to message #265448]

Thu, 06 September 2007 06:23

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

Senior Member

crosscheck backup
delete expired

then restore

Report message to a moderator

Re: rman problem-------- help [message #265460 is a reply to message #265454]

Thu, 06 September 2007 06:42

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.

Report message to a moderator

Re: rman problem-------- help [message #265461 is a reply to message #265448]

Thu, 06 September 2007 06:45

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.

Report message to a moderator

Re: rman problem-------- help [message #265463 is a reply to message #265448]

Thu, 06 September 2007 06:50

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.

Report message to a moderator

Re: rman problem-------- help [message #265471 is a reply to message #265463]

Thu, 06 September 2007 07:05

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

Report message to a moderator

Re: rman problem-------- help [message #265479 is a reply to message #265471]

Thu, 06 September 2007 07:16

Michel Cadot
Messages: 68653
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

Report message to a moderator

Re: rman problem-------- help [message #265553 is a reply to message #265479]

Thu, 06 September 2007 11:30

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;

Report message to a moderator

Re: rman problem-------- help [message #265661 is a reply to message #265448]

Thu, 06 September 2007 17:19

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

Report message to a moderator

Re: rman problem-------- help [message #265668 is a reply to message #265661]

Thu, 06 September 2007 21:42

ebrian
Messages: 2794
Registered: April 2006

Senior Member

oracleo wrote on Thu, 06 September 2007 18:19

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>

Report message to a moderator

Re: rman problem-------- help [message #265962 is a reply to message #265668]

Sat, 08 September 2007 01:22

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

Report message to a moderator

Re: rman problem-------- help [message #265986 is a reply to message #265962]

Sat, 08 September 2007 08:55

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.

Report message to a moderator

Previous Topic:	rman
Next Topic:	RMAN error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 19 17:29:41 CDT 2024