No question at this time
DBA Top 10
1 M. Cadot 7400
2 B. Vroman 1700
3 P. Wisse 1300
4 P. Tsongayinwe 1200
5 J. PĂ©ran 800
6 J. Schnackenberg 400
7 J. Alcroft 200
7 D. Walgude 200
7 B. M 200
10 A. Hudspith 100
10 L. Ywema 100
10 D. Johnson 100
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48726
Total active users1323
Act. users last 24h0
Act. users last hour0
Registered user hits last week35
Registered user hits last month263
Go up

Monitor RMAN Duplicate DB from ACTIVE DATABASE
Next thread: Full DB export
Prev thread: maximum number of open files per process

Message Score Author Date
I am creating a physical standby database using rm...... Charles Kgopa Feb 17, 2023, 08:28
I am using the script below to monitor progress bu...... Charles Kgopa Feb 17, 2023, 08:32
On which database did you execute the SQL? Pl...... Michel Cadot Feb 17, 2023, 09:15
I am executing the script on the standby server. ...... Charles Kgopa Feb 17, 2023, 09:36
Hi Ant assistance? Thanks... Charles Kgopa Feb 21, 2023, 10:31
The extract you posted shows no problems, each f...... Michel Cadot Feb 21, 2023, 15:11
Hi Michel Thanks for your response, yes there i...... Charles Kgopa Feb 21, 2023, 16:13
>>> <i> I am executing the script on the standby...... Michel Cadot Feb 21, 2023, 16:51

Follow up by mail Click here


Subject: Monitor RMAN Duplicate DB from ACTIVE DATABASE
Author: Charles Kgopa, South Africa
Date: Feb 17, 2023, 08:28, 36 days ago
Os info: AIX 7
Oracle info: Oracle 11.2..0.3
Error info: No error
Message: I am creating a physical standby database using rman duplicate target database form active database pfile

Currently I am on day two, I would like to monitor RMAN progress by monitoring script returns zero rows


run {
allocate channel prmy1 type disk;
allocate channel prmy2 type disk;
allocate channel prmy3 type disk;
allocate channel prmy4 type disk;
allocate auxiliary channel stby type disk;

duplicate target database for standby from active database spfile
parameter_value_convert 'NODE','NODEDR'
set db_unique_name='NODEDR'
#set db_file_name_convert='+DATA/NODE','+DATA/NODEDR'
#set log_file_name_convert='+DATA/NODE','+DATA/NODEDR'
#set control_files='+DATA/NODE','+DATA/NODEDR'
set log_archive_max_processes='5'
set fal_client='NODEDR'
set fal_server='NODE'
set standby_file_management='MANUAL'
set log_archive_config='dg_config=(NODE,NODEDR)'
set log_archive_dest_2='service=NODE ASYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=NODE'
#set db_recovery_file_dest='/u01/app/oracle/recovery'
#set db_recovery_file_dest='+DATA/NODEDR'
set audit_file_dest='/u01/app/oracle/admin/NODEDR/adump'
set diagnostic_dest='/u01/app/oracle'
;
}
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Monitor RMAN Duplicate DB from ACTIVE DATABASE
Author: Charles Kgopa, South Africa
Date: Feb 17, 2023, 08:32, 36 days ago
Message: I am using the script below to monitor progress but no results returned even though my RMAN job has been running for two days now.

SQL> select
to_char(start_time,'DD-MON-YY HH24:MI') "BACKUP STARTED",
sofar,
totalwork,
elapsed_seconds/60 "ELAPSE (Min)",
round(sofar/totalwork*100,2) "Complete%"
from v$session_longops
2 3 4 5 6 7 8
SQL> /

no rows selected
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Monitor RMAN Duplicate DB from ACTIVE DATABASE
Author: Michel Cadot, France
Date: Feb 17, 2023, 09:15, 36 days ago
Message:
On which database did you execute the SQL?

Please post the last lines of the RMAN log (at least 20 lines or more if these ones are not conclusive).

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Monitor RMAN Duplicate DB from ACTIVE DATABASE
Author: Charles Kgopa, South Africa
Date: Feb 17, 2023, 09:36, 36 days ago
Message: I am executing the script on the standby server.

