SQL> SELECT THREAD#, SEQUENCE#, APPLIED FROM V$ARCHIVED_LOG;

THREAD# SEQUENCE# APP
---------- ---------- ---
1 12335 NO
1 12336 NO
1 12337 NO
1 12338 NO
1 12339 NO
1 12340 NO
1 12341 NO
1 12342 NO
1 12343 NO
1 12344 NO
1 12345 NO

THREAD# SEQUENCE# APP
---------- ---------- ---
1 12346 NO
1 12347 NO
1 12348 NO
1 12349 NO
1 12350 NO
1 12351 NO
1 12352 NO
1 12353 NO
1 12354 NO
1 12355 NO
1 12356 NO

THREAD# SEQUENCE# APP
---------- ---------- ---
1 12357 NO
1 12358 NO
1 12359 NO
1 12360 NO
1 12361 NO
1 12362 NO
1 12363 NO
1 12364 NO
11:18AM Artis, Bernard: 1 12365 NO
1 12366 NO
1 12367 NO

THREAD# SEQUENCE# APP
---------- ---------- ---
1 12368 NO
1 12369 NO
1 12370 NO
1 12371 NO
1 12372 NO
1 12373 NO
1 12374 NO
1 12375 NO
1 12376 NO
1 12377 NO
1 12378 NO

THREAD# SEQUENCE# APP
---------- ---------- ---
1 12379 NO
1 12380 NO
1 12381 NO
1 12382 NO
1 12383 NO
1 12384 NO
1 12385 NO
1 12386 NO
1 12387 NO
1 12388 NO
1 12389 NO

THREAD# SEQUENCE# APP
---------- ---------- ---
1 12390 NO
1 12391 NO
1 12392 NO
1 12393 NO
1 12394 NO
1 12395 NO
1 12396 NO
1 12397 NO
1 12398 NO
1 12399 NO
1 12400 NO

THREAD# SEQUENCE# APP
---------- ---------- ---
1 12401 NO
1 12402 NO
11:18AM Artis, Bernard: 1 12403 NO
1 12404 NO
1 12405 NO
1 12406 NO
1 12407 NO
1 12408 NO
1 12409 NO
1 12410 NO
1 12411 NO

THREAD# SEQUENCE# APP
---------- ---------- ---
1 12412 NO
1 12413 NO
1 12414 NO
1 12415 NO
1 12416 NO
1 12417 NO
1 12418 NO
1 12419 NO
1 12420 NO
1 12421 NO
1 12422 NO

THREAD# SEQUENCE# APP
---------- ---------- ---
1 12423 NO
1 12424 NO
1 12425 NO
1 12426 NO
1 12427 NO
1 12428 NO
1 12429 NO
1 12430 NO
1 12431 NO
1 12432 NO
1 12433 NO

THREAD# SEQUENCE# APP
---------- ---------- ---
1 12434 NO
1 12435 NO
1 12436 NO
1 12437 NO
1 12438 NO

104 rows selected.
WHERE TESTP-PRIMARY DATABASE
TESTS STANDBY
##Modification to primary##

*.log_archive_dest_2='SERVICE=TESTS valid_for=(online_logfiles,primary_role) DB_UNIQUE_NAME=TESTS'
*.db_file_name_convert='/u05/oradata/TESTS','/u05/oradata/TESTP'
*.log_file_name_convert='/u02/origlog/TESTS','/u02/origlog/TESTP','/u03/mirrlog/TESTS','/u03/mirrlog/TESTP'
*.fal_client='TESTP'
*.fal_server='TESTS'
*.standby_file_management='AUTO'
*.STANDBY_ARCHIVE_DEST='/u01/app/oracle/arch/db_2/WTEXP'

##Modifications to standby##

TESTP1.__db_cache_size=1392508928
TESTS.__db_cache_size=1392508928
TESTP1.__java_pool_size=16777216
TESTS.__java_pool_size=16777216
TESTP1.__large_pool_size=16777216
TESTS.__large_pool_size=16777216
TESTP1.__shared_pool_size=452984832
TESTS.__shared_pool_size=452984832
TESTP1.__streams_pool_size=0
TESTS.__streams_pool_size=0
*.archive_lag_target=900
*.audit_file_dest='/u01/app/oracle/admin/TESTS/adump'
*.background_dump_dest='/u01/app/oracle/admin/TESTS/bdump'
*.backup_tape_io_slaves=true
*.cluster_database_instances=1
*.compatible='10.2.0.2.0'
*.control_file_record_keep_time=45
*.core_dump_dest='/u01/app/oracle/admin/TESTS/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_file_name_convert='/u05/oradata/TESTP','/u05/oradata/TESTS'
*.db_name='TESTP'
*.db_recovery_file_dest='/u04/app/oracle/flash_recovery/TESTS'
*.db_recovery_file_dest_size=2147483648
*.db_unique_name='TESTS'
*.fal_client='TESTS'
*.fal_server='TESTP'
*.instance_name='TESTS'
TESTS.instance_number=1
*.job_queue_processes=10
*.local_listener='LISTENER_TESTS'
*.log_archive_config='DG_CONFIG=(TESTP,TESTS)'
*.log_archive_dest_1='LOCATION=/u01/app/oracle/arch/TESTS VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=TESTS'
*.log_archive_dest_2='SERVICE=TESTP valid_for=(online_logfiles,primary_role) DB_UNIQUE_NAME=TESTP'
*.log_archive_format='TESTPARCH_%t_%s_%r.dbf'
*.log_file_name_convert='/u02/origlog/TESTP','/u02/origlog/TESTS','/u03/mirrlog/TESTP','/u03/mirrlog/TESTS'
*.open_cursors=300
*.pga_aggregate_target=200M
*.processes=1000
*.remote_listener='LISTENER_TESTS'
*.remote_login_passwordfile='exclusive'
*.sessions=225
*.sga_target=1800M
*.standby_archive_dest='/u01/app/oracle/arch/TESTS'
*.standby_file_management='AUTO'
*.undo_management='AUTO'
TESTS1.undo_tablespace='UNDO_01'
*.user_dump_dest='/u01/app/oracle/admin/TESTS/udump'