Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
http://www.free-online-exams.com
Problem Description: While cloning getting ORA-01034:Oracle Not available
When attempting to Use rapidclone to clone the database
the following error occurs.
ERROR
-----------------------
Control file created.
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oradata1/addev/system01.dbf'
On alert log file,
alter database open resetlogs
ORA-1194 signalled during: alter database open resetlogs...
ORACLE instance started.
Total System Global Area 1073741824 bytes
Fixed Size 2232104 bytes
Variable Size 435744984 bytes
Database Buffers 624951296 bytes
Redo Buffers 10813440 bytes
Control file created.
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oradata1/addev/system01.dbf'
The issue can be reproduced at will with the following steps:
1. perl adcfgclone.pl dbTier
Justification:
When using rapidclone the source database always need to be stopped using normal. see from: Note:230672.1 - Cloning Oracle Applications Release 11i with Rapid Clone :
Copy the Database Tier File System
Log on to the Source System Database Node as the ORACLE user.
* Perform a normal shutdown of the Source System Database
* Copy the Database (DBF) files from the Source to the Target System
Solution:
The issue is caused by the following: source database not stopped correctly causing a DB not to be consistent
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oradata1/addev/system01.dbf'
This means the source database was not stopped properly. When cloning the DB the source needs to be stopped using shutdown normal.
Do the following to fix:
1 - Stop the source database using shutdown normal
2 - Copy the datafiles again
3 - execute the rapidclone scripts again.
When attempting to Use rapidclone to clone the database
the following error occurs.
ERROR
-----------------------
Control file created.
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oradata1/addev/system01.dbf'
On alert log file,
alter database open resetlogs
ORA-1194 signalled during: alter database open resetlogs...
ORACLE instance started.
Total System Global Area 1073741824 bytes
Fixed Size 2232104 bytes
Variable Size 435744984 bytes
Database Buffers 624951296 bytes
Redo Buffers 10813440 bytes
Control file created.
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oradata1/addev/system01.dbf'
The issue can be reproduced at will with the following steps:
1. perl adcfgclone.pl dbTier
Justification:
When using rapidclone the source database always need to be stopped using normal. see from: Note:230672.1 - Cloning Oracle Applications Release 11i with Rapid Clone :
Copy the Database Tier File System
Log on to the Source System Database Node as the ORACLE user.
* Perform a normal shutdown of the Source System Database
* Copy the Database (DBF) files from the Source to the Target System
Solution:
The issue is caused by the following: source database not stopped correctly causing a DB not to be consistent
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oradata1/addev/system01.dbf'
This means the source database was not stopped properly. When cloning the DB the source needs to be stopped using shutdown normal.
Do the following to fix:
1 - Stop the source database using shutdown normal
2 - Copy the datafiles again
3 - execute the rapidclone scripts again.
No comments:
Post a Comment