openwares.net

$ ps aux grep wal

$ sudo -u postgres psql
postgres=# select pg_is_in_recovery();
pg_is_in_recovery
-------------------
 f
(1 row)

$ sudo -u postgres /usr/lib/postgresql/11/bin/pg_controldata -D /var/lib/postgresql/11/main/
g_control version number: 1100
Catalog version number: 201809051
Database system identifier: 6745356148899875633
Database cluster state: in production
pg_control last modified: Thu 09 Jul 2020 02:40:49 PM CST
Latest checkpoint location: 825/245660D8
Latest checkpoint's REDO location: 825/245660A0
...

trigger_file='/var/lib/postgresql/11/main/.postgresql.trigger'

$ sudo systemctl stop postgresql@11-main.service

$ pg_lsclusters
Ver Cluster Port Status Owner Data directory Log file
11 main 5432 online postgres /var/lib/postgresql/11/main /var/log/postgresql/postgresql-11-main.log

$ sudo pg_ctlcluster 11 main stop

$ sudo touch /var/lib/postgresql/11/main/.postgresql.trigger

recovery_target_timeline='latest'
standby_mode = 'on'
primary_conninfo = 'host=59.206.31.149 port=5432 user=xxxx password=xxxx'
primary_slot_name = 'repl_slot_2'

$ sudo pg_ctlcluster 11 main promote

STATDOPTS="--port 3000 --outgoing-port 3001"

RPCMOUNTDOPTS="--manage-gids --port 3002"

fs.nfs.nlm_tcpport = 3003
fs.nfs.nlm_udpport = 3003

$ sudo sysctl -p /etc/sysctl.d/nfs-static-ports.conf
$ sudo systemctl restart nfs-utils.service
$ sudo systemctl restart nfs-kernel-server.service

mount.nfs: access denied by server while mounting ...

$ sudo exportfs -a

$ sudo apt install dante-server

logoutput: syslog /var/log/sockd.log stdout
internal: br0 port = 1080
external: 10.100.0.32
clientmethod: none
socksmethod: none
user.privileged: proxy
user.unprivileged: nobody
user.libwrap: nobody
client pass {
 from: 0.0.0.0/0 port 1-65535 to: 0.0.0.0/0
}
socks pass {
 from: 0.0.0.0/8 to: 0.0.0.0/0
 command: bind connect udpassociate
 log: error
}

$ sshfs user@host:/mnt/data/reis_dump/ /mnt/hwy06_reisdb_bak/ -o reconnect,ServerAliveInterval=15,ServerAliveCountMax=3

$ sshfs hwy-reisdb-3:/mnt/data/reis_dump/ /mnt/hwy06_reisdb_bak/ -o reconnect,ServerAliveInterval=15,ServerAliveCountMax=3

client_loop: send disconnect: Broken pipe

ClientAliveInterval 30
ClientAliveCountMax 3

RMAN>delete archivelog all completed before 'sysdate-1';

$ rman target /
rman> crosscheck archivelog all;
rman> delete expired archivelog all;

listen_address: 192.168.136.250
broadcast_address: 59.206.31.152
rpc_address: 192.168.136.250
broadcast_rpc_address: 59.206.31.152

seed_provider:
 # Addresses of hosts that are deemed contact points. 
 # Cassandra nodes use this list of hosts to find each other and learn
 # the topology of the ring. You must change this if you are running
 # multiple nodes!
 - class_name: org.apache.cassandra.locator.SimpleSeedProvider
 parameters:
 # seeds is actually a comma-delimited list of addresses.
 # Ex: "<ip1>,<ip2>,<ip3>"
 - seeds: "59.206.31.152,10.160.4.196,10.160.4.197"

load pubkey "/Users/xxx/.ssh/id_rsa": invalid format

$ ssh-keygen -f ~/.ssh/id_rsa -y > ~/.ssh/id_rsa.pub

/srv/debsrcs/debian-10.1.0-amd64-DVD-1.iso/media/cdrom1udf,iso9660 loop 0 0
/srv/debsrcs/debian-10.1.0-amd64-DVD-2.iso/media/cdrom2udf,iso9660 loop 0 0
/srv/debsrcs/debian-10.1.0-amd64-DVD-3.iso/media/cdrom3udf,iso9660 loop 0 0
/srv/debsrcs/debian-10.1.0-amd64-DVD-4.iso/media/cdrom4udf,iso9660 loop 0 0

deb \[ trusted=yes \] file:/media/cdrom1/ buster main contrib 
deb \[ trusted=yes \] file:/media/cdrom2/ buster main contrib 
deb \[ trusted=yes \] file:/media/cdrom3/ buster main contrib 
deb \[ trusted=yes \] file:/media/cdrom4/ buster main contrib 

SQL> shutdown immediate
SQL> startup mount
SQL> alter database open read only;

SQL> set serveroutput on
SQL> declare
    db_ready boolean;
  begin
    /* db_ready is ignored, but with SERVEROUTPUT set to ON any 
     * conditions preventing transport will be output to console */
    db_ready := dbms_tdb.check_db('Linux x86 64-bit', dbms_tdb.skip_none);
  end;
 /

SQL> set serveroutput on
SQL> declare
     external boolean;
  begin
    /* value of external is ignored, but with SERVEROUTPUT set to ON
     * dbms_tdb.check_external displays report of external objects
     * on console */
    external := dbms_tdb.check_external;
  end;
 /

