Reply from khemmerl on Jan 17 at 5:21 PM Crosscheck is just a check - you still have to issue a command to tell RMAN that the missing files are no longer available. Use DELETE [NOPROMPT] EXPIRED ARCHIVELOG <LOG_NAME>.
> RMAN> change archivelog all crosscheck;
>
> allocated channel: ORA_DISK_1
> channel ORA_DISK_1: sid=33 devtype=DISK
> validation failed for archived log
> archive log filename=/u02/arch/arch_1_0000002653.arc recid=2655 stamp=563973106
> validation succeeded for archived log
> archive log filename=/u02/arch/arch_1_0000002654.arc recid=2656 stamp=563973108
>
> RMAN> delete expired archivelog '/u02/arch/arch_1_0000002653.arc';
>
> using channel ORA_DISK_1
>
> List of Archived Log Copies
> Key Thrd Seq S Low Time Name
> ------- ---- ------- - --------- ----
> 782782 1 2653 X 17-JUL-05 /u02/arch/arch_1_0000002653.arc
>
> Do you really want to delete the above objects (enter YES or NO)? yes
> deleted archive log
> archive log filename=/u02/arch/arch_1_0000002653.arc recid=2655 stamp=563973106
>
Ken
| | | ---------------Original Message---------------
From: Michael Chapman
Sent: Tuesday, January 10, 2012 11:21 AM
Subject: Oracle Backup/Recovery Situation
I need an Oracle backup/recovery experts advice in a big way. I have inherited an Oracle DB running on a Solaris flavor of Unix. I discovered it was not using RMAN and has never been backed up. The DB is in archivelog mode and I have about 300GB of redo logs dating back to March of 2008. Currently the only 'backup' available are OS copies of the directories the datafiles, log files and product files reside on which are produced each night abd stored on a TSM server. I have successfully copied the files, logs, etc. down to a development box, started, mounted and opened the DB and used RMAN to make a full backup of the development instance. Due to space constraints I had to remove all the archive logs in order to have enough space to place the backup on.
My question is can I do the same thing on the Production instance and end up with a valid recovery base copy, remove the old log files and begin to manage them through RMAN's retention policy? I am a SQL SERVER/DB2 DBA so I am also way out of my comfort zone here. |
| Reply to this email to post your response. __.____._ |  _.____.__ |
No comments:
Post a Comment