Networker

[Networker] General Oracle RMAN backup/recover question?

2007-05-01 13:53:31
Subject: [Networker] General Oracle RMAN backup/recover question?
From: George Sinclair <George.Sinclair AT NOAA DOT GOV>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Tue, 1 May 2007 13:50:23 -0400
Hi,

General question here about Oracle backups using RMAN with the NetWorker Oracle module.

1. Is is recommended to take a level full backup after the database has been re-started?

We're thinking that just because the database is shut down for whatever reason and later restarted that we should be able to simply continue with the same backup schedule as before. So, if the next scheduled backup calls for an incremental then that's what we run. However,
would re-starting the database in any way require you to run a full?

2. What if you recover an older version of the database? Then should you take a full backup
after the recovery?

Our current backup strategy is level 0 (full) once per week with level 1 backups (cumulative incrementals)
all other days of the week.

Thanks.

George

--
George Sinclair - NOAA/NESDIS/National Oceanographic Data Center
SSMC3 4th Floor Rm 4145       | Voice: (301) 713-3284 x210
1315 East West Highway        | Fax:   (301) 713-3301
Silver Spring, MD 20910-3282  | Web Site:  http://www.nodc.noaa.gov/
- Any opinions expressed in this message are NOT those of the US Govt. -
To sign off this list, send email to listserv AT listserv.temple DOT edu and type 
"signoff networker" in the body of the email. Please write to networker-request 
AT listserv.temple DOT edu if you have any problems with this list. You can access the 
archives at http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER

<Prev in Thread] Current Thread [Next in Thread>