Oracle 19c - Migrating Database Running Non-ASM to ASM – Part 2 Migrate Database through RMAN - Demo
Step by Step migrating Non-ASM to ASM:
Step 1: Database status
srvctl status database -d srcdb19c
Step 2: The database not yet protect in oracle restart. By adding database and start (fake start) and then show status again
srvctl add database -d srcdb19c -oraclehome /u01/app/oracle/product/19.0.0.0/db_2
Step 3: Let’s see now crsctl to show all resources managed by Oracle Restart
crsctl stat res -t
Step 4: Let’s create ASM directories for the database using asmcmd inside Diskgroup +DATA
mkdir +DATA/SRCDB19C
mkdir +DATA/SRCDB19C/pdbseed
mkdir +DATA/SRCDB19C/srcdb19cplug
Step 5: Restore spfile on ASM
restore spfile to '+DATA/SRCDB19C/spfilesrcdb19c.ora';
Step 6: Change the configuration of spfile managed by Oracle Restart
srvctl modify database -d srcdb19c -spfile +DATA/SRCDB19C/spfilesrcdb19c.ora
srvctl config database -d srcdb19c
Step 7: Create a file $ORACLE_HOME/dbs/initsrcdb19c.ora pointing to spfile on ASM
cat initsrcdb19c.ora
spfile='+DATA/SRCDB19C/spfilesrcdb19c.ora'
srvctl stop database -d srcdb19c -o immediate
srvctl start database -d srcdb19c -o nomount
Step 8: Now we can see the database parameter file is on ASM
. oraenv
srcdb19c
sql
show parameter spfile
Step 9: Adjust some parameters to ASM, to direct the controlfiles and new future files. put the database in NOMOUNT mode.
SQL> ALTER SYSTEM SET DB_CREATE_FILE_DEST='+DATA' SID='*';
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE='15G' SID='*';
SQL> ALTER SYSTEM SET CONTROL_FILES='+DATA' SCOPE=SPFILE SID='*';
SQL> STARTUP NOMOUNT FORCE;
Step 10: Log on RMAN and restore the controlfile from your original controlfile and then MOUNT the database.
RMAN> restore controlfile from '/oradata/data/SRCDB19C/control01.ctl';
Step 11: Issue a rman backup to ASM -> backup as copy database format '+DATA';
RMAN> backup as copy database format '+DATA';
Step 12: Rename the datafiles on controlfile –> switch database to copy;
RMAN> switch database to copy;
Step 13: Rename tempfiles on controlfile –> set newname -> switch tempfile all;
RMAN> report schema;
Report of database schema for database with db_unique_name SRCDB19C
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 760 SYSTEM YES /oradata/data/SRCDB19C/system01.dbf
2 210 PDB$SEED:SYSTEM NO /oradata/data/SRCDB19C/pdbseed/system01.dbf
3 550 SYSAUX NO /oradata/data/SRCDB19C/sysaux01.dbf
4 165 PDB$SEED:SYSAUX NO /oradata/data/SRCDB19C/pdbseed/sysaux01.dbf
5 315 UNDOTBS1 YES /oradata/data/SRCDB19C/undotbs01.dbf
6 165 PDB$SEED:UNDOTBS1 NO /oradata/data/SRCDB19C/pdbseed/undotbs01.dbf
7 5 USERS NO /oradata/data/SRCDB19C/users01.dbf
8 220 SRCDB19CPLUG:SYSTEM YES /oradata/data/SRCDB19C/srcdb19cplug/system01.dbf
9 165 SRCDB19CPLUG:SYSAUX NO /oradata/data/SRCDB19C/srcdb19cplug/sysaux01.dbf
10 165 SRCDB19CPLUG:UNDOTBS1 YES /oradata/data/SRCDB19C/srcdb19cplug/undotbs01.dbf
11 5 SRCDB19CPLUG:USERS NO /oradata/data/SRCDB19C/srcdb19cplug/users01.dbf
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 20 TEMP 32767 /oradata/data/SRCDB19C/temp01.dbf
2 20 PDB$SEED:TEMP 32767 /oradata/data/SRCDB19C/pdbseed/temp01.dbf
3 20 SRCDB19CPLUG:TEMP 32767 /oradata/data/SRCDB19C/srcdb19cplug/temp01.dbf
run
{
set newname for tempfile 1 to '+DATA';
set newname for tempfile 2 to '+DATA';
set newname for tempfile 3 to '+DATA';
switch tempfile all;
}
run
{
set newname for tempfile 1 to '+DATA/SRCDB19C/temp01.dbf';
set newname for tempfile 2 to '+DATA/SRCDB19C/pdbseed/temp01.dbf';
set newname for tempfile 3 to '+DATA/SRCDB19C/srcdb19cplug/temp01.dbf';
switch tempfile all;
}
Step 14: Then open the database
RMAN> alter database open;
As we choose the long downtime approach, not recover is needed to open database.
Step 15: Let’s drop and recreate redologs on '+DATA'
SQL> select group#,member from v$logfile;
SQL> select bytes from v$log;
SQL> alter database add logfile group 4 '+DATA/SRCDB19C/redo04.dbf' size 209715200;
SQL> alter database add logfile group 5 '+DATA/SRCDB19C/redo05.dbf' size 209715200;
SQL> alter database add logfile group 6 '+DATA/SRCDB19C/redo06.dbf' size 209715200;
SQL> alter system switch logfile; --- 3 switchtes
SQL> alter system checkpoint;
SQL> alter database drop logfile group 1;
SQL> alter database drop logfile group 2;
SQL> alter database drop logfile group 3;
Step 16: Checking redologs migrated
SQL> select group#,member from v$logfile;
Step 17: Checking all the files, now stored on ASM diskgroup +DATA
SQL> select 'Controlfile' filetype,name from v$controlfile
union all
select 'Datafile', name from v$datafile
union all
select 'Tempfile', name from v$tempfile
union all
select 'Logfile', member from v$logfile;
10 165 SRCDB19CPLUG:UNDOTBS1 YES /oradata/data/SRCDB19C/srcdb19cplug/undotbs01.dbf
11 5 SRCDB19CPLUG:USERS NO /oradata/data/SRCDB19C/srcdb19cplug/users01.dbf
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 20 TEMP 32767 /oradata/data/SRCDB19C/temp01.dbf
2 20 PDB$SEED:TEMP 32767 /oradata/data/SRCDB19C/pdbseed/temp01.dbf
3 20 SRCDB19CPLUG:TEMP 32767 /oradata/data/SRCDB19C/srcdb19cplug/temp01.dbf
RMAN> exit
Recovery Manager complete.
[oracle@srlab ~]$
[oracle@srlab ~]$ clear scr
[oracle@srlab ~]$ ps -ef |grep pmon
oracle 4490 1 0 10:51 ? 00:00:00 ora_pmon_srcdb19c
oracle 8117 3690 0 11:26 pts/0 00:00:00 grep --color=auto pmon
oracle 16581 1 0 09:05 ? 00:00:01 asm_pmon_+ASM
[oracle@srlab ~]$ ps -ef |grep tns
root 22 2 0 06:24 ? 00:00:00 [netns]
oracle 7040 1 0 08:57 ? 00:00:00 /u01/app/19.0.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit
oracle 8137 3690 0 11:26 pts/0 00:00:00 grep --color=auto tns
[oracle@srlab ~]$ . oraenv
ORACLE_SID = [srcdb19c] ? +ASM
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@srlab ~]$ asmcmd
ASMCMD> lsdg
State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 512 4096 4194304 40956 40856 0 40856 0 N DATA/
MOUNTED EXTERN N 512 512 4096 1048576 20479 20425 0 20425 0 N FRA/
ASMCMD> cd DATA
ASMCMD> ls
ASM/
orapwasm
ASMCMD>
ASMCMD> mkdir +DATA/SRCDB19C
mkdir +DATA/SRCDB19C/pdbseed
mkdir +DATA/SRCDB19C/srcdb19cplugASMCMD> ASMCMD>
ASMCMD>
ASMCMD>
ASMCMD> ls
ASM/
SRCDB19C/
orapwasm
ASMCMD> cd SRCDB19C/
ASMCMD> ls
pdbseed/
srcdb19cplug/
ASMCMD> cd ..
ASMCMD> ls
ASM/
SRCDB19C/
orapwasm
ASMCMD> exit
[oracle@srlab ~]$
[oracle@srlab ~]$ . oraenv
ORACLE_SID = [+ASM] ? srcdb19c
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@srlab ~]$
[oracle@srlab ~]$ echo $ORACLE_SID
srcdb19c
[oracle@srlab ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Sat Sep 25 11:31:08 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: SRCDB19C (DBID=1852486693)
RMAN> restore spfile to '+DATA/SRCDB19C/spfilesrcdb19c.ora';
Starting restore at 25-SEP-21
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=271 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: restoring SPFILE
output file name=+DATA/SRCDB19C/spfilesrcdb19c.ora
channel ORA_DISK_1: reading from backup piece /oradata/fra/SRCDB19C/autobackup/2021_09_12/o1_mf_s_1083051205_jmtqzoqd_.bkp
channel ORA_DISK_1: piece handle=/oradata/fra/SRCDB19C/autobackup/2021_09_12/o1_mf_s_1083051205_jmtqzoqd_.bkp tag=TAG20210912T073325
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
Finished restore at 25-SEP-21
RMAN> exit
Recovery Manager complete.
[oracle@srlab ~]$ cd $ORACLE_HOME/dbs
[oracle@srlab dbs]$ ls -lrt
total 18308
-rwxr-xr-x. 1 oracle oinstall 3079 May 14 2015 init.ora
-rwxr-xr-x. 1 oracle oinstall 24 Sep 11 21:00 lkSRCDB19C
-rw-r-----. 1 oracle oinstall 2048 Sep 11 23:35 orapwsrcdb19c
-rwxr-xr-x. 1 oracle oinstall 18726912 Sep 12 07:33 snapcf_srcdb19c.f
-rwxr-xr-x. 1 oracle oinstall 1544 Sep 25 10:51 hc_srcdb19c.dat
-rwxr-xr-x. 1 oracle oinstall 3584 Sep 25 10:51 spfilesrcdb19c.ora
[oracle@srlab dbs]$ vi initsrcdb19c.ora
[oracle@srlab dbs]$ cat initsrcdb19c.ora
spfile='+DATA/SRCDB19C/spfilesrcdb19c.ora'
[oracle@srlab dbs]$ mv spfilesrcdb19c.ora spfilesrcdb19c.ora_bak
[oracle@srlab dbs]$ pwd
/u01/app/oracle/product/19.0.0.0/db_2/dbs
[oracle@srlab dbs]$ . oraenv
ORACLE_SID = [srcdb19c] ? +ASM
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@srlab dbs]$ asmcmd
ASMCMD> lsdg
State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 512 4096 4194304 40956 40852 0 40852 0 N DATA/
MOUNTED EXTERN N 512 512 4096 1048576 20479 20425 0 20425 0 N FRA/
ASMCMD> cd DATA
ASMCMD> ls
ASM/
DB_UNKNOWN/
SRCDB19C/
orapwasm
ASMCMD> cd SRCDB19C
ASMCMD> ls
pdbseed/
spfilesrcdb19c.ora
srcdb19cplug/
ASMCMD> pwd
+DATA/SRCDB19C
ASMCMD> pwcopy /u01/app/oracle/product/19.0.0.0/db_2/dbs/orapwsrcdb19c '+DATA/SRCDB19C/orapwsrcdb19c' -f
copying /u01/app/oracle/product/19.0.0.0/db_2/dbs/orapwsrcdb19c -> +DATA/SRCDB19C/orapwsrcdb19c
ASMCMD> ls
orapwsrcdb19c
pdbseed/
spfilesrcdb19c.ora
srcdb19cplug/
ASMCMD> exit
[oracle@srlab dbs]$ cd /u01/app/19.0.0/grid/network/admin/
[oracle@srlab admin]$ ls -lrt
total 16
-rw-r--r--. 1 oracle oinstall 1536 Feb 14 2018 shrept.lst
drwxr-xr-x. 2 oracle oinstall 4096 Apr 17 2019 samples
-rw-r-----. 1 oracle oinstall 176 Sep 25 08:57 sqlnet.ora
-rw-r-----. 1 oracle oinstall 552 Sep 25 08:57 listener.ora
[oracle@srlab admin]$ cat sqlnet.ora
# sqlnet.ora Network Configuration File: /u01/app/19.0.0/grid/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
[oracle@srlab admin]$ exit
logout
[root@srlab trace]# usermod -u 54321 -g oinstall -G dba,oper,asmdba,asmoper,asmadmin,racdba oracle
[root@srlab trace]# id oracle
uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54330(racdba),54331(asmdba),54332(asmoper),54333(asmadmin)
[root@srlab trace]# su - oracle
Last login: Sat Sep 25 10:43:11 IST 2021 on pts/0
[oracle@srlab ~]$ . oraenv
ORACLE_SID = [oracle] ? srcdb19c
The Oracle base has been set to /u01/app/oracle
[oracle@srlab ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Sat Sep 25 12:01:39 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: SRCDB19C (not mounted)
RMAN> restore controlfile from '/oradata/data/SRCDB19C/control01.ctl';
Starting restore at 25-SEP-21
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=262 device type=DISK
channel ORA_DISK_1: copied control file copy
output file name=+DATA/SRCDB19C/CONTROLFILE/current.259.1084190513
Finished restore at 25-SEP-21
RMAN> backup as copy database format '+DATA';
Starting backup at 25-SEP-21
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 09/25/2021 12:02:42
ORA-01507: database not mounted
RMAN> alter database mount;
released channel: ORA_DISK_1
Statement processed
RMAN> backup as copy database format '+DATA';
Starting backup at 25-SEP-21
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=262 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/oradata/data/SRCDB19C/system01.dbf
output file name=+DATA/SRCDB19C/DATAFILE/system.260.1084190585 tag=TAG20210925T120303 RECID=1 STAMP=1084190633
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:56
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/oradata/data/SRCDB19C/sysaux01.dbf
output file name=+DATA/SRCDB19C/DATAFILE/sysaux.261.1084190641 tag=TAG20210925T120303 RECID=2 STAMP=1084190678
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=/oradata/data/SRCDB19C/undotbs01.dbf
output file name=+DATA/SRCDB19C/DATAFILE/undotbs1.262.1084190687 tag=TAG20210925T120303 RECID=3 STAMP=1084190709
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00008 name=/oradata/data/SRCDB19C/srcdb19cplug/system01.dbf
output file name=+DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/system.263.1084190713 tag=TAG20210925T120303 RECID=4 STAMP=1084190726
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=/oradata/data/SRCDB19C/pdbseed/system01.dbf
output file name=+DATA/SRCDB19C/CBBAE98514CB56B1E0536738A8C0B662/DATAFILE/system.264.1084190727 tag=TAG20210925T120303 RECID=5 STAMP=1084190742
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/oradata/data/SRCDB19C/pdbseed/sysaux01.dbf
output file name=+DATA/SRCDB19C/CBBAE98514CB56B1E0536738A8C0B662/DATAFILE/sysaux.265.1084190743 tag=TAG20210925T120303 RECID=6 STAMP=1084190754
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00006 name=/oradata/data/SRCDB19C/pdbseed/undotbs01.dbf
output file name=+DATA/SRCDB19C/CBBAE98514CB56B1E0536738A8C0B662/DATAFILE/undotbs1.266.1084190759 tag=TAG20210925T120303 RECID=7 STAMP=1084190771
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00009 name=/oradata/data/SRCDB19C/srcdb19cplug/sysaux01.dbf
output file name=+DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/sysaux.267.1084190775 tag=TAG20210925T120303 RECID=8 STAMP=1084190786
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00010 name=/oradata/data/SRCDB19C/srcdb19cplug/undotbs01.dbf
output file name=+DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/undotbs1.268.1084190791 tag=TAG20210925T120303 RECID=9 STAMP=1084190802
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00007 name=/oradata/data/SRCDB19C/users01.dbf
output file name=+DATA/SRCDB19C/DATAFILE/users.269.1084190807 tag=TAG20210925T120303 RECID=10 STAMP=1084190806
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
input datafile file number=00011 name=/oradata/data/SRCDB19C/srcdb19cplug/users01.dbf
output file name=+DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/users.270.1084190807 tag=TAG20210925T120303 RECID=11 STAMP=1084190808
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 25-SEP-21
Starting Control File and SPFILE Autobackup at 25-SEP-21
piece handle=+FRA/SRCDB19C/AUTOBACKUP/2021_09_25/s_1084188965.256.1084190813 comment=NONE
Finished Control File and SPFILE Autobackup at 25-SEP-21
RMAN> switch database to copy;
datafile 1 switched to datafile copy "+DATA/SRCDB19C/DATAFILE/system.260.1084190585"
datafile 2 switched to datafile copy "+DATA/SRCDB19C/CBBAE98514CB56B1E0536738A8C0B662/DATAFILE/system.264.1084190727"
datafile 3 switched to datafile copy "+DATA/SRCDB19C/DATAFILE/sysaux.261.1084190641"
datafile 4 switched to datafile copy "+DATA/SRCDB19C/CBBAE98514CB56B1E0536738A8C0B662/DATAFILE/sysaux.265.1084190743"
datafile 5 switched to datafile copy "+DATA/SRCDB19C/DATAFILE/undotbs1.262.1084190687"
datafile 6 switched to datafile copy "+DATA/SRCDB19C/CBBAE98514CB56B1E0536738A8C0B662/DATAFILE/undotbs1.266.1084190759"
datafile 7 switched to datafile copy "+DATA/SRCDB19C/DATAFILE/users.269.1084190807"
datafile 8 switched to datafile copy "+DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/system.263.1084190713"
datafile 9 switched to datafile copy "+DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/sysaux.267.1084190775"
datafile 10 switched to datafile copy "+DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/undotbs1.268.1084190791"
datafile 11 switched to datafile copy "+DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/users.270.1084190807"
RMAN> report schema;
Report of database schema for database with db_unique_name SRCDB19C
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 760 SYSTEM *** +DATA/SRCDB19C/DATAFILE/system.260.1084190585
2 210 PDB$SEED:SYSTEM *** +DATA/SRCDB19C/CBBAE98514CB56B1E0536738A8C0B662/DATAFILE/system.264.1084190727
3 550 SYSAUX *** +DATA/SRCDB19C/DATAFILE/sysaux.261.1084190641
4 165 PDB$SEED:SYSAUX *** +DATA/SRCDB19C/CBBAE98514CB56B1E0536738A8C0B662/DATAFILE/sysaux.265.1084190743
5 315 UNDOTBS1 *** +DATA/SRCDB19C/DATAFILE/undotbs1.262.1084190687
6 165 PDB$SEED:UNDOTBS1 *** +DATA/SRCDB19C/CBBAE98514CB56B1E0536738A8C0B662/DATAFILE/undotbs1.266.1084190759
7 5 USERS *** +DATA/SRCDB19C/DATAFILE/users.269.1084190807
8 220 SRCDB19CPLUG:SYSTEM *** +DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/system.263.1084190713
9 165 SRCDB19CPLUG:SYSAUX *** +DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/sysaux.267.1084190775
10 165 SRCDB19CPLUG:UNDOTBS1 *** +DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/undotbs1.268.1084190791
11 5 SRCDB19CPLUG:USERS *** +DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/users.270.1084190807
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 20 TEMP 32767 /oradata/data/SRCDB19C/temp01.dbf
2 20 PDB$SEED:TEMP 32767 /oradata/data/SRCDB19C/pdbseed/temp01.dbf
3 20 SRCDB19CPLUG:TEMP 32767 /oradata/data/SRCDB19C/srcdb19cplug/temp01.dbf
RMAN> run
{
set newname for tempfile 1 to '+DATA';
set newname for tempfile 2 to '+DATA';
set newname for tempfile 3 to '+DATA';
switch tempfile all;
}2> 3> 4> 5> 6> 7>
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
renamed tempfile 1 to +DATA in control file
renamed tempfile 2 to +DATA in control file
renamed tempfile 3 to +DATA in control file
RMAN> report schema;
Report of database schema for database with db_unique_name SRCDB19C
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 760 SYSTEM *** +DATA/SRCDB19C/DATAFILE/system.260.1084190585
2 210 PDB$SEED:SYSTEM *** +DATA/SRCDB19C/CBBAE98514CB56B1E0536738A8C0B662/DATAFILE/system.264.1084190727
3 550 SYSAUX *** +DATA/SRCDB19C/DATAFILE/sysaux.261.1084190641
4 165 PDB$SEED:SYSAUX *** +DATA/SRCDB19C/CBBAE98514CB56B1E0536738A8C0B662/DATAFILE/sysaux.265.1084190743
5 315 UNDOTBS1 *** +DATA/SRCDB19C/DATAFILE/undotbs1.262.1084190687
6 165 PDB$SEED:UNDOTBS1 *** +DATA/SRCDB19C/CBBAE98514CB56B1E0536738A8C0B662/DATAFILE/undotbs1.266.1084190759
7 5 USERS *** +DATA/SRCDB19C/DATAFILE/users.269.1084190807
8 220 SRCDB19CPLUG:SYSTEM *** +DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/system.263.1084190713
9 165 SRCDB19CPLUG:SYSAUX *** +DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/sysaux.267.1084190775
10 165 SRCDB19CPLUG:UNDOTBS1 *** +DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/undotbs1.268.1084190791
11 5 SRCDB19CPLUG:USERS *** +DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/users.270.1084190807
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 20 TEMP 32767 +DATA
2 20 PDB$SEED:TEMP 32767 +DATA
3 20 SRCDB19CPLUG:TEMP 32767 +DATA
RMAN> run
{
set newname for tempfile 1 to '+DATA/SRCDB19C/temp01.dbf';
set newname for tempfile 2 to '+DATA/SRCDB19C/pdbseed/temp01.dbf';
set newname for tempfile 3 to '+DATA/SRCDB19C/srcdb19cplug/temp01.dbf';
switch tempfile all;
}
2> 3> 4> 5> 6> 7>
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
renamed tempfile 1 to +DATA/SRCDB19C/temp01.dbf in control file
renamed tempfile 2 to +DATA/SRCDB19C/pdbseed/temp01.dbf in control file
renamed tempfile 3 to +DATA/SRCDB19C/srcdb19cplug/temp01.dbf in control file
RMAN> report schema
2> ;
Report of database schema for database with db_unique_name SRCDB19C
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 760 SYSTEM *** +DATA/SRCDB19C/DATAFILE/system.260.1084190585
2 210 PDB$SEED:SYSTEM *** +DATA/SRCDB19C/CBBAE98514CB56B1E0536738A8C0B662/DATAFILE/system.264.1084190727
3 550 SYSAUX *** +DATA/SRCDB19C/DATAFILE/sysaux.261.1084190641
4 165 PDB$SEED:SYSAUX *** +DATA/SRCDB19C/CBBAE98514CB56B1E0536738A8C0B662/DATAFILE/sysaux.265.1084190743
5 315 UNDOTBS1 *** +DATA/SRCDB19C/DATAFILE/undotbs1.262.1084190687
6 165 PDB$SEED:UNDOTBS1 *** +DATA/SRCDB19C/CBBAE98514CB56B1E0536738A8C0B662/DATAFILE/undotbs1.266.1084190759
7 5 USERS *** +DATA/SRCDB19C/DATAFILE/users.269.1084190807
8 220 SRCDB19CPLUG:SYSTEM *** +DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/system.263.1084190713
9 165 SRCDB19CPLUG:SYSAUX *** +DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/sysaux.267.1084190775
10 165 SRCDB19CPLUG:UNDOTBS1 *** +DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/undotbs1.268.1084190791
11 5 SRCDB19CPLUG:USERS *** +DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/users.270.1084190807
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 20 TEMP 32767 +DATA/SRCDB19C/temp01.dbf
2 20 PDB$SEED:TEMP 32767 +DATA/SRCDB19C/pdbseed/temp01.dbf
3 20 SRCDB19CPLUG:TEMP 32767 +DATA/SRCDB19C/srcdb19cplug/temp01.dbf
RMAN> alter database open;
Statement processed
RMAN>
RMAN> exit
Recovery Manager complete.
[oracle@srlab ~]$ sql
SQL*Plus: Release 19.0.0.0.0 - Production on Sat Sep 25 12:24:29 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> select * from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------
SRCDB19C
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRCDB19CPLUG READ WRITE NO
SQL>
SQL> alter database move datafile '+DATA/SRCDB19C/DATAFILE/system.260.1084190585' to '+DATA/SRCDB19C/system01.dbf';
Database altered.
SQL> alter database move datafile 2 to '+DATA/SRCDB19C/pdbseed/system02.dbf';
alter database move datafile 2 to '+DATA/SRCDB19C/pdbseed/system02.dbf'
*
ERROR at line 1:
ORA-01516: nonexistent log file, data file, or temporary file "2" in the
current container
SQL> alter database move datafile '+DATA/SRCDB19C/CBBAE98514CB56B1E0536738A8C0B662/DATAFILE/system.264.1084190727' to '+DATA/SRCDB19C/pdbseed/system02.dbf';
alter database move datafile '+DATA/SRCDB19C/CBBAE98514CB56B1E0536738A8C0B662/DATAFILE/system.264.1084190727' to '+DATA/SRCDB19C/pdbseed/system02.dbf'
*
ERROR at line 1:
ORA-01516: nonexistent log file, data file, or temporary file "2" in the
current container
SQL> alter database move datafile 3 to '+DATA/SRCDB19C/sysaux02.dbf';
Database altered.
SQL> alter database move datafile 5 to '+DATA/SRCDB19C/undotbs1.dbf';
Database altered.
SQL> alter database move datafile 7 to '+DATA/SRCDB19C/users.dbf';
Database altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRCDB19CPLUG READ WRITE NO
SQL> alter session set container=PDB$SEED;
Session altered.
SQL> alter database move datafile 2 to '+DATA/SRCDB19C/pdbseed/system02.dbf';
Database altered.
SQL> alter database move datafile 4 to '+DATA/SRCDB19C/pdbseed/sysaux02.dbf';
Database altered.
SQL> alter session set container=SRCDB19CPLUG;
Session altered.
SQL> alter database move datafile 8 to '+DATA/SRCDB19C/SRCDB19CPLUG/system03.dbf';
Database altered.
SQL> alter database move datafile 9 to '+DATA/SRCDB19C/SRCDB19CPLUG/sysaux03.dbf';
Database altered.
SQL> alter database move datafile 10 to '+DATA/SRCDB19C/SRCDB19CPLUG/undotbs1.dbf';
Database altered.
SQL> alter database move datafile 11 to '+DATA/SRCDB19C/SRCDB19CPLUG/users.dbf';
Database altered.
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
+DATA/SRCDB19C/SRCDB19CPLUG/system03.dbf
+DATA/SRCDB19C/SRCDB19CPLUG/sysaux03.dbf
+DATA/SRCDB19C/SRCDB19CPLUG/undotbs1.dbf
+DATA/SRCDB19C/SRCDB19CPLUG/users.dbf
SQL> alter session set container=cdb$root;
Session altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRCDB19CPLUG READ WRITE NO
FILETYPE NAME
----------- -------------------------------------------
Controlfile +DATA/SRCDB19C/CONTROLFILE/current.259.1084
190513
Datafile +DATA/SRCDB19C/system01.dbf
Datafile +DATA/SRCDB19C/pdbseed/system02.dbf
Datafile +DATA/SRCDB19C/sysaux02.dbf
Datafile +DATA/SRCDB19C/pdbseed/sysaux02.dbf
Datafile +DATA/SRCDB19C/undotbs1.dbf
Datafile +DATA/SRCDB19C/CBBAE98514CB56B1E0536738A8C0
B662/DATAFILE/undotbs1.266.1084190759
FILETYPE NAME
----------- -------------------------------------------
Datafile +DATA/SRCDB19C/users.dbf
Datafile +DATA/SRCDB19C/SRCDB19CPLUG/system03.dbf
Datafile +DATA/SRCDB19C/SRCDB19CPLUG/sysaux03.dbf
Datafile +DATA/SRCDB19C/SRCDB19CPLUG/undotbs1.dbf
Datafile +DATA/SRCDB19C/SRCDB19CPLUG/users.dbf
Tempfile +DATA/SRCDB19C/temp01.dbf
Tempfile +DATA/SRCDB19C/pdbseed/temp01.dbf
Tempfile +DATA/SRCDB19C/srcdb19cplug/temp01.dbf
Logfile +DATA/SRCDB19C/redo04.dbf
Logfile +DATA/SRCDB19C/redo05.dbf
Logfile +DATA/SRCDB19C/redo06.dbf
18 rows selected.
SQL> alter session set container=pdb$seed;
Session altered.
SQL> alter database move datafile 6 to '+DATA/SRCDB19C/pdbseed/undotbs1.dbf';
Database altered.
SQL> select name,total_mb/1024,free_mb/1024,state from v$asm_diskgroup;
NAME TOTAL_MB/1024 FREE_MB/1024
------------------------------------------- ------------- ------------
STATE
-----------
DATA 39.9960938 36.4921875
CONNECTED
FRA 19.9990234 18.0888672
CONNECTED
SQL> col name for a20
SQL> /
NAME TOTAL_MB/1024 FREE_MB/1024 STATE
-------------------- ------------- ------------ -----------
DATA 39.9960938 36.4921875 CONNECTED
FRA 19.9990234 18.0888672 CONNECTED
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@srlab ~]$ ps -ef |grep tns
root 22 2 0 06:24 ? 00:00:00 [netns]
oracle 7040 1 0 08:57 ? 00:00:00 /u01/app/19.0.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit
oracle 19198 12819 0 13:03 pts/0 00:00:00 grep --color=auto tns
[oracle@srlab ~]$ ps -ef |grep pmon
oracle 11037 1 0 11:46 ? 00:00:00 asm_pmon_+ASM
oracle 12434 1 0 11:58 ? 00:00:00 ora_pmon_srcdb19c
oracle 19212 12819 0 13:03 pts/0 00:00:00 grep --color=auto pmon
[oracle@srlab ~]$ free -g
total used free shared buff/cache available
Mem: 7 1 0 2 5 2
Swap: 7 0 7
[oracle@srlab ~]$
[oracle@srlab ~]$ /u01/app/19.0.0/grid/bin/crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE srlab STABLE
ora.FRA.dg
ONLINE ONLINE srlab STABLE
ora.LISTENER.lsnr
ONLINE ONLINE srlab STABLE
ora.asm
ONLINE ONLINE srlab Started,STABLE
ora.ons
OFFLINE OFFLINE srlab STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE srlab STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.driver.afd
1 ONLINE ONLINE srlab STABLE
ora.evmd
1 ONLINE ONLINE srlab STABLE
ora.srcdb19c.db
1 ONLINE ONLINE srlab Open,HOME=/u01/app/o
racle/product/19.0.0
.0/db_2,STABLE
--------------------------------------------------------------------------------
[oracle@srlab ~]$
Datafile /oradata/data/SRCDB19C/undotbs01.dbf
Datafile /oradata/data/SRCDB19C/pdbseed/undotbs01.dbf
Datafile /oradata/data/SRCDB19C/users01.dbf
Datafile /oradata/data/SRCDB19C/srcdb19cplug/system01.dbf
Datafile /oradata/data/SRCDB19C/srcdb19cplug/sysaux01.dbf
Datafile /oradata/data/SRCDB19C/srcdb19cplug/undotbs01.dbf
Datafile /oradata/data/SRCDB19C/srcdb19cplug/users01.dbf
Tempfile /oradata/data/SRCDB19C/temp01.dbf
Tempfile /oradata/data/SRCDB19C/pdbseed/temp01.dbf
Tempfile /oradata/data/SRCDB19C/srcdb19cplug/temp01.dbf
Logfile /oradata/data/SRCDB19C/redo01.log
Logfile /oradata/data/SRCDB19C/redo02.log
Logfile /oradata/data/SRCDB19C/redo03.log
19 rows selected.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@srlab bin]$
[oracle@srlab bin]$ clear
[oracle@srlab bin]$ ps -ef | grep pmon
oracle 4490 1 0 10:51 ? 00:00:00 ora_pmon_srcdb19c
oracle 8212 3094 0 11:27 pts/1 00:00:00 grep --color=auto pmon
oracle 16581 1 0 09:05 ? 00:00:01 asm_pmon_+ASM
[oracle@srlab bin]$ ps -ef | grep tns
root 22 2 0 06:24 ? 00:00:00 [netns]
oracle 7040 1 0 08:57 ? 00:00:00 /u01/app/19.0.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit
oracle 8231 3094 0 11:27 pts/1 00:00:00 grep --color=auto tns
[oracle@srlab bin]$
[oracle@srlab bin]$ echo $ORACLE_SID
srcdb19c
[oracle@srlab bin]$ echo $ORACLE_HOME
/u01/app/oracle/product/19.0.0.0/db_2
[oracle@srlab bin]$
[oracle@srlab bin]$ srvctl status database -d srcdb19c
PRCD-1120 : The resource for database srcdb19c could not be found.
PRCR-1001 : Resource ora.srcdb19c.db does not exist
[oracle@srlab bin]$ srvctl add database -d srcdb19c -oraclehome /u01/app/oracle/product/19.0.0.0/db_2
[oracle@srlab bin]$ srvctl status database -d srcdb19c Database is not running.
[oracle@srlab bin]$ crsctl stat res -t
bash: crsctl: command not found...
[oracle@srlab bin]$ /u01/app/19.0.0/grid/bin/crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE srlab STABLE
ora.FRA.dg
ONLINE ONLINE srlab STABLE
ora.LISTENER.lsnr
ONLINE ONLINE srlab STABLE
ora.asm
ONLINE ONLINE srlab Started,STABLE
ora.ons
OFFLINE OFFLINE srlab STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE srlab STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.driver.afd
1 ONLINE ONLINE srlab STABLE
ora.evmd
1 ONLINE ONLINE srlab STABLE
ora.srcdb19c.db
1 OFFLINE OFFLINE STABLE
--------------------------------------------------------------------------------
[oracle@srlab bin]$ srvctl modify database -d srcdb19c -spfile +DATA/SRCDB19C/spfilesrcdb19c.ora
[oracle@srlab bin]$ srvctl config database -d srcdb19c
Database unique name: srcdb19c
Database name:
Oracle home: /u01/app/oracle/product/19.0.0.0/db_2
Oracle user: oracle
Spfile: +DATA/SRCDB19C/spfilesrcdb19c.ora
Password file:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Disk Groups: DATA
Services:
OSDBA group:
OSOPER group:
Database instance: srcdb19c
[oracle@srlab bin]$ srvctl config database -d srcdb19c | grep Spfile
Spfile: +DATA/SRCDB19C/spfilesrcdb19c.ora
[oracle@srlab bin]$ srvctl stop database -d srcdb19c -o immediate
PRCC-1016 : srcdb19c was already stopped
[oracle@srlab bin]$ ps -ef |grep pmon
oracle 4490 1 0 10:51 ? 00:00:00 ora_pmon_srcdb19c
oracle 9548 3094 0 11:35 pts/1 00:00:00 grep --color=auto pmon
oracle 16581 1 0 09:05 ? 00:00:01 asm_pmon_+ASM
[oracle@srlab bin]$ srvctl status database -d srcdb19c
Database is not running.
[oracle@srlab bin]$ sql
SQL*Plus: Release 19.0.0.0.0 - Production on Sat Sep 25 11:35:50 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@srlab bin]$ srvctl start database -d srcdb19c -o nomount
PRCD-1332 : failed to start database srcdb19c
PRCR-1079 : Failed to start resource ora.srcdb19c.db
CRS-5017: The resource action "ora.srcdb19c.db start" encountered the following error:
ORA-01017: invalid username/password; logon denied
. For details refer to "(:CLSN00107:)" in "/u01/app/oracle/diag/crs/srlab/crs/trace/ohasd_oraagent_oracle.trc".
CRS-2674: Start of 'ora.srcdb19c.db' on 'srlab' failed
ORA-01017: invalid username/password; logon denied
[oracle@srlab bin]$ srvctl config database -d srcdb19c
Database unique name: srcdb19c
Database name:
Oracle home: /u01/app/oracle/product/19.0.0.0/db_2
Oracle user: oracle
Spfile: +DATA/SRCDB19C/spfilesrcdb19c.ora
Password file:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Disk Groups: DATA
Services:
OSDBA group:
OSOPER group:
Database instance: srcdb19c
[oracle@srlab bin]$ srvctl start database -d srcdb19c -o nomount
PRCD-1332 : failed to start database srcdb19c
PRCR-1079 : Failed to start resource ora.srcdb19c.db
CRS-5017: The resource action "ora.srcdb19c.db start" encountered the following error:
ORA-01017: invalid username/password; logon denied
. For details refer to "(:CLSN00107:)" in "/u01/app/oracle/diag/crs/srlab/crs/trace/ohasd_oraagent_oracle.trc".
CRS-2674: Start of 'ora.srcdb19c.db' on 'srlab' failed
ORA-01017: invalid username/password; logon denied
[oracle@srlab bin]$ view /u01/app/oracle/diag/crs/srlab/crs/trace/ohasd_oraagent_oracle.trc
[oracle@srlab bin]$
[oracle@srlab bin]$ ps -ef |grep pmon
oracle 10816 3094 0 11:45 pts/1 00:00:00 grep --color=auto pmon
oracle 16581 1 0 09:05 ? 00:00:01 asm_pmon_+ASM
[oracle@srlab bin]$
[oracle@srlab bin]$ srvctl stop asm
PRCR-1065 : Failed to stop resource ora.asm
CRS-2974: unable to act on resource 'ora.asm' on server 'srlab' because that would require stopping or relocating resource 'ora.DATA.dg' but the appropriate force flag was not specified
[oracle@srlab bin]$ srvctl stop asm -f
[oracle@srlab bin]$ ps -ef |grep pmon
oracle 10936 3094 0 11:45 pts/1 00:00:00 grep --color=auto pmon
[oracle@srlab bin]$
[oracle@srlab bin]$ crsctl check has
bash: crsctl: command not found...
[oracle@srlab bin]$ /u01/app/19.0.0/grid/bin/crsctl check has
CRS-4638: Oracle High Availability Services is online
[oracle@srlab bin]$
[oracle@srlab bin]$ srvctl start asm
[oracle@srlab bin]$
[oracle@srlab bin]$ ps -ef |grep pmon
oracle 11037 1 0 11:46 ? 00:00:00 asm_pmon_+ASM
oracle 11168 3094 0 11:47 pts/1 00:00:00 grep --color=auto pmon
[oracle@srlab bin]$
[oracle@srlab bin]$ /u01/app/19.0.0/grid/bin/crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE srlab STABLE
ora.FRA.dg
ONLINE ONLINE srlab STABLE
ora.LISTENER.lsnr
ONLINE ONLINE srlab STABLE
ora.asm
ONLINE ONLINE srlab Started,STABLE
ora.ons
OFFLINE OFFLINE srlab STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE srlab STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.driver.afd
1 ONLINE ONLINE srlab STABLE
ora.evmd
1 ONLINE ONLINE srlab STABLE
ora.srcdb19c.db
1 ONLINE OFFLINE Instance Shutdown,ST
ABLE
--------------------------------------------------------------------------------
[oracle@srlab bin]$ srvctl start database -d srcdb19c -o nomount PRCD-1332 : failed to start database srcdb19c
PRCR-1079 : Failed to start resource ora.srcdb19c.db
CRS-5017: The resource action "ora.srcdb19c.db start" encountered the following error:
ORA-01017: invalid username/password; logon denied
. For details refer to "(:CLSN00107:)" in "/u01/app/oracle/diag/crs/srlab/crs/trace/ohasd_oraagent_oracle.trc".
CRS-2674: Start of 'ora.srcdb19c.db' on 'srlab' failed
ORA-01017: invalid username/password; logon denied
[oracle@srlab bin]$ id oracle
uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54331(asmdba),54332(asmoper),54333(asmadmin)
[oracle@srlab bin]$ id oracle
uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54330(racdba),54331(asmdba),54332(asmoper),54333(asmadmin)
[oracle@srlab bin]$ srvctl start database -d srcdb19c -o nomount
[oracle@srlab bin]$ sql
SQL*Plus: Release 19.0.0.0.0 - Production on Sat Sep 25 11:57:16 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> select name,open_mode,log_mode,database_role from v$database;
select name,open_mode,log_mode,database_role from v$database
*
ERROR at line 1:
ORA-01507: database not mounted
SQL> show parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/SRCDB19C/spfilesrcdb19c.
ora
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@srlab bin]$ sql
SQL*Plus: Release 19.0.0.0.0 - Production on Sat Sep 25 11:58:02 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL>
SQL> ALTER SYSTEM SET DB_CREATE_FILE_DEST='+DATA' SID='*';
System altered.
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE='15G' SID='*';
System altered.
SQL> ALTER SYSTEM SET CONTROL_FILES='+DATA' SCOPE=SPFILE SID='*';
System altered.
SQL> STARTUP NOMOUNT FORCE;
ORACLE instance started.
Total System Global Area 2432695832 bytes
Fixed Size 9137688 bytes
Variable Size 536870912 bytes
Database Buffers 1879048192 bytes
Redo Buffers 7639040 bytes
SQL> show parameter db_create
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_create_file_dest string +DATA
db_create_online_log_dest_1 string
db_create_online_log_dest_2 string
db_create_online_log_dest_3 string
db_create_online_log_dest_4 string
db_create_online_log_dest_5 string
SQL> show parameter recovery
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /oradata/fra
db_recovery_file_dest_size big integer 15G
recovery_parallelism integer 0
remote_recovery_file_dest string
SQL> alter system set db_recovery_file_dest='FRA' sid='*';
alter system set db_recovery_file_dest='FRA' sid='*'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-01261: Parameter db_recovery_file_dest destination string cannot be
translated
ORA-01262: Stat failed on a file destination directory
Linux-x86_64 Error: 2: No such file or directory
SQL> alter system set db_recovery_file_dest='+FRA' sid='*';
System altered.
SQL> sho parameter recovery
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string +FRA
db_recovery_file_dest_size big integer 15G
recovery_parallelism integer 0
remote_recovery_file_dest string
SQL> sho parameter controlfile
SQL> show parameter control
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
control_files string +DATA
control_management_pack_access string DIAGNOSTIC+TUNING
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@srlab bin]$ srvctl config database -d srcdb19c
Database unique name: srcdb19c
Database name:
Oracle home: /u01/app/oracle/product/19.0.0.0/db_2
Oracle user: oracle
Spfile: +DATA/SRCDB19C/spfilesrcdb19c.ora
Password file:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Disk Groups: DATA
Services:
OSDBA group:
OSOPER group:
Database instance: srcdb19c
[oracle@srlab bin]$ srvctl status database -d srcdb19c
Database is running.
[oracle@srlab bin]$ sql
SQL*Plus: Release 19.0.0.0.0 - Production on Sat Sep 25 12:12:56 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> select name,open_mode,log_mode,database_role from v$database;
NAME OPEN_MODE LOG_MODE DATABASE_ROLE
--------- -------------------- ------------ ----------------
SRCDB19C READ WRITE ARCHIVELOG PRIMARY
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRCDB19CPLUG READ WRITE NO
SQL> col name for a65
SQL> select name from v$datafile;
NAME
-----------------------------------------------------------------
+DATA/SRCDB19C/DATAFILE/system.260.1084190585
+DATA/SRCDB19C/CBBAE98514CB56B1E0536738A8C0B662/DATAFILE/system.2
64.1084190727
+DATA/SRCDB19C/DATAFILE/sysaux.261.1084190641
+DATA/SRCDB19C/CBBAE98514CB56B1E0536738A8C0B662/DATAFILE/sysaux.2
65.1084190743
+DATA/SRCDB19C/DATAFILE/undotbs1.262.1084190687
+DATA/SRCDB19C/CBBAE98514CB56B1E0536738A8C0B662/DATAFILE/undotbs1
.266.1084190759
NAME
-----------------------------------------------------------------
+DATA/SRCDB19C/DATAFILE/users.269.1084190807
+DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/system.2
63.1084190713
+DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/sysaux.2
67.1084190775
+DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/undotbs1
.268.1084190791
NAME
-----------------------------------------------------------------
+DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/users.27
0.1084190807
11 rows selected.
SQL> set lines 300 pages 2000
SQL> select name from v$datafile;
NAME
-----------------------------------------------------------------
+DATA/SRCDB19C/DATAFILE/system.260.1084190585
+DATA/SRCDB19C/CBBAE98514CB56B1E0536738A8C0B662/DATAFILE/system.2
64.1084190727
+DATA/SRCDB19C/DATAFILE/sysaux.261.1084190641
+DATA/SRCDB19C/CBBAE98514CB56B1E0536738A8C0B662/DATAFILE/sysaux.2
65.1084190743
+DATA/SRCDB19C/DATAFILE/undotbs1.262.1084190687
+DATA/SRCDB19C/CBBAE98514CB56B1E0536738A8C0B662/DATAFILE/undotbs1
.266.1084190759
+DATA/SRCDB19C/DATAFILE/users.269.1084190807
+DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/system.2
63.1084190713
+DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/sysaux.2
67.1084190775
+DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/undotbs1
.268.1084190791
+DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/users.27
0.1084190807
11 rows selected.
SQL> select name from v$controlfile;
NAME
-----------------------------------------------------------------
+DATA/SRCDB19C/CONTROLFILE/current.259.1084190513
SQL> select memeber from v$logfile;
select memeber from v$logfile
*
ERROR at line 1:
ORA-00904: "MEMEBER": invalid identifier
SQL> select member from v$logfile;
MEMBER
--------------------------------------
/oradata/data/SRCDB19C/redo01.log
/oradata/data/SRCDB19C/redo02.log
/oradata/data/SRCDB19C/redo03.log
SQL> select bytes from v$log;
BYTES
----------
209715200
209715200
209715200
SQL> alter database add logfile group 4 '+DATA/SRCDB19C/redo04.dbf' size 209715200;
Database altered.
SQL> alter database add logfile group 5 '+DATA/SRCDB19C/redo05.dbf' size 209715200;
Database altered.
SQL> alter database add logfile group 6 '+DATA/SRCDB19C/redo06.dbf' size 209715200;
Database altered.
SQL> alter system switch logfile;
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> alter system checkpoint;
System altered.
SQL>
SQL> col member for a65
SQL> select member from v$logfile;
MEMBER
-----------------------------------------------------------------
/oradata/data/SRCDB19C/redo01.log
/oradata/data/SRCDB19C/redo02.log
/oradata/data/SRCDB19C/redo03.log
+DATA/SRCDB19C/redo04.dbf
+DATA/SRCDB19C/redo05.dbf
+DATA/SRCDB19C/redo06.dbf
6 rows selected.
SQL> alter database drop logfile group 1;
Database altered.
SQL> select group#,member from v$logfile;
GROUP# MEMBER
---------- -----------------------------------------------------------------
2 /oradata/data/SRCDB19C/redo02.log
3 /oradata/data/SRCDB19C/redo03.log
4 +DATA/SRCDB19C/redo04.dbf
5 +DATA/SRCDB19C/redo05.dbf
6 +DATA/SRCDB19C/redo06.dbf
SQL> alter database drop logfile group 2;
Database altered.
SQL> alter database drop logfile group 3;
Database altered.
SQL> select group#,member from v$logfile;
GROUP# MEMBER
---------- -----------------------------------------------------------------
4 +DATA/SRCDB19C/redo04.dbf
5 +DATA/SRCDB19C/redo05.dbf
6 +DATA/SRCDB19C/redo06.dbf
SQL> alter system switch logfile;
System altered.
SQL> select 'Controlfile' filetype,name from v$controlfile
union all
select 'Datafile', name from v$datafile
union all
select 'Tempfile', name from v$tempfile
union all
select 'Logfile', member from v$logfile; 2 3 4 5 6 7
FILETYPE NAME
----------- -----------------------------------------------------------------
Controlfile +DATA/SRCDB19C/CONTROLFILE/current.259.1084190513
Datafile +DATA/SRCDB19C/DATAFILE/system.260.1084190585
Datafile +DATA/SRCDB19C/CBBAE98514CB56B1E0536738A8C0B662/DATAFILE/system.2
64.1084190727
Datafile +DATA/SRCDB19C/DATAFILE/sysaux.261.1084190641
Datafile +DATA/SRCDB19C/CBBAE98514CB56B1E0536738A8C0B662/DATAFILE/sysaux.2
65.1084190743
Datafile +DATA/SRCDB19C/DATAFILE/undotbs1.262.1084190687
Datafile +DATA/SRCDB19C/CBBAE98514CB56B1E0536738A8C0B662/DATAFILE/undotbs1
.266.1084190759
Datafile +DATA/SRCDB19C/DATAFILE/users.269.1084190807
Datafile +DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/system.2
63.1084190713
Datafile +DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/sysaux.2
67.1084190775
Datafile +DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/undotbs1
.268.1084190791
Datafile +DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/users.27
0.1084190807
Tempfile +DATA/SRCDB19C/temp01.dbf
Tempfile +DATA/SRCDB19C/pdbseed/temp01.dbf
Tempfile +DATA/SRCDB19C/srcdb19cplug/temp01.dbf
Logfile +DATA/SRCDB19C/redo04.dbf
Logfile +DATA/SRCDB19C/redo05.dbf
Logfile +DATA/SRCDB19C/redo06.dbf
18 rows selected.
SQL> select name from v$datafile;
NAME
-----------------------------------------------------------------
+DATA/SRCDB19C/DATAFILE/system.260.1084190585
+DATA/SRCDB19C/CBBAE98514CB56B1E0536738A8C0B662/DATAFILE/system.2
64.1084190727
+DATA/SRCDB19C/DATAFILE/sysaux.261.1084190641
+DATA/SRCDB19C/CBBAE98514CB56B1E0536738A8C0B662/DATAFILE/sysaux.2
65.1084190743
+DATA/SRCDB19C/DATAFILE/undotbs1.262.1084190687
+DATA/SRCDB19C/CBBAE98514CB56B1E0536738A8C0B662/DATAFILE/undotbs1
.266.1084190759
+DATA/SRCDB19C/DATAFILE/users.269.1084190807
+DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/system.2
63.1084190713
+DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/sysaux.2
67.1084190775
+DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/undotbs1
.268.1084190791
+DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/users.27
0.1084190807
11 rows selected.
SQL> col name for a75
SQL> select file_id,file_name from dba_data_files;
select file_id,file_name from dba_data_files
*
ERROR at line 1:
ORA-28365: wallet is not open
SQL> sho pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRCDB19CPLUG READ WRITE NO
SQL> sho parameter wallet
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
ssl_wallet string
wallet_root string
SQL>
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@srlab bin]$
[oracle@srlab bin]$ /u01/app/19.0.0/grid/bin/crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE srlab STABLE
ora.FRA.dg
ONLINE ONLINE srlab STABLE
ora.LISTENER.lsnr
ONLINE ONLINE srlab STABLE
ora.asm
ONLINE ONLINE srlab Started,STABLE
ora.ons
OFFLINE OFFLINE srlab STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE srlab STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.driver.afd
1 ONLINE ONLINE srlab STABLE
ora.evmd
1 ONLINE ONLINE srlab STABLE
ora.srcdb19c.db
1 ONLINE ONLINE srlab Open,HOME=/u01/app/o
racle/product/19.0.0
.0/db_2,STABLE
--------------------------------------------------------------------------------
[oracle@srlab bin]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Sat Sep 25 12:23:38 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: SRCDB19C (DBID=1852486693)
RMAN> report schema;
using target database control file instead of recovery catalog
Report of database schema for database with db_unique_name SRCDB19C
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 760 SYSTEM YES +DATA/SRCDB19C/DATAFILE/system.260.1084190585
2 210 PDB$SEED:SYSTEM NO +DATA/SRCDB19C/CBBAE98514CB56B1E0536738A8C0B662/DATAFILE/system.264.1084190727
3 550 SYSAUX NO +DATA/SRCDB19C/DATAFILE/sysaux.261.1084190641
4 165 PDB$SEED:SYSAUX NO +DATA/SRCDB19C/CBBAE98514CB56B1E0536738A8C0B662/DATAFILE/sysaux.265.1084190743
5 315 UNDOTBS1 YES +DATA/SRCDB19C/DATAFILE/undotbs1.262.1084190687
6 165 PDB$SEED:UNDOTBS1 NO +DATA/SRCDB19C/CBBAE98514CB56B1E0536738A8C0B662/DATAFILE/undotbs1.266.1084190759
7 5 USERS NO +DATA/SRCDB19C/DATAFILE/users.269.1084190807
8 220 SRCDB19CPLUG:SYSTEM YES +DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/system.263.1084190713
9 165 SRCDB19CPLUG:SYSAUX NO +DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/sysaux.267.1084190775
10 165 SRCDB19CPLUG:UNDOTBS1 YES +DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/undotbs1.268.1084190791
11 5 SRCDB19CPLUG:USERS NO +DATA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/DATAFILE/users.270.1084190807
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 20 TEMP 32767 +DATA/SRCDB19C/temp01.dbf
2 20 PDB$SEED:TEMP 32767 +DATA/SRCDB19C/pdbseed/temp01.dbf
3 20 SRCDB19CPLUG:TEMP 32767 +DATA/SRCDB19C/srcdb19cplug/temp01.dbf
RMAN>
RMAN>
RMAN> report schema
2> ;
Report of database schema for database with db_unique_name SRCDB19C
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 760 SYSTEM YES +DATA/SRCDB19C/system01.dbf
2 210 PDB$SEED:SYSTEM NO +DATA/SRCDB19C/pdbseed/system02.dbf
3 550 SYSAUX NO +DATA/SRCDB19C/sysaux02.dbf
4 165 PDB$SEED:SYSAUX NO +DATA/SRCDB19C/pdbseed/sysaux02.dbf
5 315 UNDOTBS1 YES +DATA/SRCDB19C/undotbs1.dbf
6 165 PDB$SEED:UNDOTBS1 NO +DATA/SRCDB19C/CBBAE98514CB56B1E0536738A8C0B662/DATAFILE/undotbs1.266.1084190759
7 5 USERS NO +DATA/SRCDB19C/users.dbf
8 220 SRCDB19CPLUG:SYSTEM YES +DATA/SRCDB19C/SRCDB19CPLUG/system03.dbf
9 165 SRCDB19CPLUG:SYSAUX NO +DATA/SRCDB19C/SRCDB19CPLUG/sysaux03.dbf
10 165 SRCDB19CPLUG:UNDOTBS1 YES +DATA/SRCDB19C/SRCDB19CPLUG/undotbs1.dbf
11 5 SRCDB19CPLUG:USERS NO +DATA/SRCDB19C/SRCDB19CPLUG/users.dbf
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 20 TEMP 32767 +DATA/SRCDB19C/temp01.dbf
2 20 PDB$SEED:TEMP 32767 +DATA/SRCDB19C/pdbseed/temp01.dbf
3 20 SRCDB19CPLUG:TEMP 32767 +DATA/SRCDB19C/srcdb19cplug/temp01.dbf
RMAN> report schema;
Report of database schema for database with db_unique_name SRCDB19C
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 760 SYSTEM YES +DATA/SRCDB19C/system01.dbf
2 210 PDB$SEED:SYSTEM NO +DATA/SRCDB19C/pdbseed/system02.dbf
3 550 SYSAUX NO +DATA/SRCDB19C/sysaux02.dbf
4 165 PDB$SEED:SYSAUX NO +DATA/SRCDB19C/pdbseed/sysaux02.dbf
5 315 UNDOTBS1 YES +DATA/SRCDB19C/undotbs1.dbf
6 165 PDB$SEED:UNDOTBS1 NO +DATA/SRCDB19C/pdbseed/undotbs1.dbf
7 5 USERS NO +DATA/SRCDB19C/users.dbf
8 220 SRCDB19CPLUG:SYSTEM YES +DATA/SRCDB19C/SRCDB19CPLUG/system03.dbf
9 165 SRCDB19CPLUG:SYSAUX NO +DATA/SRCDB19C/SRCDB19CPLUG/sysaux03.dbf
10 165 SRCDB19CPLUG:UNDOTBS1 YES +DATA/SRCDB19C/SRCDB19CPLUG/undotbs1.dbf
11 5 SRCDB19CPLUG:USERS NO +DATA/SRCDB19C/SRCDB19CPLUG/users.dbf
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 20 TEMP 32767 +DATA/SRCDB19C/temp01.dbf
2 20 PDB$SEED:TEMP 32767 +DATA/SRCDB19C/pdbseed/temp01.dbf
3 20 SRCDB19CPLUG:TEMP 32767 +DATA/SRCDB19C/srcdb19cplug/temp01.dbf
RMAN> backup database plus archivelog;
Starting backup at 25-SEP-21
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=36 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=18 RECID=1 STAMP=1083051615
input archived log thread=1 sequence=19 RECID=2 STAMP=1083054466
input archived log thread=1 sequence=20 RECID=3 STAMP=1084170929
input archived log thread=1 sequence=21 RECID=4 STAMP=1084191415
input archived log thread=1 sequence=22 RECID=5 STAMP=1084191416
input archived log thread=1 sequence=23 RECID=6 STAMP=1084191417
input archived log thread=1 sequence=24 RECID=7 STAMP=1084191513
input archived log thread=1 sequence=25 RECID=8 STAMP=1084192792
channel ORA_DISK_1: starting piece 1 at 25-SEP-21
channel ORA_DISK_1: finished piece 1 at 25-SEP-21
piece handle=+FRA/SRCDB19C/BACKUPSET/2021_09_25/annnf0_tag20210925t123955_0.259.1084192797 tag=TAG20210925T123955 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
Finished backup at 25-SEP-21
Starting backup at 25-SEP-21
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/SRCDB19C/system01.dbf
input datafile file number=00003 name=+DATA/SRCDB19C/sysaux02.dbf
input datafile file number=00005 name=+DATA/SRCDB19C/undotbs1.dbf
input datafile file number=00007 name=+DATA/SRCDB19C/users.dbf
channel ORA_DISK_1: starting piece 1 at 25-SEP-21
channel ORA_DISK_1: finished piece 1 at 25-SEP-21
piece handle=+FRA/SRCDB19C/BACKUPSET/2021_09_25/nnndf0_tag20210925t124021_0.260.1084192823 tag=TAG20210925T124021 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:15
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00008 name=+DATA/SRCDB19C/SRCDB19CPLUG/system03.dbf
input datafile file number=00009 name=+DATA/SRCDB19C/SRCDB19CPLUG/sysaux03.dbf
input datafile file number=00010 name=+DATA/SRCDB19C/SRCDB19CPLUG/undotbs1.dbf
input datafile file number=00011 name=+DATA/SRCDB19C/SRCDB19CPLUG/users.dbf
channel ORA_DISK_1: starting piece 1 at 25-SEP-21
channel ORA_DISK_1: finished piece 1 at 25-SEP-21
piece handle=+FRA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/BACKUPSET/2021_09_25/nnndf0_tag20210925t124021_0.261.1084192899 tag=TAG20210925T124021 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00002 name=+DATA/SRCDB19C/pdbseed/system02.dbf
input datafile file number=00004 name=+DATA/SRCDB19C/pdbseed/sysaux02.dbf
input datafile file number=00006 name=+DATA/SRCDB19C/pdbseed/undotbs1.dbf
channel ORA_DISK_1: starting piece 1 at 25-SEP-21
channel ORA_DISK_1: finished piece 1 at 25-SEP-21
piece handle=+FRA/SRCDB19C/CBBAE98514CB56B1E0536738A8C0B662/BACKUPSET/2021_09_25/nnndf0_tag20210925t124021_0.262.1084192925 tag=TAG20210925T124021 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
Finished backup at 25-SEP-21
Starting backup at 25-SEP-21
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=26 RECID=9 STAMP=1084192960
channel ORA_DISK_1: starting piece 1 at 25-SEP-21
channel ORA_DISK_1: finished piece 1 at 25-SEP-21
piece handle=+FRA/SRCDB19C/BACKUPSET/2021_09_25/annnf0_tag20210925t124240_0.263.1084192961 tag=TAG20210925T124240 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 25-SEP-21
Starting Control File and SPFILE Autobackup at 25-SEP-21
piece handle=+FRA/SRCDB19C/AUTOBACKUP/2021_09_25/s_1084192962.264.1084192965 comment=NONE
Finished Control File and SPFILE Autobackup at 25-SEP-21
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Full 17.95M DISK 00:00:10 12-SEP-21
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20210912T073325
Piece Name: /oradata/fra/SRCDB19C/autobackup/2021_09_12/o1_mf_s_1083051205_jmtqzoqd_.bkp
SPFILE Included: Modification time: 11-SEP-21
SPFILE db_unique_name: SRCDB19C
Control File Included: Ckp SCN: 1329058 Ckp time: 12-SEP-21
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2 Full 17.95M DISK 00:00:04 25-SEP-21
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20210925T120649
Piece Name: +FRA/SRCDB19C/AUTOBACKUP/2021_09_25/s_1084188965.256.1084190813
SPFILE Included: Modification time: 25-SEP-21
SPFILE db_unique_name: SRCDB19C
Control File Included: Ckp SCN: 1532574 Ckp time: 25-SEP-21
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3 Full 17.95M DISK 00:00:04 25-SEP-21
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20210925T122404
Piece Name: +FRA/SRCDB19C/AUTOBACKUP/2021_09_25/s_1084191844.257.1084191849
SPFILE Included: Modification time: 25-SEP-21
SPFILE db_unique_name: SRCDB19C
Control File Included: Ckp SCN: 1534869 Ckp time: 25-SEP-21
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4 Full 17.95M DISK 00:00:04 25-SEP-21
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20210925T123906
Piece Name: +FRA/SRCDB19C/AUTOBACKUP/2021_09_25/s_1084192746.258.1084192749
SPFILE Included: Modification time: 25-SEP-21
SPFILE db_unique_name: SRCDB19C
Control File Included: Ckp SCN: 1536086 Ckp time: 25-SEP-21
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5 286.52M DISK 00:00:20 25-SEP-21
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20210925T123955
Piece Name: +FRA/SRCDB19C/BACKUPSET/2021_09_25/annnf0_tag20210925t123955_0.259.1084192797
List of Archived Logs in backup set 5
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 18 1280946 11-SEP-21 1375742 12-SEP-21
1 19 1375742 12-SEP-21 1409590 12-SEP-21
1 20 1409590 12-SEP-21 1518322 25-SEP-21
1 21 1518322 25-SEP-21 1534614 25-SEP-21
1 22 1534614 25-SEP-21 1534620 25-SEP-21
1 23 1534620 25-SEP-21 1534623 25-SEP-21
1 24 1534623 25-SEP-21 1534689 25-SEP-21
1 25 1534689 25-SEP-21 1536125 25-SEP-21
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6 Full 842.15M DISK 00:01:11 25-SEP-21
BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20210925T124021
Piece Name: +FRA/SRCDB19C/BACKUPSET/2021_09_25/nnndf0_tag20210925t124021_0.260.1084192823
List of Datafiles in backup set 6
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
1 Full 1536182 25-SEP-21 NO +DATA/SRCDB19C/system01.dbf
3 Full 1536182 25-SEP-21 NO +DATA/SRCDB19C/sysaux02.dbf
5 Full 1536182 25-SEP-21 NO +DATA/SRCDB19C/undotbs1.dbf
7 Full 1536182 25-SEP-21 NO +DATA/SRCDB19C/users.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7 Full 270.70M DISK 00:00:24 25-SEP-21
BP Key: 7 Status: AVAILABLE Compressed: NO Tag: TAG20210925T124021
Piece Name: +FRA/SRCDB19C/CBBD1D3A70D01916E0536738A8C005C8/BACKUPSET/2021_09_25/nnndf0_tag20210925t124021_0.261.1084192899
List of Datafiles in backup set 7
Container ID: 3, PDB Name: SRCDB19CPLUG
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
8 Full 1536243 25-SEP-21 NO +DATA/SRCDB19C/SRCDB19CPLUG/system03.dbf
9 Full 1536243 25-SEP-21 NO +DATA/SRCDB19C/SRCDB19CPLUG/sysaux03.dbf
10 Full 1536243 25-SEP-21 NO +DATA/SRCDB19C/SRCDB19CPLUG/undotbs1.dbf
11 Full 1536243 25-SEP-21 NO +DATA/SRCDB19C/SRCDB19CPLUG/users.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8 Full 416.40M DISK 00:00:32 25-SEP-21
BP Key: 8 Status: AVAILABLE Compressed: NO Tag: TAG20210925T124021
Piece Name: +FRA/SRCDB19C/CBBAE98514CB56B1E0536738A8C0B662/BACKUPSET/2021_09_25/nnndf0_tag20210925t124021_0.262.1084192925
List of Datafiles in backup set 8
Container ID: 2, PDB Name: PDB$SEED
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
2 Full 1323399 11-SEP-21 NO +DATA/SRCDB19C/pdbseed/system02.dbf
4 Full 1323399 11-SEP-21 NO +DATA/SRCDB19C/pdbseed/sysaux02.dbf
6 Full 1323399 11-SEP-21 NO +DATA/SRCDB19C/pdbseed/undotbs1.dbf
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
9 68.50K DISK 00:00:00 25-SEP-21
BP Key: 9 Status: AVAILABLE Compressed: NO Tag: TAG20210925T124240
Piece Name: +FRA/SRCDB19C/BACKUPSET/2021_09_25/annnf0_tag20210925t124240_0.263.1084192961
List of Archived Logs in backup set 9
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 26 1536125 25-SEP-21 1536286 25-SEP-21
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
10 Full 17.95M DISK 00:00:04 25-SEP-21
BP Key: 10 Status: AVAILABLE Compressed: NO Tag: TAG20210925T124242
Piece Name: +FRA/SRCDB19C/AUTOBACKUP/2021_09_25/s_1084192962.264.1084192965
SPFILE Included: Modification time: 25-SEP-21
SPFILE db_unique_name: SRCDB19C
Control File Included: Ckp SCN: 1536299 Ckp time: 25-SEP-21
RMAN>
Hope this helps!
Cheers!
Ramesh.
Post a Comment: