RE: [sap-basis] How to recover datafile?
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by Basis Consultant (SAP Basis Administrator) on Mar 5 at 6:12 AM |  Mark as helpful |
Hi,
First, you check the status of the datafiles using following command.
Select Distinct Status from v$datafile;
Check if any datafile is in RECOVER status
Select File#, Name From v$Datafile Where STATUS='RECOVER';
Then recover the datafiles where are in Recover mode
Recover datafile <File#>
It may ask you about the archive file. Please provide the correct path
to your oraarch directory.
When the Datafile is recovered successfully.
Alter datafile <File#> ONLINE;
Regards
Mradul Sahney
________________________________
From: maheshkhairnar via sap-basis
[mailto:sap-basis@Groups.ITtoolbox.com]
Sent: Friday, March 05, 2010 2:21 PM
To: Mradul Sahney
Subject: Re: [sap-basis] How to recover datafile?
Posted by maheshkhairnar
on Mar 5 at 3:56 AM
Mark this reply as helpfulMark as helpful
<http://it.toolbox.com/api/ContentVote/3351532/1/1 />
Hi,
You have to recover databse using backup controlfile clause.
u can use following command
recover database using backup control file;
remember to apply the archive to it and then cancel and open in
resetlogs
option.
On Fri, Mar 5, 2010 at 12:05 PM, SAP-Della via sap-basis <
sap-basis@groups.ittoolbox.com> wrote:
> Posted by SAP-Della
> on Mar 5 at 1:38 AM
> Hi all,
> we're unable to start our db
>
> ORA-01195: online backup of file 1 needs more recovery to be
consistent
> ORA-01110: data file 1: '/oracle/CAP/sapdata1/system_1/system.data1'
>
> when I run recover datafile
'/oracle/CAP/sapdata1/system_1/system.data1' ;
>
> ORA-00283: recovery session canceled due to errors
> ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
>
> How to recover that file?
>
> Thanks.
>
> Della
__.____._ First, you check the status of the datafiles using following command.
Select Distinct Status from v$datafile;
Check if any datafile is in RECOVER status
Select File#, Name From v$Datafile Where STATUS='RECOVER';
Then recover the datafiles where are in Recover mode
Recover datafile <File#>
It may ask you about the archive file. Please provide the correct path
to your oraarch directory.
When the Datafile is recovered successfully.
Alter datafile <File#> ONLINE;
Regards
Mradul Sahney
________________________________
From: maheshkhairnar via sap-basis
[mailto:sap-basis@Groups.ITtoolbox.com]
Sent: Friday, March 05, 2010 2:21 PM
To: Mradul Sahney
Subject: Re: [sap-basis] How to recover datafile?
Posted by maheshkhairnar
on Mar 5 at 3:56 AM
Mark this reply as helpfulMark as helpful
<http://it.toolbox.com/api/ContentVote/3351532/1/1 />
Hi,
You have to recover databse using backup controlfile clause.
u can use following command
recover database using backup control file;
remember to apply the archive to it and then cancel and open in
resetlogs
option.
On Fri, Mar 5, 2010 at 12:05 PM, SAP-Della via sap-basis <
sap-basis@groups.ittoolbox.com> wrote:
> Posted by SAP-Della
> on Mar 5 at 1:38 AM
> Hi all,
> we're unable to start our db
>
> ORA-01195: online backup of file 1 needs more recovery to be
consistent
> ORA-01110: data file 1: '/oracle/CAP/sapdata1/system_1/system.data1'
>
> when I run recover datafile
'/oracle/CAP/sapdata1/system_1/system.data1' ;
>
> ORA-00283: recovery session canceled due to errors
> ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
>
> How to recover that file?
>
> Thanks.
>
> Della
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
_.____.__ 