$ rman target sys/passwd@dbinst
RMAN> CONVERT DATABASE ON TARGET PLATFORM
 CONVERT SCRIPT 'D:\\rman\\convertscript.rman'
 TRANSPORT SCRIPT 'D:\\rman\\transportscript.sql'
 new database 'orcl'
 FORMAT 'D:\\rman\\%U';

RUN {

 CONVERT DATAFILE 'E:\\ORACLE\\PRODUCT\\10.2.0\\DB_1\\DATABASE\\DIGITALSCANDATA.DAT' 
 FROM PLATFORM 'Microsoft Windows x86 64-bit' 
 FORMAT 'D:\\RMAN\\DATA_D-ORCL_I-1276927241_TS-DIGITALSCANDATA_FNO-38_HDV216EA';


 CONVERT DATAFILE 'E:\\ORACLE\\PRODUCT\\10.2.0\\DB_1\\DATABASE\\DIGITALSCANDATA01.DAT' 
 FROM PLATFORM 'Microsoft Windows x86 64-bit' 
 FORMAT 'D:\\RMAN\\DATA_D-ORCL_I-1276927241_TS-DIGITALSCANDATA_FNO-39_HEV216EA';
...

RUN {

 CONVERT DATAFILE '/mnt/data/database/DIGITALSCANDATA.DAT' 
 FROM PLATFORM 'Microsoft Windows x86 64-bit' 
 FORMAT '/u01/oradata/orcl/DATA_D-ORCL_I-1276927241_TS-DIGITALSCANDATA_FNO-38_HDV216EA';


 CONVERT DATAFILE '/mnt/data/database/DIGITALSCANDATA01.DAT' 
 FROM PLATFORM 'Microsoft Windows x86 64-bit' 
 FORMAT '/u01/oradata/orcl/DATA_D-ORCL_I-1276927241_TS-DIGITALSCANDATA_FNO-39_HEV216EA';
...

# Please change the values of the following parameters:

 control_files = "D:\\RMAN\\CF_D-ORCL_ID-1276927241_00V216EA"

 db_recovery_file_dest = "D:\\RMAN\\flash_recovery_area"

 db_recovery_file_dest_size= 2147483648

 audit_file_dest = "D:\\RMAN\\ADUMP"
...

# Please change the values of the following parameters:

 control_files = "/u01/oradata/orcl/CF_D-ORCL_ID-1276927241_00V216EA"

 db_recovery_file_dest = "/u01/app/oracle/flash_recovery_area"

 db_recovery_file_dest_size= 2147483648

 audit_file_dest = "/u01/app/oracle/admin/orcl/adump"
...

-- The following commands will create a new control file and use it
-- to open the database.
-- Data used by Recovery Manager will be lost.
-- The contents of online logs will be lost and all backups will
-- be invalidated. Use this only if online logs are damaged.

-- After mounting the created controlfile, the following SQL
-- statement will place the database in the appropriate
-- protection mode:
-- ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE

STARTUP NOMOUNT PFILE='D:\\RMAN\\INIT_00V216EA_1_0.ORA'
CREATE CONTROLFILE REUSE SET DATABASE "ORCL" RESETLOGS FORCE LOGGING ARCHIVELOG
 MAXLOGFILES 16
 MAXLOGMEMBERS 3
 MAXDATAFILES 100
 MAXINSTANCES 8
 MAXLOGHISTORY 14616
LOGFILE
 GROUP 1 'D:\\RMAN\\ARCH_D-ORCL_ID-1276927241_S-517_T-1_A-1017328065_00V216EA' SIZE 50M,
 GROUP 2 'D:\\RMAN\\ARCH_D-ORCL_ID-1276927241_S-515_T-1_A-1017328065_00V216EA' SIZE 50M,
 GROUP 3 'D:\\RMAN\\ARCH_D-ORCL_ID-1276927241_S-516_T-1_A-1017328065_00V216EA' SIZE 50M
DATAFILE
 'D:\\RMAN\\DATA_D-ORCL_I-1276927241_TS-SYSTEM_FNO-1_IKV216EF',
...

STARTUP NOMOUNT PFILE='/u01/app/oracle/admin/orcl/pfile/INIT_00V216EA_1_0.ORA'
CREATE CONTROLFILE REUSE SET DATABASE "ORCL" RESETLOGS FORCE LOGGING ARCHIVELOG
 MAXLOGFILES 16
 MAXLOGMEMBERS 3
 MAXDATAFILES 100
 MAXINSTANCES 8
 MAXLOGHISTORY 14616
LOGFILE
 GROUP 1 '/u01/oradata/orcl/ARCH_D-ORCL_ID-1276927241_S-517_T-1_A-1017328065_00V216EA' SIZE 50M,
 GROUP 2 '/u01/oradata/orcl/ARCH_D-ORCL_ID-1276927241_S-515_T-1_A-1017328065_00V216EA' SIZE 50M,
 GROUP 3 '/u01/oradata/orcl/ARCH_D-ORCL_ID-1276927241_S-516_T-1_A-1017328065_00V216EA' SIZE 50M
DATAFILE
 '/u01/oradata/orcl/DATA_D-ORCL_I-1276927241_TS-SYSTEM_FNO-1_IKV216EF',
...

$ rman target / nocatalog
RMAN> @CONVERTSCRIPT.RMAN

$ sqlplus / as sysdba;
SQL> @TRANSPORTSCRIPT.SQL

ORA-27102: out of memory
Linux-x86_64 Error: 28: No space left on device

$ orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=passwd_for_sys force=y