Skip to Main Content
Forums

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.

PLs help urgent..backup file received , need to find RMAN and suggest steps to restore

SITIDec 5 2019 — edited Dec 5 2019

Hi All,

Thanks in Advance. Urgent help needed.

I have received the below files from one of our customer. can you please tell me what kind of backup is this?

Also, please suggest how to restore if RMAN backup or cold backup

files.png

And i have opened the spfile using strings command ..Below is the attached data

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

}|{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

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

Please help me.

Thanks,

JP

Message was edited by: SITI

Comments

Salman Qureshi

Hi,

On your standby RAC, what is status of physical standby database? Is it in mount state or OPEN? Has "service role been" changed to PHYSICAL STANDBY after the switchover? I am supposing that if your standby is OPEN, service would become online.

Salman

Smit Patel

Hi,

Service role does not change after switchover. It remains PRIMARY only.

And for second query, we are using active dataguard with DG Broker, so standby database will be opened in read only mode.

Thanks,

Smit Patel

Salman Qureshi

Hi,

Yes I know that, i actually meant whether you have changed it to PHYSICAL STANDBY and also OPEN mode to MOUNT? Try these both and then do a reboot, and see if you still see your services running (which i hope not)

Salman

Robin.A-Oracle

Hi  Smit


Can you share

srvctl config database -d noddb

srvctl status database -d noddb

srvctl config database -d noddr

srvctl status  database -d noddr

Please see the below article for configuring role-based service and verify your setup

How To Configure Client Failover For Data Guard Connections Using Database Services (Doc ID 1429223.1)

Regards

Robin

2 people found this helpful
Smit Patel

Hi Robin,

Please find below outputs:

srvctl config database -d noddb

Database unique name: noddb

Database name: noddb

Oracle home: /u01/app/oracle/product/12.1.0/db_1

Oracle user: oranod

Spfile: +SSDDATA1/noddb/PARAMETERFILE/spfile.271.923402517

Password file: +SSDDATA1/noddb/PASSWORD/pwdnoddb.256.923402037

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools:

Disk Groups: SSDDATA2,SSDDATA1,SASDATA1

Mount point paths:

Services: nodpms

Type: RAC

Start concurrency:

Stop concurrency:

OSDBA group: dba

OSOPER group: dba

Database instances: noddb1,noddb2

Configured nodes: nodprs1,nodprs2

Database is administrator managed

srvctl status database -d noddb

Instance noddb1 is running on node nodprs1

Instance noddb2 is running on node nodprs2

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

srvctl config database -d noddr

Database unique name: noddr

Database name:

Oracle home: /u01/app/oracle/product/12.1.0/db_1

Oracle user: orapun

Spfile: +SSDDATA1/spfilenoddr.ora

Password file: +SSDDATA1/noddr/PASSWORD/pwdnoddr

Domain:

Start options: read only

Stop options: immediate

Database role: PHYSICAL_STANDBY

Management policy: AUTOMATIC

Server pools:

Disk Groups: SSDDATA1,SSDDATA2

Mount point paths:

Services: nodpms

Type: RAC

Start concurrency:

Stop concurrency:

OSDBA group: dba

OSOPER group: dba

Database instances: noddr1,noddr2

Configured nodes: noddrs1,noddrs2

Database is administrator managed

srvctl status  database -d noddr

Instance noddr1 is not running on node noddrs1

Instance noddr2 is running on node noddrs2

Please let me know if you require any further details.

Regards,

Smit Patel

CKPT

Surprised if you have configured any triggers related to the service? can you please check and confirm?

Also in case are you using Global data services?

Thanks.

Smit Patel

Hi CKPT,

We are not using any Global services and please find below trigger code.

create or replace trigger manage_dgrole after startup on PLUGGABLE

database

declare

v_role varchar(50);

v_unqame varchar(50);

begin

select database_role,DB_UNIQUE_NAME into v_role,v_unqame

from v$database;

if ( v_role = 'PRIMARY') AND (v_unqame = 'noddb') then

dbms_service.start_service('nodpms',1);

elsif ( v_role != 'PRIMARY') AND (v_unqame = 'noddb') then

dbms_service.stop_service('nodpms');

elsif ( v_role != 'PRIMARY') AND (v_unqame = 'noddr') then

dbms_service.stop_service('nodpms');

elsif ( v_role = 'PRIMARY') AND (v_unqame = 'noddr') then

dbms_service.start_service('nodpms',2);

end if;

end;

/

Please review above code and suggest correction if any.

Thanks and Regards,

Smit Patel

CKPT

Hello Smit,

after you shutdown of nodedb2 can you send

srvctl config service -s nodpms -d noddb

srvctl config service -s nodpms -d noddr

SVM 1225

Hi,

Interesting. Did you check the behaviour after creating a trigger at CDB level?

e.g.

create or replace trigger manage_dgrole after startup on database

declare

v_role varchar(50);

v_unqame varchar(50);

begin

select database_role,DB_UNIQUE_NAME into v_role,v_unqame

from v$database;

if ( v_role = 'PRIMARY') AND (v_unqame = 'noddb') then

dbms_service.start_service('nodpms',1);

elsif ( v_role != 'PRIMARY') AND (v_unqame = 'noddb') then

dbms_service.stop_service('nodpms');

elsif ( v_role != 'PRIMARY') AND (v_unqame = 'noddr') then

dbms_service.stop_service('nodpms');

elsif ( v_role = 'PRIMARY') AND (v_unqame = 'noddr') then

dbms_service.start_service('nodpms',2);

end if;

end;

/

CloudDB

Hi Smit,

My service configuration is :

$ srvctl config service -s nodpms -d noddb

Service name: nodpms                                                      

Server pool:                                                              

Cardinality: 1                                                            

Disconnect: false                                                         

Service role: PRIMARY                                                     

Management policy: AUTOMATIC                                              

DTP transaction: false                                                    

AQ HA notifications: true                                                 

Global: false                                                             

Commit Outcome: false                                                     

Failover type: SELECT                                                     

Failover method: BASIC                                                    

TAF failover retries: 180                                                 

TAF failover delay: 5                                                     

Connection Load Balancing Goal: LONG                                      

Runtime Load Balancing Goal: NONE                                         

TAF policy specification: NONE                                            

Edition:                                                                  

Pluggable database name: nodpm                                            

Maximum lag time: ANY                                                     

SQL Translation Profile:                                                  

Retention: 86400 seconds                                                  

Replay Initiation Time: 300 seconds                                       

Session State Consistency:                                                

GSM Flags: 0                                                              

Service is enabled                                                        

Preferred instances: noddb1                                               

Available instances: noddb2 

Behaviour you got is the correct behaviour as per this service configuration at dr side.

1 - 10

Post Details

Added on Dec 5 2019
#backup, #general-database-discussions
5 comments
227 views