| RMAN recovery question [message #213209] |
Tue, 09 January 2007 17:59  |
oracle_scorpiongirl
Messages: 39
Registered: November 2005
|
Member |
|
|
I am very new to RMAN. I did all these by just reading what I need to know to create these. I am not confident with this whole thing being right. Can someone please validate or suggest and clarify one doubt?
I created a RMAN level 0 and leve l1 script. once level0 and level1 backups were created(in flash recovery area), I removed EVERYTHING from ASM's data group and everything(but the backups) from flash recovery area.
Did the recovery this way:
1) tried "restore spfile from autobackup" - but this did not work
this is the message I got:
Starting restore at 09-JAN-07
using channel ORA_DISK_1
channel ORA_DISK_1: looking for autobackup on day: 20070109
channel ORA_DISK_1: looking for autobackup on day: 20070108
channel ORA_DISK_1: looking for autobackup on day: 20070107
channel ORA_DISK_1: looking for autobackup on day: 20070106
channel ORA_DISK_1: looking for autobackup on day: 20070105
channel ORA_DISK_1: looking for autobackup on day: 20070104
channel ORA_DISK_1: looking for autobackup on day: 20070103
channel ORA_DISK_1: no autobackup in 7 days found
RMAN-00571: ====================================================
RMAN-00569: ======= ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ====================================================
RMAN-03002: failure of restore command at 01/09/2007 08:14:11
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece
All I understood was that the backup is there, but the handle is wrong. Not sure which one I should set/change(please see my RMAN configuration below)
I had to give the full path of the location of the autobackup in flash recoveryarea:
restore spfile from +FRA/dbname/autobackup/2007_01_09/s-xxxxxxxxx_xxx_xxxxxxxxx’;
2) startup nomount
3) restore controlfile from autobackup - this worked just fine
4) mount
5) restore database;
6) recover database;
7) alter database open resetlogs;
and take a full backup
why did the error in step 1 happen?
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION ON; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON; # 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
DO I have to set these to backup everything to flash recovery area (and not to a disk location)
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT CLEAR; -- to use FRA instead of disk location for backup
CONFIGURE CONTROLFILE AUTOBACKUP FOR DEVICE TYPE DISK TO '+FRA';
also please correct any of the rman configuration that needs to be changed(to backup to the ASM flash recovery area)
Please clarify. Thanks
|
|
|
|
|
|
| Re: RMAN recovery question [message #213327 is a reply to message #213209] |
Wed, 10 January 2007 05:57  |
oracle_scorpiongirl
Messages: 39
Registered: November 2005
|
Member |
|
|
db_recovery_file_dest='+FRA'
but one of the error msgs, unable to find backup in '+FRA'. But at that time I was trying to figure out how to get it to work. so I did
restore spfile from '+FRA';
and finally realized that I have to give the full path.
But according to what you said, my flash recovery area is '+FRA'. but still I have to give the FULL path in the restore command. is that correct?
and I set the dbid before doing the restore. So, it is right that I don't have to give the dbname in the command line again.
Thanks
|
|
|
|
| Re: RMAN recovery question [message #213329 is a reply to message #213212] |
Wed, 10 January 2007 05:58 |
oracle_scorpiongirl
Messages: 39
Registered: November 2005
|
Member |
|
|
And could you also clarify this Q for me:
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION ON; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON; # 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
DO I have to set these to backup everything to flash recovery area (and not to a disk location)
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT CLEAR; -- to use FRA instead of disk location for backup
CONFIGURE CONTROLFILE AUTOBACKUP FOR DEVICE TYPE DISK TO '+FRA';
any thing that needs modification/addition?
Thanks again
|
|
|
|
|
|
|
|
| Re: RMAN recovery question [message #213383 is a reply to message #213209] |
Wed, 10 January 2007 09:07 |
oracle_scorpiongirl
Messages: 39
Registered: November 2005
|
Member |
|
|
OK. Apologize. I should have been more clear. I don't have the archivelogs and the rman backups in the same location
This is what is there in my asm diskgroups:
ASMCMD> pwd
+DATA/TESTDB
ASMCMD> ls
1_1_611401220.dbf
1_2_611401220.dbf
1_3_611401220.dbf
1_43_611051790.dbf
1_4_611401220.dbf
2_1_611401220.dbf
2_2_611401220.dbf
2_3_611401220.dbf
2_4_611401220.dbf
2_5_611401220.dbf
2_81_611051790.dbf
ARCHIVELOG/
CONTROLFILE/
DATAFILE/
ONLINELOG/
TEMPFILE/
spfileractest.ora
ASMCMD> pwd
+FRA/TESTDB
ASMCMD> ls
AUTOBACKUP/
BACKUPSET/
CHANGETRACKING/
CONTROLFILE/
FLASHBACK/
ONLINELOG/
For some reason I was thinking that my archivelogs will go to the flash recovery area(FRA). So, I initially decided to have RMAN backups in a seperate disk location. But after I saw the contents of the diskgroups, I decided to have the RMAN backups in FRA. (probably should have researched more on the archivelogs being in DATA group)...or, is it how files are placed when I select DATA group as the database area for OMF location and FRA group for the flash recovery area?
so if my file placements are correct, then is my question about RMAN configuration valid? abt having to CLEAR few of them I mentioned earlier to backup to FRA instead of disk location?
One more question. What are those .dbf files in the DATA group? I believe the database datafiles are in the DATAFILE directory underneath.
Thanks Mahesh
|
|
|
|
|
|
| Re: RMAN recovery question [message #213393 is a reply to message #213209] |
Wed, 10 January 2007 09:53 |
oracle_scorpiongirl
Messages: 39
Registered: November 2005
|
Member |
|
|
OK. That is true. I can change the location. Thanks
And yeah, those are seperate disks. Well, (I am not a very good hardware person), but I had 3 LUNS, created partitions, mapped raw devices to it and used them for the disk groups. And if I am not wrong, data and recovery were from different LUNS. (hope that will help)
Nice. Please let me know how it goes.
Thanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
