Microsoft Windows [Version 6.3.9600]
(c) 2013 Microsoft Corporation. All rights reserved.
C:\Windows\system32>pwd
'pwd' is not recognized as an internal or external command,
operable program or batch file.
C:\Windows\system32>
C:\Windows\system32>
C:\Windows\system32>
C:\Windows\system32>
C:\Windows\system32>sqlplus sys/system123
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:00:58 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
C:\Windows\system32>sqlplus sys/system123@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:01:07 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
WTENV MOUNTED PHYSICAL STANDBY
SQL> sho parameter local
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string LISTENER_WTENVDR
parallel_force_local boolean FALSE
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
C:\Windows\system32>lsnrctl status
LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 10-APR-2019 16:02:07
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SGDCPLM03.smr.motherson.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 - Production
Start Date 10-APR-2019 15:51:12
Uptime 0 days 0 hr. 10 min. 59 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\listener.ora
Listener Log File D:\app\plmadmin\diag\tnslsnr\SGDCPLM03\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SGDCPLM03.smr.motherson.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "WTENVDR" has 1 instance(s).
Instance "wtenvdr", status READY, has 1 handler(s) for this service...
Service "test" has 1 instance(s).
Instance "test", status READY, has 1 handler(s) for this service...
Service "testXDB" has 1 instance(s).
Instance "test", status READY, has 1 handler(s) for this service...
The command completed successfully
C:\Windows\system32>sqlplus sys/system123@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:03:15 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
WTENV MOUNTED PHYSICAL STANDBY
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
WTENV MOUNTED PHYSICAL STANDBY
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
C:\Windows\system32>sqlplus sys/system123@test as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:03:34 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
TEST READ WRITE PRIMARY
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
C:\Windows\system32>sqlplus sys/system123@test as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:03:56 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
C:\Windows\system32>
C:\Windows\system32>sqlplus sys/system123@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:04:05 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
C:\Windows\system32>
C:\Windows\system32>
C:\Windows\system32>sqlplus sys/infodba@test as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:04:21 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
TEST READ WRITE PRIMARY
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
C:\Windows\system32>sqlplus sys/system123@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:04:29 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
C:\Windows\system32>sqlplus sys/system123@test as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:04:34 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
C:\Windows\system32>
C:\Windows\system32>lsnrctl status
LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 10-APR-2019 16:04:38
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SGDCPLM03.smr.motherson.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 - Production
Start Date 10-APR-2019 15:51:12
Uptime 0 days 0 hr. 13 min. 29 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\listener.ora
Listener Log File D:\app\plmadmin\diag\tnslsnr\SGDCPLM03\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SGDCPLM03.smr.motherson.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "WTENVDR" has 1 instance(s).
Instance "wtenvdr", status READY, has 1 handler(s) for this service...
Service "test" has 1 instance(s).
Instance "test", status READY, has 1 handler(s) for this service...
Service "testXDB" has 1 instance(s).
Instance "test", status READY, has 1 handler(s) for this service...
The command completed successfully
C:\Windows\system32>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:04:54 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
C:\Windows\system32>
C:\Windows\system32>sqlplus sys/infodba@wtenv as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:05:01 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
WTENV READ WRITE PRIMARY
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
C:\Windows\system32>sqlplus sys/system123@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:16:25 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name: select name,open_mode,database_role from v$database;
SP2-0306: Invalid option.
Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM|SYSBACKUP|SYSDG|SYSKM}] [edition=value]]
where <logon> ::= <username>[/<password>][@<connect_identifier>]
<proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
C:\Windows\system32>
C:\Windows\system32>sqlplus sys/system123@test as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:16:35 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name: select name,open_mode,database_role from v$database;
SP2-0306: Invalid option.
Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM|SYSBACKUP|SYSDG|SYSKM}] [edition=value]]
where <logon> ::= <username>[/<password>][@<connect_identifier>]
<proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
C:\Windows\system32>
C:\Windows\system32>sqlplus sys/infodba@test as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:16:42 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
TEST READ WRITE PRIMARY
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
C:\Windows\system32>
C:\Windows\system32>sqlplus sys/infodba@test as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:52:21 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
C:\Windows\system32>sqlplus sys/system123@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:52:26 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
C:\Windows\system32>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:52:37 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
C:\Windows\system32>
C:\Windows\system32>D:
D:\>orapwd file=D:\app\plmadmin\product\12.1.0\dbhome_1\database\PWDtest.ora password=system123 entries=5 FORCE=Y
D:\>sqlplus sys/infodba@test as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:58:36 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>
D:\>sqlplus sys/system123@test as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:58:48 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>orapwd file=D:\app\plmadmin\product\12.1.0\dbhome_1\database\PWDwtenvdr.ora password=infodba entries=5 FORCE=Y
D:\>sqlplus sys/system123@test as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 17:00:07 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 17:00:15 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
WTENV MOUNTED PHYSICAL STANDBY
SQL> alter database recover managed standby database disconnect tfrom session;
alter database recover managed standby database disconnect tfrom session
*
ERROR at line 1:
ORA-00274: illegal recovery option TFROM
SQL> alter database recover managed standby database disconnect from session;
alter database recover managed standby database disconnect from session
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active
SQL> desc v$managed_standby;
Name Null? Type
----------------------------------------- -------- ----------------------------
PROCESS VARCHAR2(9)
PID VARCHAR2(24)
STATUS VARCHAR2(12)
CLIENT_PROCESS VARCHAR2(8)
CLIENT_PID VARCHAR2(40)
CLIENT_DBID VARCHAR2(40)
GROUP# VARCHAR2(40)
RESETLOG_ID NUMBER
THREAD# NUMBER
SEQUENCE# NUMBER
BLOCK# NUMBER
BLOCKS NUMBER
DELAY_MINS NUMBER
KNOWN_AGENTS NUMBER
ACTIVE_AGENTS NUMBER
CON_ID NUMBER
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>lsnrctl status
LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 10-APR-2019 17:03:59
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SGDCPLM03.smr.motherson.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 - Production
Start Date 10-APR-2019 15:51:12
Uptime 0 days 1 hr. 12 min. 50 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\listener.ora
Listener Log File D:\app\plmadmin\diag\tnslsnr\SGDCPLM03\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SGDCPLM03.smr.motherson.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "WTENVDR" has 1 instance(s).
Instance "wtenvdr", status READY, has 1 handler(s) for this service...
Service "test" has 1 instance(s).
Instance "test", status READY, has 1 handler(s) for this service...
Service "testXDB" has 1 instance(s).
Instance "test", status READY, has 1 handler(s) for this service...
The command completed successfully
D:\>tnsping wtenvdr
TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 10-APR-2019 17:04:09
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.33.105.69)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = w
tenvdr)))
OK (0 msec)
D:\>tnsping wtenv
TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 10-APR-2019 17:04:13
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = SGDCPLM01)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = wten
v)))
OK (20 msec)
D:\>tnsping wtenvdr
TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 10-APR-2019 17:06:32
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.33.105.69)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = w
tenvdr)))
OK (0 msec)
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 17:06:43 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> alter database recover managed standby database disconnect from session;
alter database recover managed standby database disconnect from session
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 17:12:04 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/infodqqqba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 17:12:11 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 17:12:19 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/system123@test as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 17:12:27 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select process,status,sequence# from v$managed_standby;
no rows selected
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
TEST READ WRITE PRIMARY
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 16
Current log sequence 18
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
TEST READ WRITE PRIMARY
SQL> alter database recover managed standby database disconnect from session;
alter database recover managed standby database disconnect from session
*
ERROR at line 1:
ORA-01665: control file is not a standby control file
SQL> select process,status,sequence# from v$managed_standby;
no rows selected
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 17:13:49 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>oradim -delete -sid WTENVDR
Instance deleted.
D:\>
D:\>oradim -new -sid WTENV -SYSPWD infodba -pfile D:\app\plmadmin\product\12.1.0\dbhome_1\database\INITwtenvdr.ora
Instance created.
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 17:22:21 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>
D:\>tnsping wtenvdr
TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 10-APR-2019 17:22:35
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.33.105.69)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = w
tenvdr)))
OK (0 msec)
D:\>oradim -delete -sid WTENV
Instance deleted.
D:\>oradim -new -sid WTENVDR -SYSPWD infodba -pfile D:\app\plmadmin\product\12.1.0\dbhome_1\database\INITwtenvdr.ora
OPW-00005: File with same name exists - please delete or rename
Instance created.
D:\>tnsping wtenvdr
TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 10-APR-2019 17:23:35
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.33.105.69)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = w
tenvdr)))
OK (0 msec)
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 17:23:37 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>
D:\>
D:\>
D:\>oradim -new -sid WTENV -SYSPWD infodba -pfile D:\app\plmadmin\product\12.1.0\dbhome_1\database\INITwtenvdr.ora
OPW-00005: File with same name exists - please delete or rename
Instance created.
D:\>
D:\>
D:\>
D:\>
D:\>
D:\>
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 17:24:20 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 08:35:42 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 08:35:49 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>
D:\>sqlplus sys/system123@test as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 08:35:57 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
TEST READ WRITE PRIMARY
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>SC DELETE OracleServiceWTENVDR
[SC] DeleteService SUCCESS
D:\>sqlplus sys/system123@test as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 08:51:32 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
TEST READ WRITE PRIMARY
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/sys@test as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 08:51:42 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>
D:\>sqlplus sys/infodba@wtenv as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 08:52:10 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
WTENV READ WRITE PRIMARY
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 08:52:20 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>
D:\>sc delete OracleServiceWTENV
[SC] DeleteService SUCCESS
D:\>oradim -new -sid WTENVDR -SYSPWD infodba -pfile D:\app\plmadmin\product\12.1.0\dbhome_1\database\INITwtenvdr.ora
OPW-00005: File with same name exists - please delete or rename
Instance created.
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 08:57:51 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 08:57:57 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>
D:\>
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 08:58:03 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>
D:\>
D:\>
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 08:58:40 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
TEST READ WRITE PRIMARY
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 08:59:04 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>
D:\>
D:\>set ORACLE_SID=wtendr
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 08:59:38 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 09:01:22 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name: select name,open_mode,database_role from v$database;
SP2-0306: Invalid option.
Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM|SYSBACKUP|SYSDG|SYSKM}] [edition=value]]
where <logon> ::= <username>[/<password>][@<connect_identifier>]
<proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 09:01:31 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 09:02:21 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 09:02:27 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name: \\
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>
D:\>lsnrctl status
LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 12-APR-2019 09:02:39
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SGDCPLM03.smr.motherson.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 - Production
Start Date 10-APR-2019 15:51:12
Uptime 1 days 17 hr. 11 min. 30 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\listener.ora
Listener Log File D:\app\plmadmin\diag\tnslsnr\SGDCPLM03\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SGDCPLM03.smr.motherson.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "test" has 1 instance(s).
Instance "test", status READY, has 1 handler(s) for this service...
Service "testXDB" has 1 instance(s).
Instance "test", status READY, has 1 handler(s) for this service...
The command completed successfully
D:\>lsnrctl stop
LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 12-APR-2019 09:02:46
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SGDCPLM03.smr.motherson.com)(PORT=1521)))
The command completed successfully
D:\>lsnrctl start
LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 12-APR-2019 09:02:54
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Starting tnslsnr: please wait...
TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 - Production
System parameter file is D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\listener.ora
Log messages written to D:\app\plmadmin\diag\tnslsnr\SGDCPLM03\listener\alert\log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SGDCPLM03.smr.motherson.com)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SGDCPLM03.smr.motherson.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 - Production
Start Date 12-APR-2019 09:02:59
Uptime 0 days 0 hr. 0 min. 8 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\listener.ora
Listener Log File D:\app\plmadmin\diag\tnslsnr\SGDCPLM03\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SGDCPLM03.smr.motherson.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
D:\>set ORACLE_SID=wtendr
D:\>set ORACLE_SID=wtenvdr
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 09:03:24 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 8.2678E+10 bytes
Fixed Size 7774968 bytes
Variable Size 1.2885E+10 bytes
Database Buffers 6.9525E+10 bytes
Redo Buffers 260657152 bytes
Database mounted.
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
WTENV MOUNTED PHYSICAL STANDBY
SQL> select name,db_unique_name,open_mode,database_role from v$database;
NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE
--------- ------------------------------ -------------------- ----------------
WTENV WTENVDR MOUNTED PHYSICAL STANDBY
SQL> alter database recover managed standby database disconnect from session;
Database altered.
SQL> select name,db_unique_name,open_mode,database_role from v$database;\
2
SQL>
SQL> select name,db_unique_name,open_mode,database_role from v$database;
NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE
--------- ------------------------------ -------------------- ----------------
WTENV WTENVDR MOUNTED PHYSICAL STANDBY
SQL> desc v$managed_standby
Name Null? Type
----------------------------------------- -------- ----------------------------
PROCESS VARCHAR2(9)
PID VARCHAR2(24)
STATUS VARCHAR2(12)
CLIENT_PROCESS VARCHAR2(8)
CLIENT_PID VARCHAR2(40)
CLIENT_DBID VARCHAR2(40)
GROUP# VARCHAR2(40)
RESETLOG_ID NUMBER
THREAD# NUMBER
SEQUENCE# NUMBER
BLOCK# NUMBER
BLOCKS NUMBER
DELAY_MINS NUMBER
KNOWN_AGENTS NUMBER
ACTIVE_AGENTS NUMBER
CON_ID NUMBER
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 09:06:17 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> select name,db_unique_name,open_mode,database_role from v$database;
NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE
--------- ------------------------------ -------------------- ----------------
WTENV WTENVDR MOUNTED PHYSICAL STANDBY
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 09:13:45 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> sho parameter fal
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
fal_client string WTENVDR
fal_server string WTENV
SQL> sho parameter standby_file
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_file_management string MANUAL
SQL> alter database recover managed standby database disconnect from session;
alter database recover managed standby database disconnect from session
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active
SQL> alter system set standby_file_management=auto scope=both;
System altered.
SQL> sho parameter standby_file
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_file_management string AUTO
SQL> alter database recover managed standby database disconnect from session;
alter database recover managed standby database disconnect from session
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active
SQL> sho parameter fal
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
fal_client string WTENVDR
fal_server string WTENV
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>pwd
'pwd' is not recognized as an internal or external command,
operable program or batch file.
D:\>tnsping wtenvdr
TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 12-APR-2019 09:28:29
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.33.105.69)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = w
tenvdr)))
OK (0 msec)
D:\>tnsping wtenv
TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 12-APR-2019 09:28:32
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = SGDCPLM01)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = wten
v)))
OK (20 msec)
D:\>tnsping wtenv
TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 12-APR-2019 09:30:16
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = SGDCPLM01)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = wten
v)))
OK (10 msec)
D:\>tnsping wtenvdr
TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 12-APR-2019 09:30:18
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.33.105.69)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = w
tenvdr)))
OK (0 msec)
D:\>tnsping test
TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 12-APR-2019 09:30:22
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = SGDCPLM03.smr.motherson.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED
) (SERVICE_NAME = test)))
OK (20 msec)
D:\>sqlplus sys/system123@test as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 09:30:35 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select process,status,sequence# from v$managed_standby;
no rows selected
SQL> select name,db_unique_name,open_mode,database_role from v$database;
NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE
--------- ------------------------------ -------------------- ----------------
TEST test READ WRITE PRIMARY
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 09:30:53 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name,db_unique_name,open_mode,database_role from v$database;
NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE
--------- ------------------------------ -------------------- ----------------
WTENV WTENVDR MOUNTED PHYSICAL STANDBY
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/infodba@wtenv as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 09:31:21 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CLOSING 968
ARCH CLOSING 966
ARCH CONNECTED 0
LNS OPENING 948
ARCH CLOSING 967
SQL> select name,db_unique_name,open_mode,database_role from v$database;
NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE
--------- ------------------------------ -------------------- ----------------
WTENV WTENV READ WRITE PRIMARY
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/infodbaaaa@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 09:31:38 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 09:31:45 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name,db_unique_name,open_mode,database_role from v$database;
NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE
--------- ------------------------------ -------------------- ----------------
WTENV WTENVDR MOUNTED PHYSICAL STANDBY
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL>
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/infodba@wtenv as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 09:39:06 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CLOSING 968
ARCH CLOSING 966
ARCH CONNECTED 0
LNS OPENING 948
ARCH CLOSING 967
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CLOSING 968
ARCH CLOSING 966
ARCH CONNECTED 0
LNS OPENING 948
ARCH CLOSING 967
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 09:40:53 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> archive logl ist;
SP2-0734: unknown command beginning "archive lo..." - rest of line ignored.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination D:\wtenv_archivelog
Oldest online log sequence 0
Next log sequence to archive 0
Current log sequence 0
SQL> sho parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string D:\APP\PLMADMIN\PRODUCT\12.1.0
\DBHOME_1\DATABASE\SPFILEWTENV
DR.ORA
SQL> sho parameter db_standby
SQL> sho parameter standby_file
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_file_management string AUTO
SQL>
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/infodba@wtenv as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 09:54:57 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> sho parameter standby_file
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_file_management string AUTO
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CLOSING 968
ARCH CLOSING 966
ARCH CONNECTED 0
LNS OPENING 948
ARCH CLOSING 967
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 09:55:11 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>lsnrctl status
LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 12-APR-2019 09:56:15
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SGDCPLM03.smr.motherson.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 - Production
Start Date 12-APR-2019 09:02:59
Uptime 0 days 0 hr. 53 min. 19 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\listener.ora
Listener Log File D:\app\plmadmin\diag\tnslsnr\SGDCPLM03\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SGDCPLM03.smr.motherson.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "WTENVDR" has 1 instance(s).
Instance "wtenvdr", status READY, has 1 handler(s) for this service...
Service "test" has 1 instance(s).
Instance "test", status READY, has 1 handler(s) for this service...
Service "testXDB" has 1 instance(s).
Instance "test", status READY, has 1 handler(s) for this service...
The command completed successfully
D:\>lsnrctl status
LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 12-APR-2019 10:02:32
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SGDCPLM03.smr.motherson.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 - Production
Start Date 12-APR-2019 09:02:59
Uptime 0 days 0 hr. 59 min. 36 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\listener.ora
Listener Log File D:\app\plmadmin\diag\tnslsnr\SGDCPLM03\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SGDCPLM03.smr.motherson.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "test" has 1 instance(s).
Instance "test", status READY, has 1 handler(s) for this service...
Service "testXDB" has 1 instance(s).
Instance "test", status READY, has 1 handler(s) for this service...
The command completed successfully
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 10:02:35 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>set ORACLE_SID=WTENVDR
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 10:02:58 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 10:03:21 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 10:06:34 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 8.2678E+10 bytes
Fixed Size 7774968 bytes
Variable Size 1.2885E+10 bytes
Database Buffers 6.9525E+10 bytes
Redo Buffers 260657152 bytes
Database mounted.
SQL> alter database convert to snapshot standby;
Database altered.
SQL> alter database open;
Database altered.
SQL> select status,instance_name,database_role,open_mode from v$database,v$Instance;
STATUS INSTANCE_NAME DATABASE_ROLE OPEN_MODE
------------ ---------------- ---------------- --------------------
OPEN wtenvdr SNAPSHOT STANDBY READ WRITE
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
LNS CONNECTED 0
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 8.2678E+10 bytes
Fixed Size 7774968 bytes
Variable Size 1.2885E+10 bytes
Database Buffers 6.9525E+10 bytes
Redo Buffers 260657152 bytes
Database mounted.
SQL> alter database convert to physical standby;
Database altered.
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
SQL> select status,instance_name,database_role,open_mode from v$database,v$Instance;
STATUS INSTANCE_NAME DATABASE_ROLE OPEN_MODE
------------ ---------------- ---------------- --------------------
MOUNTED wtenvdr PHYSICAL STANDBY MOUNTED
SQL> alter database recover managed standby database disconnect from session;
Database altered.
SQL> select status,instance_name,database_role,open_mode from v$database,v$Instance;
STATUS INSTANCE_NAME DATABASE_ROLE OPEN_MODE
------------ ---------------- ---------------- --------------------
MOUNTED wtenvdr PHYSICAL STANDBY MOUNTED
SQL> alter database convert to physical standby;
alter database convert to physical standby
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> sho parameter standby_file
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_file_management string AUTO
SQL> select * from v$pwselect * from v$pwfile_users;
select * from v$pwselect * from v$pwfile_users
*
ERROR at line 1:
ORA-00933: SQL command not properly ended
SQL> select * from v$pwfile_users;
no rows selected
SQL> select * from v$pwfile_users;
no rows selected
SQL> shut immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 10:38:45 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 8.2678E+10 bytes
Fixed Size 7774968 bytes
Variable Size 1.2885E+10 bytes
Database Buffers 6.9525E+10 bytes
Redo Buffers 260657152 bytes
Database mounted.
SQL> select * from v$pwfile_users;
no rows selected
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
SQL> alter database recover managed standby database disconnect from session;
Database altered.
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> select * from v$pwfile_users;
no rows selected
SQL> select * from v$pwfile_users;
no rows selected
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 10:42:49 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select * from v$pwfile_users;
no rows selected
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 10:43:21 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select * from v$pwfile_users;
USERNAME SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM CON_ID
------------------------------ ----- ----- ----- ----- ----- ----- ----------
SYS TRUE TRUE FALSE FALSE FALSE FALSE 0
SQL> select * from v$pwfile_users;
USERNAME SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM CON_ID
------------------------------ ----- ----- ----- ----- ----- ----- ----------
SYS TRUE TRUE FALSE FALSE FALSE FALSE 0
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>tnsping wtenvdr
TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 12-APR-2019 10:44:07
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.33.105.69)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = w
tenvdr)))
OK (20 msec)
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 10:44:09 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select * from v$pwfile_users;
USERNAME SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM CON_ID
------------------------------ ----- ----- ----- ----- ----- ----- ----------
SYS TRUE TRUE FALSE FALSE FALSE FALSE 0
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> alter database recover managed standby database disconnect from session;
alter database recover managed standby database disconnect from session
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active
SQL>
SQL>
SQL> alter database recover managed standby database disconnect from session;
alter database recover managed standby database disconnect from session
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active
SQL> select * from v$pwfile_users;
USERNAME SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM CON_ID
------------------------------ ----- ----- ----- ----- ----- ----- ----------
SYS TRUE TRUE FALSE FALSE FALSE FALSE 0
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 10:47:10 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> alter database recover managed standby database disconnect from session;
alter database recover managed standby database disconnect from session
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 11:56:52 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>set ORACLE_SID=WTENVDR
D:\>lsnrctl status
LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 12-APR-2019 11:57:01
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SGDCPLM03.smr.motherson.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 - Production
Start Date 12-APR-2019 09:02:59
Uptime 0 days 2 hr. 54 min. 5 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\listener.ora
Listener Log File D:\app\plmadmin\diag\tnslsnr\SGDCPLM03\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SGDCPLM03.smr.motherson.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "WTENVDR" has 1 instance(s).
Instance "wtenvdr", status READY, has 1 handler(s) for this service...
Service "test" has 1 instance(s).
Instance "test", status READY, has 1 handler(s) for this service...
Service "testXDB" has 1 instance(s).
Instance "test", status READY, has 1 handler(s) for this service...
The command completed successfully
D:\>
D:\>
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 11:57:06 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> alter database recover managed standby database disconnect from session;
alter database recover managed standby database disconnect from session
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active
SQL> alter database recover managed standby database disconnect from session;
alter database recover managed standby database disconnect from session
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>ping 10.33.105.69
Pinging 10.33.105.69 with 32 bytes of data:
Reply from 10.33.105.69: bytes=32 time<1ms TTL=128
Reply from 10.33.105.69: bytes=32 time<1ms TTL=128
Reply from 10.33.105.69: bytes=32 time<1ms TTL=128
Ping statistics for 10.33.105.69:
Packets: Sent = 3, Received = 3, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms
Control-C
^C
D:\>
D:\>
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 11:59:29 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> e
SP2-0042: unknown command "e" - rest of line ignored.
SQL> slelee
SP2-0042: unknown command "slelee" - rest of line ignored.
SQL> select name from v$datafile;
select name from v$datafile
*
ERROR at line 1:
ORA-12571: TNS:packet writer failure
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 12:47:14 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 12:47:20 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 8.2678E+10 bytes
Fixed Size 7774968 bytes
Variable Size 1.2885E+10 bytes
Database Buffers 6.9525E+10 bytes
Redo Buffers 260657152 bytes
Database mounted.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Mon Apr 15 09:46:09 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
D:\APP\PLMADMIN\ORADATA\WTENVDR\SYSTEM01.DBF
D:\APP\PLMADMIN\ORADATA\WTENVDR\SYSAUX01.DBF
D:\APP\PLMADMIN\ORADATA\WTENVDR\UNDOTBS01.DBF
D:\APP\PLMADMIN\ORADATA\WTENVDR\IDATA01.DBF
D:\APP\PLMADMIN\ORADATA\WTENVDR\ILOG01.DBF
D:\APP\PLMADMIN\ORADATA\WTENVDR\INDX01.DBF
6 rows selected.
SQL> alter datbase recover managed standby database disconnect from session;
alter datbase recover managed standby database disconnect from session
*
ERROR at line 1:
ORA-00940: invalid ALTER command
SQL> alter database recover managed standby database disconnect from session;
Database altered.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>set ORACLE_SID=smrprodb
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Mon Apr 15 10:07:41 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 17
Next log sequence to archive 19
Current log sequence 19
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
SMRPRODB READ WRITE PRIMARY
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>
D:\>
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Mon Apr 15 10:08:20 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
SMRPRODB READ WRITE PRIMARY
SQL> set pagesize 200 linesize 200
SQL>
SQL> select 'set newname for datafile ' || a.FILE# || ' to "' || a.NAME || '";'
2
SQL> from v$datafile a
SP2-0734: unknown command beginning "from v$dat..." - rest of line ignored.
SQL>
SQL> union all
SP2-0042: unknown command "union all" - rest of line ignored.
SQL>
SQL> select 'set newname for tempfile ' || a.FILE# || ' to "' || a.NAME || '";'
2
SQL> from v$tempfile a
SP2-0734: unknown command beginning "from v$tem..." - rest of line ignored.
SQL>
SQL> union all
SP2-0042: unknown command "union all" - rest of line ignored.
SQL>
SQL> SELECT 'SQL "ALTER DATABASE RENAME FILE ''''' || a.MEMBER || ''''' to ''''' ||
2
SQL> a.MEMBER || ''''' ";'
1* SELECT 'SQL "ALTER DATABASE RENAME FILE ''''' || a.MEMBER || ''''' to ''''' ||.MEMBER || ''''' ";'
SQL>
SQL> FROM v$logfile a;
SP2-0734: unknown command beginning "FROM v$log..." - rest of line ignored.
SQL> set pagesize 200 linesize 200
SQL>
SQL> select 'set newname for datafile ' || a.FILE# || ' to "' || a.NAME || '";' from v$datafile a
2
SQL> union all
SP2-0042: unknown command "union all" - rest of line ignored.
SQL>
SQL> select 'set newname for tempfile ' || a.FILE# || ' to "' || a.NAME || '";' from v$tempfile a
2
SQL> union all
SP2-0042: unknown command "union all" - rest of line ignored.
SQL>
SQL> SELECT 'SQL "ALTER DATABASE RENAME FILE ''''' || a.MEMBER || ''''' to ''''' || a.MEMBER || ''''' ";' FROM v$logfile a;
'SQL"ALTERDATABASERENAMEFILE'''''||A.MEMBER||'''''TO'''''||A.MEMBER||'''''";'
------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------
SQL "ALTER DATABASE RENAME FILE ''D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO03.LOG'' to ''D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO03.LOG'' ";
SQL "ALTER DATABASE RENAME FILE ''D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO02.LOG'' to ''D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO02.LOG'' ";
SQL "ALTER DATABASE RENAME FILE ''D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO01.LOG'' to ''D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO01.LOG'' ";
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL> create pfile from spfile;
File created.
SQL> sho parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string D:\APP\PLMADMIN\PRODUCT\12.1.0
\DBHOME_1\DATABASE\SPFILESMRPR
ODB.ORA
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Mon Apr 15 10:17:43 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> SELECT 'SQL "ALTER DATABASE RENAME FILE ''''' || a.MEMBER || ''''' to ''''' || a.MEMBER || ''''' ";' FROM v$logfile a;
'SQL"ALTERDATABASERENAMEFILE'''''||A.MEMBER||'''''TO'''''||A.MEMBER||'''''";'
--------------------------------------------------------------------------------
SQL "ALTER DATABASE RENAME FILE ''D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO03.LOG''
to ''D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO03.LOG'' ";
SQL "ALTER DATABASE RENAME FILE ''D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO02.LOG''
to ''D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO02.LOG'' ";
SQL "ALTER DATABASE RENAME FILE ''D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO01.LOG''
to ''D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO01.LOG'' ";
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
SMRPRODB READ WRITE PRIMARY
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>startup nomount;
'startup' is not recognized as an internal or external command,
operable program or batch file.
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Mon Apr 15 10:21:02 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 8.2678E+10 bytes
Fixed Size 7774968 bytes
Variable Size 1.2885E+10 bytes
Database Buffers 6.9525E+10 bytes
Redo Buffers 260657152 bytes
SQL> restore controlfile from 'D:\oracle12c_dump\rman_backup_63_test\control_63_SMRPRODB_20190415_cf_D-SMRPRODB_id-3201394995_kbtv1rhg.bak';
SP2-0734: unknown command beginning "restore co..." - rest of line ignored.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>set ORACLE_SID=smrprodb
D:\>rman target /
Recovery Manager: Release 12.1.0.2.0 - Production on Mon Apr 15 10:25:16 2019
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to target database: SMRPRODB (not mounted)
RMAN> restore controlfile from 'D:\oracle12c_dump\rman_backup_63_test\control_63_SMRPRODB_20190415_cf_D-SMRPRODB_id-3201394995_kbtv1rhg.bak';
Starting restore at 15-APR-19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=430 device type=DISK
channel ORA_DISK_1: copied control file copy
output file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\CONTROL01.CTL
output file name=D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\CONTROL02.CTL
Finished restore at 15-APR-19
RMAN> alter database mount;
Statement processed
released channel: ORA_DISK_1
RMAN> catalog start with 'D:\oracle12c_dump\rman_backup_63_test\';
Starting implicit crosscheck backup at 15-APR-19
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=430 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=456 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=469 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=482 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=495 device type=DISK
allocated channel: ORA_DISK_6
channel ORA_DISK_6: SID=508 device type=DISK
allocated channel: ORA_DISK_7
channel ORA_DISK_7: SID=521 device type=DISK
allocated channel: ORA_DISK_8
channel ORA_DISK_8: SID=534 device type=DISK
allocated channel: ORA_DISK_9
channel ORA_DISK_9: SID=547 device type=DISK
allocated channel: ORA_DISK_10
channel ORA_DISK_10: SID=560 device type=DISK
allocated channel: ORA_DISK_11
channel ORA_DISK_11: SID=573 device type=DISK
allocated channel: ORA_DISK_12
channel ORA_DISK_12: SID=586 device type=DISK
allocated channel: ORA_DISK_13
channel ORA_DISK_13: SID=599 device type=DISK
allocated channel: ORA_DISK_14
channel ORA_DISK_14: SID=612 device type=DISK
allocated channel: ORA_DISK_15
channel ORA_DISK_15: SID=625 device type=DISK
allocated channel: ORA_DISK_16
channel ORA_DISK_16: SID=638 device type=DISK
allocated channel: ORA_DISK_17
channel ORA_DISK_17: SID=651 device type=DISK
allocated channel: ORA_DISK_18
channel ORA_DISK_18: SID=664 device type=DISK
allocated channel: ORA_DISK_19
channel ORA_DISK_19: SID=677 device type=DISK
allocated channel: ORA_DISK_20
channel ORA_DISK_20: SID=690 device type=DISK
Crosschecked 23 objects
Finished implicit crosscheck backup at 15-APR-19
Starting implicit crosscheck copy at 15-APR-19
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
using channel ORA_DISK_7
using channel ORA_DISK_8
using channel ORA_DISK_9
using channel ORA_DISK_10
using channel ORA_DISK_11
using channel ORA_DISK_12
using channel ORA_DISK_13
using channel ORA_DISK_14
using channel ORA_DISK_15
using channel ORA_DISK_16
using channel ORA_DISK_17
using channel ORA_DISK_18
using channel ORA_DISK_19
using channel ORA_DISK_20
Finished implicit crosscheck copy at 15-APR-19
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_05\O1_MF_1_13_GBGGMS1R_.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_05\O1_MF_1_14_GBGGMS83_.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_05\O1_MF_1_15_GBGGN5CL_.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_05\O1_MF_1_16_GBGNCNB6_.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\O1_MF_1_15_GC8GLZ05_.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\O1_MF_1_16_GC8GM7T2_.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\O1_MF_1_17_GC8GMF8J_.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\O1_MF_1_18_GC8GQGD7_.ARC
searching for all files that match the pattern D:\oracle12c_dump\rman_backup_63_test\
List of Files Unknown to the Database
=====================================
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JFTV1HH0_7791_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JGTV1HH0_7792_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JHTV1HH0_7793_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JITV1HH0_7794_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JJTV1HH7_7795_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JKTV1HH7_7796_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JRTV1HHQ_7803_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JUTV1RGP_7806_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JVTV1RGP_7807_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_K0TV1RGP_7808_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_K1TV1RGP_7809_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_K2TV1RGS_7810_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_K3TV1RGT_7811_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_KATV1RHF_7818_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\CONTROL_63_SMRPRODB_20190415_CF_D-SMRPRODB_ID-3201394995_JSTV1HHR.BAK
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\CONTROL_63_SMRPRODB_20190415_CF_D-SMRPRODB_ID-3201394995_KBTV1RHG.BAK
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\RMAN_SMRPRODB_FULL.LOG
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_JLTV1HH8_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_JMTV1HH8_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_JNTV1HH8_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_JOTV1HH8_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_JPTV1HHA_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_JQTV1HHB_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K4TV1RGU_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K5TV1RGU_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K6TV1RGU_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K7TV1RGU_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K8TV1RGV_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K9TV1RH0_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\STANDBYCONTROL_SMRPRODB_20190415_JTTV1HHS_1_1.CTL
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\STANDBYCONTROL_SMRPRODB_20190415_KCTV1RHI_1_1.CTL
Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JFTV1HH0_7791_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JGTV1HH0_7792_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JHTV1HH0_7793_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JITV1HH0_7794_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JJTV1HH7_7795_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JKTV1HH7_7796_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JRTV1HHQ_7803_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JUTV1RGP_7806_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JVTV1RGP_7807_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_K0TV1RGP_7808_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_K1TV1RGP_7809_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_K2TV1RGS_7810_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_K3TV1RGT_7811_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_KATV1RHF_7818_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\CONTROL_63_SMRPRODB_20190415_CF_D-SMRPRODB_ID-3201394995_JSTV1HHR.BAK
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\CONTROL_63_SMRPRODB_20190415_CF_D-SMRPRODB_ID-3201394995_KBTV1RHG.BAK
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_JLTV1HH8_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_JMTV1HH8_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_JNTV1HH8_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_JOTV1HH8_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_JPTV1HHA_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_JQTV1HHB_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K4TV1RGU_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K5TV1RGU_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K6TV1RGU_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K7TV1RGU_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K8TV1RGV_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K9TV1RH0_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\STANDBYCONTROL_SMRPRODB_20190415_JTTV1HHS_1_1.CTL
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\STANDBYCONTROL_SMRPRODB_20190415_KCTV1RHI_1_1.CTL
List of Files Which Were Not Cataloged
=======================================
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\RMAN_SMRPRODB_FULL.LOG
RMAN-07517: Reason: The file header is corrupted
RMAN> RUN
2> {
3> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo01a.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo01a.log'' ";
4> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo02a.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo02a.log'' ";
5> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo03a.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo03a.log'' ";
6> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo04.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo04.log'' ";
7> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo_05.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo_05.log'' ";
8> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo_06.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo_06.log'' ";
9> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo_07.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo_07.log'' ";
10> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo01b.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo01b.log'' ";
11> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo01c.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo01c.log'' ";
12> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo02b.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo02b.log'' ";
13> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo02c.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo02c.log'' ";
14> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo03b.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo03b.log'' ";
15> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo03c.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo03c.log'' ";
16> set newname for datafile 1 to "D:\app\plmadmin\oradata\smrprodb\system01.dbf";
17> set newname for datafile 2 to "D:\app\plmadmin\oradata\smrprodb\sysaux01.dbf";
18> set newname for datafile 3 to "D:\app\plmadmin\oradata\smrprodb\undotbs01.dbf";
19> set newname for datafile 4 to "D:\app\plmadmin\oradata\smrprodb\idata01.dbf";
20> set newname for datafile 5 to "D:\app\plmadmin\oradata\smrprodb\ilog01.dbf";
21> set newname for datafile 6 to "D:\app\plmadmin\oradata\smrprodb\indx01.dbf";
22> set newname for datafile 7 to "D:\app\plmadmin\oradata\smrprodb\idata02.dbf";
23> set newname for tempfile 1 to "D:\app\plmadmin\oradata\smrprodb\temp01.dbf";
24> RESTORE DATABASE;
25>
26> SWITCH DATAFILE ALL;
27>
28> SWITCH TEMPFILE ALL;
29>
30> RECOVER DATABASE;
31>
32> }
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo01a.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo01a.log''
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo02a.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo02a.log''
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo03a.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo03a.log''
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo04.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo04.log''
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo_05.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo_05.log''
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo_06.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo_06.log''
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo_07.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo_07.log''
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo01b.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo01b.log''
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo01c.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo01c.log''
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo02b.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo02b.log''
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo02c.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo02c.log''
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo03b.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo03b.log''
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo03c.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo03c.log''
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 15-APR-19
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
using channel ORA_DISK_7
using channel ORA_DISK_8
using channel ORA_DISK_9
using channel ORA_DISK_10
using channel ORA_DISK_11
using channel ORA_DISK_12
using channel ORA_DISK_13
using channel ORA_DISK_14
using channel ORA_DISK_15
using channel ORA_DISK_16
using channel ORA_DISK_17
using channel ORA_DISK_18
using channel ORA_DISK_19
using channel ORA_DISK_20
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00003 to D:\app\plmadmin\oradata\smrprodb\undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00006 to D:\app\plmadmin\oradata\smrprodb\indx01.dbf
channel ORA_DISK_1: reading from backup piece D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K7TV1RGU_1_1.BCKP
channel ORA_DISK_2: starting datafile backup set restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
channel ORA_DISK_2: restoring datafile 00001 to D:\app\plmadmin\oradata\smrprodb\system01.dbf
channel ORA_DISK_2: restoring datafile 00005 to D:\app\plmadmin\oradata\smrprodb\ilog01.dbf
channel ORA_DISK_2: reading from backup piece D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K5TV1RGU_1_1.BCKP
channel ORA_DISK_3: starting datafile backup set restore
channel ORA_DISK_3: specifying datafile(s) to restore from backup set
channel ORA_DISK_3: restoring datafile 00002 to D:\app\plmadmin\oradata\smrprodb\sysaux01.dbf
channel ORA_DISK_3: restoring datafile 00007 to D:\app\plmadmin\oradata\smrprodb\idata02.dbf
channel ORA_DISK_3: reading from backup piece D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K6TV1RGU_1_1.BCKP
channel ORA_DISK_4: starting datafile backup set restore
channel ORA_DISK_4: specifying datafile(s) to restore from backup set
channel ORA_DISK_4: restoring datafile 00004 to D:\app\plmadmin\oradata\smrprodb\idata01.dbf
channel ORA_DISK_4: reading from backup piece D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K4TV1RGU_1_1.BCKP
channel ORA_DISK_1: piece handle=D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K7TV1RGU_1_1.BCKP tag=TAG20190415T095542
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:55
channel ORA_DISK_3: piece handle=D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K6TV1RGU_1_1.BCKP tag=TAG20190415T095542
channel ORA_DISK_3: restored backup piece 1
channel ORA_DISK_3: restore complete, elapsed time: 00:00:55
channel ORA_DISK_2: piece handle=D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K5TV1RGU_1_1.BCKP tag=TAG20190415T095542
channel ORA_DISK_2: restored backup piece 1
channel ORA_DISK_2: restore complete, elapsed time: 00:01:05
channel ORA_DISK_4: piece handle=D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K4TV1RGU_1_1.BCKP tag=TAG20190415T095542
channel ORA_DISK_4: restored backup piece 1
channel ORA_DISK_4: restore complete, elapsed time: 00:01:26
Finished restore at 15-APR-19
datafile 1 switched to datafile copy
input datafile copy RECID=547 STAMP=1005656034 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\SYSTEM01.DBF
datafile 2 switched to datafile copy
input datafile copy RECID=548 STAMP=1005656034 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\SYSAUX01.DBF
datafile 3 switched to datafile copy
input datafile copy RECID=549 STAMP=1005656034 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\UNDOTBS01.DBF
datafile 4 switched to datafile copy
input datafile copy RECID=550 STAMP=1005656034 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\IDATA01.DBF
datafile 5 switched to datafile copy
input datafile copy RECID=551 STAMP=1005656034 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\ILOG01.DBF
datafile 6 switched to datafile copy
input datafile copy RECID=552 STAMP=1005656034 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\INDX01.DBF
datafile 7 switched to datafile copy
input datafile copy RECID=553 STAMP=1005656034 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\IDATA02.DBF
renamed tempfile 1 to D:\app\plmadmin\oradata\smrprodb\temp01.dbf in control file
Starting recover at 15-APR-19
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
using channel ORA_DISK_7
using channel ORA_DISK_8
using channel ORA_DISK_9
using channel ORA_DISK_10
using channel ORA_DISK_11
using channel ORA_DISK_12
using channel ORA_DISK_13
using channel ORA_DISK_14
using channel ORA_DISK_15
using channel ORA_DISK_16
using channel ORA_DISK_17
using channel ORA_DISK_18
using channel ORA_DISK_19
using channel ORA_DISK_20
starting media recovery
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=18
channel ORA_DISK_1: reading from backup piece D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_KATV1RHF_7818_1_20190415
channel ORA_DISK_1: piece handle=D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_KATV1RHF_7818_1_20190415 tag=TAG20190415T095559
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\O1_MF_1_18_GC8RP4G7_.ARC thread=1 sequence=18
channel default: deleting archived log(s)
archived log file name=D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\O1_MF_1_18_GC8RP4G7_.ARC RECID=4736 STAMP=1005656036
unable to find archived log
archived log thread=1 sequence=19
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 04/15/2019 12:53:57
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 19 and starting SCN of 410913463
RMAN> RECOVER DATABASE until cancel;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "cancel": expecting one of: "scn, sequence, time"
RMAN-01007: at line 1 column 24 file: standard input
RMAN> RECOVER DATABASE until cancel;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "cancel": expecting one of: "scn, sequence, time"
RMAN-01007: at line 1 column 24 file: standard input
RMAN> RECOVER DATABASE noredo;
Starting recover at 15-APR-19
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
using channel ORA_DISK_7
using channel ORA_DISK_8
using channel ORA_DISK_9
using channel ORA_DISK_10
using channel ORA_DISK_11
using channel ORA_DISK_12
using channel ORA_DISK_13
using channel ORA_DISK_14
using channel ORA_DISK_15
using channel ORA_DISK_16
using channel ORA_DISK_17
using channel ORA_DISK_18
using channel ORA_DISK_19
using channel ORA_DISK_20
Finished recover at 15-APR-19
RMAN>
(c) 2013 Microsoft Corporation. All rights reserved.
C:\Windows\system32>pwd
'pwd' is not recognized as an internal or external command,
operable program or batch file.
C:\Windows\system32>
C:\Windows\system32>
C:\Windows\system32>
C:\Windows\system32>
C:\Windows\system32>sqlplus sys/system123
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:00:58 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
C:\Windows\system32>sqlplus sys/system123@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:01:07 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
WTENV MOUNTED PHYSICAL STANDBY
SQL> sho parameter local
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string LISTENER_WTENVDR
parallel_force_local boolean FALSE
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
C:\Windows\system32>lsnrctl status
LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 10-APR-2019 16:02:07
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SGDCPLM03.smr.motherson.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 - Production
Start Date 10-APR-2019 15:51:12
Uptime 0 days 0 hr. 10 min. 59 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\listener.ora
Listener Log File D:\app\plmadmin\diag\tnslsnr\SGDCPLM03\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SGDCPLM03.smr.motherson.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "WTENVDR" has 1 instance(s).
Instance "wtenvdr", status READY, has 1 handler(s) for this service...
Service "test" has 1 instance(s).
Instance "test", status READY, has 1 handler(s) for this service...
Service "testXDB" has 1 instance(s).
Instance "test", status READY, has 1 handler(s) for this service...
The command completed successfully
C:\Windows\system32>sqlplus sys/system123@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:03:15 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
WTENV MOUNTED PHYSICAL STANDBY
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
WTENV MOUNTED PHYSICAL STANDBY
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
C:\Windows\system32>sqlplus sys/system123@test as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:03:34 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
TEST READ WRITE PRIMARY
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
C:\Windows\system32>sqlplus sys/system123@test as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:03:56 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
C:\Windows\system32>
C:\Windows\system32>sqlplus sys/system123@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:04:05 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
C:\Windows\system32>
C:\Windows\system32>
C:\Windows\system32>sqlplus sys/infodba@test as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:04:21 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
TEST READ WRITE PRIMARY
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
C:\Windows\system32>sqlplus sys/system123@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:04:29 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
C:\Windows\system32>sqlplus sys/system123@test as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:04:34 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
C:\Windows\system32>
C:\Windows\system32>lsnrctl status
LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 10-APR-2019 16:04:38
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SGDCPLM03.smr.motherson.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 - Production
Start Date 10-APR-2019 15:51:12
Uptime 0 days 0 hr. 13 min. 29 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\listener.ora
Listener Log File D:\app\plmadmin\diag\tnslsnr\SGDCPLM03\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SGDCPLM03.smr.motherson.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "WTENVDR" has 1 instance(s).
Instance "wtenvdr", status READY, has 1 handler(s) for this service...
Service "test" has 1 instance(s).
Instance "test", status READY, has 1 handler(s) for this service...
Service "testXDB" has 1 instance(s).
Instance "test", status READY, has 1 handler(s) for this service...
The command completed successfully
C:\Windows\system32>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:04:54 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
C:\Windows\system32>
C:\Windows\system32>sqlplus sys/infodba@wtenv as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:05:01 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
WTENV READ WRITE PRIMARY
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
C:\Windows\system32>sqlplus sys/system123@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:16:25 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name: select name,open_mode,database_role from v$database;
SP2-0306: Invalid option.
Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM|SYSBACKUP|SYSDG|SYSKM}] [edition=value]]
where <logon> ::= <username>[/<password>][@<connect_identifier>]
<proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
C:\Windows\system32>
C:\Windows\system32>sqlplus sys/system123@test as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:16:35 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name: select name,open_mode,database_role from v$database;
SP2-0306: Invalid option.
Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM|SYSBACKUP|SYSDG|SYSKM}] [edition=value]]
where <logon> ::= <username>[/<password>][@<connect_identifier>]
<proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
C:\Windows\system32>
C:\Windows\system32>sqlplus sys/infodba@test as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:16:42 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
TEST READ WRITE PRIMARY
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
C:\Windows\system32>
C:\Windows\system32>sqlplus sys/infodba@test as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:52:21 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
C:\Windows\system32>sqlplus sys/system123@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:52:26 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
C:\Windows\system32>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:52:37 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
C:\Windows\system32>
C:\Windows\system32>D:
D:\>orapwd file=D:\app\plmadmin\product\12.1.0\dbhome_1\database\PWDtest.ora password=system123 entries=5 FORCE=Y
D:\>sqlplus sys/infodba@test as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:58:36 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>
D:\>sqlplus sys/system123@test as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 16:58:48 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>orapwd file=D:\app\plmadmin\product\12.1.0\dbhome_1\database\PWDwtenvdr.ora password=infodba entries=5 FORCE=Y
D:\>sqlplus sys/system123@test as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 17:00:07 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 17:00:15 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
WTENV MOUNTED PHYSICAL STANDBY
SQL> alter database recover managed standby database disconnect tfrom session;
alter database recover managed standby database disconnect tfrom session
*
ERROR at line 1:
ORA-00274: illegal recovery option TFROM
SQL> alter database recover managed standby database disconnect from session;
alter database recover managed standby database disconnect from session
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active
SQL> desc v$managed_standby;
Name Null? Type
----------------------------------------- -------- ----------------------------
PROCESS VARCHAR2(9)
PID VARCHAR2(24)
STATUS VARCHAR2(12)
CLIENT_PROCESS VARCHAR2(8)
CLIENT_PID VARCHAR2(40)
CLIENT_DBID VARCHAR2(40)
GROUP# VARCHAR2(40)
RESETLOG_ID NUMBER
THREAD# NUMBER
SEQUENCE# NUMBER
BLOCK# NUMBER
BLOCKS NUMBER
DELAY_MINS NUMBER
KNOWN_AGENTS NUMBER
ACTIVE_AGENTS NUMBER
CON_ID NUMBER
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>lsnrctl status
LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 10-APR-2019 17:03:59
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SGDCPLM03.smr.motherson.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 - Production
Start Date 10-APR-2019 15:51:12
Uptime 0 days 1 hr. 12 min. 50 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\listener.ora
Listener Log File D:\app\plmadmin\diag\tnslsnr\SGDCPLM03\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SGDCPLM03.smr.motherson.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "WTENVDR" has 1 instance(s).
Instance "wtenvdr", status READY, has 1 handler(s) for this service...
Service "test" has 1 instance(s).
Instance "test", status READY, has 1 handler(s) for this service...
Service "testXDB" has 1 instance(s).
Instance "test", status READY, has 1 handler(s) for this service...
The command completed successfully
D:\>tnsping wtenvdr
TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 10-APR-2019 17:04:09
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.33.105.69)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = w
tenvdr)))
OK (0 msec)
D:\>tnsping wtenv
TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 10-APR-2019 17:04:13
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = SGDCPLM01)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = wten
v)))
OK (20 msec)
D:\>tnsping wtenvdr
TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 10-APR-2019 17:06:32
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.33.105.69)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = w
tenvdr)))
OK (0 msec)
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 17:06:43 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> alter database recover managed standby database disconnect from session;
alter database recover managed standby database disconnect from session
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 17:12:04 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/infodqqqba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 17:12:11 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 17:12:19 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/system123@test as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 17:12:27 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select process,status,sequence# from v$managed_standby;
no rows selected
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
TEST READ WRITE PRIMARY
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 16
Current log sequence 18
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
TEST READ WRITE PRIMARY
SQL> alter database recover managed standby database disconnect from session;
alter database recover managed standby database disconnect from session
*
ERROR at line 1:
ORA-01665: control file is not a standby control file
SQL> select process,status,sequence# from v$managed_standby;
no rows selected
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 17:13:49 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>oradim -delete -sid WTENVDR
Instance deleted.
D:\>
D:\>oradim -new -sid WTENV -SYSPWD infodba -pfile D:\app\plmadmin\product\12.1.0\dbhome_1\database\INITwtenvdr.ora
Instance created.
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 17:22:21 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>
D:\>tnsping wtenvdr
TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 10-APR-2019 17:22:35
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.33.105.69)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = w
tenvdr)))
OK (0 msec)
D:\>oradim -delete -sid WTENV
Instance deleted.
D:\>oradim -new -sid WTENVDR -SYSPWD infodba -pfile D:\app\plmadmin\product\12.1.0\dbhome_1\database\INITwtenvdr.ora
OPW-00005: File with same name exists - please delete or rename
Instance created.
D:\>tnsping wtenvdr
TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 10-APR-2019 17:23:35
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.33.105.69)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = w
tenvdr)))
OK (0 msec)
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 17:23:37 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>
D:\>
D:\>
D:\>oradim -new -sid WTENV -SYSPWD infodba -pfile D:\app\plmadmin\product\12.1.0\dbhome_1\database\INITwtenvdr.ora
OPW-00005: File with same name exists - please delete or rename
Instance created.
D:\>
D:\>
D:\>
D:\>
D:\>
D:\>
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 10 17:24:20 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 08:35:42 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 08:35:49 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>
D:\>sqlplus sys/system123@test as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 08:35:57 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
TEST READ WRITE PRIMARY
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>SC DELETE OracleServiceWTENVDR
[SC] DeleteService SUCCESS
D:\>sqlplus sys/system123@test as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 08:51:32 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
TEST READ WRITE PRIMARY
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/sys@test as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 08:51:42 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>
D:\>sqlplus sys/infodba@wtenv as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 08:52:10 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
WTENV READ WRITE PRIMARY
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 08:52:20 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>
D:\>sc delete OracleServiceWTENV
[SC] DeleteService SUCCESS
D:\>oradim -new -sid WTENVDR -SYSPWD infodba -pfile D:\app\plmadmin\product\12.1.0\dbhome_1\database\INITwtenvdr.ora
OPW-00005: File with same name exists - please delete or rename
Instance created.
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 08:57:51 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 08:57:57 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>
D:\>
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 08:58:03 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>
D:\>
D:\>
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 08:58:40 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
TEST READ WRITE PRIMARY
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 08:59:04 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>
D:\>
D:\>set ORACLE_SID=wtendr
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 08:59:38 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 09:01:22 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name: select name,open_mode,database_role from v$database;
SP2-0306: Invalid option.
Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM|SYSBACKUP|SYSDG|SYSKM}] [edition=value]]
where <logon> ::= <username>[/<password>][@<connect_identifier>]
<proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 09:01:31 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 09:02:21 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 09:02:27 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name: \\
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>
D:\>lsnrctl status
LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 12-APR-2019 09:02:39
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SGDCPLM03.smr.motherson.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 - Production
Start Date 10-APR-2019 15:51:12
Uptime 1 days 17 hr. 11 min. 30 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\listener.ora
Listener Log File D:\app\plmadmin\diag\tnslsnr\SGDCPLM03\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SGDCPLM03.smr.motherson.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "test" has 1 instance(s).
Instance "test", status READY, has 1 handler(s) for this service...
Service "testXDB" has 1 instance(s).
Instance "test", status READY, has 1 handler(s) for this service...
The command completed successfully
D:\>lsnrctl stop
LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 12-APR-2019 09:02:46
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SGDCPLM03.smr.motherson.com)(PORT=1521)))
The command completed successfully
D:\>lsnrctl start
LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 12-APR-2019 09:02:54
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Starting tnslsnr: please wait...
TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 - Production
System parameter file is D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\listener.ora
Log messages written to D:\app\plmadmin\diag\tnslsnr\SGDCPLM03\listener\alert\log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SGDCPLM03.smr.motherson.com)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SGDCPLM03.smr.motherson.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 - Production
Start Date 12-APR-2019 09:02:59
Uptime 0 days 0 hr. 0 min. 8 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\listener.ora
Listener Log File D:\app\plmadmin\diag\tnslsnr\SGDCPLM03\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SGDCPLM03.smr.motherson.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
D:\>set ORACLE_SID=wtendr
D:\>set ORACLE_SID=wtenvdr
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 09:03:24 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 8.2678E+10 bytes
Fixed Size 7774968 bytes
Variable Size 1.2885E+10 bytes
Database Buffers 6.9525E+10 bytes
Redo Buffers 260657152 bytes
Database mounted.
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
WTENV MOUNTED PHYSICAL STANDBY
SQL> select name,db_unique_name,open_mode,database_role from v$database;
NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE
--------- ------------------------------ -------------------- ----------------
WTENV WTENVDR MOUNTED PHYSICAL STANDBY
SQL> alter database recover managed standby database disconnect from session;
Database altered.
SQL> select name,db_unique_name,open_mode,database_role from v$database;\
2
SQL>
SQL> select name,db_unique_name,open_mode,database_role from v$database;
NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE
--------- ------------------------------ -------------------- ----------------
WTENV WTENVDR MOUNTED PHYSICAL STANDBY
SQL> desc v$managed_standby
Name Null? Type
----------------------------------------- -------- ----------------------------
PROCESS VARCHAR2(9)
PID VARCHAR2(24)
STATUS VARCHAR2(12)
CLIENT_PROCESS VARCHAR2(8)
CLIENT_PID VARCHAR2(40)
CLIENT_DBID VARCHAR2(40)
GROUP# VARCHAR2(40)
RESETLOG_ID NUMBER
THREAD# NUMBER
SEQUENCE# NUMBER
BLOCK# NUMBER
BLOCKS NUMBER
DELAY_MINS NUMBER
KNOWN_AGENTS NUMBER
ACTIVE_AGENTS NUMBER
CON_ID NUMBER
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 09:06:17 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> select name,db_unique_name,open_mode,database_role from v$database;
NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE
--------- ------------------------------ -------------------- ----------------
WTENV WTENVDR MOUNTED PHYSICAL STANDBY
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 09:13:45 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> sho parameter fal
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
fal_client string WTENVDR
fal_server string WTENV
SQL> sho parameter standby_file
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_file_management string MANUAL
SQL> alter database recover managed standby database disconnect from session;
alter database recover managed standby database disconnect from session
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active
SQL> alter system set standby_file_management=auto scope=both;
System altered.
SQL> sho parameter standby_file
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_file_management string AUTO
SQL> alter database recover managed standby database disconnect from session;
alter database recover managed standby database disconnect from session
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active
SQL> sho parameter fal
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
fal_client string WTENVDR
fal_server string WTENV
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>pwd
'pwd' is not recognized as an internal or external command,
operable program or batch file.
D:\>tnsping wtenvdr
TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 12-APR-2019 09:28:29
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.33.105.69)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = w
tenvdr)))
OK (0 msec)
D:\>tnsping wtenv
TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 12-APR-2019 09:28:32
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = SGDCPLM01)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = wten
v)))
OK (20 msec)
D:\>tnsping wtenv
TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 12-APR-2019 09:30:16
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = SGDCPLM01)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = wten
v)))
OK (10 msec)
D:\>tnsping wtenvdr
TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 12-APR-2019 09:30:18
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.33.105.69)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = w
tenvdr)))
OK (0 msec)
D:\>tnsping test
TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 12-APR-2019 09:30:22
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = SGDCPLM03.smr.motherson.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED
) (SERVICE_NAME = test)))
OK (20 msec)
D:\>sqlplus sys/system123@test as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 09:30:35 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select process,status,sequence# from v$managed_standby;
no rows selected
SQL> select name,db_unique_name,open_mode,database_role from v$database;
NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE
--------- ------------------------------ -------------------- ----------------
TEST test READ WRITE PRIMARY
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 09:30:53 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name,db_unique_name,open_mode,database_role from v$database;
NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE
--------- ------------------------------ -------------------- ----------------
WTENV WTENVDR MOUNTED PHYSICAL STANDBY
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/infodba@wtenv as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 09:31:21 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CLOSING 968
ARCH CLOSING 966
ARCH CONNECTED 0
LNS OPENING 948
ARCH CLOSING 967
SQL> select name,db_unique_name,open_mode,database_role from v$database;
NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE
--------- ------------------------------ -------------------- ----------------
WTENV WTENV READ WRITE PRIMARY
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/infodbaaaa@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 09:31:38 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 09:31:45 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name,db_unique_name,open_mode,database_role from v$database;
NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE
--------- ------------------------------ -------------------- ----------------
WTENV WTENVDR MOUNTED PHYSICAL STANDBY
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL>
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/infodba@wtenv as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 09:39:06 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CLOSING 968
ARCH CLOSING 966
ARCH CONNECTED 0
LNS OPENING 948
ARCH CLOSING 967
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CLOSING 968
ARCH CLOSING 966
ARCH CONNECTED 0
LNS OPENING 948
ARCH CLOSING 967
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 09:40:53 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> archive logl ist;
SP2-0734: unknown command beginning "archive lo..." - rest of line ignored.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination D:\wtenv_archivelog
Oldest online log sequence 0
Next log sequence to archive 0
Current log sequence 0
SQL> sho parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string D:\APP\PLMADMIN\PRODUCT\12.1.0
\DBHOME_1\DATABASE\SPFILEWTENV
DR.ORA
SQL> sho parameter db_standby
SQL> sho parameter standby_file
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_file_management string AUTO
SQL>
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/infodba@wtenv as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 09:54:57 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> sho parameter standby_file
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_file_management string AUTO
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CLOSING 968
ARCH CLOSING 966
ARCH CONNECTED 0
LNS OPENING 948
ARCH CLOSING 967
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 09:55:11 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>lsnrctl status
LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 12-APR-2019 09:56:15
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SGDCPLM03.smr.motherson.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 - Production
Start Date 12-APR-2019 09:02:59
Uptime 0 days 0 hr. 53 min. 19 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\listener.ora
Listener Log File D:\app\plmadmin\diag\tnslsnr\SGDCPLM03\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SGDCPLM03.smr.motherson.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "WTENVDR" has 1 instance(s).
Instance "wtenvdr", status READY, has 1 handler(s) for this service...
Service "test" has 1 instance(s).
Instance "test", status READY, has 1 handler(s) for this service...
Service "testXDB" has 1 instance(s).
Instance "test", status READY, has 1 handler(s) for this service...
The command completed successfully
D:\>lsnrctl status
LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 12-APR-2019 10:02:32
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SGDCPLM03.smr.motherson.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 - Production
Start Date 12-APR-2019 09:02:59
Uptime 0 days 0 hr. 59 min. 36 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\listener.ora
Listener Log File D:\app\plmadmin\diag\tnslsnr\SGDCPLM03\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SGDCPLM03.smr.motherson.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "test" has 1 instance(s).
Instance "test", status READY, has 1 handler(s) for this service...
Service "testXDB" has 1 instance(s).
Instance "test", status READY, has 1 handler(s) for this service...
The command completed successfully
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 10:02:35 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>set ORACLE_SID=WTENVDR
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 10:02:58 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 10:03:21 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 10:06:34 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 8.2678E+10 bytes
Fixed Size 7774968 bytes
Variable Size 1.2885E+10 bytes
Database Buffers 6.9525E+10 bytes
Redo Buffers 260657152 bytes
Database mounted.
SQL> alter database convert to snapshot standby;
Database altered.
SQL> alter database open;
Database altered.
SQL> select status,instance_name,database_role,open_mode from v$database,v$Instance;
STATUS INSTANCE_NAME DATABASE_ROLE OPEN_MODE
------------ ---------------- ---------------- --------------------
OPEN wtenvdr SNAPSHOT STANDBY READ WRITE
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
LNS CONNECTED 0
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 8.2678E+10 bytes
Fixed Size 7774968 bytes
Variable Size 1.2885E+10 bytes
Database Buffers 6.9525E+10 bytes
Redo Buffers 260657152 bytes
Database mounted.
SQL> alter database convert to physical standby;
Database altered.
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
SQL> select status,instance_name,database_role,open_mode from v$database,v$Instance;
STATUS INSTANCE_NAME DATABASE_ROLE OPEN_MODE
------------ ---------------- ---------------- --------------------
MOUNTED wtenvdr PHYSICAL STANDBY MOUNTED
SQL> alter database recover managed standby database disconnect from session;
Database altered.
SQL> select status,instance_name,database_role,open_mode from v$database,v$Instance;
STATUS INSTANCE_NAME DATABASE_ROLE OPEN_MODE
------------ ---------------- ---------------- --------------------
MOUNTED wtenvdr PHYSICAL STANDBY MOUNTED
SQL> alter database convert to physical standby;
alter database convert to physical standby
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> sho parameter standby_file
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_file_management string AUTO
SQL> select * from v$pwselect * from v$pwfile_users;
select * from v$pwselect * from v$pwfile_users
*
ERROR at line 1:
ORA-00933: SQL command not properly ended
SQL> select * from v$pwfile_users;
no rows selected
SQL> select * from v$pwfile_users;
no rows selected
SQL> shut immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 10:38:45 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 8.2678E+10 bytes
Fixed Size 7774968 bytes
Variable Size 1.2885E+10 bytes
Database Buffers 6.9525E+10 bytes
Redo Buffers 260657152 bytes
Database mounted.
SQL> select * from v$pwfile_users;
no rows selected
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
SQL> alter database recover managed standby database disconnect from session;
Database altered.
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> select * from v$pwfile_users;
no rows selected
SQL> select * from v$pwfile_users;
no rows selected
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 10:42:49 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select * from v$pwfile_users;
no rows selected
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 10:43:21 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select * from v$pwfile_users;
USERNAME SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM CON_ID
------------------------------ ----- ----- ----- ----- ----- ----- ----------
SYS TRUE TRUE FALSE FALSE FALSE FALSE 0
SQL> select * from v$pwfile_users;
USERNAME SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM CON_ID
------------------------------ ----- ----- ----- ----- ----- ----- ----------
SYS TRUE TRUE FALSE FALSE FALSE FALSE 0
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>tnsping wtenvdr
TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 12-APR-2019 10:44:07
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.33.105.69)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = w
tenvdr)))
OK (20 msec)
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 10:44:09 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select * from v$pwfile_users;
USERNAME SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM CON_ID
------------------------------ ----- ----- ----- ----- ----- ----- ----------
SYS TRUE TRUE FALSE FALSE FALSE FALSE 0
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> alter database recover managed standby database disconnect from session;
alter database recover managed standby database disconnect from session
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active
SQL>
SQL>
SQL> alter database recover managed standby database disconnect from session;
alter database recover managed standby database disconnect from session
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active
SQL> select * from v$pwfile_users;
USERNAME SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM CON_ID
------------------------------ ----- ----- ----- ----- ----- ----- ----------
SYS TRUE TRUE FALSE FALSE FALSE FALSE 0
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 10:47:10 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> alter database recover managed standby database disconnect from session;
alter database recover managed standby database disconnect from session
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 11:56:52 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>set ORACLE_SID=WTENVDR
D:\>lsnrctl status
LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 12-APR-2019 11:57:01
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SGDCPLM03.smr.motherson.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 - Production
Start Date 12-APR-2019 09:02:59
Uptime 0 days 2 hr. 54 min. 5 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\app\plmadmin\product\12.1.0\dbhome_1\network\admin\listener.ora
Listener Log File D:\app\plmadmin\diag\tnslsnr\SGDCPLM03\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SGDCPLM03.smr.motherson.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "WTENVDR" has 1 instance(s).
Instance "wtenvdr", status READY, has 1 handler(s) for this service...
Service "test" has 1 instance(s).
Instance "test", status READY, has 1 handler(s) for this service...
Service "testXDB" has 1 instance(s).
Instance "test", status READY, has 1 handler(s) for this service...
The command completed successfully
D:\>
D:\>
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 11:57:06 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> alter database recover managed standby database disconnect from session;
alter database recover managed standby database disconnect from session
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active
SQL> alter database recover managed standby database disconnect from session;
alter database recover managed standby database disconnect from session
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>ping 10.33.105.69
Pinging 10.33.105.69 with 32 bytes of data:
Reply from 10.33.105.69: bytes=32 time<1ms TTL=128
Reply from 10.33.105.69: bytes=32 time<1ms TTL=128
Reply from 10.33.105.69: bytes=32 time<1ms TTL=128
Ping statistics for 10.33.105.69:
Packets: Sent = 3, Received = 3, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms
Control-C
^C
D:\>
D:\>
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 11:59:29 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 952
SQL> e
SP2-0042: unknown command "e" - rest of line ignored.
SQL> slelee
SP2-0042: unknown command "slelee" - rest of line ignored.
SQL> select name from v$datafile;
select name from v$datafile
*
ERROR at line 1:
ORA-12571: TNS:packet writer failure
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus sys/infodba@wtenvdr as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 12:47:14 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 12 12:47:20 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 8.2678E+10 bytes
Fixed Size 7774968 bytes
Variable Size 1.2885E+10 bytes
Database Buffers 6.9525E+10 bytes
Redo Buffers 260657152 bytes
Database mounted.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Mon Apr 15 09:46:09 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
D:\APP\PLMADMIN\ORADATA\WTENVDR\SYSTEM01.DBF
D:\APP\PLMADMIN\ORADATA\WTENVDR\SYSAUX01.DBF
D:\APP\PLMADMIN\ORADATA\WTENVDR\UNDOTBS01.DBF
D:\APP\PLMADMIN\ORADATA\WTENVDR\IDATA01.DBF
D:\APP\PLMADMIN\ORADATA\WTENVDR\ILOG01.DBF
D:\APP\PLMADMIN\ORADATA\WTENVDR\INDX01.DBF
6 rows selected.
SQL> alter datbase recover managed standby database disconnect from session;
alter datbase recover managed standby database disconnect from session
*
ERROR at line 1:
ORA-00940: invalid ALTER command
SQL> alter database recover managed standby database disconnect from session;
Database altered.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>set ORACLE_SID=smrprodb
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Mon Apr 15 10:07:41 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 17
Next log sequence to archive 19
Current log sequence 19
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
SMRPRODB READ WRITE PRIMARY
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>
D:\>
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Mon Apr 15 10:08:20 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
SMRPRODB READ WRITE PRIMARY
SQL> set pagesize 200 linesize 200
SQL>
SQL> select 'set newname for datafile ' || a.FILE# || ' to "' || a.NAME || '";'
2
SQL> from v$datafile a
SP2-0734: unknown command beginning "from v$dat..." - rest of line ignored.
SQL>
SQL> union all
SP2-0042: unknown command "union all" - rest of line ignored.
SQL>
SQL> select 'set newname for tempfile ' || a.FILE# || ' to "' || a.NAME || '";'
2
SQL> from v$tempfile a
SP2-0734: unknown command beginning "from v$tem..." - rest of line ignored.
SQL>
SQL> union all
SP2-0042: unknown command "union all" - rest of line ignored.
SQL>
SQL> SELECT 'SQL "ALTER DATABASE RENAME FILE ''''' || a.MEMBER || ''''' to ''''' ||
2
SQL> a.MEMBER || ''''' ";'
1* SELECT 'SQL "ALTER DATABASE RENAME FILE ''''' || a.MEMBER || ''''' to ''''' ||.MEMBER || ''''' ";'
SQL>
SQL> FROM v$logfile a;
SP2-0734: unknown command beginning "FROM v$log..." - rest of line ignored.
SQL> set pagesize 200 linesize 200
SQL>
SQL> select 'set newname for datafile ' || a.FILE# || ' to "' || a.NAME || '";' from v$datafile a
2
SQL> union all
SP2-0042: unknown command "union all" - rest of line ignored.
SQL>
SQL> select 'set newname for tempfile ' || a.FILE# || ' to "' || a.NAME || '";' from v$tempfile a
2
SQL> union all
SP2-0042: unknown command "union all" - rest of line ignored.
SQL>
SQL> SELECT 'SQL "ALTER DATABASE RENAME FILE ''''' || a.MEMBER || ''''' to ''''' || a.MEMBER || ''''' ";' FROM v$logfile a;
'SQL"ALTERDATABASERENAMEFILE'''''||A.MEMBER||'''''TO'''''||A.MEMBER||'''''";'
------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------
SQL "ALTER DATABASE RENAME FILE ''D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO03.LOG'' to ''D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO03.LOG'' ";
SQL "ALTER DATABASE RENAME FILE ''D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO02.LOG'' to ''D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO02.LOG'' ";
SQL "ALTER DATABASE RENAME FILE ''D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO01.LOG'' to ''D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO01.LOG'' ";
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL> create pfile from spfile;
File created.
SQL> sho parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string D:\APP\PLMADMIN\PRODUCT\12.1.0
\DBHOME_1\DATABASE\SPFILESMRPR
ODB.ORA
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Mon Apr 15 10:17:43 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> SELECT 'SQL "ALTER DATABASE RENAME FILE ''''' || a.MEMBER || ''''' to ''''' || a.MEMBER || ''''' ";' FROM v$logfile a;
'SQL"ALTERDATABASERENAMEFILE'''''||A.MEMBER||'''''TO'''''||A.MEMBER||'''''";'
--------------------------------------------------------------------------------
SQL "ALTER DATABASE RENAME FILE ''D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO03.LOG''
to ''D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO03.LOG'' ";
SQL "ALTER DATABASE RENAME FILE ''D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO02.LOG''
to ''D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO02.LOG'' ";
SQL "ALTER DATABASE RENAME FILE ''D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO01.LOG''
to ''D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO01.LOG'' ";
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
SMRPRODB READ WRITE PRIMARY
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>startup nomount;
'startup' is not recognized as an internal or external command,
operable program or batch file.
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Mon Apr 15 10:21:02 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 8.2678E+10 bytes
Fixed Size 7774968 bytes
Variable Size 1.2885E+10 bytes
Database Buffers 6.9525E+10 bytes
Redo Buffers 260657152 bytes
SQL> restore controlfile from 'D:\oracle12c_dump\rman_backup_63_test\control_63_SMRPRODB_20190415_cf_D-SMRPRODB_id-3201394995_kbtv1rhg.bak';
SP2-0734: unknown command beginning "restore co..." - rest of line ignored.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>set ORACLE_SID=smrprodb
D:\>rman target /
Recovery Manager: Release 12.1.0.2.0 - Production on Mon Apr 15 10:25:16 2019
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to target database: SMRPRODB (not mounted)
RMAN> restore controlfile from 'D:\oracle12c_dump\rman_backup_63_test\control_63_SMRPRODB_20190415_cf_D-SMRPRODB_id-3201394995_kbtv1rhg.bak';
Starting restore at 15-APR-19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=430 device type=DISK
channel ORA_DISK_1: copied control file copy
output file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\CONTROL01.CTL
output file name=D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\CONTROL02.CTL
Finished restore at 15-APR-19
RMAN> alter database mount;
Statement processed
released channel: ORA_DISK_1
RMAN> catalog start with 'D:\oracle12c_dump\rman_backup_63_test\';
Starting implicit crosscheck backup at 15-APR-19
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=430 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=456 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=469 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=482 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=495 device type=DISK
allocated channel: ORA_DISK_6
channel ORA_DISK_6: SID=508 device type=DISK
allocated channel: ORA_DISK_7
channel ORA_DISK_7: SID=521 device type=DISK
allocated channel: ORA_DISK_8
channel ORA_DISK_8: SID=534 device type=DISK
allocated channel: ORA_DISK_9
channel ORA_DISK_9: SID=547 device type=DISK
allocated channel: ORA_DISK_10
channel ORA_DISK_10: SID=560 device type=DISK
allocated channel: ORA_DISK_11
channel ORA_DISK_11: SID=573 device type=DISK
allocated channel: ORA_DISK_12
channel ORA_DISK_12: SID=586 device type=DISK
allocated channel: ORA_DISK_13
channel ORA_DISK_13: SID=599 device type=DISK
allocated channel: ORA_DISK_14
channel ORA_DISK_14: SID=612 device type=DISK
allocated channel: ORA_DISK_15
channel ORA_DISK_15: SID=625 device type=DISK
allocated channel: ORA_DISK_16
channel ORA_DISK_16: SID=638 device type=DISK
allocated channel: ORA_DISK_17
channel ORA_DISK_17: SID=651 device type=DISK
allocated channel: ORA_DISK_18
channel ORA_DISK_18: SID=664 device type=DISK
allocated channel: ORA_DISK_19
channel ORA_DISK_19: SID=677 device type=DISK
allocated channel: ORA_DISK_20
channel ORA_DISK_20: SID=690 device type=DISK
Crosschecked 23 objects
Finished implicit crosscheck backup at 15-APR-19
Starting implicit crosscheck copy at 15-APR-19
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
using channel ORA_DISK_7
using channel ORA_DISK_8
using channel ORA_DISK_9
using channel ORA_DISK_10
using channel ORA_DISK_11
using channel ORA_DISK_12
using channel ORA_DISK_13
using channel ORA_DISK_14
using channel ORA_DISK_15
using channel ORA_DISK_16
using channel ORA_DISK_17
using channel ORA_DISK_18
using channel ORA_DISK_19
using channel ORA_DISK_20
Finished implicit crosscheck copy at 15-APR-19
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_05\O1_MF_1_13_GBGGMS1R_.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_05\O1_MF_1_14_GBGGMS83_.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_05\O1_MF_1_15_GBGGN5CL_.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_05\O1_MF_1_16_GBGNCNB6_.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\O1_MF_1_15_GC8GLZ05_.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\O1_MF_1_16_GC8GM7T2_.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\O1_MF_1_17_GC8GMF8J_.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\O1_MF_1_18_GC8GQGD7_.ARC
searching for all files that match the pattern D:\oracle12c_dump\rman_backup_63_test\
List of Files Unknown to the Database
=====================================
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JFTV1HH0_7791_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JGTV1HH0_7792_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JHTV1HH0_7793_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JITV1HH0_7794_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JJTV1HH7_7795_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JKTV1HH7_7796_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JRTV1HHQ_7803_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JUTV1RGP_7806_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JVTV1RGP_7807_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_K0TV1RGP_7808_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_K1TV1RGP_7809_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_K2TV1RGS_7810_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_K3TV1RGT_7811_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_KATV1RHF_7818_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\CONTROL_63_SMRPRODB_20190415_CF_D-SMRPRODB_ID-3201394995_JSTV1HHR.BAK
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\CONTROL_63_SMRPRODB_20190415_CF_D-SMRPRODB_ID-3201394995_KBTV1RHG.BAK
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\RMAN_SMRPRODB_FULL.LOG
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_JLTV1HH8_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_JMTV1HH8_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_JNTV1HH8_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_JOTV1HH8_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_JPTV1HHA_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_JQTV1HHB_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K4TV1RGU_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K5TV1RGU_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K6TV1RGU_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K7TV1RGU_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K8TV1RGV_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K9TV1RH0_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\STANDBYCONTROL_SMRPRODB_20190415_JTTV1HHS_1_1.CTL
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\STANDBYCONTROL_SMRPRODB_20190415_KCTV1RHI_1_1.CTL
Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JFTV1HH0_7791_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JGTV1HH0_7792_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JHTV1HH0_7793_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JITV1HH0_7794_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JJTV1HH7_7795_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JKTV1HH7_7796_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JRTV1HHQ_7803_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JUTV1RGP_7806_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JVTV1RGP_7807_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_K0TV1RGP_7808_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_K1TV1RGP_7809_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_K2TV1RGS_7810_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_K3TV1RGT_7811_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_KATV1RHF_7818_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\CONTROL_63_SMRPRODB_20190415_CF_D-SMRPRODB_ID-3201394995_JSTV1HHR.BAK
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\CONTROL_63_SMRPRODB_20190415_CF_D-SMRPRODB_ID-3201394995_KBTV1RHG.BAK
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_JLTV1HH8_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_JMTV1HH8_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_JNTV1HH8_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_JOTV1HH8_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_JPTV1HHA_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_JQTV1HHB_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K4TV1RGU_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K5TV1RGU_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K6TV1RGU_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K7TV1RGU_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K8TV1RGV_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K9TV1RH0_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\STANDBYCONTROL_SMRPRODB_20190415_JTTV1HHS_1_1.CTL
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\STANDBYCONTROL_SMRPRODB_20190415_KCTV1RHI_1_1.CTL
List of Files Which Were Not Cataloged
=======================================
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\RMAN_SMRPRODB_FULL.LOG
RMAN-07517: Reason: The file header is corrupted
RMAN> RUN
2> {
3> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo01a.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo01a.log'' ";
4> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo02a.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo02a.log'' ";
5> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo03a.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo03a.log'' ";
6> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo04.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo04.log'' ";
7> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo_05.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo_05.log'' ";
8> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo_06.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo_06.log'' ";
9> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo_07.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo_07.log'' ";
10> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo01b.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo01b.log'' ";
11> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo01c.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo01c.log'' ";
12> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo02b.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo02b.log'' ";
13> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo02c.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo02c.log'' ";
14> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo03b.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo03b.log'' ";
15> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo03c.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo03c.log'' ";
16> set newname for datafile 1 to "D:\app\plmadmin\oradata\smrprodb\system01.dbf";
17> set newname for datafile 2 to "D:\app\plmadmin\oradata\smrprodb\sysaux01.dbf";
18> set newname for datafile 3 to "D:\app\plmadmin\oradata\smrprodb\undotbs01.dbf";
19> set newname for datafile 4 to "D:\app\plmadmin\oradata\smrprodb\idata01.dbf";
20> set newname for datafile 5 to "D:\app\plmadmin\oradata\smrprodb\ilog01.dbf";
21> set newname for datafile 6 to "D:\app\plmadmin\oradata\smrprodb\indx01.dbf";
22> set newname for datafile 7 to "D:\app\plmadmin\oradata\smrprodb\idata02.dbf";
23> set newname for tempfile 1 to "D:\app\plmadmin\oradata\smrprodb\temp01.dbf";
24> RESTORE DATABASE;
25>
26> SWITCH DATAFILE ALL;
27>
28> SWITCH TEMPFILE ALL;
29>
30> RECOVER DATABASE;
31>
32> }
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo01a.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo01a.log''
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo02a.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo02a.log''
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo03a.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo03a.log''
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo04.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo04.log''
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo_05.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo_05.log''
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo_06.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo_06.log''
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo_07.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo_07.log''
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo01b.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo01b.log''
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo01c.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo01c.log''
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo02b.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo02b.log''
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo02c.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo02c.log''
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo03b.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo03b.log''
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo03c.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo03c.log''
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 15-APR-19
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
using channel ORA_DISK_7
using channel ORA_DISK_8
using channel ORA_DISK_9
using channel ORA_DISK_10
using channel ORA_DISK_11
using channel ORA_DISK_12
using channel ORA_DISK_13
using channel ORA_DISK_14
using channel ORA_DISK_15
using channel ORA_DISK_16
using channel ORA_DISK_17
using channel ORA_DISK_18
using channel ORA_DISK_19
using channel ORA_DISK_20
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00003 to D:\app\plmadmin\oradata\smrprodb\undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00006 to D:\app\plmadmin\oradata\smrprodb\indx01.dbf
channel ORA_DISK_1: reading from backup piece D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K7TV1RGU_1_1.BCKP
channel ORA_DISK_2: starting datafile backup set restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
channel ORA_DISK_2: restoring datafile 00001 to D:\app\plmadmin\oradata\smrprodb\system01.dbf
channel ORA_DISK_2: restoring datafile 00005 to D:\app\plmadmin\oradata\smrprodb\ilog01.dbf
channel ORA_DISK_2: reading from backup piece D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K5TV1RGU_1_1.BCKP
channel ORA_DISK_3: starting datafile backup set restore
channel ORA_DISK_3: specifying datafile(s) to restore from backup set
channel ORA_DISK_3: restoring datafile 00002 to D:\app\plmadmin\oradata\smrprodb\sysaux01.dbf
channel ORA_DISK_3: restoring datafile 00007 to D:\app\plmadmin\oradata\smrprodb\idata02.dbf
channel ORA_DISK_3: reading from backup piece D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K6TV1RGU_1_1.BCKP
channel ORA_DISK_4: starting datafile backup set restore
channel ORA_DISK_4: specifying datafile(s) to restore from backup set
channel ORA_DISK_4: restoring datafile 00004 to D:\app\plmadmin\oradata\smrprodb\idata01.dbf
channel ORA_DISK_4: reading from backup piece D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K4TV1RGU_1_1.BCKP
channel ORA_DISK_1: piece handle=D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K7TV1RGU_1_1.BCKP tag=TAG20190415T095542
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:55
channel ORA_DISK_3: piece handle=D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K6TV1RGU_1_1.BCKP tag=TAG20190415T095542
channel ORA_DISK_3: restored backup piece 1
channel ORA_DISK_3: restore complete, elapsed time: 00:00:55
channel ORA_DISK_2: piece handle=D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K5TV1RGU_1_1.BCKP tag=TAG20190415T095542
channel ORA_DISK_2: restored backup piece 1
channel ORA_DISK_2: restore complete, elapsed time: 00:01:05
channel ORA_DISK_4: piece handle=D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K4TV1RGU_1_1.BCKP tag=TAG20190415T095542
channel ORA_DISK_4: restored backup piece 1
channel ORA_DISK_4: restore complete, elapsed time: 00:01:26
Finished restore at 15-APR-19
datafile 1 switched to datafile copy
input datafile copy RECID=547 STAMP=1005656034 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\SYSTEM01.DBF
datafile 2 switched to datafile copy
input datafile copy RECID=548 STAMP=1005656034 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\SYSAUX01.DBF
datafile 3 switched to datafile copy
input datafile copy RECID=549 STAMP=1005656034 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\UNDOTBS01.DBF
datafile 4 switched to datafile copy
input datafile copy RECID=550 STAMP=1005656034 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\IDATA01.DBF
datafile 5 switched to datafile copy
input datafile copy RECID=551 STAMP=1005656034 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\ILOG01.DBF
datafile 6 switched to datafile copy
input datafile copy RECID=552 STAMP=1005656034 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\INDX01.DBF
datafile 7 switched to datafile copy
input datafile copy RECID=553 STAMP=1005656034 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\IDATA02.DBF
renamed tempfile 1 to D:\app\plmadmin\oradata\smrprodb\temp01.dbf in control file
Starting recover at 15-APR-19
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
using channel ORA_DISK_7
using channel ORA_DISK_8
using channel ORA_DISK_9
using channel ORA_DISK_10
using channel ORA_DISK_11
using channel ORA_DISK_12
using channel ORA_DISK_13
using channel ORA_DISK_14
using channel ORA_DISK_15
using channel ORA_DISK_16
using channel ORA_DISK_17
using channel ORA_DISK_18
using channel ORA_DISK_19
using channel ORA_DISK_20
starting media recovery
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=18
channel ORA_DISK_1: reading from backup piece D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_KATV1RHF_7818_1_20190415
channel ORA_DISK_1: piece handle=D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_KATV1RHF_7818_1_20190415 tag=TAG20190415T095559
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\O1_MF_1_18_GC8RP4G7_.ARC thread=1 sequence=18
channel default: deleting archived log(s)
archived log file name=D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\O1_MF_1_18_GC8RP4G7_.ARC RECID=4736 STAMP=1005656036
unable to find archived log
archived log thread=1 sequence=19
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 04/15/2019 12:53:57
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 19 and starting SCN of 410913463
RMAN> RECOVER DATABASE until cancel;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "cancel": expecting one of: "scn, sequence, time"
RMAN-01007: at line 1 column 24 file: standard input
RMAN> RECOVER DATABASE until cancel;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "cancel": expecting one of: "scn, sequence, time"
RMAN-01007: at line 1 column 24 file: standard input
RMAN> RECOVER DATABASE noredo;
Starting recover at 15-APR-19
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
using channel ORA_DISK_7
using channel ORA_DISK_8
using channel ORA_DISK_9
using channel ORA_DISK_10
using channel ORA_DISK_11
using channel ORA_DISK_12
using channel ORA_DISK_13
using channel ORA_DISK_14
using channel ORA_DISK_15
using channel ORA_DISK_16
using channel ORA_DISK_17
using channel ORA_DISK_18
using channel ORA_DISK_19
using channel ORA_DISK_20
Finished recover at 15-APR-19
RMAN>
No comments:
Post a Comment