Home » RDBMS Server » Backup & Recovery » Few questions on RMAN
Few questions on RMAN [message #200954] Thu, 02 November 2006 01:10 Go to next message
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 #200963 is a reply to message #200954] Thu, 02 November 2006 01:28 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

For ur above question plz go through documentation.

http://download-west.oracle.com/docs/cd/B19306_01/backup.102/b14191/toc.htm

hope this helps
Mohammad Taj.
Re: Few questions on RMAN [message #200982 is a reply to message #200954] Thu, 02 November 2006 02:18 Go to previous messageGo to next message
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 Go to previous message
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.
Previous Topic: Recovery with Parrallelism
Next Topic: Creating Database in Oracle 10g
Goto Forum:
  


Current Time: Sat Dec 03 15:56:17 CST 2016

Total time taken to generate the page: 0.07914 seconds