| shipon |
Posted: Apr 22, 2008 05:06:50 AM |
Total Post: 27
Joined: Feb, 2008
|
Dear friends ,
I have two Questions regarding RMAN :
1) I have to run RMAN script in my Oracle10g based Production server . Every night I take RMAN backup into my storage . Now My question is :
Is it possible to take my database 7 days ago using my lastday backup of RMAN ? i,e, Can RMAN take my database before 6/7 days ago , where my last RMAN backup is taken yesterday ?
2)
My 2nd question is :
In nomount stage when I m going to take RMAN level0 backup using follwoing script :
run
{
allocate channel t1 type disk;
backup incremental level 0
format 'F:\rman_backup\bak_%s_%T_level0.bak'
database include current controlfile plus archivelog;
}
It shows the following error :
using target database control file instead of recovery catalog
allocated channel: t1
channel t1: sid=156 devtype=DISK
Starting backup at 22-APR-08
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 04/22/2008 14:55:59
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TESTDB\ARCHIVELOG\2008_04_22\O1_MF_1_1_40V98OWS_.ARC
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
Here I dont understand why it searches for O1_MF_1_1_40V98OWS_.ARC archive log ? I think, I delete it in my absent mind . Plz help me in this moment how can I run level 0 backup now ?
Waiting for ur reply .. ...
|
|
|
 GOPU |
| Posted: Apr 22, 2008 06:14:40 AM |  |
|
Total Post: 239
Joined: Apr, 2008
|
Hi,
i did't get your first question ? what you mean in that ? and tell me what is your requirement ?
In the second one your archive log is missing may be you accidently deleted it.
you crosscheck the archivelogs and try to take the backup again
regards
Gopu
|
|
|
|
|
| Gitesh |
| Posted: Apr 29, 2008 01:20:24 AM | |
|
Total Post: 322
Joined: May, 2005
|
Answer of your first question.
RMAN can't take backup of database before 7 days ago. If you took backup using RMAN before 7 days and store in the tape media or storage then you can take same backup in the tape. How RMAN identified this backup it depends upon RETENTION POLICY of RMAN.
|
|
|
|
|
| GOPU |
| Posted: Apr 29, 2008 01:29:19 AM | |
|
Total Post: 239
Joined: Apr, 2008
|
Hi,
RMAN cant take backup of a database before 7 days agae ? why ?
I think it depends on the retention ploicy of RMAN.If i increase the policy to 14 days, then it will take the backup ?
Regards
Gopu
|
|
|
|
|
| shipon |
| Posted: Apr 29, 2008 06:57:28 AM | |
|
Total Post: 27
Joined: Feb, 2008
|
Thx Gitesh and Gopu for ur replies .
Now I want to know how is it possible to remove all the RMAN related information from the control files . Is it possible to do ?
Plz inform .. ...
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
