Printable View
Hi, How to create rman catalog and register database for 2 nodes RAC. Is the procedure same as of single database. I want to take backup using RMAN by creating catalog and registering RAC database on another Sun server consists of oracle 9i database, for my 2 nodes oracle 9i RAC database.
All the datafiles are stored in SAN storage and for archivelogs the drive is shared for the two nodes.
thanks,
why dont you read the docs which go over all of this?
Hi, I have gone through the Oracle 9i RMAN documentation of oracle press. But sorry to say that I didn't found the method for creating catalog and registering the target RAC database in the manual.
My question is:
Is it the same procedure to create catalog and register database for RAC DB with 2 nodes as of Single Production DB.
since there are two nodes and a shared external storage which contains database files and archive logs, when I register the target database in recovery catalog database which is on different system and issue the RMAN>backup database plus archivelog; does archive logs are backed up from both the nodes along with datafiles.
Thanks,
Hi
If the archived redologs are on the clustered filesystems (and i strongly advise you to use a clustered file system) and both the nodes can see the filesystem and it is properly configured then yes
BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
This will work perfectly
You should read the RMAN docs and its all documented there
http://download.oracle.com/docs/cd/B...ops.htm#443638
regards
Hrishy
Hi, thanks for the answers.
Currently Iam taking RMAN full weekly backups on node 1, I can store only one weekly backup on node 1 due to space shortage. So first I delete the previous weekly backup before taking new weekly backup.
After successfully taking the backup using
RMAN>backup database plus archivelog;
the backup files are written to disk and on tape.
But when I issue
RMAN>crosscheck backup completed before 'sysdate';
RMAN shows the latest backup files as "Expired". It should have shown as "Available" as the files are physically present on disk, i have not deleted the latest backup files.
Note: My catalog database is on another solaris machine.
Question: Why RMAN is not treating the latest backup files as Available.
One more thing: Iam getting a Solaris operating system message on node 1 as,
message overflow on /dev/log minor #6 -- is syslogd (1M) running?
Question: Is this the reason RMAN is not treating the files as Available, but it is reading the directory as it is displaying the backup files as Expired.
Your kind help is appreciated,
thanks,
Hi
What commnad do you use to delete those backups
The solaris error has nothing to do with rman
regards
Hrishy
Hi, I go to rman backup directory and give rm* command, to delete the backup files from operating system.
thanks,
Hi, Hrishy you have understood my case. please help me to solve this problem.
Note: the os command $scstat -p, shows one of the resource
Infra as online but Degraded - IPMP Failure
this error is on node 1 on which Iam taking backups, is this the reason RMAN showing the latest backups as Expired eventhough they exists on disk.
thanks,
Hi
Please let me know what does the following command return
crosscheck backup of database
completed between 'SYSDATE' and 'SYSDATE-30';
When you are deleting backups ensure that you dont use OS commands to do so.
For deleting expired backups of previous week type the following
RMAN>DELETE EXPIRED BACKUP COMPLETED BEFORE SYSDATE-7
and for deleting backups completed before 7 days type
RMAN>DELETE BACKUP COMPLETED BEFORE SYSDATE-7
Don't use the OS utilites to maintain the backups.
This message below
Infra as online but Degraded - IPMP Failure
has got nothing do with rman its something to Sun Cluster but i am not sure check with your solaris admin
regards
Hrishy
Hi, first sorry for delay in replying to your message.
Hrishy, this is the output of the command that you have asked for. It is not displaying any backups records.
RMAN> crosscheck backup completed
2> between 'sysdate' and 'sysdate-30';
using channel ORA_SBT_TAPE_1
using channel ORA_DISK_1
RMAN>
thanks and regards,
Hi
Well i am confused.
In one of the above post you mention the rman command
crosscheck backup completed before sysdate
shows the backup as expired But now you are saying the command does not return anything.
This clearly means there is more than what meets the eyes.
You ran some other commands in between like a rman delete command that deleted the backups from the rman catalog database.
I am not sure what you did but if you need help like this remotely you need to be precise and post the entire sequence of commands you executed for us to help.
You need to also consider buying disk space so you can store enough backups or start looking at a very good tape library that can manage your backups in accordance with your retention policy
IMHO you need practice rman backups on a single instance database first in a test environment till you grasp the nuances of rman
The crosscheck command should have worked for you
Look here in the documentation
http://download-uk.oracle.com/docs/c...yn21.htm#80887
You can perform a small test your self to reproduce what you did liek this
1)Backup database plus archivelog
2)Make a copy of the backupset
3)Delete the backupset using os commands
4)run rman crosscheck command it should report the backup pieces as expired since they are no longer accessible from the place where rman thinks they should be
5)move the backupsets to the smae place as before
6)run rman crosscheck command rman should recognize the backup pieces and mark them available
regards
Hrishy
Hi,
hrishy I typed the command wrongly as
RMAN>crosscheck backup completed between 'sysdate' and 'sysdate-30';
It should be
RMAN>crosscheck backup completed between 'sysdate-30' and 'sysdate';
as we are searching result from the previous 30 days to till date.
So this is returning me correct output which shows backup files as expired.
Sorry for inconvenience, hrishy I think you are very near to clear my problem as you have understood everything clearly from OS to database. Please help me.
Regards,
Hi
Well now if you have restored the backupsets exactly at the same path from where you had deleted it then the crosscheck backup command should now find that the backupsets are available and should mark them as available
What else do you need ?
regards
Hrishy
Hi,
hrishy sorry to say that again we went back to initial stage. As I said initially that the latest backup sets/files are physically present on disk, I have not deleted them. Than why to restore them?
Regards,
Hi
If the backupsets are present on the disk in the same place as rman expects them to be then you dont need to anything ?
Whats your question now ?
regards
Hrishy
Hi,
Hrishy. Why RMAN showing these backup files as Expired when crosschecked?
Regards,
Hi
RMAN expects them to find at the same place where it previously backed them up.Now not finding it at the same place rman thinks that the backup has expired.
Are these files at the same place where it was backed up
regards
Hrishy
Yes Hrishy, they are at the same place.
Hi
Post the full output of the command
RMAN>crosscheck backup of database completed between 'sysdate-14' and 'sysdate'
regards
Hrishy
Hrishy, this is the output
RMAN> crosscheck backup of database
2> completed between 'sysdate-14' and 'sysdate';
using channel ORA_SBT_TAPE_1
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/4fiq9uj1_1_1 recid=3144 stamp=631568993
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/4giq9uko_1_1 recid=3145 stamp=631569048
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/4hiq9unn_1_1 recid=3146 stamp=631569144
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/4iiq9us9_1_1 recid=3147 stamp=631569289
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/4jiq9uuu_1_1 recid=3148 stamp=631569374
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/4kiq9v0v_1_1 recid=3149 stamp=631569440
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/4liq9v2n_1_1 recid=3150 stamp=631569495
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/4miq9v4e_1_1 recid=3151 stamp=631569550
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/4niq9v65_1_1 recid=3152 stamp=631569606
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/4oiq9v7t_1_1 recid=3153 stamp=631569661
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/4piq9v9u_1_1 recid=3154 stamp=631569727
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/5aiqjugs_1_1 recid=3171 stamp=631896604
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/5biqjuij_1_1 recid=3172 stamp=631896660
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/5ciqjuli_1_1 recid=3173 stamp=631896755
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/5diqjuq4_1_1 recid=3174 stamp=631896900
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/5eiqjusp_1_1 recid=3175 stamp=631896985
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/5fiqjuuq_1_1 recid=3176 stamp=631897051
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/5giqjv0i_1_1 recid=3177 stamp=631897106
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/5hiqjv29_1_1 recid=3178 stamp=631897161
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/5iiqjv40_1_1 recid=3179 stamp=631897217
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/5jiqjv5o_1_1 recid=3180 stamp=631897272
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/5kiqjv7p_1_1 recid=3181 stamp=631897340
Crosschecked 22 objects
Hi
Can you please post the full path where the backup pieces are available on the OS ?
Can you post the values of RMAN CONFIGURATION Parameters especially the retention policy ?
regards
Hrishy
Hi, Hrishy
The OS path for rman backup is
/makkdb1-bk/rman
And the configuration parameters are as follows:
These parameters are set before taking datafiles backup:
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/makkdb1-bk/rma
n/%F';
configuration for DISK channel 2 is ignored
configuration for DISK channel 3 is ignored
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 1;
CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/makkdb1-bk/rman/%U';
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT '/makkdb2-bk/rman/%U';
CONFIGURE CHANNEL 3 DEVICE TYPE DISK FORMAT '/makkdb2-bk/rman/%U';
CONFIGURE MAXSETSIZE TO 5 G;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/9iRAC/dbs/snapcf_rcdb1.f';
These parameters are set before taking backup of archivelogs: only one change mark in red.
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/makkdb1-bk/rman/%F';
configuration for DISK channel 2 is ignored
configuration for DISK channel 3 is ignored
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 1;
CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/makkdb1-bk/rman/arc_%U';
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT '/makkdb2-bk/rman/%U';
CONFIGURE CHANNEL 3 DEVICE TYPE DISK FORMAT '/makkdb2-bk/rman/%U';
CONFIGURE MAXSETSIZE TO 5 G;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/9iRAC/dbs/snapcf_rcdb1.f';
HI
What does list expired backupset return please post the output
Are you sure that the backup was lying there is not more then 30 days old ?
regards
Hrishy
Hi, Hrishy.
The output of the command is scrolling up on screen, any condition can be given to limit output and put in this window.
Hi
Can you paste the output of
Code:select
b.NAME,
a.COMPLETION_TIME,
a.MEDIA,
a.STATUS,
a.HANDLE
from
rc_backup_piece a,
rc_database b
where a.DB_KEY = b.DB_KEY
and HANDLE in
('/makkdb1-bk/rman/4fiq9uj1_1_1',
'/makkdb1-bk/rman/4giq9uko_1_1')
order by b.NAME, a.COMPLETION_TIME, a.STATUS
regards
Hrishy
Hi, Hrishy. The shown ls command shows that the latest backup files exists on disk:
$ cd /makkdb1-bk/rman
$ ls
5aiqjugs_1_1 5fiqjuuq_1_1 5kiqjv7p_1_1
5biqjuij_1_1 5giqjv0i_1_1 arc_5miqjvbh_1_1
5ciqjuli_1_1 5hiqjv29_1_1 arc_5niqjvcm_1_1
5diqjuq4_1_1 5iiqjv40_1_1 c-521704063-20070829-00
5eiqjusp_1_1 5jiqjv5o_1_1 c-521704063-20070829-01
Hrishy, the files in the makkdb2-bk/oracle-bk are daily archive log files backup.
SQL> select handle
2 from rc_backup_piece
3 where completion_time between sysdate-30 and sysdate;
HANDLE
--------------------------------------------------------------------------------
/makkdb2-bk/oracle-bk/arc_12ionbvd_1_1
/makkdb2-bk/oracle-bk/arc_1diov93e_1_1
/makkdb2-bk/oracle-bk/arc_1fiov93k_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070809-01
/makkdb2-bk/oracle-bk/arc_2kipf3bd_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070815-00
/makkdb2-bk/oracle-bk/arc_2mipf5d2_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070815-01
/makkdb2-bk/oracle-bk/arc_2sipkc36_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070817-00
/makkdb2-bk/oracle-bk/arc_52iqenre_1_1
HANDLE
--------------------------------------------------------------------------------
/makkdb2-bk/oracle-bk/c-521704063-20070827-00
/makkdb2-bk/oracle-bk/arc_5riqmkvc_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070830-00
/makkdb2-bk/oracle-bk/arc_5tiqmn11_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070830-01
/makkdb2-bk/oracle-bk/arc_61iqpbd1_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070831-01
/makkdb2-bk/oracle-bk/arc_0pioi37c_1_1
/makkdb2-bk/oracle-bk/arc_0qioi37g_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070804-01
/makkdb2-bk/oracle-bk/arc_11ionbvb_1_1
HANDLE
--------------------------------------------------------------------------------
/makkdb1-bk/rman/1pip52de_1_1
/makkdb1-bk/rman/1qip52f5_1_1
/makkdb1-bk/rman/1rip52i4_1_1
/makkdb1-bk/rman/1sip52ml_1_1
/makkdb1-bk/rman/1tip52pb_1_1
/makkdb1-bk/rman/1uip52rc_1_1
/makkdb1-bk/rman/1vip52t3_1_1
/makkdb1-bk/rman/20ip52ur_1_1
/makkdb1-bk/rman/21ip530i_1_1
/makkdb1-bk/rman/22ip532a_1_1
/makkdb1-bk/rman/23ip534b_1_1
HANDLE
--------------------------------------------------------------------------------
/makkdb1-bk/rman/c-521704063-20070811-01
/makkdb1-bk/rman/arc_25ip5384_1_1
/makkdb1-bk/rman/arc_26ip5398_1_1
/makkdb1-bk/rman/c-521704063-20070811-02
/makkdb2-bk/oracle-bk/arc_3tipuvl1_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070821-01
/makkdb2-bk/oracle-bk/arc_3viq1hve_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070822-00
/makkdb2-bk/oracle-bk/arc_41iq1k11_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070822-01
/makkdb2-bk/oracle-bk/arc_47iq6qn6_1_1
HANDLE
--------------------------------------------------------------------------------
/makkdb2-bk/oracle-bk/c-521704063-20070824-00
/makkdb2-bk/oracle-bk/arc_65iqrvp2_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070901-01
/makkdb2-bk/oracle-bk/arc_30ipn0fe_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070818-00
/makkdb2-bk/oracle-bk/arc_16ioq0bg_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070807-00
/makkdb2-bk/oracle-bk/c-521704063-20070809-00
/makkdb2-bk/oracle-bk/arc_2iipch13_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070814-01
/makkdb2-bk/oracle-bk/arc_3pipsb91_1_1
HANDLE
--------------------------------------------------------------------------------
/makkdb2-bk/oracle-bk/c-521704063-20070820-01
/makkdb2-bk/oracle-bk/arc_45iq48d3_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070823-01
/makkdb1-bk/rman/5aiqjugs_1_1
/makkdb1-bk/rman/5biqjuij_1_1
/makkdb1-bk/rman/5ciqjuli_1_1
/makkdb1-bk/rman/5diqjuq4_1_1
/makkdb1-bk/rman/5eiqjusp_1_1
/makkdb1-bk/rman/5fiqjuuq_1_1
/makkdb1-bk/rman/5giqjv0i_1_1
/makkdb1-bk/rman/5hiqjv29_1_1
HANDLE
--------------------------------------------------------------------------------
/makkdb1-bk/rman/5iiqjv40_1_1
/makkdb1-bk/rman/5jiqjv5o_1_1
/makkdb1-bk/rman/5kiqjv7p_1_1
/makkdb1-bk/rman/c-521704063-20070829-00
/makkdb2-bk/oracle-bk/c-521704063-20070805-01
/makkdb2-bk/oracle-bk/arc_15ioq0ba_1_1
/makkdb1-bk/rman/arc_5miqjvbh_1_1
/makkdb1-bk/rman/arc_5niqjvcm_1_1
/makkdb1-bk/rman/c-521704063-20070829-01
/makkdb2-bk/oracle-bk/c-521704063-20070812-00
/makkdb2-bk/oracle-bk/c-521704063-20070812-01
HANDLE
--------------------------------------------------------------------------------
/makkdb2-bk/oracle-bk/arc_3nips97c_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070820-00
/makkdb2-bk/oracle-bk/arc_43iq46b8_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070823-00
/makkdb2-bk/oracle-bk/arc_54iqept1_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070827-01
/makkdb2-bk/oracle-bk/arc_63iqrtnd_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070901-00
/makkdb2-bk/oracle-bk/arc_67iqui3e_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070902-00
/makkdb2-bk/oracle-bk/arc_69iquk51_1_1
HANDLE
--------------------------------------------------------------------------------
/makkdb2-bk/oracle-bk/c-521704063-20070902-01
/makkdb2-bk/oracle-bk/arc_19ioskna_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070808-00
/makkdb2-bk/oracle-bk/c-521704063-20070808-01
/makkdb2-bk/oracle-bk/arc_1iip1tfj_1_1
/makkdb2-bk/oracle-bk/arc_1lip4hrh_1_1
/makkdb2-bk/oracle-bk/arc_1mip4hrk_1_1
/makkdb2-bk/oracle-bk/arc_3riputje_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070821-00
/makkdb2-bk/oracle-bk/arc_4biq9f3b_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070825-00
HANDLE
--------------------------------------------------------------------------------
/makkdb2-bk/oracle-bk/arc_4uiqc3f7_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070826-00
/makkdb2-bk/oracle-bk/arc_5piqk0jc_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070829-02
/makkdb2-bk/oracle-bk/c-521704063-20070807-01
/makkdb2-bk/oracle-bk/c-521704063-20070813-00
/makkdb2-bk/oracle-bk/arc_2qiphpp1_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070816-01
/makkdb2-bk/oracle-bk/arc_4diq9h51_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070825-01
/makkdb1-bk/rman/4fiq9uj1_1_1
HANDLE
--------------------------------------------------------------------------------
/makkdb1-bk/rman/4giq9uko_1_1
/makkdb1-bk/rman/4hiq9unn_1_1
/makkdb1-bk/rman/4iiq9us9_1_1
/makkdb1-bk/rman/4jiq9uuu_1_1
/makkdb1-bk/rman/4kiq9v0v_1_1
/makkdb1-bk/rman/4liq9v2n_1_1
/makkdb1-bk/rman/4miq9v4e_1_1
/makkdb1-bk/rman/4niq9v65_1_1
/makkdb1-bk/rman/4oiq9v7t_1_1
/makkdb1-bk/rman/4piq9v9u_1_1
/makkdb1-bk/rman/c-521704063-20070825-02
HANDLE
--------------------------------------------------------------------------------
/makkdb1-bk/rman/arc_4riq9vdd_1_1
/makkdb1-bk/rman/arc_4siq9veh_1_1
/makkdb1-bk/rman/c-521704063-20070825-03
/makkdb2-bk/oracle-bk/arc_50iqc5h1_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070826-01
/makkdb2-bk/oracle-bk/arc_56iqhc7f_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070828-00
/makkdb2-bk/oracle-bk/arc_58iqhe94_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070828-01
/makkdb2-bk/oracle-bk/arc_5viqp9be_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070831-00
HANDLE
--------------------------------------------------------------------------------
/makkdb2-bk/oracle-bk/arc_1aioskng_1_1
/makkdb2-bk/oracle-bk/arc_1hip1tfh_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070810-00
/makkdb2-bk/oracle-bk/c-521704063-20070810-01
/makkdb2-bk/oracle-bk/c-521704063-20070811-00
/makkdb2-bk/oracle-bk/arc_28ip7679_1_1
/makkdb2-bk/oracle-bk/arc_29ip767e_1_1
/makkdb2-bk/oracle-bk/arc_2cip9qjc_1_1
/makkdb2-bk/oracle-bk/arc_2dip9qje_1_1
/makkdb2-bk/oracle-bk/arc_2oiphnne_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070816-00
HANDLE
--------------------------------------------------------------------------------
/makkdb2-bk/oracle-bk/arc_49iq6sp3_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070824-01
/makkdb2-bk/oracle-bk/c-521704063-20070804-00
/makkdb2-bk/oracle-bk/c-521704063-20070805-00
/makkdb2-bk/oracle-bk/arc_0tioknjc_1_1
/makkdb2-bk/oracle-bk/arc_0uioknjh_1_1
/makkdb2-bk/oracle-bk/arc_2gipcevh_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070814-00
/makkdb2-bk/oracle-bk/arc_2uipke52_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070817-01
/makkdb2-bk/oracle-bk/arc_32ipn2h2_1_1
HANDLE
--------------------------------------------------------------------------------
/makkdb2-bk/oracle-bk/c-521704063-20070818-01
/makkdb2-bk/oracle-bk/c-521704063-20070806-00
/makkdb1-bk/rman/34ipnfsl_1_1
/makkdb1-bk/rman/35ipnfud_1_1
/makkdb1-bk/rman/36ipng1c_1_1
/makkdb1-bk/rman/37ipng5t_1_1
/makkdb1-bk/rman/38ipng8i_1_1
/makkdb1-bk/rman/39ipngak_1_1
/makkdb1-bk/rman/3aipngcb_1_1
/makkdb1-bk/rman/3bipnge2_1_1
/makkdb1-bk/rman/3cipngfq_1_1
HANDLE
--------------------------------------------------------------------------------
/makkdb1-bk/rman/3dipnghh_1_1
/makkdb1-bk/rman/3eipngjj_1_1
/makkdb1-bk/rman/c-521704063-20070818-02
/makkdb1-bk/rman/arc_3gipngn1_1_1
/makkdb1-bk/rman/arc_3hipngns_1_1
/makkdb1-bk/rman/c-521704063-20070818-03
/makkdb2-bk/oracle-bk/arc_3jippkr7_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070819-00
/makkdb2-bk/oracle-bk/arc_3lippmt1_1_1
/makkdb2-bk/oracle-bk/c-521704063-20070819-01
175 rows selected.
Hi
Can you post the output of
Code:select
b.NAME,
a.COMPLETION_TIME,
a.MEDIA,
a.STATUS,
a.HANDLE
from
rc_backup_piece a,
rc_database b
where a.DB_KEY = b.DB_KEY
and HANDLE in
('/makkdb1-bk/rman/4fiq9uj1_1_1',
'/makkdb1-bk/rman/4giq9uko_1_1')
order by b.NAME, a.COMPLETION_TIME, a.STATUS
Hi, Hrishy. the output
SQL> select b.name,a.completion_time,
2 a.media,a.status,a.handle
3 from rc_backup_piece a,
4 rc_database b
5 where a.DB_KEY=b.DB_KEY
6 and handle in
7 ('/makkdb1-bk/rman/4fiq9uj1_1_1','/makkdb1-bk/rman/4giq9uko_1_1')
8 order by b.name,a.completion_time,a.status;
NAME COMPLETIO MEDIA
-------- --------- --------------------------------------------------------------------------------
S
-
HANDLE
----------------------------------------------------------------------------------------------------
RACDB 25-AUG-07
X
/makkdb1-bk/rman/4fiq9uj1_1_1
RACDB 25-AUG-07
X
/makkdb1-bk/rman/4giq9uko_1_1
Hi
Well rman says that your backups have expired based on the contents of the catalog.
I would suggest you do a clean test just to discount something funny from this whole exercise
First delete the expired
1)delete expired backup
2)backup database plus archivelog
3)Backup the files to some other location or tape
3)remove the files using host command using rm
4)run crosscheck command rman should report the backup as expired
5)restore the files to the same location
6)run crosscheck command rman should mark the backups as available
Let me know if you are able to reproduce whatever happened till now
regards
Hrishy
I hope the permissions on these files /makkdb1-bk/rman/4fiq9uj1_1_1 are 666
so rman can read them ?