| Few questions on RMAN [message #200954] |
Thu, 02 November 2006 01:10  |
reena_ch30
Messages: 100
Registered: December 2005
|
Senior Member |
|
|
Few questions on RMAN :
1)How can we remove backup entries from controlfile if controlfile is used as repository?
2)When multiple identical backups are taken of a database, which backup would the restore command pick?
3) If we have a backup of tablespace (with datfile 1) and backup of full database(with no changes), which backup would be picked to restore datafile 1?
4) Can we force RMAN to pick a specified backup if all backups are identical?
Thanks,
Reena
|
|
|
|
|
|
| Re: Few questions on RMAN [message #200982 is a reply to message #200954] |
Thu, 02 November 2006 02:18  |
reena_ch30
Messages: 100
Registered: December 2005
|
Senior Member |
|
|
Hi,
Thanks for the link. I checked for control file backup info deletion. It talks about control_file_record_keep_time to keep backup info. for specified no. of days before being reused. What if i want to delete the backup info. now?
Thanks
Reena
|
|
|
|
| Re: Few questions on RMAN [message #201042 is a reply to message #200982] |
Thu, 02 November 2006 06:08 |
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
|
Senior Member |
|
|
control_file_record_keep_time
Control file : are circularly reusable fashion.
and it keeps 1.archive log records and various bkp records.
It is not apply for records such as datafile, tablespace, and redo thread records, which are never reused unless the corresponding object is dropped from the tablespace.
Control file size also depand on "Control_file_record_keep_time" parameter.
Plz. Go through below link
8.1.2.2 Interaction of Flash Recovery Area and CONTROL_FILE_RECORD_KEEP_TIME
1.http://download-west.oracle.com/docs/cd/B19306_01/backup.102/b14192/maint001.htm#sthref691
Hope this Helps.
Mohammad Taj.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
