Thanks rafiq ,
will hope that the gurus of Oracle smile upon us mortals soon.
- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Saturday, June 21, 2003 03:14
: Sorry, I never used RMAN so far but this point came in my mind. I am
: surprised why Robert is not giving you a reply.
:
: Regards
: Rafiq
:
:
:
:
: Reply-To: [EMAIL PROTECTED]
: To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
: Date: Fri, 20 Jun 2003 09:45:11 -0800
:
: Rafiq that is a good point , but I have set
: my control_file_record_keep_time=7 (which is also the default , I
: think )
: and recovery window is 4 days
:
: Anything else to check ?
: ........................
:
: ----- Original Message -----
: To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
: Sent: Friday, June 20, 2003 08:14
:
:
: : Is your control_file_record_keep_time database parameter value is
: less than
: : the time set for retention policy?
: : I am not using rman but in Robert Freeman's 9i new features book I
: saw
: : aboves point.
: :
: : It might help or Robert may see your message and suggest some
: solution.
: :
: : Regards
: : Rafiq
: :
: :
: :
: :
: : Reply-To: [EMAIL PROTECTED]
: : To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
: : Date: Thu, 19 Jun 2003 18:09:18 -0800
: :
: : Hello List, sorry about posting this again but , no one responded
: and
: : I am really stuck
: : I am using Oracle 9i release 2 enterprise edition on win32
: :
: : After connecting thru rman , I made sure that I did not have any
: : backupsets by running
: : delete backup ;
: : and then checked with list backup ;
: :
: : I have set a recovery window of 4 days with :
: : CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 4 DAYS;
: :
: : And enabled autobackup of controlfiles and spfiles :
: : CONFIGURE CONTROLFILE AUTOBACKUP ON;
: : CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO
: : 'D:\%F';
: :
: : Then I created a backup of the entire database :
: : backup database ;
: : (This created a separate backup piece :
D:\C-2202427048-20030619-05)
: :
: : This is the only backup of the control file I have. I checked
with
: : RMAN> LIST BACKUP OF CONTROLFILE;
: :
: : List of Backup Sets
: : ===================
: :
: : BS Key Type LV Size Device Type Elapsed Time Completion
Time
: :
:
: ------- ---- -- ---------- ----------- ------------ ----------------
: --
: : --
: : 60 Full 672K DISK 00:00:02 19-Jun-2003
: 08:04:
: : 42
: : BP Key: 60 Status: AVAILABLE Tag:
: : Piece Name: D:\C-2202427048-20030619-05
: : Controlfile Included: Ckp SCN: 190854 Ckp time:
19-Jun-2003
: : 08:04:40
: :
: : Now when I run report obsolete ;
: : Its gives me the following o/p
: :
: : RMAN retention policy will be applied to the command
: : RMAN retention policy is set to recovery window of 4 days
: : Report of obsolete backups and copies
: : Type Key Completion Time Filename/Handle
:
: -------------------- ------ ------------------ --------------------
: : Backup Set 60 19-Jun-2003 08:04:42
: : Backup Piece 60 19-Jun-2003 08:04:42
: : D:\C-2202427048-20030619-05
: :
: : Why is this sole backup of the controlfile , obsolete ?
: : If someone runs a delete obselete; they will delete this backup.
: :
: :
:
: --
: Please see the official ORACLE-L FAQ: http://www.orafaq.net
: --
: Author: <[EMAIL PROTECTED]
: INET: [EMAIL PROTECTED]
:
: Fat City Network Services -- 858-538-5051 http://www.fatcity.com
: San Diego, California -- Mailing list and web hosting
services
: --------------------------------------------------------------------
-
: To REMOVE yourself from this mailing list, send an E-Mail message
: to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
: the message BODY, include a line containing: UNSUB ORACLE-L
: (or the name of mailing list you want to be removed from). You may
: also send the HELP command for other information (like subscribing).
:
: _________________________________________________________________
: Help STOP SPAM with the new MSN 8 and get 2 months FREE*
: http://join.msn.com/?page=features/junkmail
:
: --
: Please see the official ORACLE-L FAQ: http://www.orafaq.net
: --
: Author: M Rafiq
: INET: [EMAIL PROTECTED]
:
: Fat City Network Services -- 858-538-5051 http://www.fatcity.com
: San Diego, California -- Mailing list and web hosting
services
: --------------------------------------------------------------------
-
: To REMOVE yourself from this mailing list, send an E-Mail message
: to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
: the message BODY, include a line containing: UNSUB ORACLE-L
: (or the name of mailing list you want to be removed from). You may
: also send the HELP command for other information (like subscribing).
:
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <[EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Jun 20 2003 - 21:20:12 CDT
