Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

RMAN backup..how to restore?

SITIDec 5 2019 — edited Dec 27 2019

Hi All,

I am new to RMAN restore

Can you please guide me or suggest URL to follow, how to restore the below RMAN backup?

Thanks in Advance

And in have opened the spfile using strings command. and below is the attached

==============================================================

}|{z

O1N4LIVE

)="d

TAG20191204T123315

N4LIVE

n4live.__db_cache_size=2801795072

n4live.__java_pool_size=16777216

n4live.__large_pool_size=16777216

n4live.__oracle_base='/oracle'#ORACLE_BASE set from environment

n4live.__pga_aggregate_target=1610612736

n4live.__sga_target=4831838208

n4live.__shared_io_pool_size=134217728

n4live.__shared_pool_size=1778384896

n4live.__streams_pool_size=33554432

*.audit_file_dest='/oracle/admin/n4live/adump'

*.audit_trail='db'

*.compatible='11.2.0.0.0'

*.control_files='/oracle/oradata//n4live/control01.ctl','/oracle/oradata//n4live/control02.ctl','/oracle/oradata//n4live/control03.ctl'

*.db_block_size=8192

*.db_domain='sech.local'

*.db_file_name_convert='/oracle/oradata/n4live/','/oracle/dati/n4livesb/'

*.db_name='n4live'

*.db_recovery_file_dest_size=4322230272

*.db_recovery_file_dest='/oracle/fast_recovery_area'

*.diagnostic_dest='/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=n4liveXDB)'

*.fal_client='N4LIVE'

*.fal_server='N4LIVESB'

*.log_archive_config='DG_CONFIG=(n4live,n4liveSB)'

*.log_archive_dest_1='LOCATION=/oracle/archived/'

*.log_archive_dest_2='SERVICE=n4livesb LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=n4livesb'

*.log_archive_format='%t_%s_%r.dbf'

*.log_file_name_convert='/oracle/oradata/n4live/','/oracle/dati/n4livesb/'

*.memory_max_target=6442450944

*.memory_target=6442450944

*.nls_length_semantics='CHAR'

*.open_cursors=300

*.pga_aggregate_target=1610612736

*.processes=300

*.remote_login_passwordfile='EXCLUSIVE'

*.sessions=350

*.sga_target=4831838208

*.undo_tablespace='UNDOTBS1'

/oracle/Ora11R2/dbs/spfilen4live.ora

===================================================================

Thank you,

Timo Hahn

Vishnu, tell us your jdev version, please!

You should read better describe what you want to do (maybe read https://tompeez.wordpress.com/2016/10/14/how-to-ask-questions-in-otn-spaces/ ).

If you set a child node as selected the parent node doesn't discloses itself, you have to do it yourself. Once all nodes to the child are disclosed, you don't see the 'go to top'. If you know the child node you create a new RowKeySet and add the child node to it. then you traverse the tree up and add each parent node to the rowKeySet until you reach the root node which you have to add too. This should do it. For an implementation you can look at https://blogs.oracle.com/jdevotnharvest/entry/how_to_programmatically_disclose_a which shows how to implement this.

Timo

Vishnu Chada

Apologize for not putting the question clearly.

I'm using Jdev 11.1.1.7.

Yes, I do understand that I have to traverse through the tree and find respective parents to disclose a particular node.

But my question is regarding setting selected row and not disclosed rows. I'm able to disclose rows as required.

Upon setting selected keys and refreshing the tree, I don't see entire tree but only the selected node. (with a blue arrow as shown in my screenshot)

Is there a way to avoid this behavior, so that the blue arrow doesn't appear and just required row is selected and entire tree is displayed as-is.

-Vishnu

Timo Hahn

Yes, the blue arrow means that you have set the root node and not selected node.

How have you implemented the selection?

Vishnu Chada

Thanks for the responses, Timo.

I've noticed that it is not because of selected node but because of 'setFocusRowKey()'.

I'm trying to disclose necessary nodes, select a particular row and bring the focus to that row. (automatically scroll to that row)

disclose and select are working fine, but focus is bringing in the blue arrow with 'go to top'.

-Vishnu

Timo Hahn

So is the problem solved?

I made a small test case which is working fine. I can search for a node in a tree and select it.

My search is for the LocationId. I enter 1200 and on click on select the node is searched the tree and selected

Timo

Vishnu Chada

Appreciate your interest.

No, problem isn't solved.

It is actually an extension to the example you used. Let's say there are 100s of rows that aren't visible without scroll, and the selected row is somewhere at the bottom. To focus the selected row, I'm using setFocusKey(), which brings in the arrow.

-Vishnu

Morgan Freeman

Answer

Hi Vishnu,

I have used the below code to show the selected row in a table which is not visible. It should be something similar for tree component.

The method gets the current row key from the iterator and makes the table to scroll / brings to the top.

Thanks

Morgan.

Marked as Answer by Vishnu Chada · Sep 27 2020

Vishnu Chada

thank you, Morgan. That worked.

Morgan Freeman

Hi Vishnu,

Glad I could be of some help

Cheers

Morgan

1 - 9

Added on Dec 5 2019

#general-database-discussions, #refresh, #rman

11 comments

423 views

Oracle Database Discussions

RMAN backup..how to restore?

Comments

Post Details