OraFAQ Forum: Backup & Recovery » applying RMAN hot backups on cold backup

Home » RDBMS Server » Backup & Recovery » applying RMAN hot backups on cold backup

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

applying RMAN hot backups on cold backup [message #117965]

Mon, 02 May 2005 03:51

rohitr
Messages: 1
Registered: May 2005

Junior Member

I've cold backup taken on Friday.
I took hot incremental backups on mon,tue.
On wed system crashes.
I need to apply hot backups of mon,tue on cold backup of fri.
Is there any way out to do this,and to make up database with data up to tue.

Report message to a moderator

Re: applying RMAN hot backups on cold backup [message #118131 is a reply to message #117965]

Tue, 03 May 2005 03:27

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

If you use RMAN for your hot and cold backups, you should not have any problem restoring. For more details (and some examples), see the RMAN manual.

CONNECT TARGET /
CONNECT CATALOG rman/rman@orcl
STARTUP FORCE MOUNT;
RUN {
  SET UNTIL TIME = "to_date('03-MAY-2005 19:18:29','DD-MON-YYYY HH24:MI:SS')";
  ALLOCTE CHANNEL t1 TYPE 'SBT_TAPE';
  RESTORE DATABASE;
  RECOVER DATABASE;
}
ALTER DATABASE OPEN RESETLOGS;

Best regards.

Frank

Report message to a moderator

Previous Topic:	when to delete archive log file
Next Topic:	10g Archive log files fill disk

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 15:08:28 CST 2024