1

Topic: Backup Redlog

RMAN> At Backup database;
There is a backup copy only.DBF and how to make that both  and REDO LOG and how to do recover database if is not present Redo Log files

2

Re: Backup Redlog

alter system switch logfile
backup archivelog...

3

Re: Backup Redlog

Yes - and a DB in a mode archivelog????

4

Re: Backup Redlog

landy wrote:

Yes - and a DB in a mode archivelog????

Yes in a mode archivelog

5

Re: Backup Redlog

Goofy122;
Generally it becomes here so:

RMAN> Backup database plus archivelog

But on me it is better to archive pens broad gulls.
RMAN generally very much  .

6

Re: Backup Redlog

maverick2104 wrote:

Goofy122;
Generally it becomes here so:

RMAN> Backup database plus archivelog

But on me it is better to archive pens broad gulls.
RMAN generally very much  .

And I do, backup basis and archive dens all norms.
I delete all that is stored in Oracle\oradata\orcl: Controlfile.DBF and Redolog 01, 02, 03.
restore control file from ' <path> '; - Kontrol of a fillet was recovered
Then restore database.DBF too were recovered, but without files.
Then RECOVER DATABASE; and here

ORA-00283: recovery session canceled due to errors
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: ' E:\ORACLE\ORADATA\ORCL\REDO01.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

Is not present  to recover.
What I not correctly made? And how them to recover if they have been remote?

7

Re: Backup Redlog

Goofy122;
But without files Redo LOG

8

Re: Backup Redlog

I can register certainly shell script.sh in linux through crontab daily to copy and archive in.zip, but really oracle did not provide backup ?

9

Re: Backup Redlog

maverick2104 wrote:

But on me it is better to archive pens broad gulls.
RMAN generally very much  .

What??? 8-o

10

Re: Backup Redlog

[quote =-2] Goofy122;
online redo it is useless jotas-bakapit, and in an offline they are not necessary. For their safety mirroring is used. If all copies actual  are lost, recovery from  to the last actual state is impossible. Only until... According to present archive-redo. And accordingly open with reset logs.

Whether tell please enough once to save copies REDO LOG -  or them it is necessary to reserve every day?