1

Topic: recover database

Help, please, somebody. One of hards was screwed, a hard recovered, the basis does not open. Last full  the monthly prescription - very much would like to recover basis in later variant. Here that writes:
SQL> recover automatic database using backup controlfile
ORA-00279: the change 327738955 generated 01/15/2018 5:11:03 PM, is necessary
For 1
ORA-00289: a sentence:
C:\ORA\BIZ\FLASH_RECOVERY_AREA\AEROGEO\ARCHIVELOG\2018_03_01\O1_MF_1_11471 _ % U_. A
RC
ORA-00280: change 327738955 for a flow 1 in sequence #11471
ORA-00278: a legal file
' C:\ORA\BIZ\FLASH_RECOVERY_AREA\AEROGEO\ARCHIVELOG\2018_03_01\O1_MF_1_11471 _ % U_.
ARC ' more it is not necessary for this recovery
ORA-00308: cannot open archived log
' C:\ORA\BIZ\FLASH_RECOVERY_AREA\AEROGEO\ARCHIVELOG\2018_03_01\O1_MF_1_11471 _ % U_.
ARC'
ORA-27041: unable to open file
OSD-04002: it is impossible to open a file
O/S-Error: (OS 2) it is not possible to find the specified file.
Set log: {<RET> = | file name | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log
' C:\ORA\BIZ\FLASH_RECOVERY_AREA\AEROGEO\ARCHIVELOG\2018_03_01\O1_MF_1_11471 _ % U_.
ARC'
ORA-27041: unable to open file
OSD-04002: it is impossible to open a file
O/S-Error: (OS 2) it is not possible to find the specified file.
ORA-00308: cannot open archived log
' C:\ORA\BIZ\FLASH_RECOVERY_AREA\AEROGEO\ARCHIVELOG\2018_03_01\O1_MF_1_11471 _ % U_.
ARC'
ORA-27041: unable to open file
OSD-04002: it is impossible to open a file
O/S-Error: (OS 2) it is not possible to find the specified file.
SQL> alter database open resetlogs;
alter database open resetlogs
*
Error in line 1:
ORA-01113: for a file 1 carrier recovery is required
ORA-01110: the data file 1: ' C:\ORA\BIZ\ORADATA\AEROGEO\SYSTEM01.DBF'
SQL> recover datafile 1;
ORA-00283: the recovery session is excellent because of errors
ORA-01610: it is necessary to fulfill recovery, using option BACKUP CONTROLFILE
Thanks.

2

Re: recover database

SBZN wrote:

SQL> alter database open resetlogs;

Ah the good fellow.
Copy of files that saved?

3

Re: recover database

mefman, what?

4

Re: recover database

SBZN wrote:

C:\ORA\BIZ\FLASH_RECOVERY_AREA\AEROGEO\ARCHIVELOG\2018_03_01

So what disk that collapsed? With?
In  broad gulls remained or not?

5

Re: recover database

SBZN wrote:

ORA-01113: for a file 1 carrier recovery is required
ORA-01110: the data file 1: ' C:\ORA\BIZ\ORADATA\AEROGEO\SYSTEM01.DBF '

I suppose, proceeding from the given way, given on With a disk just and ...
Correctly I understand?
, and  there become?

6

Re: recover database

Q.Tarantino, generally it is not clear that there happens. There were 3 disks, the basis hung on With ssd, in due course rested against shortage of the disk, one of files has been transferred on disk , the basis worked. After that the administrator replaced ssd on  one month ago. Like all too worked. Yesterday it was necessary  from basis, there was no communication on an Internet on 1521 (it at our administrator happens), got on  on a computer, there   about incapacity of basis. It was clarified that that separate file on , and a disk began to be called , and most  at all did not become for some reason. I renamed a disk, restarted Windows. The computer was not launched at all. Knocked to the administrator. That reported on changeover of loops of a supply by hards then the computer was launched. And from this point on the tambourine began.

7

Re: recover database

SBZN;
Well and before it

wrote:

recover automatic database using backup controlfile

What there was that?  a computer?  on a place? A file on it on a place?
Basis on what  at start?

8

Re: recover database

Q.Tarantino, at start swore that the basis is not opened. Therefore swore on a file 4, which just on . On it  too long swore, like even told with abuse that it . Then started to swear on 1 already. Well and here already the tambourine of couples does not gain.

9

Re: recover database

SBZN wrote:

Q.Tarantino, at start swore that the basis is not opened. Therefore swore on a file 4, which just on . On it  too long swore, like even told with abuse that it . Then started to swear on 1 already. Well and here already the tambourine of couples does not gain.

It is clinic...
It is accepted not to write similar, and
- That was in  at the first attempt to lift a DB
- What  fulfilled.
And so this guessing on a coffee thick.
And yes, and where then files from disk , what in FRA lay? He, how I understood, remained on a place?.

10

Re: recover database

Q.Tarantino, what such fra? Where ?

11

Re: recover database

SBZN wrote:

Q.Tarantino, what such fra? Where ?

.
Hammer. Return to  monthly prescription smile

12

Re: recover database

Q.Tarantino, there are basis files. How them to connect? What difference, what in broad gulls?

13

Re: recover database

SBZN wrote:

Q.Tarantino, there are basis files. How them to connect? What difference, what in broad gulls?

And how you disconnected them? smile

14

Re: recover database

Q.Tarantino, in any way.

15

Re: recover database

SBZN wrote:

Q.Tarantino, in any way.

Then what for to connect? All should be connected. smile
On business - you so wrote "at first on that swore much, then on that..."
As a result, without knowledge of a question, I suspect that you made only worse.
Here you can describe what actions you did and for what reason?

16

Re: recover database

Q.Tarantino, a market about what, as well as always at this forum. Though one sentence on business.

17

Re: recover database

SBZN;
On business.  in studio. Though it is finite Tarantino of the rights - the medicine here is powerless.

18

Re: recover database

mefman, really, 10 years on a forum did not come, and changed nothing - one .

19

Re: recover database

Fuck-up, here also talked smile
One leading question did not answer, and  we smile
As always, anything new for 10 years smile

20

Re: recover database

To store database files on system a disk,  it is interesting.
I so understood a database  through Rman?
And where Rman copied the data?

21

Re: recover database

SAS2014 wrote:

to Store database files on system a disk,  it is interesting.
I so understood a database  through Rman?
And where Rman copied the data?

in a bath. A question ...

22

Re: recover database

mefman wrote:

it is passed...
in a bath. A question ...

Grief...