| Can we recover archived logs from new backups [message #482840] |
Tue, 16 November 2010 03:05  |
SystemEng
Messages: 12
Registered: November 2010
|
Junior Member |
|
|
Hello
I have been able to restore/recover rman incremental backups on a fresh database.
What i dont understand is how rman does the restore.
I have incremental backup 0 and 1 everyday.
I thought if i copied the latest backup 0 and followd by its incremental 1, rman would restore.
But it was not the case , i had to put older backups to be able to restore all files.
Why is it so.
Also, if i restored the database successfully, wouldn't a simple recover database with latest backups update the database?. I mean i dont need to restore the database with new control file each time?. The recover database command would take the backup archived logs and restore them?
Else wats the use of doing new backups if its to restore the database only from spfile each time.
Im a bit confused as to how rman restores.
Thanks
|
|
|
|
|
|
| Re: Can we recover archived logs from new backups [message #482844 is a reply to message #482841] |
Tue, 16 November 2010 03:29  |
SystemEng
Messages: 12
Registered: November 2010
|
Junior Member |
|
|
From the previous post to this one, i came to understand that i need to copy archived logs to the standby database before doing a restore. Having done so, i had the two databases with the same info in the v$Archived_log table.
What I still dont understand is given that i have incremental backups 0 and 1 twice a day, how can i restore the backup archived logs (let say i cant keep track of the archived logs since they are deleted on each rman backup done, meaning the log is switched and are backuped and then deleted).
At time t1 on day 1, i restored/recover a fresh database.
At time t2 on day 1, there are backups being done on the primary database hence contain the archived logs.
when i copy the recent backups to the standby database..then i do
RESTORE ARCHIVELOG ALL;
RMAN-06026: some targets not found - aborting restore
RMAN-06025: no backup of log thread 1 seq 1076 lowscn 18315311 found to restore
May Im doing it the wrong way??
Else , i dont see the use of so many incremental backups if i cant restore only archived logs on the standby database.
|
|
|
|
| Re: Can we recover archived logs from new backups [message #482848 is a reply to message #482844] |
Tue, 16 November 2010 04:56 |
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Hello, SystemEng - from this post and your earlier posts, I am wondering what you actually want to do. Are you trying to create a copy of the database, which you update regularly with all changes applied on the original database? If so, the Oracle product you need is Data Guard - but unfortunately, Data Guard requires Enterprise Edition licenses. However, you can do the same thing manually with standard edition, this doc explains how
http://www.orafaq.com/papers/create_non_managed_standby_db.pdf
This technique might be much easier than the way you are doing it now.
If you are trying to do something different, please ignore this.
|
|
|
|
|
|
|
|
| Re: Can we recover archived logs from new backups [message #482961 is a reply to message #482863] |
Wed, 17 November 2010 02:27 |
SystemEng
Messages: 12
Registered: November 2010
|
Junior Member |
|
|
How can we delete backup archived logs manually without using the command DELETE INPUT..
Since in our backup procedures, we switch log before backup. Hence i will always lose one of the Archived Logs.
I have been requested to manage the deletion rather than rman does it. So i must be sure that they have been properly backup then only i can delete them.
Any help please
|
|
|
|
| Re: Can we recover archived logs from new backups [message #483076 is a reply to message #482961] |
Thu, 18 November 2010 02:28 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
Hi
To delete all archivelog on disk no matter whether they are backed up or not ...
RMAN > delete archivelog all;
To delete all archivelog on disk no matter wether they are backed up or not and are one day old ...
RMAN > delete archivelog all completed before 'sysdate -1';
To Delete archived redo logs from disk based on whether they are backed up on tape:
DELETE ARCHIVELOG ALL
BACKED UP 1 TIMES TO sbt;
Alternatively, after manually deleting archive log files, run the following from RMAN
run {
crosscheck archivelog all;
delete expired archivelog all;
}
This will crosscheck existing archivelogs and will show you the ones which are EXPIRED and need to be deleted, that is, they are not on the disks anymore, cause you have deleted them not using RMAN.
Regards
Girish
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
