Yes, i do plan to record Dataguard configurations. Now that there I know there is a need, I'll move it up on the upload list. I am also planning a RAC series. --Justin
Great tutorials ,, thanks ,, but why it is showing only 3 files when running select * from v$backup while u have 4 tablespaces? Is it the temp that not counted? I am a newbie by the way
Justin, I need to clone some really large databases while they're on-line, so I'm trying to capture changes as they're entering the RMAN "target". I'm thinking RMAN will do this better for us. Do you agree?
Justin, your are videos are awesome. I concur with Noah and robind999, and would really appreciate seeing a video on how to clone an Oracle database by RMAN. Please?
Your new database is still using the log_archive_dest_n location of your original database because you did not change that parameter in the init file. You often do need more than just db_name in the init file. You could have, however, changed the parameter using an alter system set statement after duplication. Any file path parameters not explicitly set by the backup controlfile must be changed manually one way or the other. Also, you made no mention of changing the DBID. While this is not strictly necessary for useful duplication, it can become an issue for databases that are to be backed up using RMAN. All RMAN registered databases must have a unique DBID, so any discussion of database cloning should at least mention this and even demonstrate how the DBID can be changed with the nid program. Of course, duplication with RMAN takes care of this. Cheers, Russ
ORA-10879: error signaled in parallel recovery slave ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01195: online backup of file 1 needs more recovery to be consistent ORA-01110: data file 1: 'D:\APP\AA\C-PROD\SYSTEM01.DBF' SQL> set logsource 'D:\app\aa\flash_recovery_area\Prod\ARCHIVELOG\2017_09_27'; SQL> recover database using backup controlfile until cancel; ORA-00275: media recovery has already been started SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01195: online backup of file 1 needs more recovery to be consistent ORA-01110: data file 1: 'D:\APP\AA\C-PROD\SYSTEM01.DBF' Could you please explain me the reason for this error and what i should do with this kind of scenarios.. Thank you..!
Great post. Very useful too 👍🏻
Excellent teaching.
Yes, i do plan to record Dataguard configurations. Now that there I know there is a need, I'll move it up on the upload list. I am also planning a RAC series.
--Justin
Justin, your are wonderful.
I would like to see if you can show how to clone an Oracle database by RMAN. will you?
Great tutorials ,, thanks ,, but why it is showing only 3 files when running select * from v$backup while u have 4 tablespaces? Is it the temp that not counted? I am a newbie by the way
Nice and sweet.
Justin. thanking you for the great work,,, Have a question and don;t know where can I post my question?... any weblogs etc?
could u share some video on configuring physical and logical standby database
expecting ur reply
Abdul Kalam
Oracle DBA
Justin, I need to clone some really large databases while they're on-line, so I'm trying to capture changes as they're entering the RMAN "target". I'm thinking RMAN will do this better for us. Do you agree?
Justin, your are videos are awesome.
I concur with Noah and robind999, and would really appreciate seeing a video on how to clone an Oracle database by RMAN. Please?
what about how to clone database using RMAN , please can you explain how to do it using RMAN
and thank you for your efforts
Hi Justin, we're you able to upload your RAC series? Thank you in Advance!
So we don't need to register the database to the listeners ????
Your new database is still using the log_archive_dest_n location of your original database because you did not change that parameter in the init file. You often do need more than just db_name in the init file. You could have, however, changed the parameter using an alter system set statement after duplication. Any file path parameters not explicitly set by the backup controlfile must be changed manually one way or the other. Also, you made no mention of changing the DBID. While this is not strictly necessary for useful duplication, it can become an issue for databases that are to be backed up using RMAN. All RMAN registered databases must have a unique DBID, so any discussion of database cloning should at least mention this and even demonstrate how the DBID can be changed with the nid program. Of course, duplication with RMAN takes care of this. Cheers, Russ
is the finance2 database created before cloning?
@jbleistein11 thanks a lot for rac if u r thinking
@jbleistein11 Would really appreciate seeing a video on how to clone an Oracle database by RMAN. Could u plzzzz?
@jbleistein11 nice every body use rac now
net start | findstr Ora
at command line to find the Oracle Service....:P
Man there is ora-00308 error oracle cannot open archive log , so i cant open the database:(
ORA-10879: error signaled in parallel recovery slave
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'D:\APP\AA\C-PROD\SYSTEM01.DBF'
SQL> set logsource 'D:\app\aa\flash_recovery_area\Prod\ARCHIVELOG\2017_09_27';
SQL> recover database using backup controlfile until cancel;
ORA-00275: media recovery has already been started
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'D:\APP\AA\C-PROD\SYSTEM01.DBF'
Could you please explain me the reason for this error and what i should do with this kind of scenarios..
Thank you..!