channel prmy7: datafile copy complete, elapsed time: 04:01:27
channel prmy7: starting datafile copy
input datafile file number=00077 name=+POVS/prime_mwp/datafile/vps_index.8251.890790711
output file name=+POVS/standby_141/datafile/messages_data_aug13.3637.1129001331 tag=TAG20230216T093914
channel prmy14: datafile copy complete, elapsed time: 04:04:59
channel prmy14: starting datafile copy
input datafile file number=00099 name=+POVS/prime_mwp/datafile/vps_index.8667.890794539
output file name=+POVS/standby_141/datafile/messages_data_aug13.3636.1129001485 tag=TAG20230216T093914
channel prmy6: datafile copy complete, elapsed time: 04:03:41
channel prmy6: starting datafile copy
input datafile file number=00103 name=+POVS/prime_mwp/datafile/vps_index.9528.890792073
output file name=+POVS/standby_141/datafile/vps_index.3630.1129002063 tag=TAG20230216T093914
channel prmy1: datafile copy complete, elapsed time: 04:02:45
channel prmy1: starting datafile copy
input datafile file number=00104 name=+POVS/prime_mwp/datafile/vps_index.8917.890792019
output file name=+POVS/standby_141/datafile/vps_index.3627.1129002469 tag=TAG20230216T093914
channel prmy4: datafile copy complete, elapsed time: 03:57:48
channel prmy4: starting datafile copy
input datafile file number=00076 name=+POVS/prime_mwp/datafile/vps_index.9781.890793303
output file name=+POVS/standby_141/datafile/vps_index.3633.1129001647 tag=TAG20230216T093914
channel prmy8: datafile copy complete, elapsed time: 04:12:33
channel prmy8: starting datafile copy
input datafile file number=01463 name=+POVS/prime_mwp/datafile/vps_index.8284.890790755
output file name=+POVS/standby_141/datafile/vps_index.3631.1129001855 tag=TAG20230216T093914
channel prmy2: datafile copy complete, elapsed time: 04:09:11
channel prmy2: starting datafile copy
input datafile file number=01408 name=+POVS/prime_mwp/datafile/messages_data_sep13.9506.890792987
output file name=+POVS/standby_141/datafile/vps_index.3628.1129002465 tag=TAG20230216T093914
channel prmy10: datafile copy complete, elapsed time: 03:59:38
channel prmy10: starting datafile copy
input datafile file number=01409 name=+POVS/prime_mwp/datafile/messages_data_sep13.9791.890792925
output file name=+POVS/standby_141/datafile/vps_index.3629.1129002331 tag=TAG20230216T093914
channel prmy3: datafile copy complete, elapsed time: 04:01:56
channel prmy3: starting datafile copy
input datafile file number=01410 name=+POVS/prime_mwp/datafile/messages_data_sep13.9120.890790325
output file name=+POVS/standby_141/datafile/vps_index.3632.1129001733 tag=TAG20230216T093914
channel prmy11: datafile copy complete, elapsed time: 04:12:37
channel prmy11: starting datafile copy
input datafile file number=00075 name=+POVS/prime_mwp/datafile/vps_index.8271.890790743
output file name=+POVS/standby_141/datafile/vps_index.3635.1129001537 tag=TAG20230216T093914
channel prmy13: datafile copy complete, elapsed time: 04:18:20
channel prmy13: starting datafile copy
input datafile file number=01467 name=+POVS/prime_mwp/datafile/vps_index.10078.890792035
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Monitor RMAN Duplicate DB from ACTIVE DATABASE
Author: Charles Kgopa, South Africa
Date: Feb 21, 2023, 10:31, 32 days ago
Message: Hi

Ant assistance?

Thanks
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Monitor RMAN Duplicate DB from ACTIVE DATABASE
Author: Michel Cadot, France
Date: Feb 21, 2023, 15:11, 32 days ago
Message:
The extract you posted shows no problems, each file is copied in about 4 minutes.
I don't know the size of your files and if they are small or large, in the former they may be IO problem.
Query v$asm_disk to see the IO times and rates.

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Monitor RMAN Duplicate DB from ACTIVE DATABASE
Author: Charles Kgopa, South Africa
Date: Feb 21, 2023, 16:13, 32 days ago
Message: Hi Michel

Thanks for your response, yes there is no problem everything is running smooth. I just needed a script similar to the one above that show a nice progress report that I can present to manager.

DB is more than 20TB duplicate command is now on day 5.

Regards
Charles
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Monitor RMAN Duplicate DB from ACTIVE DATABASE
Author: Michel Cadot, France
Date: Feb 21, 2023, 16:51, 32 days ago
Message:
>>> I am executing the script on the standby server.

The SQL statements must be executed on the source database.
You can also monitor the duplicate using v$rman_status view.

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here